SELECT `tbl_products`.`id`, `category`.`name` as `catname`, `category`.`slug` as `catSlug`, `tbl_brands`.`name` as `brandname`, `tbl_products`.`name`, `tbl_products`.`model`, `tbl_products`.`slug`, `pimage`, `price`, `sale_price`, `quantity`, `tbl_colors`.`id` as `colorid`, `tbl_colors`.`name` as `colorname`, `tbl_size`.`id` as `sizeid`, `tbl_size`.`name` as `sizename`
FROM `tbl_products`
LEFT JOIN `tbl_category` as `category` ON `category`.`id`=`tbl_products`.`category_id`
LEFT JOIN `tbl_brands` ON `tbl_brands`.`id`=`tbl_products`.`brand_id`
LEFT JOIN `tbl_colors` ON `tbl_colors`.`id`=`tbl_products`.`color_id`
LEFT JOIN `tbl_size` ON `tbl_size`.`id`=`tbl_products`.`size_id`
WHERE `tbl_products`.`status` = 1
ORDER BY `tbl_products`.`created` DESC
 LIMIT 50