1. 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 (2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061) 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
    
  1. 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] => 2048
        [save_view_results] => product_id
        [cid] => 2048
        [subcats] => Y
        [sort_by] => timestamp
        [sort_order] => desc
        [include_child_variations] => 
        [group_child_variations] => 
        [parent_product_id] => 0
        [sort_order_rev] => asc
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 77724
                [product] => 5 pcs DIY Latex Flower Balloons Globo's Plastic Clip Birthday Wedding Party Decoration Accessories New Year Baby Shower Balloon
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [1] => Array
            (
                [product_id] => 77738
                [product] => 6pcs Balloons Clip - Flower Stand Clip Holder for Balloons - Balloons Tie Holder Birthday Wedding Party Decoration
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [2] => Array
            (
                [product_id] => 77739
                [product] => 10 Pcs/set Mini LED Light Ball Lamp For Balloon Lantern Birthday Parties D├ęcor Kids Glow in the Dark Toys 6 Colors
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [3] => Array
            (
                [product_id] => 77740
                [product] => 10pcs Latex Balloon Clip Fixed Balloon Holder Accessories Birthday Party Car Decor Diy Balloon Arch Kit Party Decoration
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [4] => Array
            (
                [product_id] => 77747
                [product] => 5 Pieces Large Red Heart Foil Balloons 18 Size For Marriage Anniversary Engagement Helium Inflatable
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [5] => Array
            (
                [product_id] => 77748
                [product] => 16 inch Foil Balloons ITS GIRL Letter Banner for Baby Shower Decoration
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [6] => Array
            (
                [product_id] => 77749
                [product] => Party Water Popup Balloons 3 Bunches- Balloons
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [7] => Array
            (
                [product_id] => 77750
                [product] => 111Pcs/set Funny Colorful Mini Balloon Water Balloons For Children Beach Toys Outdoor Sports Swimming Pool Party Automatic Tie Magic Bunch Of Water Balloons
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [8] => Array
            (
                [product_id] => 77752
                [product] => Bride To Be 16pcs Foil Balloons for Bridal Shower Party Backdrop Wedding Celebration Decoration.
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [9] => Array
            (
                [product_id] => 77754
                [product] => Baby Shower Banner Foil Balloons for Decoration  Celebration Party
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [10] => Array
            (
                [product_id] => 77755
                [product] => Double Hole Portable Air Compressor Inflatable Electric Balloon Pump Air Balloon Pump Electric Balloon Inflator Pump - High Quality
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [11] => Array
            (
                [product_id] => 77759
                [product] => 220V Electric Balloon Inflator Pump AC Plug Double Hole Nozzle Air Compressor Inflatable Electric Balloon Pump Air Blower
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [12] => Array
            (
                [product_id] => 77760
                [product] => Portable Electric Balloon Inflator Pump High Power Air Blower EU/US Plug Two Nozzle Air Compressor Balloon Pump Air Blower Hot
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [13] => Array
            (
                [product_id] => 77763
                [product] => Baby Shower Banner Foil Balloons for Decoration Celebration Party - Good Quality
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [14] => Array
            (
                [product_id] => 77764
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons.
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [15] => Array
            (
                [product_id] => 77765
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons - Good Quality
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [16] => Array
            (
                [product_id] => 77766
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons - Yellow Color
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [17] => Array
            (
                [product_id] => 77767
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons - White Color
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [18] => Array
            (
                [product_id] => 77768
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons - Baby Pink Color
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [19] => Array
            (
                [product_id] => 77769
                [product] => 10 Color Pack of 50 -14 Inch Big Size Pearl Shape Latex  Balloons - Green Color
                [company_name] => Taheri Supplies
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [20] => Array
            (
                [product_id] => 75417
                [product] => Star Master Projector for Room 1 Piece
                [company_name] => Creacion Int
                [product_type] => P
                [parent_product_id] => 0
            )
    
    )