Array
(
    [0] => 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 'ORDER BY position' at line 1
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
)

Array
(
    [0] => 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 'ORDER BY position' at line 1
    [1] => 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 'ORDER BY position' at line 1
    [2] => 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 '' at line 7
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
    [1] => 
    [2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
)

Array
(
    [0] => 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 'ORDER BY position' at line 1
    [1] => 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 'ORDER BY position' at line 1
    [2] => 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 '' at line 7
    [3] => 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 '))
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
    [1] => 
    [2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [3] => SELECT s.manufacturer_id FROM s_product s
						JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1) 
								WHERE s.active = 1
								AND s.manufacturer_id > 0
								AND spd.name != ''
								GROUP BY s.manufacturer_id;	
						
)

Array
(
    [0] => 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 'ORDER BY position' at line 1
    [1] => 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 'ORDER BY position' at line 1
    [2] => 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 '' at line 7
    [3] => 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 '))
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
    [4] => 
    [5] => 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 '' at line 7
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
    [1] => 
    [2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [3] => SELECT s.manufacturer_id FROM s_product s
						JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1) 
								WHERE s.active = 1
								AND s.manufacturer_id > 0
								AND spd.name != ''
								GROUP BY s.manufacturer_id;	
						
    [4] => 
    [5] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
)

Array
(
    [0] => 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 'ORDER BY position' at line 1
    [1] => 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 'ORDER BY position' at line 1
    [2] => 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 '' at line 7
    [3] => 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 '))
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
    [4] => 
    [5] => 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 '' at line 7
    [6] => 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 '))
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = ' at line 8
    [7] => 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 '))
					JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe' at line 6
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
    [1] => 
    [2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [3] => SELECT s.manufacturer_id FROM s_product s
						JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1) 
								WHERE s.active = 1
								AND s.manufacturer_id > 0
								AND spd.name != ''
								GROUP BY s.manufacturer_id;	
						
    [4] => 
    [5] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [6] => SELECT COUNT(distinct sp.id) AS cnt,
					MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
					MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
        				
			FROM s_product sp
				JOIN s_product_extras spe ON (sp.id = spe.product_id )
				
				 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )  WHERE 1=1  AND sp.active = 1 AND spd.name != ''  AND IFNULL(sp.hidden,0)=0  
    [7] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
					FROM s_product AS sp
					JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )
					JOIN s_product_extras spe ON(sp.id = spe.product_id )
					JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
					 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
					JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
					WHERE 1=1
						AND sp.active = 1
						
						AND spd.name != ''
						
						AND IFNULL(sp.hidden,0)=0
						
					GROUP BY s_attribute2s_attribute_value_id, spe.product_id
					
)

Array
(
    [0] => 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 'ORDER BY position' at line 1
    [1] => 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 'ORDER BY position' at line 1
    [2] => 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 '' at line 7
    [3] => 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 '))
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id' at line 2
    [4] => 
    [5] => 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 '' at line 7
    [6] => 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 '))
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = ' at line 8
    [7] => 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 '))
					JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe' at line 6
    [8] => 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 '))
		 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language' at line 5
)

Array
(
    [0] => SELECT attribute_id AS id FROM s_attribute_list2s_category WHERE category_id= ORDER BY position
    [1] => 
    [2] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [3] => SELECT s.manufacturer_id FROM s_product s
						JOIN s_product2s_category spc ON (s.id = spc.product_id AND spc.category_id IN ())
						JOIN s_product_desc spd ON (s.id = spd.s_product_id AND spd.language_id=1) 
								WHERE s.active = 1
								AND s.manufacturer_id > 0
								AND spd.name != ''
								GROUP BY s.manufacturer_id;	
						
    [4] => 
    [5] => SELECT c1.id AS c1, c2.id AS c2, c3.id AS c3, c4.id AS c4, c5.id AS c5
                FROM s_category AS c1
                LEFT JOIN s_category as c2 ON (c2.parent = c1.id AND IFNULL(c2.active,0)=1)
                LEFT JOIN s_category as c3 ON (c3.parent = c2.id AND IFNULL(c3.active,0)=1)
                LEFT JOIN s_category as c4 ON (c4.parent = c3.id AND IFNULL(c4.active,0)=1)
                LEFT JOIN s_category as c5 ON (c5.parent = c4.id AND IFNULL(c5.active,0)=1)
             WHERE IFNULL(c1.active,0)=1 AND c1.parent = 
        
    [6] => SELECT COUNT(distinct sp.id) AS cnt,
					MAX(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS max_price,
					MIN(IF(IFNULL(spe.action_price,0)>0, spe.action_price, spe.price)) AS min_price
        				
			FROM s_product sp
				JOIN s_product_extras spe ON (sp.id = spe.product_id )
				
				 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
		 JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )  WHERE 1=1  AND sp.active = 1 AND spd.name != ''  AND IFNULL(sp.hidden,0)=0  
    [7] => SELECT s_attribute2s_attribute_value_id, COUNT(s_attribute2s_attribute_value_id) AS cnt
					FROM s_product AS sp
					JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id = '1' )
					JOIN s_product_extras spe ON(sp.id = spe.product_id )
					JOIN s_product_pivot AS pivot ON (sp.id=pivot.product_id AND spe.id=pivot.product_extras_id )
					 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
					JOIN s_product_extras2s_attribute2s_attribute_value AS spe2sa2sav ON(spe.id = spe2sa2sav.s_product_extras_id)
					WHERE 1=1
						AND sp.active = 1
						
						AND spd.name != ''
						
						AND IFNULL(sp.hidden,0)=0
						
					GROUP BY s_attribute2s_attribute_value_id, spe.product_id
					
    [8] => 
			SELECT sp.id AS id, (IF(spe.stock > 0, 1, 0)+IF(spe.action_price > 0, 1, 0)+is_new+exposed ) as defsort
			FROM s_product sp
				JOIN s_product_extras spe ON (sp.id = spe.product_id )
				
				 JOIN s_product2s_category sp2sc ON(sp.id = sp2sc.product_id AND sp2sc.category_id IN ())
		 	LEFT JOIN s_product_desc spd ON(sp.id = spd.s_product_id AND spd.language_id=1)	
						LEFT JOIN system_url su ON(su.pkey_value = sp.id AND su.table='s_product')
						LEFT JOIN system_url_desc sud ON(su.id = sud.system_url_id)
						
						LEFT JOIN s_manufacturer sm ON (sp.manufacturer_id = sm.id)
						LEFT JOIN s_manufacturer_desc smd ON (sm.id = smd.s_manufacturer_id AND smd.language_id = 1)
		 WHERE 1=1  AND sp.active = 1 AND spd.name != ''  AND IFNULL(sp.hidden,0)=0   GROUP BY sp.id  ORDER BY defsort DESC, spd.name ASC LIMIT 0, 21 
)

