Query problem / WHERE conditions

[pollux 992]

Hi,

i have a problem with a query...

 

This is my working query:

SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name 
	FROM log.loginlog2 AS l 
	LEFT JOIN player.player AS p ON (p.id = l.pid) 
	WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
	ORDER BY l.id DESC;

 

This is my non-working query:

SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name 
	FROM log.loginlog2 AS l 
	LEFT JOIN player.player AS p ON (p.id = l.pid) 
	WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
	AND WHERE l.is_gm = 'Y'
	ORDER BY l.id DESC;

 

This is the error i get:

Quote

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE l.is_gm = 'Y'  ORDER BY l.id DESC' at line 5

 

Can you tell me why? Or provide me a solution? I really don't want to do a work-around in php...

 

Thank you,

.PolluX

[Endymion 399]

SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name 
    FROM log.loginlog2 AS l 
    LEFT JOIN player.player AS p ON (p.id = l.pid) 
    WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
    AND  l.is_gm = 'Y'
    ORDER BY l.id DESC;

[pollux 992]

OMG.. Shame on me..

 

Thank you