SELECT p.product_id, (SELECT AVG(rating) AS total FROM toptel_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM toptel_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM toptel_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM toptel_product p LEFT JOIN toptel_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN toptel_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '75' GROUP BY p.product_id ORDER BY p.quantity DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,13
Scosche
Найдено в категориях
Артикул: BI-0814 Кабель Lightning Scosche SyncAbel Black (HDI310) 1.8 м

890 грн

Артикул: BI-0002 AUX кабель Scosche AdaptTour (IU335K)

580 грн

Артикул: BI-0003 AUX кабель Scosche Auxmic

957 грн

Артикул: BI-0035 AUX кабель Scosche FlatOut (AUX3FBK)

560 грн

Артикул: BI-0036 AUX кабель Scosche FlatOut (AUX3FBL)

499 грн

Артикул: BI-0037 AUX кабель Scosche FlatOut (AUX3FG)

499 грн

Артикул: BI-0039 AUX кабель Scosche FlatOut (AUX3FR)

499 грн

Артикул: BI-0132 AUX кабель Scosche RePlay (IU3.5RC)

475 грн

Артикул: BI-0173 AUX кабель Scosche TapLine II (IRM355)

696 грн

Артикул: BI-0067 AUX-кабель Scosche hookUP FlatOut Black 1.8 м

435 грн

Артикул: BI-0074 Bluetooth-гарнитура Scosche jabberJAW II (BTHS200)

1 199 грн

Артикул: BI-0182 Bluetooth-наушники Scosche TuneStream II (HZ8)

2 870 грн

Артикул: BI-0183 Bluetooth-наушники Scosche TuneStream sport (HFBT200)

2 755 грн

Показать еще
15 товаров