SELECT p.modul,p.subint,p.uroven, o.id, IF(o.id,o.prijmeni,'VSICHNI') as prijmeni,o.jmeno FROM `prava` p JOIN osoby o ON o.id = p.osoba AND o.mrtev='NE' 
WHERE p.modul<>'ADMIN' AND p.modul<>'ADMIN2'
ORDER BY modul,subint,uroven,prijmeni, jmeno

SELECT p.modul,p.subint,p.uroven, o.id, IF(o.id,o.prijmeni,'VSICHNI') as prijmeni,o.jmeno FROM `prava` p JOIN osoby o ON o.id = p.osoba AND o.mrtev='NE' WHERE p.modul<>'ADMIN' AND p.modul<>'ADMIN2' AND p.modul<>'ADMIN3' AND p.modul<>'ADMINOLD' AND p.modul<>'ADMINOLD2' ORDER BY modul,subint,uroven,prijmeni, jmeno


SELECT * FROM (SELECT p.modul,p.subint,p.uroven, o.id, IF(p.osoba,o.prijmeni,'VSICHNI') as prijmeni,o.jmeno FROM `prava` p LEFT JOIN osoby o ON o.id = p.osoba WHERE p.modul<>'ADMIN' AND p.modul<>'ADMIN2' AND p.modul<>'ADMIN3' AND p.modul<>'ADMINOLD' AND p.modul<>'ADMINOLD2' )a WHERE prijmeni<>'' ORDER BY modul,subint,uroven,prijmeni, jmeno


SELECT * FROM (SELECT p.modul,p.subint,p.uroven, o.id, IF(p.osoba,o.prijmeni,'VSICHNI') as prijmeni,o.jmeno FROM `prava` p LEFT JOIN osoby o ON o.id = p.osoba WHERE p.modul<>'ADMIN' AND p.modul<>'ADMIN2' AND p.modul<>'ADMIN3' AND p.modul<>'ADMINOLD' AND p.modul<>'ADMINOLD2' )a WHERE prijmeni<>'' ORDER BY modul,subint,uroven DESC,prijmeni, jmeno


ZDI1ZWE1M





jen odkládám: SELECT zd.*,z.cas,z.cislo,z.domaci_id, z.domaci_nazev,z.domaci_zkraceny,z.hoste_id, z.hoste_nazev, z.hoste_zkraceny,z.adresa, z.hala_nazev,z.hala_ruian,z.poznamka, z.poznamka as zapas_poznamka, z.skupina_rozhodci, z.skupina_id,z.skupina_kod,z.soutez_kod,z.vysledek FROM v_zapasy z LEFT JOIN v_zapas_delegace zd ON zd.zapas_id = z.zapas_id WHERE 1=1 AND DATE(z.cas)= '2022-09-24' AND domaci_nazev LIKE '%Meteor%' ORDER 

BY z.cas






SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'DATABASENAME' 
    AND     TABLE_NAME      = 'VIEWNAME';