Unnamed

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'