string(1130) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '2' 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 oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '2' 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 oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '324' GROUP BY p.product_id ORDER BY LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,100"
INTEL
Para seguimiento de su compra, haga clic acá

INTEL


INTEL

3849

INTEL

12475

INTEL

12474

INTEL

14675

INTEL

13532

INTEL

13670

INTEL

14109

INTEL

15138

INTEL

10415

INTEL

11128

INTEL

9967

INTEL

8545

INTEL

12602

INTEL

8983

INTEL

11423

INTEL

11216

INTEL

9966

INTEL

9965

INTEL

11527

INTEL

11683

INTEL

10700

INTEL

9964

INTEL

14319

INTEL

11999

INTEL

14856

Mostrando del 1 al 34 de 34 (1 páginas)