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 January 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)=01 and year(date)=2026 group by cast(date as date)
| 01 |
|
59 |
42 |
66 |
58 |
| 02 |
65 |
70 |
96 |
05 |
92 |
| 03 |
63 |
69 |
81 |
91 |
99 |
| 04 |
44 |
68 |
28 |
13 |
23 |
| 05 |
88 |
65 |
36 |
05 |
40 |
| 06 |
18 |
42 |
86 |
13 |
78 |
| 07 |
61 |
10 |
28 |
44 |
11 |
| 08 |
06 |
34 |
49 |
04 |
25 |
| 09 |
95 |
80 |
66 |
28 |
21 |
| 10 |
24 |
35 |
43 |
33 |
52 |
| 11 |
05 |
60 |
51 |
73 |
78 |
| 12 |
33 |
73 |
04 |
21 |
14 |
| 13 |
51 |
33 |
07 |
88 |
58 |
| 14 |
05 |
74 |
89 |
84 |
70 |
| 15 |
56 |
|
|
|
|
|
