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

Array ( [0] => Array ( [product_id] => 170 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => NATALIE FIBER DRINK [brand_id] => 239 [product_description] => Natalie Herbs Fiber Drink is a Thai-made beverage powder formulated to support weight loss, prevent hemorrhoids, lower cholesterol levels, and promote digestive health. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8002022365565 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => مشروب ناتالي بالألياف [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => beverages/natalie-fiber-drink [url_name] => natalie-fiber-drink [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] => 1750683889 [stock_id] => 170 [mrp] => 0.000 [selling_price] => 12.600 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [1] => Array ( [product_id] => 169 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Constanta Coffee Srim [brand_id] => 238 [product_description] => Constanta Coffee Srim is a sugar-free instant coffee blend formulated with Arabica coffee, collagen, and fruit extracts like green apple and pomegranate to support weight management and enhance skin health. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8809399376046 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => قهوة كونستانتا سرِم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => beverages/constanta-coffee-srim [url_name] => constanta-coffee-srim [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] => 1750683889 [stock_id] => 169 [mrp] => 0.000 [selling_price] => 5.700 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [2] => Array ( [product_id] => 167 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => NESCAFÉ Protect Proslim Instant Coffee [brand_id] => 236 [product_description] => NESCAFÉ Protect Proslim Instant Coffee is a low-fat, cholesterol-free coffee blend enriched with 3,000 mg of fiber and white kidney bean extract to support weight management and digestion. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8850127009095 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => نسكافيه بروتكت برو سليم القهوة الفورية [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => beverages/nescaf-protect-proslim-instant-coffee [url_name] => nescaf-protect-proslim-instant-coffee [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] => 1750683889 [stock_id] => 167 [mrp] => 0.000 [selling_price] => 7.700 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) ) Queenhouse Beauty Care

Search:

Beverages