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

Array ( [0] => Array ( [product_id] => 510 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => GP Royal Ginger Foot Patch [brand_id] => 323 [product_description] => GP Royal Ginger Foot Patch offers natural detoxification by absorbing impurities through the soles overnight. Infused with ginger extract, it promotes circulation and relieves fatigue. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8859443700143 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => لصقات قدم جي بي رويال بالزنجبيل (10 قطع) [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => foot-care/gp-royal-ginger-foot-patch [url_name] => gp-royal-ginger-foot-patch [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] => 1750683899 [stock_id] => 510 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [1] => Array ( [product_id] => 509 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Royal Lavender Foot Patch [brand_id] => 322 [product_description] => Royal Lavender Foot Patch is designed to naturally detoxify the body overnight, promoting relaxation and refreshing tired feet with the calming scent of lavender. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8859443700136 [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] => foot-care/royal-lavender-foot-patch [url_name] => royal-lavender-foot-patch [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] => 1750683899 [stock_id] => 509 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [2] => Array ( [product_id] => 421 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Fatima Foot Cream 100G [brand_id] => 316 [product_description] => Fatima Foot Cream is specially formulated to moisturize, soothe, and repair dry, cracked heels and rough feet. Enriched with herbal ingredients, it helps maintain soft and healthy skin. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8857123479761 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => كريم القدم فاطيما 100 جرام [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => foot-care/fatima-foot-cream-100g [url_name] => fatima-foot-cream-100g [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] => 1750683896 [stock_id] => 421 [mrp] => 0.000 [selling_price] => 2.800 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [3] => Array ( [product_id] => 142 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => MOOYAM TEA TREE OIL FOOT CREAM 250G [brand_id] => 57 [product_description] => MOOYAM Tea Tree Oil Foot Cream is a moisturizing cream formulated with tea tree oil and aloe vera, designed to hydrate and nourish dry, cracked feet. It also helps alleviate itching and inflammation, promoting overall foot health. Suitable for daily us [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 6940824186013 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => كريم موويام زيت شجرة الشاي للقدمين 250جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => foot-care/mooyam-tea-tree-oil-foot-cream-250g [url_name] => mooyam-tea-tree-oil-foot-cream-250g [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] => 1750683888 [stock_id] => 142 [mrp] => 0.000 [selling_price] => 1.600 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) [4] => Array ( [product_id] => 135 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => VASELINE DEEP MOISTURE FOOT CREAM 60G [brand_id] => 67 [product_description] => Vaseline Deep Moisture Foot Cream is a non-greasy moisturizer designed to hydrate and repair dry, cracked feet. Enriched with high-quality ingredients, it provides gentle care, leaving feet feeling smooth, healthy, and moisturized throughout the day. ? [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8809745080368 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => كريم فازلين مرطب للقدم 60جم [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => foot-care/vaseline-deep-moisture-foot-cream-60g [url_name] => vaseline-deep-moisture-foot-cream-60g [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] => 1750683888 [stock_id] => 135 [mrp] => 0.000 [selling_price] => 2.200 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => ) ) Queenhouse Beauty Care

Search:

Foot Care