Linear systems

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

  PENCIL AIR

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

  PENCIL

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

  PRIME