Linear systems

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

  PRIME CORE

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

  PRIME X　　　　　(Pure White)

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

  PRIME X　　　　　(RGBW)

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

  PENCIL PLUS　　　(Pure White)

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

  PENCIL PLUS　　　　　(RGBW)

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

  PENCIL AIR　　　　　　(Pure White)

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

  PENCIL AIR　　　　　　(RGBW)

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

  PENCIL HIDE　　　　　　(Pure White)

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

  PENCIL HIDE　　　　　　(RGBW)

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

  PENCIL FACE　　　　　　(Pure White)

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

  PENCIL FACE　　　　　　(RGBW)

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