Array
(
[0] => Array
(
[product_id] => 8110
[product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[1] => Array
(
[product_id] => 8118
[product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[2] => Array
(
[product_id] => 8121
[product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[3] => Array
(
[product_id] => 8123
[product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[4] => Array
(
[product_id] => 8125
[product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[5] => Array
(
[product_id] => 8139
[product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[6] => Array
(
[product_id] => 8147
[product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[7] => Array
(
[product_id] => 8639
[product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[8] => Array
(
[product_id] => 8640
[product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[9] => Array
(
[product_id] => 12049
[product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[10] => Array
(
[product_id] => 15153
[product] => Women's Health Trail Mix, Roasted Almonds, Cashews, Walnuts, Pista and Mixed Seeds - 200g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[11] => Array
(
[product_id] => 15156
[product] => Ajwa Dates - 350g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[12] => Array
(
[product_id] => 15158
[product] => Brazil Nuts - 150g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[13] => Array
(
[product_id] => 15159
[product] => Nutty Grtties Raw Pine Nuts - 100g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[14] => Array
(
[product_id] => 16291
[product] => Premium California Whole Almonds - 500 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[15] => Array
(
[product_id] => 18186
[product] => Premium California Whole Almonds - Pack of 2 - 500 gm each
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[16] => Array
(
[product_id] => 26214
[product] => Whole Almonds - 500gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[17] => Array
(
[product_id] => 31750
[product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[18] => Array
(
[product_id] => 35781
[product] => Ambrosia Bakers Delight Combo 500g -Walnut Kernels Light Broken & Blackcurrant
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[19] => Array
(
[product_id] => 35782
[product] => Ambrosia Bakers Delight Combo 750g - Cranberries, Blackcurrants & Raisins
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[20] => Array
(
[product_id] => 36555
[product] => California Pitted Prunes, Dried Fruit Plums - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[21] => Array
(
[product_id] => 36557
[product] => Indian Long Raisins, Seedless Premium Green Raisins, Kishmish, Healthy Snack - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[22] => Array
(
[product_id] => 36558
[product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants Jar Pack- 250 (5 Pack of 50g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[23] => Array
(
[product_id] => 36564
[product] => Sports Mix (Pack of 6 x 40g each) - 240g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
)
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, 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.parent_product_id = 0 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 (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 72, 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.parent_product_id = 0 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 (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006))
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] => 4
[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] => 2421
[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] => products
[value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006
)
)
)
[hide_out_of_stock_products] =>
[for_current_storefront] => 1
[company_status] => A
[usergroup_ids] => Array
(
[0] => 0
[1] => 1
)
[include_child_variations] =>
[group_child_variations] =>
[parent_product_id] => 0
[sort_order_rev] => asc
[total_items] => 152
)
Array
(
[0] => Array
(
[product_id] => 8110
[product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[1] => Array
(
[product_id] => 8118
[product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[2] => Array
(
[product_id] => 8121
[product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[3] => Array
(
[product_id] => 8123
[product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[4] => Array
(
[product_id] => 8125
[product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[5] => Array
(
[product_id] => 8139
[product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[6] => Array
(
[product_id] => 8147
[product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[7] => Array
(
[product_id] => 8639
[product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[8] => Array
(
[product_id] => 8640
[product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[9] => Array
(
[product_id] => 12049
[product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[10] => Array
(
[product_id] => 15153
[product] => Women's Health Trail Mix, Roasted Almonds, Cashews, Walnuts, Pista and Mixed Seeds - 200g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[11] => Array
(
[product_id] => 15156
[product] => Ajwa Dates - 350g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[12] => Array
(
[product_id] => 15158
[product] => Brazil Nuts - 150g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[13] => Array
(
[product_id] => 15159
[product] => Nutty Grtties Raw Pine Nuts - 100g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[14] => Array
(
[product_id] => 16291
[product] => Premium California Whole Almonds - 500 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[15] => Array
(
[product_id] => 18186
[product] => Premium California Whole Almonds - Pack of 2 - 500 gm each
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[16] => Array
(
[product_id] => 26214
[product] => Whole Almonds - 500gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[17] => Array
(
[product_id] => 31750
[product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[18] => Array
(
[product_id] => 35781
[product] => Ambrosia Bakers Delight Combo 500g -Walnut Kernels Light Broken & Blackcurrant
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[19] => Array
(
[product_id] => 35782
[product] => Ambrosia Bakers Delight Combo 750g - Cranberries, Blackcurrants & Raisins
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[20] => Array
(
[product_id] => 36555
[product] => California Pitted Prunes, Dried Fruit Plums - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[21] => Array
(
[product_id] => 36557
[product] => Indian Long Raisins, Seedless Premium Green Raisins, Kishmish, Healthy Snack - 400g (2 Pack of 200g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[22] => Array
(
[product_id] => 36558
[product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants Jar Pack- 250 (5 Pack of 50g each)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
[23] => Array
(
[product_id] => 36564
[product] => Sports Mix (Pack of 6 x 40g each) - 240g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 61
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
)
)
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, 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.parent_product_id = 0 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 (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 72, 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.parent_product_id = 0 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 (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006))
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] => 4
[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] => 2421
[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] => products
[value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006
)
)
)
[hide_out_of_stock_products] =>
[for_current_storefront] => 1
[company_status] => A
[usergroup_ids] => Array
(
[0] => 0
[1] => 1
)
[include_child_variations] =>
[group_child_variations] =>
[parent_product_id] => 0
[sort_order_rev] => asc
[total_items] => 152
)
All orders 
Sort by
Filters
Free shipping on
5 days
100% authentic,
1M+ units sold
