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

Array ( [0] => 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] => [varient_name] => ) ) Queenhouse Beauty Care