SQL Error in application
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'mediator'.
SELECT
vijesti.*,
(
SELECT
count
(
broj
)
FROM
OSIGURANJE_PORTAL..komentar
WHERE
komentar.broj = vijesti.broj
)
AS komentara,
(
SELECT
tip
FROM
OSIGURANJE_PORTAL..kolumne
WHERE
kolumne.sifra=vijesti.oznaka
)
AS tip
FROM
vijesti
WHERE
(
(
lower
(
SUBSTRING
(
naslov,1,DATALENGTH
(
naslov
)
)
)
LIKE '%s%' AND lower
(
SUBSTRING
(
naslov,1,DATALENGTH
(
naslov
)
)
)
LIKE '%r%' AND lower
(
SUBSTRING
(
naslov,1,DATALENGTH
(
naslov
)
)
)
LIKE '% ' mediator%'
)
OR
(
lower
(
SUBSTRING
(
sazetak,1,DATALENGTH
(
sazetak
)
)
)
LIKE '%s%' AND lower
(
SUBSTRING
(
sazetak,1,DATALENGTH
(
sazetak
)
)
)
LIKE '%r%' AND lower
(
SUBSTRING
(
sazetak,1,DATALENGTH
(
sazetak
)
)
)
LIKE '% ' mediator%'
)
OR
(
lower
(
SUBSTRING
(
tekst,1,DATALENGTH
(
tekst
)
)
)
LIKE '%s%' AND lower
(
SUBSTRING
(
tekst,1,DATALENGTH
(
tekst
)
)
)
LIKE '%r%' AND lower
(
SUBSTRING
(
tekst,1,DATALENGTH
(
tekst
)
)
)
LIKE '% ' mediator%'
)
)
AND
(
(
prikazi_od IS NULL
)
OR
(
prikazi_od <= CONVERT
(
varchar
(
23
)
,'2025.2.5 00:00:00 ', 104
)
)
)
order by datum desc, broj desc'