MySQL Error!
------------------------

The Error returned was:
Unknown column 'spa' in 'where clause'

Error Number:
1054

SELECT series, SERIES_NAME2 FROM dle_post LEFT JOIN series ON SERIES_ID = series WHERE approve = '1' AND category >= 100 and firm = spa GROUP BY series ORDER BY SERIES_NAME2