---

SELECT pp.id, pp.price, pp.vat, pp.stock, pp.configurator_type, pp.id_configurator, pp.extras, pp.flag_marked, pp.flag_first_page, ppt.title, ppt.short, ppt.title_clean, pagp.show_in_warranty (SELECT ph.file FROM prod_photos ph WHERE ph.id_product = pp.id ORDER BY ph.sort LIMIT 1) as file FROM prod_addons_groups_products pagp RIGHT JOIN prod_products pp ON pp.id = pagp.id_product RIGHT JOIN prod_products_trans ppt ON pp.id = ppt.id_parent WHERE pagp.id_group = "180" AND pp.flag_archive = "0" AND pp.flag_active = "1" ORDER BY pp.flag_first_page DESC, pp.id ASC


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ph.file FROM prod_photos ph WHERE ph.id_product = pp.id ORDER BY ph.sort ' at line 1


1: query called at /var/www/html/dell24.pl/public_html/lib/class.db.php on line 118
2: getAll called at /var/www/html/dell24.pl/public_html/modules/shop/models/m_product.php on line 88
3: getProductsFromAddonsGroup called at /var/www/html/dell24.pl/public_html/modules/shop/models/m_product.php on line 106
4: getAllPromotedAddons called at /var/www/html/dell24.pl/public_html/modules/shop/controllers/c_product.php on line 281
5: view called at /var/www/html/dell24.pl/public_html/lib/FrontController.php on line 102
6: dispatch called at /var/www/html/dell24.pl/public_html/index.php on line 72

---