query
SELECT p.id, p.price, p.stock, p.id_category, p.flag_new, p.extras, p.extras_url, pt.title, pp.file
FROM prod_products p
RIGHT JOIN prod_products_trans pt ON p.id = pt.id_parent
RIGHT JOIN prod_photos pp ON p.id = pp.id_product
WHERE p.flag_active = 1
AND p.stock > 0
AND (
p.flag_promo = 1 OR p.flag_first_page = 1 OR p.flag_marked = 1 OR p.sticker = 1
)
GROUP BY p.id
ORDER BY favicon.ico asc
error
Unknown column 'favicon.ico' in 'order clause'
backtrace
1: query called at /var/www/html/brothersklep.pl/public_html/lib/class.db.php on line 118
2: getAll called at /var/www/html/brothersklep.pl/public_html/modules/cms/models/m_promotions.php on line 36
3: getList called at /var/www/html/brothersklep.pl/public_html/modules/cms/controllers/c_cms.php on line 11
4: promotions_index called at /var/www/html/brothersklep.pl/public_html/lib/FrontController.php on line 102
5: dispatch called at /var/www/html/brothersklep.pl/public_html/index.php on line 34