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 and (pd.products_name like '%magic%' or p.products_model like '%magic%' or ' at line 15
select distinct s.studios_name, m.manufacturers_name, p.products_status, p.products_flash, pd.products_id, pd.products_name, p.products_date_available, 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 where 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 ((pd.products_name like '%heroes%' or p.products_model like '%heroes%' or m.manufacturers_name like '%heroes%' or s.studios_name like '%heroes%' or pd.products_searchkeywords like '%heroes%') and (pd.products_name like '%might%' or p.products_model like '%might%' or m.manufacturers_name like '%might%' or s.studios_name like '%might%' or pd.products_searchkeywords like '%might%') and and and (pd.products_name like '%magic%' or p.products_model like '%magic%' or m.manufacturers_name like '%magic%' or s.studios_name like '%magic%' or pd.products_searchkeywords like '%magic%') and (pd.products_name like '%tribes%' or p.products_model like '%tribes%' or m.manufacturers_name like '%tribes%' or s.studios_name like '%tribes%' or pd.products_searchkeywords like '%tribes%') and (pd.products_name like '%the%' or p.products_model like '%the%' or m.manufacturers_name like '%the%' or s.studios_name like '%the%' or pd.products_searchkeywords like '%the%') and (pd.products_name like '%east%' or p.products_model like '%east%' or m.manufacturers_name like '%east%' or s.studios_name like '%east%' or pd.products_searchkeywords like '%east%') ) order by pd.products_name
[TEP STOP]
select distinct s.studios_name, m.manufacturers_name, p.products_status, p.products_flash, pd.products_id, pd.products_name, p.products_date_available, 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 where 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 ((pd.products_name like '%heroes%' or p.products_model like '%heroes%' or m.manufacturers_name like '%heroes%' or s.studios_name like '%heroes%' or pd.products_searchkeywords like '%heroes%') and (pd.products_name like '%might%' or p.products_model like '%might%' or m.manufacturers_name like '%might%' or s.studios_name like '%might%' or pd.products_searchkeywords like '%might%') and and and (pd.products_name like '%magic%' or p.products_model like '%magic%' or m.manufacturers_name like '%magic%' or s.studios_name like '%magic%' or pd.products_searchkeywords like '%magic%') and (pd.products_name like '%tribes%' or p.products_model like '%tribes%' or m.manufacturers_name like '%tribes%' or s.studios_name like '%tribes%' or pd.products_searchkeywords like '%tribes%') and (pd.products_name like '%the%' or p.products_model like '%the%' or m.manufacturers_name like '%the%' or s.studios_name like '%the%' or pd.products_searchkeywords like '%the%') and (pd.products_name like '%east%' or p.products_model like '%east%' or m.manufacturers_name like '%east%' or s.studios_name like '%east%' or pd.products_searchkeywords like '%east%') ) order by pd.products_name
[TEP STOP]