Tops
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='4' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='112' AND cat_index.is_parent=1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0 ORDER BY `e`.`created_at` desc, `e`.`created_at` desc LIMIT 200
-
X-Small
1700
Small
1700
Medium
1700
Large
1700
X-Large
1700
1700
-
X-Small
650
Small
650
Medium
650
Large
650
X-Large
650
650
-
Small
1800
Medium
1800
Large
1800
1800
-
Small
1800
Medium
1800
Large
1800
1800
-
-
-
Small
580
Medium
580
Large
580
X-Large
580
580
-
Small
640
Medium
640
Large
640
640
-
-
X-Small
580
Small
580
Medium
580
Large
580
X-Large
580
580
-
Medium
800
Large
800
X-Large
800
800
-
-
-
X-Small
980
Small
980
Medium
980
Large
980
X-Large
980
980
-
X-Small
1400
Small
1400
Medium
1400
Large
1400
X-Large
1400
1400
-
X-Small
1700
Small
1700
Medium
1700
Large
1700
X-Large
1700
1700
-
-
Small
900
Medium
900
Large
900
900
-
X-Small
900
Small
900
Medium
900
Large
900
X-Large
900
900
-
X-Small
980
Small
980
Medium
980
Large
980
X-Large
980
980
-
Small
1450
Medium
1450
Large
1450
X-Large
1450
1450
-
-
X-Small
1400
Small
1400
Medium
1400
Large
1400
X-Large
1400
1400
-
X-Small
750
Small
750
Medium
750
Large
750
X-Large
750
750
-
X-Small
1340
Small
1340
Large
1340
X-Large
1340
1340
-
X-Small
850
Small
850
Medium
850
Large
850
X-Large
850
850
-
X-Small
850
Small
850
Medium
850
Large
850
X-Large
850
850
-
X-Small
850
Small
850
Medium
850
Large
850
X-Large
850
850
-
Medium
900
Large
900
X-Large
900
900
-
X-Small
1280
Small
1280
Medium
1280
Large
1280
X-Large
1280
1280
-
X-Small
950
Small
950
Medium
950
Large
950
X-Large
950
950
-
X-Small
950
Small
950
Medium
950
Large
950
X-Large
950
950
-
Small
1500
Medium
1500
Large
1500
1500
-
Small
1500
Medium
1500
Large
1500
1500
-
X-Small
900
Small
900
Medium
900
Large
900
X-Large
900
900
-
X-Small
1340
Small
1340
Medium
1340
Large
1340
X-Large
1340
1340
-
X-Small
1290
Small
1290
Medium
1290
Large
1290
X-Large
1290
1290
-
Small
1180
Medium
1180
Large
1180
1180
-
Small
1180
Medium
1180
Large
1180
1180
-
Small
1700
Medium
1700
Large
1700
1700
-
Medium
1800
Large
1800
Small
1800
1800
-
X-Small
1801
Small
1801
Medium
1801
Large
1801
X-Large
1801
1801
-
Small
2600
Medium
2600
Large
2600
2600
-
-
X-Small
900
Small
900
Medium
900
Large
900
X-Large
900
900
-
X-Small
780
Small
780
Large
780
X-Large
780
780
-
X-Small
2801
Medium
2801
Large
2801
X-Large
2801
Small
2801
2801
-
X-Small
900
Small
900
Medium
900
Large
900
X-Large
900
900
-
X-Small
750
Small
750
Medium
750
Large
750
X-Large
750
750
-
-
-
-
X-Small
2200
Small
2200
Large
2200
2200
-
Small
2801
Medium
2801
Large
2801
2801
-
-
-
Small
1300
X-Small
1300
Medium
1300
Large
1300
X-Large
1300
1300
-
X-Small
1300
Small
1300
Medium
1300
Large
1300
X-Large
1300
1300
-
X-Small
1500
Small
1500
Large
1500
X-Large
1500
1500
-
-
Small
1400
X-Large
1400
Medium
1400
1400
-
-
-
X-Small
700525
Medium
700525
X-Large
700525
700525
-
X-Small
18001350
Large
18001350
X-Large
18001350
18001350
-
X-Small
18001350
Small
18001350
Medium
18001350
Large
18001350
X-Large
18001350
18001350
-
Small
900675
Medium
900675
Large
900675
900675
-
-