select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-01 00:00:01' AND n.date<='2025-01-01 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-02 00:00:01' AND n.date<='2025-01-02 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-03 00:00:01' AND n.date<='2025-01-03 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-04 00:00:01' AND n.date<='2025-01-04 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-05 00:00:01' AND n.date<='2025-01-05 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-06 00:00:01' AND n.date<='2025-01-06 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-07 00:00:01' AND n.date<='2025-01-07 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-08 00:00:01' AND n.date<='2025-01-08 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-09 00:00:01' AND n.date<='2025-01-09 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-10 00:00:01' AND n.date<='2025-01-10 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-11 00:00:01' AND n.date<='2025-01-11 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-12 00:00:01' AND n.date<='2025-01-12 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-13 00:00:01' AND n.date<='2025-01-13 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-14 00:00:01' AND n.date<='2025-01-14 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-15 00:00:01' AND n.date<='2025-01-15 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-16 00:00:01' AND n.date<='2025-01-16 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-17 00:00:01' AND n.date<='2025-01-17 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-18 00:00:01' AND n.date<='2025-01-18 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-19 00:00:01' AND n.date<='2025-01-19 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-20 00:00:01' AND n.date<='2025-01-20 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-21 00:00:01' AND n.date<='2025-01-21 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-22 00:00:01' AND n.date<='2025-01-22 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-23 00:00:01' AND n.date<='2025-01-23 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-24 00:00:01' AND n.date<='2025-01-24 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-25 00:00:01' AND n.date<='2025-01-25 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-26 00:00:01' AND n.date<='2025-01-26 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-27 00:00:01' AND n.date<='2025-01-27 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-28 00:00:01' AND n.date<='2025-01-28 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-29 00:00:01' AND n.date<='2025-01-29 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-30 00:00:01' AND n.date<='2025-01-30 23:59:59'
select count(n.id) from news n
inner join menu m
ON m.type=1 AND m.lang=1 AND m.id=n.menuId
WHERE n.date>='2025-01-31 00:00:01' AND n.date<='2025-01-31 23:59:59'
| |
|
1 |
2 |
3 |
4 |
5 |
| 6 |
7 |
8 |
9 |
10 |
11 |
12 |
| 13 |
14 |
15 |
16 |
17 |
18 |
19 |
| 20 |
21 |
22 |
23 |
24 |
25 |
26 |
| 27 |
28 |
29 |
30 |
31 |
|
|
