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

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

465

• 
• JHLH071
• 5/8
• BLUE BIRD
• 3
• 30610-H8800
  30610-40F50
  30610-10G00

466

• 
• JHLH104
• 5/8
• C120
• 3
• 30610-C07G0

467

• 
• JHLH072
• 5/8
• PATHFINDER
• 3
• 30610-3S107

468

• 
• JHLH105
• 5/8
• 510 610 710
• 3
• 30610-21010
  30610-45802
  30610-M3800

469

• 
• JHLH072-1
• 5/8
• URVAN
• 3
• 30610-VW007
  30610-VW00A

470

• 
• JHLH125
• 5/8
• DATSUN
• 3
• 30610-U7500
  30610-H2502
  30610-H5801