clothing
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='248' 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
-
0-6M
700
6-12M
700
12-18M
700
2T
800
800
-
0-6M
1400
6-12M
700
12-18M
700
2T
800
800
-
0-6M
600
6-12M
600
2T
680
3T
680
4Y
720
5Y
720
6T
720
7Y-8Y
780
9Y-10Y
780
780
-
0-6M
490
6-12M
490
12-18M
490
2T
520
3T
520
4Y
600
5Y
600
6T
600
7Y-8Y
680
9Y-10Y
680
680
-
2T
740
3T
740
4T
860
5Y
860
6Y
860
860
-
0-6M
650
6-12M
650
12-18M
650
2T
680
3T
680
4Y
750
5T
750
6T
750
7Y-8Y
800
9Y-10Y
800
800
-
-
18-24M
800
2T
800
3T
800
12-18M
700
7T
1200
8T
1200
9T
1200
1200
-
0-6M
800
6-12M
800
12-18M
800
2T
850
3T
850
4T
900
5T
900
6T
900
7T
990
8T
990
9T
990
990
-
0-6M
700
12-18M
700
2T
800
3T
800
18X24M
800
4T
900
5T
900
6T
900
7T
1200
8T
1200
9T
1200
1200
-
12-18M
350
2T
450
6-12M
350
350
-
0-6M
800
6-12M
800
5T
990
7T
1200
8T
1200
10T
1200
9T
1200
1200
-
2T
520
3T
520
4T
580
5T
580
580
-
2T
520
3T
520
4T
580
5T
580
580
-
2T
520
3T
520
4T
580
5T
580
580
-
2T
520
3T
520
4T
580
5T
580
580
-
-
2T
1600
3T
1600
4T
1700
5T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
3T
1600
4T
1700
5T
1700
6T
1700
1700
-
2T
1600
3T
1600
4T
1700
5T
1700
1700
-
2T
680
3T
680
6T
720
7T
780
8T
780
780
-
6-12M
580
12-18M
580
18X24M
640
2T
640
640
-
-
0-6M
500
6-12M
500
12-18M
500
500
-
0-6M
500
6-12M
500
12-18M
500
500
-
-
-
0-6M
500
6-12M
500
12-18M
500
500
-
-
0-6M
350
6-12M
350
12-18M
350
2T
450
450
-
2T
450
3T
450
4T
500
5T
500
6T
500
500
-
2T
450
3T
450
4T
500
5T
500
6T
500
0-6M
350
6-12M
350
12-18M
350
350
-
0-6M
450
6-12M
450
12-18M
450
2T
480
3T
480
5T
550
6T
550
7T
620
8T
620
12T
620
620
-
0-6M
550
6-12M
550
12-18M
550
2T
600
3T
600
4T
650
5T
650
6T
650
7Y-8Y
700
9Y-10Y
700
11Y-12Y
750
750
-
0-6M
700
2T
800
9Y-10Y
1200
1200
-
12-18M
600
6-12M
600
0-6M
600
2T
680
680
-
0-6M
800
6-12M
800
3T
850
4T
900
5T
900
6T
900
7T
990
8T
990
9T
990
10T
990
990
-
0-6M
800
6-12M
800
12-18M
800
2T
850
3T
850
4T
900
5T
900
6T
900
7T
990
8T
990
9T
990
10T
990
990
-