1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'S BUTTONS PEARL W/PASSAMANERIE ' and pg.products_id = pd.' at line 1
select distinct p.products_image, pd.products_mis as misname, p.products_misid as mis, pd.products_conf as conf, p.products_id as id, p.products_model as model, pg.customers_group_price as pricer, pd.products_uv as uv, p.xcd as xcd from products_groups pg, products p, products_to_categories p2c, products_description pd where p.products_misid = '46' and pd.products_name = 'WOMEN'S BUTTONS PEARL W/PASSAMANERIE ' and pg.products_id = pd.products_id and pg.customers_group_id = '10000' and p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id LIKE '8031079%' and p.products_misid= '46' order by p.products_model ASC