#Ordinace pro děti a dorost Žulová

SELECT
  *
FROM
  ads
WHERE
  (
    (
      zobrazovat_do >= '2024-12-04'
      and zobrazovat_od <= '2024-12-04'
    )
    or (zobrazovat_do is NULL or zobrazovat_do = '0000-00-00')
  )
	and id not in (1)
	and aktivni = 1
  and typ_reklamy = 'native-hashtag'
 and lower(umisteni_podrobnosti) regexp '.*O[rřŕ][dď][iíï][nńň][aáä][cčć][eéěë] p[rřŕ][óoö] [dď][eéěë][tť][iíï] [aáä] [dď][óoö][rřŕ][óoö][šśs][tť] Z[úuůü][lľĺ][óoö]v[aáä].*'
ORDER BY
  priorita DESC,
  RAND()
  limit 1;

SELECT
  *
FROM
  ads
WHERE
  (
    (
      zobrazovat_do >= '2024-12-04'
      and zobrazovat_od <= '2024-12-04'
    )
    or (zobrazovat_do is NULL or zobrazovat_do = '0000-00-00')
  )
	and id not in (1)
	and aktivni = 1
  and typ_reklamy like '%eshop'
ORDER BY
  priorita DESC,
  RAND()
  limit 1;