SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_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 (?:categories.usergroup_ids = '' OR FIND_IN_SET(0, ?:categories.usergroup_ids) OR FIND_IN_SET(1, ?:categories.usergroup_ids)) AND ?:categories.status IN ('A', 'H') WHERE 1 AND ?:categories.category_id IN (1685, 1686, 1687, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 2104, 2132, 2006) AND companies.status = 'A' 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.amount != '0' AND products.parent_product_id = 0 AND products.product_type != 'D' GROUP BY products.product_id ORDER BY products.timestamp desc, products.product_id ASC LIMIT 0, 21
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
[3] => categories
[4] => description
[5] => 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] => 21
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[dispatch] => categories.view
[category_id] => 1685
[save_view_results] => product_id
[cid] => 1685
[subcats] => Y
[sort_by] => timestamp
[sort_order] => desc
[include_child_variations] =>
[group_child_variations] =>
[parent_product_id] => 0
[sort_order_rev] => asc
)
Array
(
[0] => Array
(
[product_id] => 80091
[product] => Philips LED Bulb 15W B-22 DL - Pin Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[1] => Array
(
[product_id] => 80090
[product] => Philips LED Bulb 13W B-22 DL - Pin Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[2] => Array
(
[product_id] => 80089
[product] => Philips LED Bulb 10W B-22 DL - Pin Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[3] => Array
(
[product_id] => 77730
[product] => New latest design Letter Happy Birthday lamp LED String Lights Home kids Children boys girls Birthday baby shower Party Decoration
[company_name] => Taheri Supplies
[product_type] => P
[parent_product_id] => 0
)
[4] => Array
(
[product_id] => 77479
[product] => Philips ESS LED Bulb 10W B22 3000K 230V 1CT/48 PK. - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[5] => Array
(
[product_id] => 77480
[product] => Philips ESS LED Bulb 10W B22 6500K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[6] => Array
(
[product_id] => 77481
[product] => Philips ESS LED Bulb 10W E27 3000K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[7] => Array
(
[product_id] => 77482
[product] => Philips ESS LED Bulb 10W E27 6500K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[8] => Array
(
[product_id] => 77483
[product] => Philips ESS LED Bulb 13W B22 3000K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[9] => Array
(
[product_id] => 77484
[product] => Philips ESS LED Bulb 13W B22 6500K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[10] => Array
(
[product_id] => 77485
[product] => Philips ESS LED Bulb 13W E27 3000K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[11] => Array
(
[product_id] => 77486
[product] => Philips ESS LED Bulb 13W E27 6500K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[12] => Array
(
[product_id] => 77487
[product] => Philips ESS LED Bulb 15W B22 3000K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[13] => Array
(
[product_id] => 77488
[product] => Philips ESS LED Bulb 15W B22 6500K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[14] => Array
(
[product_id] => 77489
[product] => Philips ESS LED Bulb 15W E27 3000K 230V 1CT/48 PK - Screw Bulb
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[15] => Array
(
[product_id] => 77490
[product] => Philips 59442 MESON 080 5W 30K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[16] => Array
(
[product_id] => 77491
[product] => Philips 59442 MESON 080 5W 40K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[17] => Array
(
[product_id] => 77492
[product] => Philips 59442 MESON 080 5W 65K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[18] => Array
(
[product_id] => 77493
[product] => Philips 59443 MESON 080 7W 30K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[19] => Array
(
[product_id] => 77494
[product] => Philips 59443 MESON 080 7W 65K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
[20] => Array
(
[product_id] => 77495
[product] => Philips 59449 MESON 105 9W 30K WH recessed LED
[company_name] => Philips Lighting
[product_type] => P
[parent_product_id] => 0
)
)