select GameName,TimeHours,TimeMinutes,TimeAMPM,sorttime,A.winno,B.winno Prevno,GameChart from (select g.id gameid,winno
from win_no wn right join gamemst g on wn.gameid=g.id where cast(date as date)=cast(now() as date))A
right join
(select GameName,TimeHours,TimeMinutes,TimeAMPM,sorttime,g.id gameid,winno,GameChart
from win_no wn right join gamemst g on wn.gameid=g.id and cast(date as date)=date_add(cast(now() as date),INTERVAL -1 day) where status=0)B
on A.gameid=B.gameid
Monthly Satta King Chart of February 2026 for Gali, Desawer, Gaziabad and Faridabad
|
| DATE |
DSWR |
UPBZ |
FRBD |
GZBD |
GALI |
SELECT left(DATE_FORMAT(date,'%d'),2) date ,max(case when gamename='DISHAWER' then winno else NULL end) DISHAWER,max(case when gamename='UP BAZAR' then winno else NULL end) UPBZ, max(case when gamename='GHAZIABAD' then winno else NULL end) 'GAZIYABAD', max(case when gamename='GALI' then winno else NULL end) 'GALI', max(case when gamename='Faridabad' then winno else NULL end) 'Faridabad',max(case when gamename='GURUGRAM' then winno else NULL end) GURUGRAM FROM `win_no` w join gamemst g on g.id=w.gameid where STATUS=0 and month(date)=02 and year(date)=2026 group by cast(date as date)
| 01 |
|
58 |
39 |
17 |
05 |
| 02 |
93 |
77 |
90 |
99 |
04 |
| 03 |
78 |
04 |
08 |
42 |
|
|
