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 (988, 1000, 1001, 1002, 1003, 1102, 1103, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999) 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] => 988
    [save_view_results] => product_id
    [cid] => 988
    [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] => 72023
            [product] => 2 In 1 USB 3.1 Type C Type-C USB C To 3.5mm Aux Audio Headphone Jack PD Charging Power Adapter Cable
            [company_name] => REHMAT STORE
            [product_type] => P
            [parent_product_id] => 0
        )

    [1] => Array
        (
            [product_id] => 70190
            [product] => Power Cables Cord Computer Led/lcd
            [company_name] => Eimaan
            [product_type] => P
            [parent_product_id] => 0
        )

    [2] => Array
        (
            [product_id] => 70182
            [product] => WD External Hard Drive Case
            [company_name] => Eimaan
            [product_type] => P
            [parent_product_id] => 0
        )

    [3] => Array
        (
            [product_id] => 70151
            [product] => Power Cables Cord Black Color
            [company_name] => Eimaan
            [product_type] => P
            [parent_product_id] => 0
        )

    [4] => Array
        (
            [product_id] => 69231
            [product] => Type C to Micro USB cable Converter Type C To USB 3.0 OTG Adapter for MacbookPro Xiaomi Samsung phone Charging Cable charger
            [company_name] => GadgetsMall
            [product_type] => P
            [parent_product_id] => 0
        )

    [5] => Array
        (
            [product_id] => 69226
            [product] => OTG Type C Adapter OTG Type C to USB Adapter Type-C OTG Adapter Cable For Macbook Pro Air Samsung S20 S10 USB OTG
            [company_name] => GadgetsMall
            [product_type] => P
            [parent_product_id] => 0
        )

    [6] => Array
        (
            [product_id] => 69214
            [product] => 2 In 1 Audio Adapter Charging Earphone Cable For iPhone 11 12 Pro Max xXS Aux Jack Headset Lighting 3.5mm To Headphone Splitter
            [company_name] => GadgetsMall
            [product_type] => P
            [parent_product_id] => 0
        )

    [7] => Array
        (
            [product_id] => 69198
            [product] => RS232 COM Port Serial Convert Adapter 9 Pin DB9 Adapter | My Tele Shop
            [company_name] => My Tele Shop
            [product_type] => P
            [parent_product_id] => 0
        )

    [8] => Array
        (
            [product_id] => 68214
            [product] => 7-Port USB Hub USB 2.0 Hub Data Transfer with Individual Switches Indicator Lights for PC Laptop
            [company_name] => My Tele Shop
            [product_type] => P
            [parent_product_id] => 0
        )

    [9] => Array
        (
            [product_id] => 66635
            [product] => WiFi Repeater Pro 300M Amplifier Network Expander Router Power Extender 2 Antenna
            [company_name] => HSF Electronics
            [product_type] => P
            [parent_product_id] => 0
        )

    [10] => Array
        (
            [product_id] => 66247
            [product] => 15W USB AC Desktop Charger 4 USB Ports
            [company_name] => Express
            [product_type] => P
            [parent_product_id] => 0
        )

    [11] => Array
        (
            [product_id] => 66233
            [product] => Hexagon Socket Extension With 4 USB Ports
            [company_name] => Ali
            [product_type] => P
            [parent_product_id] => 0
        )

    [12] => Array
        (
            [product_id] => 59670
            [product] => Easy USB Converter- Black
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [13] => Array
        (
            [product_id] => 59678
            [product] => Type C 3.1 To Lan And USB Hub - White
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [14] => Array
        (
            [product_id] => 59699
            [product] => Case 3.5 Inch New SATA Hard Disk Case 2.0
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [15] => Array
        (
            [product_id] => 59700
            [product] => CASE 3.5 INCH SATA HARD DISK CASE 2.0
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [16] => Array
        (
            [product_id] => 59853
            [product] => Usb To Vga Converter 3.0 - White
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [17] => Array
        (
            [product_id] => 59863
            [product] => Type C 3.1 To Lan And USB Hub - White
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [18] => Array
        (
            [product_id] => 59880
            [product] => HDMI Female To Female Joiner - Black
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [19] => Array
        (
            [product_id] => 59881
            [product] => HDMI To Mini HDMI Connector - Black
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

    [20] => Array
        (
            [product_id] => 60535
            [product] => Remax RA-USB3 Type-C to USB 3.0 OTG Authentic Adapter - Black
            [company_name] => Muzamil Store
            [product_type] => P
            [parent_product_id] => 0
        )

)