https://media.jeseniky.cz/katalog-medii/?f=stromy&fid=3201
Zachycena vyjímka - Error performing query : /* Records: katalog-medii */ SELECT SQL_CALC_FOUND_ROWS r.mod_339_id as id, r.mod_339_specPromText as specPromText, r.mod_339_specProm as specProm, r.mod_339_owner as owner, r.mod_339_category as category, r.mod_339_level as level, r.mod_339_datum_upr as datum_upr, r.mod_339_datum_birth as datum_birth, r.mod_339_relToCat as relToCat, r.mod_339_priority as priority, r.mod_339_poradi as poradi, r.mod_339_copyOf as copyOf, r.mod_339_lokalita as lokalita, r.mod_339_rec_email as rec_email, r.mod_339_odkaz as odkaz, r.mod_339_visibility as visibility, r.mod_339_carovy_kod as carovy_kod, r.mod_339_vlozil as vlozil, r.mod_339_upravil as upravil, r.mod_339_numValue1 as numValue1, r.mod_339_numValue2 as numValue2, r.mod_339_numValue3 as numValue3, r.mod_339_visibleFor as visibleFor, r.mod_339_team as team, r.mod_339_skupina as skupina, r.mod_339_locked as locked, rl.*, extPrices.id_extended_prices,extPrices.cena,extPrices.cena_nak,extPrices.cena_dop,extPrices.cena_PLN,extPrices.cena_dop_PLN,extPrices.dph,extPrices.sleva,extPrices.mnozstvi,extPrices.nostock_sell,extPrices.unit,extPrices.unit_info,extPrices.nostock_delivery_time,extPrices.mena,(extPrices.cena * if(extPrices.mnozstvi > 0,extPrices.mnozstvi,1)) as totalPrice, extFiles.*, znacka.mod_431_id as znacka_id, znacka.mod_431_nazev as znacka_nazev, extZnackaFile.obr_poloha as znacka_logo, ep.*, gd.discountPerc, dp.id_discount, sum(es.es_amount) as stav_skladu, MAX(d.sleva_discount) as sleva_discount,if((1-(100-(((extPrices.cena_dop - extPrices.cena_nak) * if(mod_339_numValue3 = 1,0,0)) / extPrices.cena_dop))/100)*100+(if(mod_339_numValue2 = 1 || 0 = 1, GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0) + extPrices.sleva,0)),MAX(COALESCE(gd.discountPerc,0))), if(mod_339_numValue2 = 2 and if(mod_339_numValue3 = 1,0,0) > 0, 100-((100 - extPrices.sleva) * ((100 - if(mod_339_numValue3 = 1,0,0)) / 100)), GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0),0)),MAX(COALESCE(gd.discountPerc,0))) ))) >0,(if((100-(if(mod_339_numValue2 = 1 || 0 = 1, GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0) + extPrices.sleva,0)),MAX(COALESCE(gd.discountPerc,0))), if(mod_339_numValue2 = 2 and if(mod_339_numValue3 = 1,0,0) > 0, 100-((100 - extPrices.sleva) * ((100 - if(mod_339_numValue3 = 1,0,0)) / 100)), GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0),0)),MAX(COALESCE(gd.discountPerc,0))) ))) )/100 < (100-(((extPrices.cena_dop - extPrices.cena_nak) * if(mod_339_numValue3 = 1,0,0)) / extPrices.cena_dop))/100, (100-(if(mod_339_numValue2 = 1 || 0 = 1, GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0) + extPrices.sleva,0)),MAX(COALESCE(gd.discountPerc,0))), if(mod_339_numValue2 = 2 and if(mod_339_numValue3 = 1,0,0) > 0, 100-((100 - extPrices.sleva) * ((100 - if(mod_339_numValue3 = 1,0,0)) / 100)), GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0),0)),MAX(COALESCE(gd.discountPerc,0))) ))) )/100*extPrices.cena_dop, (100-(((extPrices.cena_dop - extPrices.cena_nak) * if(mod_339_numValue3 = 1,0,0)) / extPrices.cena_dop))/100*extPrices.cena_dop)),extPrices.cena) as priceOut, if((if(mod_339_numValue2 = 1 || 0 = 1, GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0) + extPrices.sleva,0)),MAX(COALESCE(gd.discountPerc,0))), if(mod_339_numValue2 = 2 and if(mod_339_numValue3 = 1,0,0) > 0, 100-((100 - extPrices.sleva) * ((100 - if(mod_339_numValue3 = 1,0,0)) / 100)), GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0),0)),MAX(COALESCE(gd.discountPerc,0))) ))) > (1-(100-(((extPrices.cena_dop - extPrices.cena_nak) * if(mod_339_numValue3 = 1,0,0)) / extPrices.cena_dop))/100)*100, (if(mod_339_numValue2 = 1 || 0 = 1, GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0) + extPrices.sleva,0)),MAX(COALESCE(gd.discountPerc,0))), if(mod_339_numValue2 = 2 and if(mod_339_numValue3 = 1,0,0) > 0, 100-((100 - extPrices.sleva) * ((100 - if(mod_339_numValue3 = 1,0,0)) / 100)), GREATEST(MAX(COALESCE(extPrices.sleva,0)),MAX(COALESCE(d.sleva_discount, 0)),MAX(COALESCE(if(mod_339_numValue3 = 1,0,0),0)),MAX(COALESCE(gd.discountPerc,0))) ))) , round((1-(100-(((extPrices.cena_dop - extPrices.cena_nak) * if(mod_339_numValue3 = 1,0,0)) / extPrices.cena_dop))/100)*100)) as sleva, MATCH (nazev,popis,tags,specPromLang,mod_339_specPromText,mod_339_carovy_kod,mod_339_rec_email,mod_339_odkaz) AGAINST ('+*stromy*' IN BOOLEAN MODE) as relevance, 10*MATCH (nazev) AGAINST ('+*stromy*' IN BOOLEAN MODE) as title_relevance, MATCH (extFiles.obr_poloha) AGAINST ('+*stromy*' IN BOOLEAN MODE) as files, MATCH () AGAINST ('+*stromy*' IN BOOLEAN MODE) as 0 FROM cz_mod_339 as r JOIN cz_mod_339_lang as rl on rl.recid = mod_339_id and rl.lang = 'cz' LEFT JOIN extended_prices as extPrices on extPrices.id_record = r.mod_339_id and extPrices.id_module = 339 and extPrices.lang = 'cz' LEFT OUTER JOIN extended_files as extFiles on extFiles.id_record = r.mod_339_id and extFiles.id_module = 339 and extFiles.lang = 'cz' /*relItemQue*/ LEFT JOIN cz_recRelTo as relznacka on relznacka.rec_id = r.mod_339_id and relznacka.rec_mod = 339 and relznacka.rel_mod = 431 LEFT JOIN cz_mod_431 as znacka on znacka.mod_431_id = relznacka.rel_id and relznacka.rel_mod = 431 LEFT JOIN extended_files as extZnackaFile on extZnackaFile.id_module = 431 and extZnackaFile.id_record = mod_431_id LEFT JOIN eshop_discount_product as dp on dp.id_record = r.mod_339_id LEFT JOIN eshop_discounts as d on d.id_discount = dp.id_discount and d.fromdate_discount < '2025-06-30 23:10:38' and d.todate_discount > '2025-06-30 23:10:38' LEFT JOIN eshop_product as ep on ep.id_record = r.mod_339_id and ep.id_module = 339 LEFT JOIN eshop_group_discounts as gd on gd.discountGroup = ep.discountGroup and gd.id_user = 'hostpla9jv50gh7vanh7185l2dbmbo' LEFT JOIN eshop_stock as es on es.es_rid = mod_339_id and es.es_nostock = 0 where (mod_339_category like '%#339#%') and mod_339_visibility != 'ne' and mod_339_level <= 0 and nazev != '' GROUP BY mod_339_id HAVING (title_relevance+relevance+files+0) > 0 ORDER BY title_relevance+relevance+files+0 DESC limit 0, 24 Message : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AGAINST ('+*stromy*' IN BOOLEAN MODE) as 0 FROM cz_mod_339 as r JOIN cz_mo...' at line 31