WHERE clause with INNER JOINS not working

[Pedro Guimaraes]

Hi folks,

I have a SELECT with several INNER JOINS and a WHERE at the end. But the WHERE does not work accordingly. The field exp_continuum_log.timestamp is a varchar(16)

Thanks a lot.

SELECT * FROM `exp_continuum_log` INNER JOIN `exp_continuum_urls` ON exp_continuum_log.url_id = exp_continuum_urls.url_id INNER JOIN `exp_continuum_users` ON exp_continuum_log.user_id = exp_continuum_users.user_id INNER JOIN `exp_member_data` ON exp_continuum_users.member_id = exp_member_data.member_id INNER JOIN `exp_sites` ON exp_continuum_log.site_id = exp_sites.site_id WHERE exp_continuum_log.timestamp >= '1423245571' ORDER BY exp_continuum_log.timestamp DESC;