ovaj kod mi daje ono sto sam trazio, promenio sam ga onako kako mi odgovara, za izvrsavanje nije potrebno imati nijednu tabelu. izvrsi se veoma brzo, mnogo brze nego sto sam ja mogao izvuci iz svoje tabele. period sam namestio od 01.07.2017 do 15.11.2017.
Code:
SELECT
LAST_DAY(DATE_FORMAT(m1, '%Y-%m-%d')) datum
FROM
(
SELECT
('2017-07-01' - INTERVAL DAYOFMONTH('2017-07-01')-1 DAY)
+INTERVAL m MONTH AS m1
FROM
(
SELECT @rownum:=@rownum+1 AS m FROM
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) t1,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) t2,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) t3,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) t4,
(SELECT @rownum:=-1) t0
) d1
) d2
WHERE m1<='2017-11-15'
ORDER BY m1