SELECT TP.*, TB.brand_name, (SELECT image_name FROM tbl_product_images WHERE product_id = TP.product_id ORDER BY set_default DESC LIMIT 1 ) as default_image, IFNULL((TP.stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = TP.product_id AND erase_time > NOW() ) ), 0) AS available_stock, ( SELECT IFNULL(ROUND(AVG(rating),1), 0) FROM tbl_product_rating WHERE product_id = TP.product_id ) as rating , CASE WHEN IFNULL((TP.stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = TP.product_id AND erase_time > NOW() ) ), 0) = 0 THEN 0 ELSE 1 END as stock_sort FROM tbl_product AS TP LEFT JOIN tbl_category AS TC ON TC.category_id = TP.category_id LEFT JOIN tbl_subcategory AS TSC ON TSC.subcategory_id = TP.subcategory_id LEFT JOIN tbl_brand AS TB ON TB.brand_id = TP.brand_id WHERE TP.`status` = 'ACTIVE' AND TC.status = 'ACTIVE' AND TB.status = 'ACTIVE' ORDER BY stock_sort DESC , TP.product_name ASC
BROWSE CATEGORIES
BROWSE BRANDS

Search results

Filter By

  • Free Shipping (13)
  • In stock (9)
  • New Release (1)
  • Featured (8)

Price Range

  • ` 0 - 999 (4)
  • ` 1,000 - 2,499 (11)
  • ` 2,500 - 4,999 (7)
  • ` 5,000 - 9,999 (17)
  • ` 10,000 - 99,999 (5)

Brands

  • WLL (1)
  • LILLIPUT (2)
  • MICNOVA (1)
  • Quantum (3)
  • PHOTOPRO (5)
  • SAVAGE (15)
  • Kenko (15)
  • Zeiss (2)

Category

  • Cleaning Solutions (1)
  • Monitors (2)
  • Micnova MQ-MDS01 Beauty Dish Kit (1)
  • Quantum (3)
  • Reflector (1)
  • Lighting & Studio (15)
  • Filters (16)
  • Lens Accessories (1)
  • Studio Accessories (4)
Home
Sort by
View by

Login

Please fill your login details to rate.

E-Mail:


Password:

Forgot Password?