Můj účet
*

*


Zapomněl jsem heslo
Vytvořit novou registraci
Můj účet
*

*


Zapomněl jsem heslo
Vytvořit novou registraci
Úvod   |   Informace   |   Prodejna   |   Kontakt   |  
KATALOG

Mobilní telefony, mobily, smartphone

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 AND kat_id IN (957,2472,2473,2475,2476,2808,2812,2814,2815,2816,2817)) 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 (957,2472,2473,2475,2476,2808,2812,2814,2815,2816,2817), 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 AND (f1.vyrobce=167?sort=cena) AND pouze_darek = 0 AND f1.kat_id != '2903' ) f_all GROUP BY f_all.id HAVING viditelne = 1 ORDER BY je_telefon DESC, preference_prodej DESC, pocet_zobrazeni DESC LIMIT 0, 24Chyba: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 '?sort=cena) AND pouze_darek = 0 AND f1.kat_id != '2903' ) f_a' at line 69
MYSQLDotaz:SELECT Count(id) AS totalRecords FROM (SELECT f_all.* FROM (SELECT f1.id, RAND() AS rnd, 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 AND kat_id IN (957,2472,2473,2475,2476,2808,2812,2814,2815,2816,2817)) km1 LEFT JOIN (SELECT id, kat_cislo, datum_vlozeni, datum_novinka, produkt, typ_polozky, barva, 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 (957,2472,2473,2475,2476,2808,2812,2814,2815,2816,2817), 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 AND (f1.vyrobce=167?sort=cena) AND pouze_darek = 0 AND f1.kat_id != '2903' ) f_all GROUP BY f_all.id HAVING viditelne = 1 ) AS TChyba: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 '?sort=cena) AND pouze_darek = 0 AND f1.kat_id != '2903' ) f_a' at line 63
Výpis je omezen těmito vybranými parametry:
Zrušit všechny filtryMYSQLDotaz:SELECT id, name, IF(poradi > 0, poradi, 100000) AS poradi2 FROM c_vyrobci WHERE id IN (167?sort=cena) ORDER BY poradi2, nameChyba: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 '?sort=cena) ORDER BY poradi2, name' at line 1
  |     |     |     |  
Nebyl nalezen žádný odpovídající produkt

© 1M.cz,   2001-2024   |   e-shop: triangl web