WHERE (o.cis_typ=? ) AND o.online = '1'
SELECT o.id, o.nazev, o.nazev_dop, o.cis_stav, o.cis_typ, o.kraj,
o.cis_typ_dop, o.loc_x, o.loc_y, o.pristupnost, o.mnm,
o.cis_country, m.obec, t.text, o.urceni_mista, o.url
FROM objekty AS o
LEFT JOIN cis_mista AS m ON m.id = o.urceni_mista
LEFT JOIN text_info AS t ON t.hid=o.id AND t.tid='7' AND t.lang ='0'
WHERE (o.cis_typ=? ) AND o.online = '1'
GROUP BY o.id, hrady_cz.t.text
ORDER BY
CASE
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 0
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 2
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 3
ELSE 4
END
LIMIT 0,15
QUERY: SELECT o.id, o.nazev, o.nazev_dop, o.cis_stav, o.cis_typ, o.kraj,
o.cis_typ_dop, o.loc_x, o.loc_y, o.pristupnost, o.mnm,
o.cis_country, m.obec, t.text, o.urceni_mista, o.url
FROM objekty AS o
LEFT JOIN cis_mista AS m ON m.id = o.urceni_mista
LEFT JOIN text_info AS t ON t.hid=o.id AND t.tid='7' AND t.lang ='0'
WHERE (o.cis_typ=? ) AND o.online = '1'
GROUP BY o.id, hrady_cz.t.text
ORDER BY
CASE
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 0
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 2
WHEN LOWER(o.nazev) LIKE LOWER( ? ) THEN 3
ELSE 4
END
LIMIT 0,15
DATA: 99; ; %; %
Existuje SELECT, vratime vysledek
Hledání turisticky zajímavých míst