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 'ANCHOR' ' and pg.products_id = pd.products_id and pg.customers_group_id =' 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 = '8S' and pd.products_name = 'PEARLY EMBROIDERY THREAD CCC 4591/4596 'ANCHOR' ' 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 '1020250%' and p.products_misid= '8S' order by p.products_model ASC