SELECT
k.`id`,k.`id_trener`,k.`od`,k.`do`,
COALESCE(k.`id_vzor`,k.`id`) AS `id_vzor`,
COALESCE(k.`url`,v.`url`) AS `url`,
COALESCE(k.`banner`,v.`banner`) AS `banner`,
COALESCE(k.`nazev`,v.`nazev`) AS `nazev`,
COALESCE(k.`popis`,v.`popis`) AS `popis`,
COALESCE(k.`text`,v.`text`) AS `text`,
COALESCE(k.`misto`,v.`misto`) AS `misto`,
COALESCE(k.`cena`,v.`cena`) AS `cena`,
COALESCE(k.`body`,v.`body`) AS `body`,
COALESCE(k.`delka`,v.`delka`) AS `delka`,
COALESCE(k.`ikona`,v.`ikona`) AS `ikona`,
COALESCE(k.`kapacita`,v.`kapacita`) AS `kapacita`,
COALESCE(k.`odborny`,v.`odborny`) AS `odborny`
FROM `kurz` AS k LEFT JOIN `kurz` AS v ON v.`id`=k.`id_vzor`
WHERE COALESCE(k.`url`,v.`url`)='reflexni-zonova-terapie-na-nohou-funkcni-a-organove-souvislosti-iii.-' AND SUBSTR(k.`od`,1,10)='2026-10-02'
AND k.`smazany`=0
ORDER BY k.`od`,k.`do` LIMIT 1
Kurz nebyl nalezen!