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 (870, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1293, 1383, 2084, 2208, 801, 865, 866) 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] => 870
    [save_view_results] => product_id
    [cid] => 870
    [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] => 77297
            [product] => X7 BLUETOOTH SMART WATCH
            [company_name] => Usama Mobile
            [product_type] => P
            [parent_product_id] => 0
        )

    [1] => Array
        (
            [product_id] => 77296
            [product] => High Quality X7 Bluetooth Smart Watch
            [company_name] => Usama Mobile
            [product_type] => P
            [parent_product_id] => 0
        )

    [2] => Array
        (
            [product_id] => 76714
            [product] => Band 4 Fitness Tracker Smart Bracelet  Heart Rate Blood Pressure Smart Band Monitor Health Wristband Band 4
            [company_name] => Technology Zone
            [product_type] => P
            [parent_product_id] => 0
        )

    [3] => Array
        (
            [product_id] => 75763
            [product] => NEW SMART WATCH I7 PLUS BLUETOOTH 5.0 WITH MULTI FUNCTIONS 1 PIECE
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [4] => Array
        (
            [product_id] => 75762
            [product] => NEW SMART WATCH 7 N-76 GOOD QUALITY AND SMART LOOK BLUETOOTH 5.0 1 Piece
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [5] => Array
        (
            [product_id] => 75700
            [product] => M16 PLUS SMART WATCH 44mm
            [company_name] => Usama Mobile
            [product_type] => P
            [parent_product_id] => 0
        )

    [6] => Array
        (
            [product_id] => 75677
            [product] => Hi-watch 6 / Series 6 Watch Replica/1.75 inch / Super big screen/ Magnetic Charge/ Blood pressure 1 Piece
            [company_name] => GADGETMANIA
            [product_type] => P
            [parent_product_id] => 0
        )

    [7] => Array
        (
            [product_id] => 75676
            [product] => W3 Smart Watch  Round Dial |metal Body-black| Watch Clone | 5 Day Battery
            [company_name] => GADGETMANIA
            [product_type] => P
            [parent_product_id] => 0
        )

    [8] => Array
        (
            [product_id] => 75623
            [product] => High Quality Smart Watch 7 Series
            [company_name] => Usama Mobile
            [product_type] => P
            [parent_product_id] => 0
        )

    [9] => Array
        (
            [product_id] => 75509
            [product] => Best W22+ Smart Watch 45mm Size For Watch Men Bluetooth Call 1.75 Screen Rotation Function
            [company_name] => Apne Shop
            [product_type] => P
            [parent_product_id] => 0
        )

    [10] => Array
        (
            [product_id] => 75413
            [product] => Haylou Rt Ls05s Smartwatch
            [company_name] => HSF Electronics
            [product_type] => P
            [parent_product_id] => 0
        )

    [11] => Array
        (
            [product_id] => 75412
            [product] => Mibro Lite Amoled Smartwatch Waterproof With Heart Rate Sensor - Black Color
            [company_name] => HSF Electronics
            [product_type] => P
            [parent_product_id] => 0
        )

    [12] => Array
        (
            [product_id] => 75411
            [product] => Black Color Mibro Color Smartwatch Waterproof With Heart Rate Sensor
            [company_name] => HSF Electronics
            [product_type] => P
            [parent_product_id] => 0
        )

    [13] => Array
        (
            [product_id] => 74356
            [product] => New Smart Watch T-700 Pro Ip67 Waterproof Dust Proof Display - 1 Piece
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [14] => Array
        (
            [product_id] => 74355
            [product] => New Smart Watch Hw-16  1.72 Inches Display Ip67 1 Piece
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [15] => Array
        (
            [product_id] => 74353
            [product] => New Smart Watch T-200 Plus Bluetooth 5.0 Ip67 1 Piece
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [16] => Array
        (
            [product_id] => 74351
            [product] => Best New Smart Watch T-200 Plus Bluetooth 5.0 Ip67 1 Piece
            [company_name] => Marwa collection
            [product_type] => P
            [parent_product_id] => 0
        )

    [17] => Array
        (
            [product_id] => 72662
            [product] => Women,men smart watch 2019 Original M3 Plus Smart Armband Fitness  Digital Sport  Bluetooth
            [company_name] => Everythings Is Here
            [product_type] => P
            [parent_product_id] => 0
        )

    [18] => Array
        (
            [product_id] => 72242
            [product] => NEW SMART WATCH HW-22 FULL LCD DISPLAY BLUETOOTH 5.0  SMART LOOK - 1 Piece
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [19] => Array
        (
            [product_id] => 72241
            [product] => NEW SMART WATCH HW-22 PRO BLUETOOTH 5.0 FULL LCD DISPLAY 1-PIECE
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

    [20] => Array
        (
            [product_id] => 72240
            [product] => NEW HW-16 SMART WATCH BLUETOOTH 5.0 FULL LCD DISPLAY 1.72 44 MM 1-PIECE
            [company_name] => Gilani Communication
            [product_type] => P
            [parent_product_id] => 0
        )

)