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

Array ( [0] => Array ( [product_id] => 877 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => IKT Hair Wax 130g [brand_id] => 375 [product_description] => IKT Hair Wax 130g is designed to provide a strong hold for various hairstyles, ensuring your look stays in place throughout the day. Its non-greasy formula allows for easy application and removal, leaving no residue behind. Suitable for all hair types, this hair wax offers a natural finish and is ideal for daily use. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 6970832440050 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => شمع الشعر من IKT بحجم 130 جرام [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => hair-care/-ikt-hair-wax-130g [url_name] => -ikt-hair-wax-130g [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] => 1750683912 [stock_id] => 877 [mrp] => 0.000 [selling_price] => 2.500 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [1] => Array ( [product_id] => 617 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Hair Wax Stick Coconut Oil 75g [brand_id] => 335 [product_description] => A non-greasy hair wax stick enriched with coconut oil for smooth styling, frizz control, and a natural finish. Ideal for edges, flyaways, and sleek looks. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 6290360591421 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => شمع تصفيف الشعر بزيت جوز الهند 75 جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => hair-styling/hair-wax-stick-coconut-oil-75g [url_name] => hair-wax-stick-coconut-oil-75g [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] => [updated_on] => [updated_by] => 0 [created_on] => 1750683903 [stock_id] => 617 [mrp] => 0.000 [selling_price] => 2.800 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [2] => Array ( [product_id] => 587 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Hair Wax Stick Protein Collagen 75g [brand_id] => 335 [product_description] => A protein and collagen-infused wax stick that delivers firm hold, nourishes hair, and smooths flyaways for a sleek finish. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8852086000113 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => ستيك شمع الشعر بالبروتين والكولاجين 75 جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => hair-styling/hair-wax-stick-protein-collagen-75g [url_name] => hair-wax-stick-protein-collagen-75g [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] => [updated_on] => [updated_by] => 0 [created_on] => 1750683902 [stock_id] => 587 [mrp] => 0.000 [selling_price] => 2.800 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [3] => Array ( [product_id] => 586 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Wax Stick 75g [brand_id] => 375 [product_description] => A styling wax stick that offers firm hold, tames frizz, and defines hair with a natural finish. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8858842030110 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => ستيك شمع 75 جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => hair-styling/wax-stick-75g [url_name] => wax-stick-75g [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] => [updated_on] => [updated_by] => 0 [created_on] => 1750683902 [stock_id] => 586 [mrp] => 0.000 [selling_price] => 2.800 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [4] => Array ( [product_id] => 585 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Hair Wax Stick 75g [brand_id] => 374 [product_description] => A convenient wax stick that provides strong hold and smooth styling for edges and flyaways without residue. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 100001976 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => ستيك شمع تصفيف الشعر 75 جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => hair-styling/hair-wax-stick-75g [url_name] => hair-wax-stick-75g [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] => [updated_on] => [updated_by] => 0 [created_on] => 1750683902 [stock_id] => 585 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) ) Queenhouse Beauty Care

Search:

Hair Care