CB

#
SELECT COUNT
FROM famus_comprofiler ue, famus_users u

WHERE u.block = 0

AND ue.approved = 1

AND ue.confirmed = 1

AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25)

AND u.`id` = ue.`id`
AND (`cb_famuscategory` LIKE '%Mουσικός%')

`cb_famuscategory` LIKE '%Mουσικός%'

#
SELECT COUNT(*)
  FROM famus_comprofiler ue, famus_users u

  WHERE u.block = 0

  AND ue.approved = 1

  AND ue.confirmed = 1

  AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25)

  AND u.`id` = ue.`id` 
  AND (`cb_famuscategory` LIKE '%Mουσικός%')
#
S

tested latest with Greek character test case and looks fixed!