MySQL Query : SELECT COUNT(*) as count FROM (SELECT v.*,(case when (a.t) is not null then (a.t) else 0 end) as total from wmfc_yq_video v LEFT JOIN (SELECT nid,catid,ttime,COUNT(nid) t from wmfc_like_yq where catid = '29' GROUP BY nid) as a on v.id = a.nid where v.catid = '29' ORDER BY v.id) T
MySQL Error : Table 'wmfc.wmfc_like_yq' doesn't exist
MySQL Errno : 1146
Message : Table 'wmfc.wmfc_like_yq' doesn't exist
Need Help?