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 'LIMIT 0, 30' at line 7
SELECT p.products_id, p.products_price, pd.products_name, p.products_store_id, p.products_tax_class_id, p.products_image, s.stores_mod, s.stores_name
FROM products as p left join products_description as pd on p.products_id = pd.products_id left join
products_to_categories as pc on p.products_id = pc.products_id
left join ds_cat_to_cat as dsc on pc.categories_id = dsc.categories_id
left join stores as s on p.products_store_id = s.stores_id
WHERE pd.language_id = 1 and p.products_status = 1
AND dsc.ds_id = LIMIT 0, 30
[TEP STOP]