/ Háztartási gépek, kiegészítők / Hűtő, Fagyasztószekrény / Fagyasztó

Hiba: SELECT kat1.MenuNev as mnev, kat1.Kategoria AS fokat, kat1.Menuoszlop,kat1.KatID AS fokat_ID, kat2.Kategoria AS kat, kat2.KatID AS kat_ID, kat3.Kategoria AS alkat, kat3.KatID AS alkat_ID, ifnull(fodb.fodb,0) as fodb, ifnull(db.db,0) as db, ifnull(aldb.aldb,0) as aldb FROM kategoriak kat1 LEFT JOIN kategoriak kat2 ON kat1.KatID = kat2.ParentID LEFT JOIN kategoriak kat3 ON kat2.KatID = kat3.ParentID INNER JOIN ( SELECT FoKatID, count( FoKatID ) AS fodb FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not FoKatID in (365,535) GROUP BY FoKatID )fodb ON fodb.FoKatID = kat1.KatID left JOIN ( SELECT KatID, count( KatID ) AS db FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not KatID in (365,535) GROUP BY KatID )db ON db.KatID = kat2.KatID left JOIN ( SELECT AlKatID, count( AlKatID ) AS aldb FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not AlKatID in (365,535) GROUP BY AlKatID )aldb ON aldb.AlKatID = kat3.KatID WHERE (kat1.ParentID =0 and kat1.menukell<>0 and kat1.KatID not in (0) and (kat2.KatID not in (0) or kat2.KatID is null) and (kat3.KatID not in (0) or kat3.KatID is null)) and (kat1.KatID in (5,305,399,181,214,342,45,227,0,365,402,118,100,505,491,499,271,535,542) or kat2.KatID in (7,1,6,15,19,20,26,35,24,33,306,400,204,337,213,182,414,201,413,218,377,443,423,412,391,428,462,192,389,66,410,437,408,368,401,470,0,296,416,460,305,467,46,11,23,14,21,65,22,34,366,441,403,418,458,113,431,319,172,411,405,387,241,404,361,119,396,513,514,508,493,94,511,506,502,499,228,328,525,518,512,465,101,500,257,406,395,475,527,534,348,517,530,507,407,448,125,474,481,132,529,515,343,164,471,144,445,473,354,285,533,449,234,145,394,536,543) or kat3.KatID in (9,10,2,4,0,16,18,29,30,38,309,371,397,217,206,185,379,386,447,383,439,374,183,440,373,438,409,430,434,381,392,419,67,461,425,300,426,452,435,455,415,414,305,370,8,13,3,36,215,39,208,37,444,367,464,427,380,69,384,433,504,385,469,432,322,429,179,390,226,382,472,451,388,387,446,361,466,378,123,393,244,241,398,312,513,514,508,220,493,94,511,531,302,506,502,499,480,335,525,518,512,313,101,500,453,520,424,475,524,527,180,412,534,375,517,417,421,530,482,522,231,372,507,230,298,479,456,474,481,436,463,529,188,498,515,343,468,369,245,258,376,473,526,242,532,287,533,68,132,450,236,394,457,70) ) ORDER BY kat1.menukell,fokat, kat, alkat

Hiba: Lost connection to MySQL server during query
Sor: 52

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/gen_menu.php on line 57
Bejelentkezés
   
Érdekes hírek, újdonságok   Hozzászólások Értékeld te is a termékeket! Regisztrálj, és segíts másokat a döntésben!
 
kategóriák

Hiba: SELECT kat1.Kategoria AS fokat, kat1.KatID AS fokat_ID, kat2.Kategoria AS kat, kat2.KatID AS kat_ID, kat3.Kategoria AS alkat, kat3.KatID AS alkat_ID, ifnull(fodb.fodb,0) as fodb, ifnull(db.db,0) as db, ifnull(aldb.aldb,0) as aldb FROM kategoriak kat1 LEFT JOIN kategoriak kat2 ON kat1.KatID = kat2.ParentID LEFT JOIN kategoriak kat3 ON kat2.KatID = kat3.ParentID INNER JOIN ( SELECT FoKatID, count( FoKatID ) AS fodb FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not FoKatID in (365,535) GROUP BY FoKatID )fodb ON fodb.FoKatID = kat1.KatID left JOIN ( SELECT KatID, count( KatID ) AS db FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not KatID in (365,535) GROUP BY KatID )db ON db.KatID = kat2.KatID left JOIN ( SELECT AlKatID, count( AlKatID ) AS aldb FROM termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and not AlKatID in (365,535) GROUP BY AlKatID )aldb ON aldb.AlKatID = kat3.KatID WHERE kat1.ParentID =0 ORDER BY kat1.sorrend, fokat, kat, alkat

