Kod wygląda następująco:
Kod: Zaznacz cały
SELECT *
FROM `lista_PHS` AS A
WHERE UPPER(A.NICK_GRACZA) NOT LIKE '%BOT%'
AND UPPER(A.NICK_GRACZA) NOT IN ( SELECT UPPER(phpbb_users.username)
FROM `phpbb_users`, `phpbb_groups`, `phpbb_user_group`
WHERE phpbb_groups.group_name = 'BRAK GRUPY'
AND phpbb_groups.group_id = phpbb_user_group.group_id
AND phpbb_user_group.user_id = phpbb_users.user_id )
AND UPPER(A.NICK_GRACZA) LIKE UPPER('%')
AND COUNT (SELECT B.NICK_GRACZA
FROM `lista_PHS` AS B
WHERE UPPER(A.NICK_GRACZA) = UPPER(B.NICK_GRACZA)
AND YEAR(B.DATA) >= 2016
AND MONTH(B.DATA) >= 3
AND DAY(B.DATA) >= 1) < 3
AND YEAR(A.DATA) >= 2016
AND MONTH(A.DATA) >= 3
AND DAY(A.DATA) >= 1
ORDER BY A.DATA desc, UPPER(A.NICK_GRACZA) asc
LIMIT 0 , 100
Co wpisałem źle, bo nie widzę błędu niestety... ?#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT B.NICK_GRACZA FROM `lista_PHS` AS B WHERE' at line 10