| mysqli | SET NAMES 'utf8' |
|---|
| mysqli | set auto_increment_increment=1; |
|---|
| mysqli | SELECT nev, url FROM kategoria WHERE storno = 'f' AND aktiv = 't' AND parent_id = 1 ORDER BY sorrend |
|---|
| mysqli | SELECT nev, url FROM kategoria WHERE storno = 'f' AND aktiv = 't' AND parent_id = 2 ORDER BY sorrend |
|---|
| mysqli | SELECT c.id, c.nev, c.url, c.title FROM cimkek c WHERE c.storno = 'f' AND c.aktiv = 't' ORDER BY sorrend LIMIT 16 |
|---|
| mysqli | SELECT v.id, v.cim, v.datum, v.hossz, v.file, v.file_mp4, osszes_nezettseg as nezettseg, ka.url, v.szoveg, v.leiras, vtvszf.szazalek as ertekeles, v.file, k.file as kep, k.id as kep_id, v.title, v.description, v.keywords, ka.nev as kategoria_nev, ka.url as kategoria_url FROM video v LEFT JOIN kep k ON k.galeria_id = v.id AND k.tipus = 'video' AND k.def = 't' /* LEFT JOIN video_nezettseg vn ON vn.video_id = v.id */ LEFT JOIN kategoria ka ON ka.id = v.kategoria_id LEFT JOIN vt_video_szavazas_full vtvszf ON vtvszf.video_id = v.id WHERE v.storno = 'f' AND v.aktiv = 't' AND v.id = ? GROUP BY v.id |
|---|---|
| Parameters | 0=>'i' |
| mysqli | SELECT c.nev, c.url, c.id FROM cimke_to_video ctv LEFT JOIN cimkek c ON c.id = ctv.cimkek_id WHERE ctv.video_id = ? AND c.storno = 'f' AND c.aktiv = 't' |
|---|---|
| Parameters | 0=>'i' |
| mysqli | SELECT v.id, v.cim, v.datum, v.hossz, v.osszes_ertekeles as ertekeles, v.osszes_nezettseg as nezettseg, ka.url as url, k.file, k.id as kep_id FROM video_to_video vtv LEFT JOIN video v ON v.id = vtv.kapcs_video_id LEFT JOIN kep k ON k.galeria_id = v.id AND k.tipus = 'video' AND k.def = 't' LEFT JOIN kategoria ka ON ka.id = v.kategoria_id WHERE v.storno = 'f' AND v.aktiv = 't' AND vtv.video_id = ? AND ka.storno = 'f' GROUP BY v.id ORDER BY v.sorrend |
|---|---|
| Parameters | 0=>'i' |
| mysqli | SELECT t.id,t.nev, t.link,t.kep_link, t.ext_id,t.ext_id_cat FROM termekek t WHERE t.storno = 'f' AND t.aktiv = 't' AND t.video_id = ? AND t.tipus = 'video' ORDER BY t.sorrend |
|---|---|
| Parameters | 0=>'i' |