SELECT
    id,
    name,
    photo,
    about,
    rules,
    private,
    type,
    count_members as full_count_members,
    (SELECT COUNT(*)
     FROM tbl_groups g1
              JOIN tbl_users_groups_relations gc on gc.group_id = g1.id
              JOIN tbl_user u on u.id = gc.user_id
     WHERE g1.id = tg.id
       AND IF(
                 g1.type != 'Gym',
                 u.id IN (1231, 1232, 1233),
                 g1.type = 'Gym'
         )
       AND u.is_delete = '0'
       AND u.deleted_at IS NULL
       AND (((6372 * 2 * ASIN(SQRT(POWER
           (SIN((48.924 - u.lat) * pi() / 180 / 2), 2) +
           COS(48.924 * pi() / 180) * COS(u.lat * pi() / 180) *
           POWER(SIN((59.545 - u.lng) * pi() / 180 / 2), 2))
         )) * 1000) between 0 AND 200000)
    ) as count_members,
    IF(type = 'Spec',
       CONCAT('group_icon/', icon),
       icon
        ) as icon,
    CONCAT('constant.group_image/', photo) as photo,
    CONCAT('constant.group_image_imagekit/', photo) as photo_imagekit
FROM tbl_groups tg
WHERE type IN (?)
  AND type != 'Gym'
ORDER BY name