COVID – 19
[Error] Select failed (with recursive cte (ID, uroven, nazov_url, enNazov_url, poradie, parentID, tip_medailonu, top_medailon, medailon, skTitle, skPerex, skDescription, show_date, DateValidFrom, DateValidTo) AS (SELECT ID, uroven, nazov_url, enNazov_url, poradie, parentID, tip_medailonu, top_medailon, medailon, skTitle AS Title, skPerex AS Perex, skDescription AS Description, show_date, DateValidFrom, DateValidTo FROM `SK_page_page1` WHERE parentID=837 union all SELECT p.ID, p.uroven, p.nazov_url, p.enNazov_url, p.poradie, p.parentID, p.tip_medailonu, p.top_medailon, p.medailon, p.skTitle AS Title, p.skPerex AS Perex, p.skDescription AS Description, p.show_date, p.DateValidFrom, p.DateValidTo FROM `SK_page_page1` p inner join cte on p.parentID = cte.ID)SELECT ID, uroven, nazov_url, enNazov_url, poradie, parentID, tip_medailonu, top_medailon, medailon, skTitle AS Title, skPerex AS Perex, skDescription AS Description, show_date, DateValidFrom, DateValidTo FROM cte WHERE skTitle NOT LIKE 'Napíš titul%' AND tip_medailonu=0 AND medailon!=0 AND DateValidTo IS NULL ORDER BY DateValidFrom DESC LIMIT 20?,10)[DB]:
nahradaskody.sk