Chyba v SQL dotazu:
SELECT oprcena FROM (SELECT CASE WHEN (s.skladem > s.aktprod) THEN 1 ELSE 0 END AS jeskladem, e.*, CASE WHEN e.cena1>0 AND e.cena1 IS NOT NULL THEN e.cena1 WHEN d.cena1 IS NOT NULL THEN d.cena1 ELSE 0 END as oprcena FROM intimity_es_sortiment e LEFT JOIN maca_es_sortiment d ON e.idz=d.idz LEFT JOIN maca_es_sklad s ON e.idz=s.idz WHERE e.ukaz=1 AND (IFNULL(e.nadrazen, '') NOT LIKE '' ) AND (e.nadrazen like '%|1318|%' OR e.nadrazen like '%|1319|%' OR e.nadrazen like '%|1321|%' OR e.nadrazen like '%|1322|%' OR e.nadrazen like '%|1323|%' OR e.nadrazen like '%|1324|%' OR e.nadrazen like '%|1325|%' OR e.nadrazen like '%|1326|%' OR e.nadrazen like '%|1327|%' OR e.nadrazen like '%|1328|%' OR e.nadrazen like '%|1329|%' OR e.nadrazen like '%|1330|%' OR e.nadrazen like '%|1331|%' OR e.nadrazen like '%|1334|%' OR e.nadrazen like '%|1335|%' OR e.nadrazen like '%|1336|%' OR e.nadrazen like '%|1337|%' OR e.nadrazen like '%|1338|%' OR e.nadrazen like '%|1339|%' OR e.nadrazen like '%|1340|%' OR e.nadrazen like '%|1341|%' OR e.nadrazen like '%|1342|%' OR e.nadrazen like '%|1343|%' OR e.nadrazen like '%|1344|%' OR e.nadrazen like '%|1346|%' OR e.nadrazen like '%|1347|%' OR e.nadrazen like '%|1348|%' OR e.nadrazen like '%|1349|%' OR e.nadrazen like '%|1351|%' OR e.nadrazen like '%|1356|%' OR e.nadrazen like '%|1357|%' OR e.nadrazen like '%|1358|%' OR e.nadrazen like '%|1360|%' OR e.nadrazen like '%|1361|%' OR e.nadrazen like '%|1362|%') AND ) w WHERE (oprcena>0 OR oprcena=-1)
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 ') w WHERE (oprcena>0 OR oprcena=-1)' at line 1
Chyba v SQL dotazu:
SELECT MIN(oprcena) as mincena, MAX(oprcena) as maxcena FROM (SELECT oprcena FROM (SELECT CASE WHEN (s.skladem > s.aktprod) THEN 1 ELSE 0 END AS jeskladem, e.*, CASE WHEN e.cena1>0 AND e.cena1 IS NOT NULL THEN e.cena1 WHEN d.cena1 IS NOT NULL THEN d.cena1 ELSE 0 END as oprcena FROM intimity_es_sortiment e LEFT JOIN maca_es_sortiment d ON e.idz=d.idz LEFT JOIN maca_es_sklad s ON e.idz=s.idz WHERE e.ukaz=1 AND (IFNULL(e.nadrazen, '') NOT LIKE '' ) AND (e.nadrazen like '%|1318|%' OR e.nadrazen like '%|1319|%' OR e.nadrazen like '%|1321|%' OR e.nadrazen like '%|1322|%' OR e.nadrazen like '%|1323|%' OR e.nadrazen like '%|1324|%' OR e.nadrazen like '%|1325|%' OR e.nadrazen like '%|1326|%' OR e.nadrazen like '%|1327|%' OR e.nadrazen like '%|1328|%' OR e.nadrazen like '%|1329|%' OR e.nadrazen like '%|1330|%' OR e.nadrazen like '%|1331|%' OR e.nadrazen like '%|1334|%' OR e.nadrazen like '%|1335|%' OR e.nadrazen like '%|1336|%' OR e.nadrazen like '%|1337|%' OR e.nadrazen like '%|1338|%' OR e.nadrazen like '%|1339|%' OR e.nadrazen like '%|1340|%' OR e.nadrazen like '%|1341|%' OR e.nadrazen like '%|1342|%' OR e.nadrazen like '%|1343|%' OR e.nadrazen like '%|1344|%' OR e.nadrazen like '%|1346|%' OR e.nadrazen like '%|1347|%' OR e.nadrazen like '%|1348|%' OR e.nadrazen like '%|1349|%' OR e.nadrazen like '%|1351|%' OR e.nadrazen like '%|1356|%' OR e.nadrazen like '%|1357|%' OR e.nadrazen like '%|1358|%' OR e.nadrazen like '%|1360|%' OR e.nadrazen like '%|1361|%' OR e.nadrazen like '%|1362|%') AND ) w WHERE oprcena>0) t
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 ') w WHERE oprcena>0) t' at line 1
Chyba v SQL dotazu:
SELECT * FROM (SELECT CASE WHEN (s.skladem > s.aktprod) THEN 1 ELSE 0 END AS jeskladem, e.*, CASE WHEN e.cena1>0 AND e.cena1 IS NOT NULL THEN e.cena1 WHEN d.cena1 IS NOT NULL THEN d.cena1 ELSE 0 END as oprcena FROM intimity_es_sortiment e LEFT JOIN maca_es_sortiment d ON e.idz=d.idz LEFT JOIN maca_es_sklad s ON e.idz=s.idz WHERE e.ukaz=1 AND (IFNULL(e.nadrazen, '') NOT LIKE '' ) AND (e.nadrazen like '%|1318|%' OR e.nadrazen like '%|1319|%' OR e.nadrazen like '%|1321|%' OR e.nadrazen like '%|1322|%' OR e.nadrazen like '%|1323|%' OR e.nadrazen like '%|1324|%' OR e.nadrazen like '%|1325|%' OR e.nadrazen like '%|1326|%' OR e.nadrazen like '%|1327|%' OR e.nadrazen like '%|1328|%' OR e.nadrazen like '%|1329|%' OR e.nadrazen like '%|1330|%' OR e.nadrazen like '%|1331|%' OR e.nadrazen like '%|1334|%' OR e.nadrazen like '%|1335|%' OR e.nadrazen like '%|1336|%' OR e.nadrazen like '%|1337|%' OR e.nadrazen like '%|1338|%' OR e.nadrazen like '%|1339|%' OR e.nadrazen like '%|1340|%' OR e.nadrazen like '%|1341|%' OR e.nadrazen like '%|1342|%' OR e.nadrazen like '%|1343|%' OR e.nadrazen like '%|1344|%' OR e.nadrazen like '%|1346|%' OR e.nadrazen like '%|1347|%' OR e.nadrazen like '%|1348|%' OR e.nadrazen like '%|1349|%' OR e.nadrazen like '%|1351|%' OR e.nadrazen like '%|1356|%' OR e.nadrazen like '%|1357|%' OR e.nadrazen like '%|1358|%' OR e.nadrazen like '%|1360|%' OR e.nadrazen like '%|1361|%' OR e.nadrazen like '%|1362|%') AND ) w WHERE (oprcena>0 OR oprcena=-1) ORDER BY poradi DESC LIMIT 0,16
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 ') w WHERE (oprcena>0 OR oprcena=-1) ORDER BY poradi DESC LIMIT 0,16' at line 1
Výsledek vyhledávání - Intimity.cz

Výsledek vyhledávání

Tomuto výběru neodpovídá žádný produkt