Queenhouse Beauty Care

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` = '57'
AND `product_status` = 1
GROUP BY `n_products`.`product_id`
ORDER BY `product_id` DESC
 LIMIT 24

Array ( )

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` = '57'
AND `product_status` = 1
GROUP BY `n_products`.`product_id`
ORDER BY `product_id` DESC
 LIMIT 24

Array ( [0] => Array ( [product_id] => 83 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Euthymol Original Toothpaste 75ml [brand_id] => 36 [product_description] => Euthymol Original Toothpaste is a 75ml fluoride-free toothpaste known for its distinctive bright pink color and potent flavor. Formulated with a blend of antiseptic ingredients, it effectively helps remove plaque and tartar, promoting fresh breath and maintaining oral hygiene. The toothpaste comes in a recyclable aluminum tube, making it both an effective and eco-friendly choice for your oral care routine. ? [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8801051109962 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => معجون أسنان Euthymol الأصلي 75 مل [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => oral-care/euthymol-original-toothpaste-75ml [url_name] => euthymol-original-toothpaste-75ml [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => 10 [updated_on] => [updated_by] => 0 [created_on] => 1750683887 [stock_id] => 83 [mrp] => 0.000 [selling_price] => 2.800 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) ) Queenhouse Beauty Care