sqln:SELECT b.SMT_hd,a.* FROM `smt_video` a JOIN `smt_hd` b ON a.`SMT_hdid`=b.`SMT_id` WHERE a.`SMT_wap` = '1' AND a.`SMT_ykcid` IS NOT NULL AND a.`SMT_ykvid` IS NOT NULL AND a.`SMT_hdid` = '29'
sqln2:
sqln2:SELECT * FROM `smt_video` WHERE `SMT_wap` = '1' AND `SMT_ykcid` IS NOT NULL AND `SMT_ykvid` IS NOT NULL AND `SMT_hdid` = '29' order by SMT_sortid