Powered by Zen Cart :: The Art of E-Commerce
select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id from (products p left join featured f on p.products_id = f.products_id left join products_description pd on p.products_id = pd.products_id left join products_to_categories pc on p.products_id = pc.products_id ) where p.products_id = f.products_id and p.products_id = pd.products_id and pc.categories_id = 280 and p.products_status = 1 and f.status = 1 and pd.language_id = '1' limit 4