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

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

622

• 
• JHLH050
• 5/8
• 03 ACCORD 2.4
• 5
• 46920-S7A-A02

624

• 
• JHLH051
• 5/8
• CIVIC FAI
• 5
• 46920-SNA-A01
  46920-SNA-A02

626

• 
• JHLH052
• 5/8
• 92 CIVIC EG8
• 5
• 46920-SR3-A01
  46920-SO4-A01

628

• 
• JHLH101
• 5/8
• CIVIC
• 5
• 46920-S5A-G01

630

• 
• JHLH132
• 11/16
• 98 ACCORD 2.3
• 5
• 46920-S84-A02

632

• 
• JHLH134
• 5/8
• 5
• 46920-TTI-003