 |
New Products For May |
 |
1054 - Unknown column 'p.products_id' in 'on clause'
select distinct p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price , pp.pp_file products_image
from products p
left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c
left join product_photos pp on p.products_id = pp.pp_pr_id and pp.pp_default='1'
where p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and c.parent_id = '22'
and p.products_status = '1'
order by p.products_id DESC
limit 9
[TEP STOP]
|
