select count(ID) as idCount from [test_Products]where ViewFlagch and SortID like '%1%' and Unitch like '%%'

• PICTURE
• JH number
• diameter
• model
• Vehicle
• OEM

319

• 
• JHLH108
• 5/8
• L200
• 2
• MR995036
  M10

320

• 
• JHLH022
• 5/8
• RACING
• 2
• MR491945

321

• 
• JHLH108-1
• 5/8
• L200
• 2
• MR995034
  M12

322

• 
• JHLH023
• 5/8
• MONTERO
• 2
• MB555391
  MB555383

323

• 
• JHLH118
• 5/8
• CHARIOT
• 2
• MB891409
  MB949156
  MB864084

324

• 
• JHLH033-1
• 5/8
• PAJERO(90-00)
• 2
• MB012261