Pole mounted luminaires

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

  PEBBLE

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

  SWAN

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

  TRIGO

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

  STARLING

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

  STARLING ARC

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

  WOODY

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

  CONE

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

  BEETLE

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

  BEETLE STICK

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

  THOR