SELECT (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100)) GROUP BY product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
C
Array
(
[0] => Array
(
[product_id] => 13927
[product] => Ginseng Essence Water | 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 735
[product_ids] => 13927
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[1] => Array
(
[product_id] => 31326
[product] => Royal Honey Propolis Enrich Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 31326
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[2] => Array
(
[product_id] => 26971
[product] => Ginseng essence water deluxe - 40ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 26971
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[3] => Array
(
[product_id] => 27066
[product] => Sake Glass-Glow Essence - 80ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 502
[product_ids] => 27066
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[4] => Array
(
[product_id] => 31330
[product] => Argan Oil Silk Plus Hair Essence - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_ids] => 31330
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[5] => Array
(
[product_id] => 6090
[product] => Glow Potion Essence Toner - Hydrating & Plumping - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 71
[product_ids] => 6090
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[6] => Array
(
[product_id] => 13800
[product] => Sun Project Light Sun Essence SPF50+ PA+++(40ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13800
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[7] => Array
(
[product_id] => 13801
[product] => Sun Project Shimmer Sun Essence SPF30 PA++
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13801
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[8] => Array
(
[product_id] => 13889
[product] => Phyto Niacin Brightening Essence - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13889
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[9] => Array
(
[product_id] => 13907
[product] => Snail Repair Intensive Essence - 100 ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13907
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[10] => Array
(
[product_id] => 14825
[product] => Hyaluronic Acid Water Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 14825
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[11] => Array
(
[product_id] => 14838
[product] => Black Rice Hyaluronic Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 14838
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[12] => Array
(
[product_id] => 17025
[product] => Parijat Essence of Natural Shine Soap Bar for Men and Women- 125gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17025
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[13] => Array
(
[product_id] => 17027
[product] => Rose Essence of Fragrant Beauty Soap Bar for Men and Women - 125gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17027
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[14] => Array
(
[product_id] => 17051
[product] => Lady M Fragrance Body Mist for Men & Women With Essence of Femininity 100 ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17051
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[15] => Array
(
[product_id] => 17741
[product] => Acne Control Spot Essence Ex - 15gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 17741
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[16] => Array
(
[product_id] => 18073
[product] => Numero 10 Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 18073
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[17] => Array
(
[product_id] => 30109
[product] => All Around Safe Block Essence Sun SPF45 PA+++_2018 - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 30109,30109
[product_types] => P,P
[parent_product_ids] => 0,0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[18] => Array
(
[product_id] => 30148
[product] => Time Revolution The First Essence 5X - 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 716
[product_ids] => 30148
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[19] => Array
(
[product_id] => 30949
[product] => Exotic Essentials Essence Herbal Soap Bar - 125 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 562
[product_ids] => 30949
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[20] => Array
(
[product_id] => 30958
[product] => Natural Rose Essence Herbal Soap Bar - 125 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 562
[product_ids] => 30958
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[21] => Array
(
[product_id] => 31304
[product] => I'M Gentle All In 1 Essence - 130ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 719
[product_ids] => 31304
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[22] => Array
(
[product_id] => 31305
[product] => I'M Aqua Sun Essence SPF50+ PA++++ - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 719
[product_ids] => 31305,31305
[product_types] => P,P
[parent_product_ids] => 0,0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[23] => Array
(
[product_id] => 31333
[product] => Pantothenic Water Parsley Silence Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_ids] => 31333
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
)
SELECT (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100)) GROUP BY product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
SELECT COUNT(*) FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100))
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
[3] => categories
[4] => description
[5] => description
[6] => full_description
[7] => categories
[8] => sales
[9] => companies
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 24
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
[show_master_products_only] =>
[currency] => USD
[sort_order] => desc
[sl] => en
[dispatch] => categories.view
[category_id] => 1901
[save_view_results] => product_id
[sort_by] => bestsellers
[subcats] => Y
[runtime_company_id] => 0
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => feature
[value] => 10351,36598
[value_name] =>
)
[2] => Array
(
[operator] => in
[condition] => products
[value] => 3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100
)
)
)
[include_child_variations] => 1
[hide_out_of_stock_products] =>
[for_current_storefront] => 1
[company_status] => A
[usergroup_ids] => Array
(
[0] => 0
[1] => 1
)
[group_child_variations] => 1
[sort_order_rev] => asc
[total_items] => 30
)
SELECT (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100)) GROUP BY product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
C
Array
(
[0] => Array
(
[product_id] => 13927
[product] => Ginseng Essence Water | 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 735
[product_ids] => 13927
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[1] => Array
(
[product_id] => 31326
[product] => Royal Honey Propolis Enrich Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 31326
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[2] => Array
(
[product_id] => 26971
[product] => Ginseng essence water deluxe - 40ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 26971
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[3] => Array
(
[product_id] => 27066
[product] => Sake Glass-Glow Essence - 80ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 502
[product_ids] => 27066
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[4] => Array
(
[product_id] => 31330
[product] => Argan Oil Silk Plus Hair Essence - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_ids] => 31330
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[5] => Array
(
[product_id] => 6090
[product] => Glow Potion Essence Toner - Hydrating & Plumping - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 71
[product_ids] => 6090
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[6] => Array
(
[product_id] => 13800
[product] => Sun Project Light Sun Essence SPF50+ PA+++(40ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13800
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[7] => Array
(
[product_id] => 13801
[product] => Sun Project Shimmer Sun Essence SPF30 PA++
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13801
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[8] => Array
(
[product_id] => 13889
[product] => Phyto Niacin Brightening Essence - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13889
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[9] => Array
(
[product_id] => 13907
[product] => Snail Repair Intensive Essence - 100 ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 13907
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[10] => Array
(
[product_id] => 14825
[product] => Hyaluronic Acid Water Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 14825
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[11] => Array
(
[product_id] => 14838
[product] => Black Rice Hyaluronic Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 14838
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[12] => Array
(
[product_id] => 17025
[product] => Parijat Essence of Natural Shine Soap Bar for Men and Women- 125gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17025
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[13] => Array
(
[product_id] => 17027
[product] => Rose Essence of Fragrant Beauty Soap Bar for Men and Women - 125gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17027
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[14] => Array
(
[product_id] => 17051
[product] => Lady M Fragrance Body Mist for Men & Women With Essence of Femininity 100 ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 350
[product_ids] => 17051
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[15] => Array
(
[product_id] => 17741
[product] => Acne Control Spot Essence Ex - 15gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 17741
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[16] => Array
(
[product_id] => 18073
[product] => Numero 10 Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 18073
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[17] => Array
(
[product_id] => 30109
[product] => All Around Safe Block Essence Sun SPF45 PA+++_2018 - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_ids] => 30109,30109
[product_types] => P,P
[parent_product_ids] => 0,0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[18] => Array
(
[product_id] => 30148
[product] => Time Revolution The First Essence 5X - 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 716
[product_ids] => 30148
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[19] => Array
(
[product_id] => 30949
[product] => Exotic Essentials Essence Herbal Soap Bar - 125 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 562
[product_ids] => 30949
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[20] => Array
(
[product_id] => 30958
[product] => Natural Rose Essence Herbal Soap Bar - 125 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 562
[product_ids] => 30958
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[21] => Array
(
[product_id] => 31304
[product] => I'M Gentle All In 1 Essence - 130ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 719
[product_ids] => 31304
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[22] => Array
(
[product_id] => 31305
[product] => I'M Aqua Sun Essence SPF50+ PA++++ - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 719
[product_ids] => 31305,31305
[product_types] => P,P
[parent_product_ids] => 0,0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[23] => Array
(
[product_id] => 31333
[product] => Pantothenic Water Parsley Silence Essence - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_ids] => 31333
[product_types] => P
[parent_product_ids] => 0
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
)
SELECT (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100)) GROUP BY product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
SELECT COUNT(*) FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100))
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
[3] => categories
[4] => description
[5] => description
[6] => full_description
[7] => categories
[8] => sales
[9] => companies
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 24
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
[show_master_products_only] =>
[currency] => USD
[sort_order] => desc
[sl] => en
[dispatch] => categories.view
[category_id] => 1901
[save_view_results] => product_id
[sort_by] => bestsellers
[subcats] => Y
[runtime_company_id] => 0
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => feature
[value] => 10351,36598
[value_name] =>
)
[2] => Array
(
[operator] => in
[condition] => products
[value] => 3964,3970,4792,5137,5173,5446,6090,10738,13800,13801,13868,13889,13907,13927,13939,13952,14825,14838,16093,16094,17025,17027,17051,17741,18072,18073,18074,19824,24913,26971,27066,27511,27709,28541,28558,28575,28980,29371,30077,30109,30118,30148,30192,30338,30339,30949,30958,31304,31305,31326,31330,31333,31341,31350,31356,31363,31386,31484,31563,31881,32010,32024,32031,32048,32090,32119,32135,32139,32155,32156,32169,32183,32189,32223,32235,32236,32237,32306,32434,32494,32516,33079,33100
)
)
)
[include_child_variations] => 1
[hide_out_of_stock_products] =>
[for_current_storefront] => 1
[company_status] => A
[usergroup_ids] => Array
(
[0] => 0
[1] => 1
)
[group_child_variations] => 1
[sort_order_rev] => asc
[total_items] => 30
)
All orders 
Sort by
Filters
Free shipping on
5 days
100% authentic,
1M+ units sold
