Includes any word     Includes all words
ABOUT US
PRODUCTS
CONTACT

Featured products


Unknown column 'CEG_4.AKCIOS_14' in 'where clause'
SELECT DISTINCT CEG_4.*, ARUK.NEV_en AS "Nev", ARUK_KATEGORIZALAS.KAT_ID, ARUK_KATEGORIAK.ID AS "KatID", ARUK_KATEGORIAK.PARENT AS "KatParent", ARUK_KATEGORIAK.NEV_en AS "KatNev" FROM CEG_4 LEFT JOIN ARUK ON (CEG_4.TKOD=ARUK.TKOD) LEFT JOIN ARUK_KATEGORIZALAS ON (ARUK_KATEGORIZALAS.TKOD=ARUK.TKOD) LEFT JOIN ARUK_KATEGORIAK ON (ARUK_KATEGORIAK.ID=ARUK_KATEGORIZALAS.KAT_ID) WHERE (CEG_4.AKCIOS_14>-1) AND (CEG_4.KIFUTO="0") AND (HAVI_AKCIO=9) AND (CEG_4.ARULT="1") AND (ARUK_KATEGORIAK.ARULT_4="1") ORDER BY ARUK_KATEGORIAK.NEV_HU, ARUK_KATEGORIZALAS.IND, ARUK_KATEGORIZALAS.IND;