Hiba: MySQL server has gone away
Sor: *

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/menu.php on line 43
 
akciók
SPAR, INTERSPAR
ALDI
KIKA
MediaMarkt
Lidl
Auchan
Metro
dm
 
hozzászólások

Hiba: SELECT termekek.* , termek_velemeny.*, k.volt FROM termekek INNER JOIN ( SELECT TermekID, max( ID ) AS utso, count(TermekID) as volt FROM `termek_velemeny` GROUP BY TermekID ORDER BY utso DESC limit 0,10 )k ON k.TermekID = termekek.TermekID INNER JOIN termek_velemeny ON termek_velemeny.ID = k.utso inner join kereskedok on termekek.CegID=kereskedok.CegID where termekek.Torolve=0 and termekek.TermAktiv=1 and kereskedok.KerAktiv=1

Hiba: MySQL server has gone away
Sor: 25

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/utolso_hozzaszolasok.php on line 26

Hiba: select kat1.Kategoria as fokat, kat1.KatID as fokat_ID, kat2.Kategoria as kat, kat2.KatID as kat_ID, kat3.Kategoria as alkat, kat3.KatID as alkat_ID from kategoriak kat1 left join kategoriak kat2 on kat1.KatID=kat2.ParentID left join kategoriak kat3 on kat2.KatID=kat3.ParentID where kat3.KatID=415

Hiba: MySQL server has gone away
Sor: 55

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/kategoria.php on line 56

Hiba: select count(TermekID) as darab from termekek inner join kereskedok on termekek.CegID=kereskedok.CegID where TermAktiv=1 and KerAktiv=1 and FoKatID =181 and KatID =414 and AlKatID =415 and (not FoKatID in (365,535) and not KatID in (365,535)and not AlKatID in (365,535))

Hiba: MySQL server has gone away
Sor: 126

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/kategoria.php on line 127

Hiba: select termekek.*, kereskedok.Cegnev, ((AkcioKezdete<=curdate() and AkcioKezdete<>'0000-00-00' and AkcioVege ='0000-00-00') or (AkcioKezdete='0000-00-00' and AkcioVege >= curdate()) or (curdate() between AkcioKezdete and AkcioVege)) as vanAkcio, termekkep.KepNev from termekek inner join kereskedok on termekek.CegID=kereskedok.CegID left join termekkep on termekek.TermekID=termekkep.termekID where TermAktiv=1 and KerAktiv=1 and FoKatID =181 and KatID =414 and AlKatID =415 and (not FoKatID in (365,535) and not KatID in (365,535)and not AlKatID in (365,535)) group by termekek.TermekID order by termekek.Megnevezes asc Limit 0,25

Hiba: MySQL server has gone away
Sor: *

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/kategoria.php on line 156
/ /
 
Rendezés: Tétel oldalanként:
 
 
Partnereink
Alföldapró.hu
Alföldautó.hu
Lakáskínálat.hu
Hír3.hu
Női napozó
 
 
Gyakori keresések

Hiba: SELECT distinct AlKatID, Kategoria, termekek.KatID, FoKatID from termekek inner Join kategoriak on termekek.AlKatID=kategoriak.KatID inner join kereskedok on termekek.CegID=kereskedok.CegID where termekek.Torolve=0 and KerAktiv=1 and AlKatID<>0 order by rand() limit 0, 20

Hiba: MySQL server has gone away
Sor: 14

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/kategoriak_listazas.php on line 15

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/kategoriak_listazas.php on line 18

Warning: Division by zero in /home/alfold07/alfoldplaza.hu/kategoriak_listazas.php on line 31
 
 
Aktív tagok

Hiba: select * from megrendelok where VanKep<>'' and Torolt_m=0 order by rand() limit 0,6

Hiba: MySQL server has gone away
Sor: 20

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/alfold07/alfoldplaza.hu/tagok_listazas.php on line 22
 
Hasznos információk
Segítség a vásárláshoz
Hogyan nyithat áruházat nálunk?
Kik vagyunk?
Felhasználási feltételek
Adatkezelés
 
© 2010-2018 Comeon  I  Médiaajánlat  I  Kapcsolat