SELECT * FROM cms_1_contents_en WHERE SUB='0' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='1' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='83' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='78' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='88' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='60' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='79' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='61' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='63' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='80' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='91' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='84' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='90' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="1" ORDER BY POSITION ASC
SELECT *,(VIEW + CART + BUY) AS STATS FROM cms_1_shop_en WHERE ACTIVE='1' ORDER BY STATS DESC LIMIT 3
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='7' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='7' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_contents_en WHERE ACTIVE="1" AND SUB="90" ORDER BY NO DESC
SELECT * FROM cms_1_pictures WHERE CONTENTID='90' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='90' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='90' AND MAIN='1' AND CONTENTTYPE='1'
PROMOTION | DYDEX
SELECT * FROM cms_1_news_en WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_en WHERE ACTIVE='1' AND SUB='0' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_en WHERE ACTIVE='1' AND SUB='78' ORDER BY NO ASC
SELECT * FROM cms_1_templates_en WHERE EXTRA="0"

PROMOTION

Current promotions

For the purchase of 2 identical products you receive 5% discount
For the purchase of 3 identical products you receive 10% discount
For the purchase of 4 identical products you receive 15% discount
For the purchase of 5 and every further identical products you receive 20% discount


The discounts above are not valid for promotional products!


GLS will deliver every order above HUF 12,000 free of charge!



  • Online order
    Order processing: From 08.00 to 14.00
  • Free shipping
    For orders above HUF 12000
  • Safe shopping
    your order information is safe

Cart

Total payable: 0 EUR
Continue shopping Jump to payment
DEVELOPER BAR