1054 - Unknown column 'prod.products_id' in 'on clause'
select * from products prod, products_to_categories prodcate , products_description proddescr INNER JOIN products_to_stores p2s ON prod.products_id = p2s.products_id where p2s.stores_id = '1' and prod.products_status = '1' and prodcate.categories_id=29 and prod.products_id=prodcate.products_id and proddescr.language_id=1 and proddescr.products_id=prod.products_id order by proddescr.products_name