SELECT i4sc.appid,i4sc.appname,i4sc.imageicon,ipd.imageicon as bigicon,i4sc.short_appname,ipd.price,ipd.size,ipd.version,ipd.itune_path FROM i4software.i4software_com i4sc INNER JOIN iphone_descrip ipd on ipd.appid = i4sc.appid WHERE i4sc.priority = 1 and i4sc.iphone = 1 ORDER BY listorder
Table 'i4software.iphone_descrip' doesn't exist