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 (2035, 1299, 1300, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1627, 1628, 1684, 1863, 1873, 1874, 1966, 1968, 1629, 1630, 1631, 1632, 1633, 1634, 1649, 1974, 1975, 1988, 1992, 2028, 2097, 2222, 1864, 1905, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 2101, 885) 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] => 2035
[save_view_results] => product_id
[cid] => 2035
[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] => 79870
[product] => Hotpot 3 Pcs Set
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[1] => Array
(
[product_id] => 76440
[product] => Pocket Gram Scale
[company_name] => Ali
[product_type] => P
[parent_product_id] => 0
)
[2] => Array
(
[product_id] => 76156
[product] => Hot Water Tap Instant Heating Electric Water Heater Faucet, instant electric water heater tap, instant electric geyser, Electric Water Tap, Water Heater, Shock Proof, Digital Display with Shower Head for kitchen and bathroom, Water Geezer
[company_name] => Taheri Supplies
[product_type] => P
[parent_product_id] => 0
)
[3] => Array
(
[product_id] => 75852
[product] => Crystal Sugar Pot
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[4] => Array
(
[product_id] => 75850
[product] => Stainless Steel Travel Coffee Mugs With Lids 1 Piece
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[5] => Array
(
[product_id] => 75611
[product] => Air Tight 3.74 Litre Round Storage Box Sealed B Round 3 Piece
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[6] => Array
(
[product_id] => 75604
[product] => (5.7 litre) Air tight 3 Pieces Food Container Set Microbox
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[7] => Array
(
[product_id] => 75600
[product] => DEAL 14 PACK OF 3 BOTTLES ( ICE SPLASH)
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[8] => Array
(
[product_id] => 75591
[product] => Set Of 12 Tropical Unbreakable Glasses
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[9] => Array
(
[product_id] => 75589
[product] => (Deal 11) 3 Piece Dustbins Pack Clean & Green
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[10] => Array
(
[product_id] => 75587
[product] => (Deal 9) 6 Jars Set With Seal Cereal Flavor Pack
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[11] => Array
(
[product_id] => 75586
[product] => 3 Jars Set With Seal Cereal Flavor Pack
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[12] => Array
(
[product_id] => 75581
[product] => Family Pack Of 10 Boxes High Capacity Jars
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[13] => Array
(
[product_id] => 75579
[product] => 2 JUGS SET COMBO
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[14] => Array
(
[product_id] => 75575
[product] => PACK OF 6 FOOD CONTAINERS (total litre 2.764L)
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[15] => Array
(
[product_id] => 75573
[product] => SUPER BOXES !! (Total 10 litre) Pack OF 5 High Capacity
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[16] => Array
(
[product_id] => 75179
[product] => Vintage Marble Onyx Plate - 12 inches
[company_name] => The Kraft Man
[product_type] => P
[parent_product_id] => 0
)
[17] => Array
(
[product_id] => 74691
[product] => (Deal 1) Pack of 10 Food Boxes (Total 5.346 Litre)
[company_name] => tpw family
[product_type] => P
[parent_product_id] => 0
)
[18] => Array
(
[product_id] => 74362
[product] => Kitchen Whisk Semi Automatic Pull and Whisk 1 Piece
[company_name] => Arham Ali Traders
[product_type] => P
[parent_product_id] => 0
)
[19] => Array
(
[product_id] => 74365
[product] => EF 24-105 Mm Camera Lens Cup
[company_name] => Arham Ali Traders
[product_type] => P
[parent_product_id] => 0
)
[20] => Array
(
[product_id] => 74366
[product] => Wooden Pepper Mill Pepper Grinder Spice Grinder
[company_name] => Arham Ali Traders
[product_type] => P
[parent_product_id] => 0
)
)