select 
            p.id,
            p.supplier_id,
            p.category_id,
            p.slog as product_slug,
            p.product_title,
            p.meta_title,
            p.meta_keyword,
            p.meta_description,
            p.product_description,
            p.main_product_image,
            s.s_product_count,
            s.company_name,
            s.slug as supplier_slug,
            c.slug as category_slug,
            c.category_name
         from `products` as `p` inner join `suppliers` as `s` on `p`.`supplier_id` = `s`.`id` inner join `categories` as `c` on `p`.`category_id` = `c`.`id` where `p`.`status` = ? and `p`.`category_id` = ? order by `p`.`id` desc limit 10 offset 0