02 564 95 40

prodaja@geder.si

• Obročno odplačilo
• O nas
• Servis
• Lokacije poslovalnic
• Kontakt

Košarica:

0,00 € (0)

0

Košarica je prazna

Brezplačna dostava za nakup nad 150 €

• Trata
  Robotske kosilnice
  Vrtne kosilnice
  Vrtni traktorji
  Zero-turn kosilnice
  Riderji
  Komunalni riderji
  Kose in trimerji
  Prezračevalniki
• Gozd
  Verižne žage
  Gozdarski obrezovalniki
  Višinski obrezovalniki
• Vrt & okolica
  Škarje za živo mejo
  Pihalniki
  Prekopalniki
  Visokotlačni čistilniki
  Sesalniki
  Snežne freze
  Škropilnice
  Freze za štore
  Drobilniki
  Zalivalni sistemi
  Ročno orodje
  Rovokopači
• Delavnica
  Akumulatorsko orodje
  Električno orodje
  Agregati in črpalke
• Dodatna oprema
  Pribor in dodatna oprema za stroje
  Osebna varovalna oprema
  Sekire in gozdarsko orodje
  Otroške igrače
  Maziva, gorivo in posode
  Pasovi za orodja
  Oblačila in dodatki
• Akcijska ponudba
• Odprodaja
  Rezervni deli

02 564 95 40

prodaja@geder.si

Košarica:

0,00 € (0)

0

Košarica je prazna

Brezplačna dostava za nakup nad 150 €

• Obročno odplačilo
• O nas
• Servis
• Lokacije poslovalnic
• Kontakt

• Trata
  • Robotske kosilnice
  • Vrtne kosilnice
  • Vrtni traktorji
  • Zero-turn kosilnice
  • Riderji
  • Komunalni riderji
  • Kose in trimerji
  • Prezračevalniki
• Gozd
  • Verižne žage
  • Gozdarski obrezovalniki
  • Višinski obrezovalniki
• Vrt & okolica
  • Škarje za živo mejo
  • Pihalniki
  • Prekopalniki
  • Visokotlačni čistilniki
  • Sesalniki
  • Snežne freze
  • Škropilnice
  • Freze za štore
  • Drobilniki
  • Zalivalni sistemi
  • Ročno orodje
  • Rovokopači
• Delavnica
  • Akumulatorsko orodje
  • Električno orodje
  • Agregati in črpalke
• Dodatna oprema
  • Pribor in dodatna oprema za stroje
  • Osebna varovalna oprema
  • Sekire in gozdarsko orodje
  • Otroške igrače
  • Maziva, gorivo in posode
  • Pasovi za orodja
  • Oblačila in dodatki
• Akcijska ponudba
• Odprodaja
  • Rezervni deli

Prijava uporabnika

E-pošta Geslo

Prijava

Pozabil/a sem geslo

Kupujete prvič?

Nakupujte varno in udobno. Kot naš uporabnik imate vpogled tudi v status naročila. Postopek je enostaven, potrebujemo le vaš elektronski naslov in nekaj podatkov.

Registracija

Naročite ogled

Vsak vrt je edinstven – zato vam na podlagi ogleda svetujemo katera robotska kosilnica je primerna za vas. Pri ogledu točno določimo območje košnje, najdemo primerno mesto polnilne postaje, svetujemo kako pripraviti vrt, da bo robotska kosilnica karseda učinkovita. Parcelo premerimo in vam pošljemo relevantno ponudbo. Za ogled se obračuna kavcija 50€, katera se v primeru nakupa robotske kosilnice pri nas obračuna v ceni le-te.

Ime in priimek *

Naslov *

E-pošta *

Telefon *

Strinjam se, da podjetje GEDER, servis, trgovina d.o.o. interno hrani in obdeluje osebne podatke, ki so navedeni v obrazcu za interne analize ter statistične obdelave. *

Strinjam se s plačilom kavcije 50€ *

Polja označena z * so obvezna!