"select t1.*,(select storeName from t_store where storeId=t1.storeId) storeName,(select orderState from d_orderstate where osId=t1.osId) orderState,(select mobile from t_user where userId=t1.psy) mobile, (select userName from t_user where userId=t1.psy) userName from t_order t1 where storeId=(select storeId from t_store where storeCode='$storeCode') and osId in ($states) and isDownLoad=$isDownload order by createDate desc";