INSERT INTO s_online (uid,session) VALUES (0,'u5epai02ce1v1ufd46dh8ul5e6')SELECT kurs FROM s_kurs WHERE mena='EUR'SELECT kurs FROM s_kurs WHERE mena='GBP'SELECT kurs FROM s_kurs WHERE mena='PLN'SELECT * FROM s_nastaveni WHERE active = 1 AND (iso2 = '' OR iso2 = 'cz') ORDER BY idSELECT id FROM s_menu_items WHERE view='slunecni-bryle' AND uroven = 0 LIMIT 1;SELECT title,other,description,keywords FROM s_titles WHERE view='slunecni-bryle' AND display='' AND lang='cz' LIMIT 1SELECT nazev FROM s_menu_items WHERE view='slunecni-bryle' AND display='' AND lang='cz' LIMIT 1SELECT description FROM s_titles WHERE view='slunecni-bryle' AND display='' AND lang='cz'SELECT keywords FROM s_titles WHERE view='slunecni-bryle' AND display='' AND lang='cz'SELECT description FROM s_titles WHERE view='main' AND display='' AND lang='cz'SELECT keywords FROM s_titles WHERE view='main' AND display='' AND lang='cz'SELECT k.*,c.id,c.username,c.uid,c.item_id,c.session,c.quantity,c.atributy,c.val_dostupnost,k.cena,(k.cena - k.cena/100*tax.percent_tax) AS cena_bez_dane,k.sleva,(k.sleva - k.sleva/100*tax.percent_tax) AS sleva_bez_dane,tax.percent_tax,mn.pocet FROM s_cart AS c LEFT JOIN s_katalog AS k ON(c.item_id = k.id) LEFT JOIN s_katalog_mnozstvi AS mn ON(k.id = mn.id_katalog) LEFT JOIN s_taxes AS tax ON(k.id_tax = tax.id_tax) WHERE c.session = 'u5epai02ce1v1ufd46dh8ul5e6' AND (c.username = 'guest' OR c.username = '')ORDER BY c.timestamp DESC; slunecni-bryle | e-shop | TITLE
SELECT mi.*,me.nazev AS menu_nazev, me.type, IF(mi.poradi < 100 AND mi.uroven > 1,CONCAT(SUBSTRING(mi.cesta,1,CHAR_LENGTH(mi.cesta)-2),'0',SUBSTRING_INDEX(mi.cesta, '-', -1)),mi.cesta) AS cesta2 FROM s_menu_items AS mi LEFT JOIN s_menu AS me ON(mi.menu_id = me.id) WHERE me.nazev='leftmenu' AND mi.lang='cz' AND mi.uroven <= 999 AND mi.uroven >= 0 AND mi.active = TRUE ORDER BY cesta2,mi.skupina,mi.poradi,mi.nazev
  •