view all
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='226' 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
-
Small
2300
Medium
2300
Large
2300
2300
-
-
-
-
X-Small
1700
Small
1700
Medium
1700
Large
1700
X-Large
1700
1700
-
Small
6400
Medium
6400
Large
6400
X-Large
6400
6400
-
Small
2500
Medium
2500
Large
2500
X-Large
2500
2500
-
Small
990
Medium
990
Large
990
990
-
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
-
-
-
X-Small
990
Small
990
Medium
990
Large
990
X-Large
990
990
-
X-Small
1500
Small
1500
Medium
1500
Large
1500
X-Large
1500
1500
-
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
-
-
-
Small
1200
Medium
1200
Large
1200
1200
-
X-Small
1500
Small
1500
Medium
1500
Large
1500
X-Large
1500
1500
-
-
-
Small
1400
Medium
1400
Large
1400
X-Large
1400
1400
-
-
-
60" x 60" (4 Seater)
990
60" x 90" (6 Seater)
1400
72" x 108" (8 Seater)
2100
2100
-
60" x 60" (4 Seater)
990
60" x 90" (6 Seater)
1400
72" x 108" (8 Seater)
2100
2100
-
X-Small
2140
Small
2140
Medium
2140
Large
2140
X-Large
2140
2140
-
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
-
-
-
Small
1400
Medium
1400
Large
1400
X-Large
1400
1400
-
-
-
sandal
350
Neem Tulsi
350
350
-
-
Small
1400
Medium
1400
Large
1400
X-Large
1400
1400
-
Small
1400
X-Large
1400
Medium
1400
Large
1400
1400
-
-
-
-
Medium
800
Large
800
X-Large
800
800
-
-
X-Small
1500
Small
1500
Medium
1500
Large
1500
X-Large
1500
1500
-
X-Small
1150
Small
1150
Medium
1150
Large
1150
X-Large
1150
1150
-
X-Small
1150
Small
1150
Medium
1150
Large
1150
X-Large
1150
1150
-
X-Small
1350
Small
1350
Medium
1350
Large
1350
1350
-
X-Small
1900
Small
1900
Medium
1900
Large
1900
1900
-
X-Small
1200
Small
1200
Medium
1200
Large
1200
X-Large
1200
1200
-
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
1150
Small
1150
Medium
1150
Large
1150
X-Large
1150
1150
-
X-Small
1200
Small
1200
Medium
1200
Large
1200
X-Large
1200
1200
-
X-Small
1200
Large
1200
Small
1200
Medium
1200
X-Large
1200
1200
-
-
-
X-Small
1700
Small
1700
Medium
1700
Large
1700
X-Large
1700
1700
-
X-Small
2400
Small
2400
Medium
2400
Large
2400
X-Large
2400
2400
-
X-Small
1150
Small
1150
Medium
1150
Large
1150
X-Large
1150
1150
-
X-Small
1500
Small
1500
Medium
1500
Large
1500
1500
-
X-Small
1200
Small
1200
Medium
1200
X-Large
1200
1200
-
Small
900
Medium
900
Large
900
900
-
X-Small
900
Small
900
Medium
900
Large
900
X-Large
900
900
-
-
X-Small
1200
Small
1200
Medium
1200
Large
1200
X-Large
1200
1200
-
Small
2400
Medium
2400
Large
2400
X-Large
2400
2400
-
X-Small
2400
Small
2400
Medium
2400
Large
2400
X-Large
2400
2400
-
X-Small
980
Small
980
Medium
980
Large
980
X-Large
980
980
-
-
-
X-Small
2100
Small
2100
Medium
2100
Large
2100
X-Large
2100
2100
-
X-Small
2100
Small
2100
Medium
2100
Large
2100
X-Large
2100
2100
-
-
X-Small
2300
Small
2300
Medium
2300
Large
2300
X-Large
2300
2300
-
X-Small
1400
Small
1400
Medium
1400
Large
1400
X-Large
1400
+1
1400
1400
-
X-Small
1400
Small
1400
Medium
1400
Large
1400
+1
1400
1400
-
X-Small
2300
Small
2300
Medium
2300
Large
2300
X-Large
2300
2300
-
18-24M
800
2T
800
3T
800
12-18M
700
7T
1200
8T
1200
9T
1200
1200
-
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
-
X-Small
2200
Small
2200
Medium
2200
Large
2200
X-Large
2200
2200
-
Small
1450
Medium
1450
Large
1450
X-Large
1450
1450
-
X-Small
1800
Small
1800
Medium
1800
Large
1800
X-Large
1800
1800
-
Small
1900
Medium
1900
Large
1900
1900
-
-
-
Small
2640
Medium
2640
Large
2640
2640
-
-
Medium
4400
Large
4400
Small
4400
4400
-
Medium
4400
Small
4400
Large
4400
4400
-
Medium
4400
Small
4400
Large
4400
4400
-
-
-
X-Small
3400
Small
3400
Medium
3400
Large
3400
X-Large
3400
3400
-
X-Small
3400
Small
3400
Medium
3400
Large
3400
X-Large
3400
3400
-
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
-
Small
1200
Medium
1200
Large
1200
1200
-
-
Small
2640
Medium
2640
Large
2640
2640
-
X-Small
2640
Small
2640
Medium
2640
Large
2640
2640
-
X-Small
1200
Small
1200
Medium
1200
Large
1200
X-Large
1200
1200
-
Small
900
Medium
900
Large
900
900
-
X-Small
1450
Small
1450
Medium
1450
Large
1450
X-Large
1450
1450
-
X-Small
1450
Small
1450
Medium
1450
Large
1450
X-Large
1450
1450
-
X-Small
1450
Small
1450
Medium
1450
Large
1450
X-Large
1450
1450
-
X-Small
2600
Small
2600
Medium
2600
Large
2600
X-Large
2600
2600
-
X-Small
1340
Small
1340
Large
1340
X-Large
1340
1340
-
-
-
-
X-Small
2100
Small
2100
Medium
2100
Large
2100
X-Large
2100
2100
-
-
X-Small
1800
Small
1800
Medium
1800
Large
1800
X-Large
1800
1800
-
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
-
X-Small
1780
Small
1780
Medium
1780
Large
1780
X-Large
1780
1780
-
Small
2140
Medium
2140
Large
2140
X-Large
2140
2140
-
Small
2140
Medium
2140
Large
2140
X-Large
2140
2140
-
Small
2640
Medium
2640
Large
2640
2640
-
Medium
900
Large
900
X-Large
900
900
-
X-Small
2350
Small
2350
Medium
2350
Large
2350
X-Large
2350
2350
-
X-Small
2350
Small
2350
Medium
2350
Large
2350
2350
-
X-Small
2350
Small
2350
Medium
2350
Large
2350
X-Large
2350
2350
-
X-Small
3200
Small
3200
Medium
3200
Large
3200
X-Large
3200
3200
-
X-Small
3200
Small
3200
Medium
3200
Large
3200
X-Large
3200
3200
-
X-Small
1200
Small
1200
Medium
1200
Large
1200
X-Large
1200
1200
-
X-Small
1300
Small
1300
Medium
1300
Large
1300
X-Large
1300
1300
-
X-Small
2200
Medium
2200
Large
2200
2200
-
X-Small
1900
Small
1900
Large
1900
Medium
1900
1900
-
-
X-Small
4200
Small
4200
Medium
4200
Large
4200
X-Large
4200
4200
-
X-Small
1280
Small
1280
Medium
1280
Large
1280
X-Large
1280
1280
-
X-Small
1900
Small
1900
Medium
1900
Large
1900
1900
-