Invalid SQL: SELECT pm.*, pmtext.* ,icon.iconpath, icon.title AS icontitle FROM pm AS pm INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid) WHERE pm.userid = 1 AND pmtext.dateline > 1167932901 AND pm.messageread = 0;