SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.slug, p.price,
-- i.image,
p.ref_num, p.promo, p.price_promo, p.created_at, pt.meta_description, p.new,
pub.name as publisher, p.top, p.action, p.soon, p.promo,
pt.price as actual_price, p.most_sold
FROM products p
INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
INNER JOIN products_params pp ON pp.product_id = p.id
INNER JOIN products_params_sizes pps ON pp.id = pps.param_id AND pps.quantity > 0
LEFT JOIN pages_text pub ON p.publisher_id = pub.page_id AND pub.language_id = 1
WHERE p.status != 'deleted'
--
GROUP BY p.id
ORDER BY pc_0.order_id ASC
LIMIT 50 OFFSET 0
Unknown column 'pc_0.order_id' in 'order clause'
file -
line -