SELECT l.songid, l.title, l.dateline, l.scrollerartist, a.searcha, a.relatedids, l.locked, a.artist, c.albumid, al.album, al.searchal, l.artistid, l.rateusers, l.searcht, l.ratetotal, l.hasbody, lb.body, l.searcht FROM songs AS l, artists AS a, songsbody AS lb LEFT JOIN albumsongs AS c ON(c.songid=l.songid) LEFT JOIN albums AS al ON(c.albumid=al.albumid) WHERE l.searcht LIKE 'ciara' AND a.artistid=l.artistid AND lb.songid=l.songid


'songid', 'int(20)', 'NO', 'PRI', '', 'auto_increment'
'dateline', 'int(20)', 'NO', 'MUL', '1104015382', ''
'artistid', 'int(20)', 'NO', 'MUL', '0', ''
'featuring', 'varchar(250)', 'NO', '', '', ''
'title', 'varchar(250)', 'NO', 'MUL', '', ''
'hasbody', 'smallint(1)', 'NO', 'MUL', '0', ''
'views', 'int(20)', 'NO', '', '0', ''
'viewstoday', 'int(20)', 'NO', '', '0', ''
'viewsweek', 'int(20)', 'NO', 'MUL', '0', ''
'noratetime', 'int(20)', 'NO', '', '0', ''
'ratetotal', 'int(20)', 'NO', '', '0', ''
'rateusers', 'int(20)', 'NO', '', '0', ''
'lastupdate', 'date', 'NO', '', '2005-12-31', ''
'holiday', 'int(1)', 'NO', 'MUL', '0', ''
'locked', 'int(1)', 'NO', '', '0', ''
'trackno', 'smallint(2)', 'NO', '', '0', ''
'rs', 'int(3)', 'NO', 'MUL', '0', ''
'crammed', 'varchar(250)', 'NO', 'MUL', '', ''
'seindex', 'int(1)', 'NO', '', '0', ''
'userid', 'int(20)', 'NO', '', '0', ''
'searcht', 'varchar(250)', 'NO', 'UNI', '', ''
'scrollerartist', 'tinyint(1)', 'NO', '', '0', ''



'albumid', 'int(20)', 'NO', 'PRI', '0', ''
'songid', 'int(20)', 'NO', 'PRI', '0', ''



mysql error: Unknown column 'l.songid' in 'on clause'