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

Search results

Filter By

  • Free Shipping (120)
  • In stock (52)
  • New Release (21)
  • Featured (59)

Price Range

  • ` 0 - 999 (20)
  • ` 1,000 - 2,499 (55)
  • ` 2,500 - 4,999 (52)
  • ` 5,000 - 9,999 (58)
  • ` 10,000 - 99,999 (68)
  • ` 1,00,000 And Above (2)

Brands

  • LIGHT CHROM (11)
  • DATACOLOR (1)
  • PIXEL (2)
  • KATA (17)
  • NATIONAL GEOGRAPHIC (8)
  • OP/TECH USA (5)
  • GOPRO (29)
  • LOWEPRO (2)
  • MANFROTTO (13)
  • ALLMAN (3)
  • JOBY (8)
  • CARRY SPEED (3)
  • GITZO (8)
  • PHOTOPRO (6)
  • WLL (1)
  • MISCELLANEOUS (1)
  • SANDISK (7)
  • SENNHEISER (2)
  • ZOOM (6)
  • SEKONIC (1)
  • SAVAGE (16)
  • SEVENOAK (2)
  • KODAK (1)
  • Quantum (3)
  • LILLIPUT (2)
  • Pelican (1)
  • MICNOVA (1)
  • Rode (56)
  • K Line (2)
  • Kenko (15)
  • Zeiss (3)
  • Audio Technica (2)
  • Samson (4)
  • Belkin (1)
  • Panasonic (3)
  • YONGNUO (1)
  • Profoto (1)
  • MagMod (3)
  • Sony (2)
  • DIKANG (1)
  • Alto (1)

Category

  • Calibration Solutions (1)
  • Photographic Accessories (3)
  • Camera Bags (29)
  • Cleaning Solutions (1)
  • Film Shooting Accessories (1)
  • Gopro Accessories (26)
  • Gorilla Mobile (2)
  • Professional Audio (68)
  • Kodak Ektapro 80 Slide Tray (1)
  • Monitors (2)
  • Micnova MQ-MDS01 Beauty Dish Kit (1)
  • Quantum (3)
  • Reflector (1)
  • RIG (2)
  • Tripods & Monopods (28)
  • Photography (41)
  • Lighting & Studio (17)
  • Filters (16)
  • Lens Accessories (1)
  • Flash (2)
  • Studio Accessories (4)
  • Battery Charger (3)
  • INDUSTRIAL AND SCIENTIFIC (1)
  • MUSICAL INSTRUMENT (1)

Login

Please fill your login details to rate.

E-Mail:


Password:

Forgot Password?