Naposledy prohlížené
MYSQLDotaz:SELECT f_all.* FROM
(SELECT
f1.id,
RAND() AS rnd,
f1.produkt AS name,
f1.typ_polozky,
CONCAT(f1.produkt,' ',f1.barva) AS name_full,
f1.barva,
f1.popis AS kratky_popis,
f1.vyprodej,
f1.end_of_life,
f1.nelze_objednat,
f1.tip,
f1.3dz,
f1.akce,
f1.pripravujeme,
f1.dostupnost,
f14.novinka,
IF(f1.datum_novinka > 0, f1.datum_novinka, f1.datum_vlozeni) AS datum_vlozeni,
IF (akcni_cena > 0 OR akce = 1,
IF(akcni_cena > 0 AND (akce_od <= current_date OR akce_od IS NULL OR akce_od = 0) AND (akce_do >= current_date OR akce_do IS NULL OR akce_do = 0), akcni_cena,
IF (akce = 1, cena, 0)), 0) AS akcni_cena,
IF (akcni_cena > 0, IF((akce_od <= current_date OR akce_od IS NULL OR akce_od = 0) AND (akce_do >= current_date OR akce_do IS NULL OR akce_do = 0), akcni_cena, cena), cena) AS cena,
IFNULL(sklad_mnozstvi_verejne,0) AS sklad_mnozstvi_verejne,
IFNULL((SELECT SUM(mnozstvi) FROM rezervace WHERE rezervace.varianta_id = f1.id GROUP BY rezervace.varianta_id), 0) AS rezervace,
doprava_zdarma,
preference_prodej,
f5.name AS dostupnost_txt,
f1.je_telefon,
f1.kat_id,
f13.name AS vyrobce_txt,
f2.pocet_zobrazeni,
IF(pripravujeme = 1, docasne_foto, 0) AS docasne_foto,
f1.viditelne,
f1.date_ocekavane_naskladneni
FROM
(SELECT
*
FROM
(SELECT * FROM katalog2menu WHERE prod_id > 0 ) km1
LEFT JOIN (SELECT id, kat_cislo, datum_vlozeni, datum_novinka, produkt, typ_polozky, barva, popis, dph, akcni_cena, akce_od, akce_do, cena, cena_prodejna, parametry, zaruka, dostupnost, vyprodej, ean, ean2, ean3,
vyrobce, tip, akce, home, viditelne, archiv, param_set, pripravujeme, docasne_foto, 3dz, pouze_darek, end_of_life, nelze_objednat, doprava_zdarma, preference_prodej, IF(date_ocekavane_naskladneni > 0 AND date_ocekavane_naskladneni >= current_date, DATE_FORMAT(date_ocekavane_naskladneni, '%d.%m.%Y'), '') AS date_ocekavane_naskladneni,
IF(957 IN (0), 1, 0) AS je_telefon
FROM katalog WHERE archiv=0 AND viditelne=1) fx1 ON (km1.prod_id = fx1.id)
) f1
LEFT JOIN sklad_mnozstvi2_verejne f3 ON (f3.katalog_id = f1.id)
LEFT JOIN katalog_zobrazeni f2 ON (f2.katalog_id = f1.id)
LEFT JOIN c_dostupnost f5 ON (f5.id = f1.dostupnost)
LEFT JOIN c_vyrobci f13 ON (f1.vyrobce = f13.id)
LEFT JOIN katalog_novinka f14 ON (f14.katalog_id = f1.id)
WHERE
f1.id > 0
f1.kat_id != '2903'
) f_all
GROUP BY f_all.id
HAVING
viditelne = 1
ORDER BY je_telefon DESC
LIMIT 6Chyba:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f1.kat_id != '2903'
) f_all
GROUP BY f_all.i' at line 69