MySQL Query : SELECT b.id,b.title FROM dmt_video as v LEFT JOIN dmt_brand as b ON b.id = substring(substring_index(v.brandids,',',2),2) where b.status = 99 GROUP BY b.id ORDER BY b.title LIMIT 99 MySQL Error : Table 'dmtpro3.dmt_video' doesn't exist MySQL Errno : 1146 Message : Table 'dmtpro3.dmt_video' doesn't exist