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 'and ) group by p.products_id order by pd.products_name' at line 24
select distinct group_concat(fp.Products_Price) as PPrices, group_concat(fp.code) as PCodes, p.products_free, p.products_countries_view, p.products_tricat, p.products_types, p.products_lr_include, p.products_csg_exclude, products_csg_include, p.products_reservation, s.studios_name, m.manufacturers_name, p.products_status, p.products_flash, pd.products_id, pd.products_name, p.products_date_available, p.products_published, p2c.categories_id FROM products p LEFT JOIN manufacturers m USING ( manufacturers_id ) LEFT JOIN studios s ON s.studios_id = p.products_studio_id, products_description pd, products_to_categories p2c, fixed_prices fp where fp.product_id = p.products_id and ( p.products_lr_include LIKE '%;10;%' or p.products_lr_include LIKE '10;%' or p.products_lr_include = '10' or p.products_lr_include LIKE '%;10' ) and p.products_id = pd.products_id and p2c.products_id = p.products_id and p.products_status = '1' and p2c.categories_id in (27, 28, 33, 30) and ( and ) group by p.products_id order by pd.products_name
[TEP STOP]
select distinct group_concat(fp.Products_Price) as PPrices, group_concat(fp.code) as PCodes, p.products_free, p.products_countries_view, p.products_tricat, p.products_types, p.products_lr_include, p.products_csg_exclude, products_csg_include, p.products_reservation, s.studios_name, m.manufacturers_name, p.products_status, p.products_flash, pd.products_id, pd.products_name, p.products_date_available, p.products_published, p2c.categories_id FROM products p LEFT JOIN manufacturers m USING ( manufacturers_id ) LEFT JOIN studios s ON s.studios_id = p.products_studio_id, products_description pd, products_to_categories p2c, fixed_prices fp where fp.product_id = p.products_id and ( p.products_lr_include LIKE '%;10;%' or p.products_lr_include LIKE '10;%' or p.products_lr_include = '10' or p.products_lr_include LIKE '%;10' ) and p.products_id = pd.products_id and p2c.products_id = p.products_id and p.products_status = '1' and p2c.categories_id in (27, 28, 33, 30) and ( and ) group by p.products_id order by pd.products_name
[TEP STOP]