In-ground luminaires

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

  LOGAN MINI

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

  LOGAN

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

  JOY