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

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

337

• 
• JHLH305
• 7/8
• 4D33
• 2
• ME607346

338

• 
• JHLH348
• 7/8
• CANTER
• 2
• ME607348

461

• 
• JHLH039
• 5/8
• VANETTE Bus
• 3
• 30610-G2700
  30610-01C00
  30610-01C10

462

• 
• JHLH103
• 5/8
• PATROL
• 3
• 30610-17N01
  30610-01N11
  30610-01N01

463

• 
• JHLH068
• 5/8
• PATROL
• 3
• 30610-01J64
  30610-01J60
  30610-01J61

464

• 
• JHLH103-1
• 5/8
• PATROL
• 3
• 30610-C7300
  30610-C7301
  30610-C7311