I am trying to run this query
but it is giving me this error
SQL ERROR [ mysqli ]
Unknown column 'AL' in 'where clause' 
SELECT a.*, u.user_id, u.username, u.user_colour from phpbb_classifieds a, phpbb_users u WHERE u.user_id = a.ad_poster_id and a.state = AL and a.ad_expire > 1242052562 ORDER BY a.ad_date DESC LIMIT 10
I cant figure out why it is doing this, any ideas?