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 (1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1204, 1205, 1473, 1694, 2207) 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] => 1186
    [save_view_results] => product_id
    [cid] => 1186
    [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] => 79940
            [product] => Men Fashion Copper Ring, Premium Quality Sizes Available
            [company_name] => Luxurify
            [product_type] => P
            [parent_product_id] => 0
        )

    [1] => Array
        (
            [product_id] => 75912
            [product] => Aqeeq Black With Chandi Ring
            [company_name] => Friends Enterprises
            [product_type] => P
            [parent_product_id] => 0
        )

    [2] => Array
        (
            [product_id] => 75796
            [product] => Beautiful Enamel Crystal Flower Lily Brooch Pearl Brooch Pins Elegant Gold Tone Flower Brooches Colorful Intertwining Flower Plant Fashion Pin Brooch Safty Shawl Pin Clip
            [company_name] => Muskan Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [3] => Array
        (
            [product_id] => 75793
            [product] => Modern Stylish Drop Earrings For Women Girls Fashion Trendy Earrings Unique Classy Light Weight/ Ladies New Style Earrings 1 Pair
            [company_name] => Muskan Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [4] => Array
        (
            [product_id] => 75787
            [product] => Fashion Revolving Flower Rhinestone Brooch Pin Colorful Crystal Lapel Pin Corsages Scarf Clips Brooches for Women Girls
            [company_name] => Muskan Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [5] => Array
        (
            [product_id] => 75781
            [product] => Fashion Flower Rhinestone Brooch Pin Colorful Crystal Lapel Pin Corsages Scarf Clips Brooches for Women Girls
            [company_name] => Muskan Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [6] => Array
        (
            [product_id] => 75455
            [product] => DJ Perfect Bezel Style Men's Ring Gift Ring For Men's
            [company_name] => Dijital Jewlery DJ
            [product_type] => P
            [parent_product_id] => 0
        )

    [7] => Array
        (
            [product_id] => 74728
            [product] => Kashmiri - Pashto Matha Patti  For  Girls / Women
            [company_name] => STITCHIGH
            [product_type] => P
            [parent_product_id] => 0
        )

    [8] => Array
        (
            [product_id] => 71373
            [product] => Silver/Bronze Thor Ax/Hammer Locket/Necklace/Pendant For Men/Boys
            [company_name] => MNS Enterprises
            [product_type] => P
            [parent_product_id] => 0
        )

    [9] => Array
        (
            [product_id] => 61167
            [product] => Luxury Original Titanium Long Lasting Steel Men Ring Black Plated Finger Ring for Men
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [10] => Array
        (
            [product_id] => 59266
            [product] => Pack Of 6 Friendship Band Bracelet Hand Band
            [company_name] => Acme Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [11] => Array
        (
            [product_id] => 59265
            [product] => Pack Of 12 Friendship Band Bracelet Hand Band
            [company_name] => Acme Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [12] => Array
        (
            [product_id] => 59264
            [product] => Pack Of 24 Friendship Band Bracelet Hand Band
            [company_name] => Acme Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [13] => Array
        (
            [product_id] => 58521
            [product] => Silver/Golden Knot Cufflinks for Men
            [company_name] => Times of Digital
            [product_type] => P
            [parent_product_id] => 0
        )

    [14] => Array
        (
            [product_id] => 58039
            [product] => 14 August Pakistan Independence Day Wrist Band for Men and Women (Pack of 2 Band)
            [company_name] => ZH Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [15] => Array
        (
            [product_id] => 58037
            [product] => 14 August Pakistan Independence Day Wrist Band for Men and Women (Single Band) 1 Piece
            [company_name] => ZH Mart
            [product_type] => P
            [parent_product_id] => 0
        )

    [16] => Array
        (
            [product_id] => 55758
            [product] => Custom Made 24K Gold Plated Name Cufflinks Personalized/Bespoke Monogram Necklace with Chain TA 44
            [company_name] => Trendy Aleena
            [product_type] => P
            [parent_product_id] => 0
        )

    [17] => Array
        (
            [product_id] => 55729
            [product] => Custom Made 24K Gold Plated Name Cufflinks Personalized/Bespoke Monogram Necklace with Chain TA 15
            [company_name] => Trendy Aleena
            [product_type] => P
            [parent_product_id] => 0
        )

    [18] => Array
        (
            [product_id] => 43893
            [product] => Beautiful Neckwear Pendent Stone Only
            [company_name] => Megamall Islamabad
            [product_type] => P
            [parent_product_id] => 0
        )

    [19] => Array
        (
            [product_id] => 37782
            [product] => Ornament 1 Karat Ethnic pearl earring
            [company_name] => Shahnaz Collection
            [product_type] => P
            [parent_product_id] => 0
        )

    [20] => Array
        (
            [product_id] => 20824
            [product] => Premium Quality Pendant & Locket For Men
            [company_name] => Quality Shop Express
            [product_type] => P
            [parent_product_id] => 0
        )

)