KẾT QUẢ XỔ SỐ Miền Bắc

select mien_id,mien_style,mien_style_sub,ngay,thang,nam,mien_name,mien_title,mien_url from dnw_tinh,dnw_mienxoso_free,dnw_kqxs where dnw_kqxs.tinh_id=dnw_tinh.tinh_id and tinh_mien_id=mien_id and mien_show=1 and tinh_show=1 and mien_id=2 and (nam < 2018 or( nam=2018 and thang < 09 ) or (nam=2018 and thang=09 and ngay<=19 )) group by mien_id,ngay,thang,nam order by nam desc, thang desc, ngay desc , mien_sort desc,mien_id asc limit 0, 7