MYSQLDotaz:SELECT id, textcz AS text FROM texty_multilangChyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`texty_multilang` MYSQLDotaz:SELECT kurz FROM kurz_cnb WHERE mena='978' Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`kurz_cnb` MYSQLDotaz:SELECT * FROM kosik_pamet WHERE id>0 AND website='3' AND user_id=0 AND ip='18.220.136.182' ORDER BY idChyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`kosik_pamet` MYSQLDotaz:DELETE FROM kosik_pamet WHERE (user_id=0 AND timestamp < DATE_SUB(current_timestamp, INTERVAL 3 MONTH)) OR website IS NULL OR katalog_id IS NULLChyba:SELECT command denied to user '21069_27535'@'localhost' for column 'user_id' in table 'kosik_pamet' MYSQLDotaz:SELECT Count(id) AS pocet, ip, id FROM `kosik_pamet` WHERE user_id=0 GROUP BY ip HAVING pocet > 25Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`kosik_pamet` MYSQLDotaz:SELECT * FROM kosik_pamet WHERE id>0 AND website='3' AND user_id=0 AND ip='18.220.136.182' ORDER BY idChyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`kosik_pamet` MYSQLDotaz:SELECT vyrobce FROM katalog WHERE id='600' Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog` MYSQLDotaz:SELECT sleva_skupina FROM zakaznici_dslevy WHERE zakaznik_id='' AND znacka_id = '' Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`zakaznici_dslevy` MYSQLDotaz:SELECT * FROM katalog_minprodej2katalog WHERE katalog_id='600' AND dealer_skupina='1'Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog_minprodej2katalog` MYSQLDotaz:INSERT INTO katalog_zobrazeni SET katalog_id='600', pocet_zobrazeni=1 ON DUPLICATE KEY UPDATE pocet_zobrazeni=pocet_zobrazeni+1Chyba:INSERT, UPDATE command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog_zobrazeni` MYSQLDotaz:SELECT f1.*,
f1.id AS katalog_id,
IF(f1.namecz != '', f1.namecz, f1.namecz) AS name,
IF(3 = 3 OR 3 = 6,
IF(f1.popis3cz != '', f1.popis3cz,
IF(f1.popiscz != '', f1.popiscz,
IF(f1.popis3cz != '', f1.popis3cz, f1.popiscz))), IF(f1.popiscz != '', f1.popiscz, f1.popiscz)) AS popis,
IF (f1.kratky_popiscz != '' OR f1.popiscz != '', IF(f1.kratky_popiscz != '', f1.kratky_popiscz, SUBSTR(f1.popiscz,1,300)), IF(f1.kratky_popiscz != '', f1.kratky_popiscz, SUBSTR(f1.popiscz,1,300))) AS kratky_popis,
f1.end_of_life,
f1.home3 AS home,
f1.vyprodej3 AS vyprodej,
f1.tip3 AS tip,
f1.novinka3 AS novinka,
IF(ADDDATE(datum_vlozeni, INTERVAL 2 MONTH) > current_date, 1, 0) AS novinka,
IF (akcni_cena2web_3cz > 0, IF(akce_do2web_3cz >= current_date OR akce_do2web_3cz IS NULL, akcni_cena2web_3cz, 0), 0) AS akcni_cena,
IF (akcni_cena2web_3cz > 0, IF(akce_do2web_3cz >= current_date OR akce_do2web_3cz IS NULL, akcni_cena2web_3cz, IF(cena2web_3cz > 0, cena2web_3cz, cenacz)), IF(cena2web_3cz > 0, cena2web_3cz, cenacz)) AS cena,
IF((3 = 3 OR 3 = 6) AND cena2web_3cz > 0, cena2web_3cz, cenacz) AS cenacz,
cena2web_3cz,
cena2web_3sk,
f10.name AS dph,
(c_dostupnost.name) AS dostupnost_txt,
f5.dostupnost,
IF (date_dostupnost > 0, DATE_FORMAT(date_dostupnost, '%d.%m.%Y'), '') AS date_dostup_upr,
f4.name AS vyrobce_txt,
IFNULL((SELECT SUM(mnozstvi) FROM rezervace fr1 LEFT JOIN (SELECT id, stav FROM objednavky WHERE stav != 4) fr2 ON (fr2.id = fr1.obj_id) WHERE fr1.varianta_id = f5.id AND fr2.stav NOT IN (4) GROUP BY fr1.varianta_id), 0) AS rezervace,
IFNULL((SELECT SUM(mnozstvi) AS total_prirazeno
FROM
(SELECT * FROM objednane_polozky WHERE sklad_id > 0) fb1
LEFT JOIN (SELECT id, stav FROM objednavky WHERE stav NOT IN (7,8)) fb2 ON (fb2.id = fb1.obj_id)
WHERE fb2.stav NOT IN (7,8) AND fb1.varianta_id=f5.id GROUP BY fb1.varianta_id),0) AS blokace,
(SELECT file FROM katalog_pics WHERE katalog_pics.katalog_id = f1.id AND verejne='1' ORDER BY poradi LIMIT 1) AS foto,
(SELECT file FROM katalog_pics WHERE katalog_pics.varianta_id = f5.id AND verejne='1' ORDER BY poradi LIMIT 1) AS foto_varianta,
if (f5.namecz != '', CONCAT(IF(f1.namecz != '', f1.namecz, f1.namecz),', ',f5.namecz), IF(f1.namecz != '', f1.namecz, f1.namecz)) AS name,
f1.namecz AS katalog_name,
f1.archiv,
f5.id AS var_id,
f5.id AS varianta_id,
f5.namecz AS varianta_name,
f5.ean AS ean,
f5.hmotnost,
f9.kat_id AS kategorie,
(SELECT GROUP_CONCAT(IF(f12.namecz != '', f12.namecz, f12.namecz) SEPARATOR ', ') AS pall FROM katalog_varianta_value f11 LEFT JOIN c_katalog_params_items f12 ON (f12.id = f11.hodnota) WHERE f11.varianta_id = f5.id) AS param_name_all,
IF (f5.viditelne = 0 OR f5.archiv=1, 'unavailable', '') AS varianta_error,
f5.seo_titlecz AS seo_title,
f5.seo_descriptioncz AS seo_description,
f5.seo_keywordscz AS seo_keywords,
(SELECT SUM(mnozstvi) FROM sklad_mnozstvi fx3 LEFT JOIN c_sklad fx4 ON (fx4.id = fx3.sklad_id) WHERE fx3.varianta_id = f5.id AND (fx3.sklad_id > 0 AND fx4.archiv = 0 AND fx4.verejne=1)) AS sklad_mnozstvi,
SUM(IF( f1.viditelne = 1
AND ((m1.viditelne IS NULL OR m1.viditelne=1)
AND (m2.viditelne IS NULL OR m2.viditelne=1)
AND (m3.viditelne IS NULL OR m3.viditelne=1)
AND (m4.viditelne IS NULL OR m4.viditelne=1)
AND (m5.viditelne IS NULL OR m5.viditelne=1)), 1, 0)) AS viditelne
FROM
katalog AS f1
LEFT JOIN c_vyrobci f4 ON (f1.vyrobce = f4.id)
LEFT JOIN (SELECT * FROM katalog_varianta WHERE (archiv=0 AND viditelne=1) OR id='1104') f5 ON (f1.id = f5.katalog_id)
LEFT JOIN c_dostupnost ON (f5.dostupnost = c_dostupnost.id)
LEFT JOIN katalog2menu f9 ON (f9.prod_id = f1.id)
LEFT JOIN c_dph f10 ON (f5.dph = f10.zkratka AND f10.aktualni = 1)
LEFT JOIN menu f11 ON (f11.id = f9.kat_id)
LEFT JOIN menu m1 ON (m1.id = f9.kat_id)
LEFT JOIN menu m2 ON (m2.id = m1.parent_id)
LEFT JOIN menu m3 ON (m3.id = m2.parent_id)
LEFT JOIN menu m4 ON (m4.id = m3.parent_id)
LEFT JOIN menu m5 ON (m5.id = m4.parent_id)
WHERE
f5.id='1104' AND web2show3 = 1 AND f11.special=0
GROUP BY f5.id
LIMIT 1
Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog` MYSQLDotaz:SELECT
*
FROM
(SELECT
f1.id,
f1.namecz AS name,
f1.viditelne,
dostupnost,
IF (akcni_cena2web_3cz > 0, IF(akce_do2web_3cz >= current_date OR akce_do2web_3cz IS NULL, akcni_cena2web_3cz, 0), 0) AS akcni_cena,
IF (akcni_cena2web_3cz > 0, IF(akce_do2web_3cz >= current_date OR akce_do2web_3cz IS NULL, akcni_cena2web_3cz, IF(cena2web_3cz > 0, cena2web_3cz, cenacz)), IF(cena2web_3cz > 0, cena2web_3cz, cenacz)) AS cena,
IF((3 = 3 OR 3 = 6) AND cena2web_3cz > 0, cena2web_3cz, cenacz) AS cenacz,
cena2web_3cz,
(SELECT COUNT(id) AS f FROM katalog_pics WHERE katalog_pics.varianta_id = f1.id AND verejne='1' ORDER BY poradi LIMIT 1) AS pocet_foto,
f4.name AS dostupnost_txt,
hmotnost,
f1.ean,
f2.hodnota,
f2.param_id,
IF(f3.namecz != '', f3.namecz, f3.namecz) AS value_txt,
f5.name AS param_name,
IF(f5.name_publiccz != '', f5.name_publiccz, f5.name_publiccz) AS param_name_public,
CONCAT(IF(f5.name_publiccz != '', f5.name_publiccz, f5.name_publiccz),': ',IF(f3.namecz != '', f3.namecz, f3.namecz)) AS param_name_full,
CONCAT(IF(f3.namecz != '', f3.namecz, f3.namecz)) AS param_name_short,
productname_zbozi,
productname_heureka,
productname_sk1,
productname_sk2,
productname_sk3,
(SELECT SUM(mnozstvi) FROM sklad_mnozstvi fx3 WHERE fx3.varianta_id = f1.id AND sklad_id=1) AS sklad_mnozstvi,
IFNULL((SELECT SUM(mnozstvi) FROM rezervace fr1 LEFT JOIN (SELECT id, stav FROM objednavky WHERE stav != 4) fr2 ON (fr2.id = fr1.obj_id) WHERE fr1.varianta_id = f1.id AND fr2.stav NOT IN (4) GROUP BY fr1.varianta_id), 0) AS rezervace
FROM
katalog_varianta f1
LEFT JOIN katalog_varianta_value f2 ON (f2.varianta_id = f1.id)
LEFT JOIN c_katalog_params_items f3 ON (f2.hodnota = f3.id)
LEFT JOIN c_katalog_params f5 ON (f2.param_id = f5.id)
LEFT JOIN param2group f6 ON (f6.param_id = f2.param_id AND f6.group_id=1)
LEFT JOIN c_dostupnost f4 ON (f4.id = f1.dostupnost)
WHERE
f1.id>0
AND f1.archiv=0
AND f1.viditelne=1
AND f1.katalog_id='600'
ORDER BY f1.poradi, f6.poradi, f3.param_id
) AS fx1
Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog_pics` MYSQLDotaz:SELECT * FROM katalog_pics WHERE katalog_id='' AND (varianta_id=0 OR varianta_id IS NULL) AND verejne=1 AND viditelne=1 ORDER BY poradiChyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog_pics` MYSQLDotaz:SELECT kat_id, f2.* FROM (SELECT * FROM katalog2menu WHERE prod_id='600') AS f1 LEFT JOIN menu f2 ON (f1.kat_id = f2.id)
LEFT JOIN menu f3 ON (f3.id = f2.parent_id)
LEFT JOIN menu f4 ON (f4.id = f3.parent_id)
LEFT JOIN menu f5 ON (f5.id = f4.parent_id)
LEFT JOIN menu f6 ON (f6.id = f5.parent_id)
WHERE
f2.parent_id = 53 OR f3.parent_id = 53 OR f4.parent_id = 53 OR f5.parent_id = 53 OR f6.parent_id = 53
ORDER BY vazba2znacka DESC LIMIT 1Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`katalog2menu` MYSQLDotaz:SELECT *, namecz AS name, namecz_h1 AS name_h1, UCASE(namecz) AS nameUC, urlcz AS url, IF (poradi > 0, poradi, 100000) AS poradi2, soucast_menu FROM menu WHERE id>0 AND id='' AND viditelne='1' ORDER BY poradi2, nameczChyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`menu` /
MYSQLDotaz:SELECT zprava, IF(prodleva > 0, prodleva, 1) AS prodleva FROM homepage_special WHERE viditelne=1 AND website='3' AND (platne_od IS NULL OR platne_od=0 OR platne_od <= current_date) AND (platne_do IS NULL OR platne_do=0 OR platne_do >= current_date)Chyba:SELECT command denied to user '21069_27535'@'localhost' for table `21069_ghoda`.`homepage_special`
