|
´ç÷ÀÏÀÚ |
·Î¶Ç»óÇ°¸í |
±¹°¡ |
|
01 |
02 |
03 |
04 |
05 |
|
06 |
07 |
08 |
09 |
10 |
select * from lotto_nation where result_date >= getdate() - 4 and substring(lotto_code,1,2) <> 'U_' and lotto_code <> 'Turkey' and result_date <= getdate() + 3 order by result_date, GMT, nation desc
24-04-22 (¿ù) |
Toto |
½Ì°¡Æú | |
select * from lotto_forecast_result where nation = 'Toto' and result_date = '2024-04-22' and forecast_num > 0 select * from final_forecast where nation = 'Toto' and result_date = '2024-04-22'
24-04-22 (¿ù) |
Lotto 6 |
ÀϺ» | |
select * from lotto_forecast_result where nation = 'Lotto6' and result_date = '2024-04-22' and forecast_num > 0 select * from final_forecast where nation = 'Lotto6' and result_date = '2024-04-22'
24-04-22 (¿ù) |
Lotto 7 |
ÀϺ» | |
select * from lotto_forecast_result where nation = 'Lotto7' and result_date = '2024-04-22' and forecast_num > 0 select * from final_forecast where nation = 'Lotto7' and result_date = '2024-04-22'
24-04-22 (¿ù) |
MIni |
ÀϺ» | |
select * from lotto_forecast_result where nation = 'MIni' and result_date = '2024-04-22' and forecast_num > 0 select * from final_forecast where nation = 'MIni' and result_date = '2024-04-22'
24-04-22 (¿ù) |
Monday |
È£ÁÖ | |
select * from lotto_forecast_result where nation = 'Australia' and result_date = '2024-04-22' and forecast_num > 0 select * from final_forecast where nation = 'Australia' and result_date = '2024-04-22'
24-04-23 (È) |
Lotto 649 |
´ë¸¸ | |
select * from lotto_forecast_result where nation = 'Lotto649' and result_date = '2024-04-23' and forecast_num > 0 select * from final_forecast where nation = 'Lotto649' and result_date = '2024-04-23'
´ç÷ÀÏÀÚ |
·Î¶Ç»óÇ°¸í |
±¹°¡ |
|
01 |
02 |
03 |
04 |
05 |
|
06 |
07 |
08 |
09 |
10 |
==> ¿¹Ãø »ý¼º °á°ú´Â °á°ú ¹ßÇ¥ ÇÏ·ç Àü ÃÖÁ¾ È®Á¤ µË´Ï´Ù. ±× Àü¿¡´Â Á¶±Ý º¯µ¿ÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù ¢¼
* ÇöÀç ¿¹Ãø ½Ã½ºÅÛÀº ½ÃÇè °¡µ¿ ÁßÀÔ´Ï´Ù. Á¤½Ä ¼ºñ½º´Â 09¿ù 01ÀÏ ºÎÅÍ ¢¼
* SAFS : ÇöÀç 10 »ì / LAFS : »ýÈÄ 1 ³â ÀÔ´Ï´Ù. Âü°í¸¸ ÇϽʽÿä ~~~ ¢¼
|