SELECT `n_products`.*, `stock_id`, `mrp`, `selling_price`, `quantity`, `off`.`sale_id` as `offer_id`, `off`.`sale_status` as `offer_status`, `off`.`discount_type` as `off_discount_type`, `off`.`discount_value` as `offer_discount`, `off`.`start_date` as `off_start_date`, `off`.`end_date` as `off_end_date`
FROM `n_product_category`
LEFT JOIN `n_products` ON `n_products`.`product_id` = `n_product_category`.`product_id`
LEFT JOIN `n_stock_products` ON `n_stock_products`.`product_id` = `n_products`.`product_id`
LEFT JOIN `n_flash_sale` as `off` ON `off`.`sale_id` = `n_products`.`offer_id`
WHERE `n_product_category`.`category_id` = '228'
AND `product_status` = 1
GROUP BY `n_products`.`product_id`
ORDER BY `product_id` DESC
LIMIT 24
SELECT `n_products`.*, `stock_id`, `mrp`, `selling_price`, `quantity`, `off`.`sale_id` as `offer_id`, `off`.`sale_status` as `offer_status`, `off`.`discount_type` as `off_discount_type`, `off`.`discount_value` as `offer_discount`, `off`.`start_date` as `off_start_date`, `off`.`end_date` as `off_end_date`, `varient_name`
FROM `n_product_subcategory`
LEFT JOIN `n_products` ON `n_products`.`product_id` = `n_product_subcategory`.`product_id`
LEFT JOIN `n_stock_products` ON `n_stock_products`.`product_id` = `n_products`.`product_id`
LEFT JOIN `n_product_varients_name` ON `n_product_varients_name`.`product_varient_id` = `n_stock_products`.`varient_id` AND `n_product_varients_name`.`product_id` = `n_stock_products`.`product_id`
LEFT JOIN `n_flash_sale` as `off` ON `off`.`sale_id` = `n_products`.`offer_id`
WHERE `n_product_subcategory`.`subcategory_id` = '228'
AND `product_status` = 1
GROUP BY `n_products`.`product_id`
ORDER BY `product_id` DESC
LIMIT 24
BHD - Bahrain Dinar 
KWD - Kuwaiti Dinar 
OMR - Omani Rial 
QAR - Qatari Riyal 
AED - Emirati Dirham 
SAR - Saudi Riyal 
USD - United States Dollar 
