Recessed luminaires

SELECT * FROM product WHERE category_fk = 1 and category_fk2=4 and category_fk3=3 order by viewnum = 0 ASC, viewnum asc, top DESC, registdate DESC
• 

  LINY

SELECT * FROM product WHERE category_fk = 1 and category_fk2=5 and category_fk3=3 order by viewnum = 0 ASC, viewnum asc, top DESC, registdate DESC
• 

  COOPERS MINI

SELECT * FROM product WHERE category_fk = 1 and category_fk2=6 and category_fk3=3 order by viewnum = 0 ASC, viewnum asc, top DESC, registdate DESC
• 

  COOPERS

SELECT * FROM product WHERE category_fk = 1 and category_fk2=7 and category_fk3=3 order by viewnum = 0 ASC, viewnum asc, top DESC, registdate DESC
• 

  WIDE MINI

SELECT * FROM product WHERE category_fk = 1 and category_fk2=8 and category_fk3=3 order by viewnum = 0 ASC, viewnum asc, top DESC, registdate DESC
• 

  WIDE