SELECT K.kunr, K.visantikkat, K.visegnekat, K.visEgenIAntikkat, K.kukatejvalgt, Ka.ejvalgt, googleAnalyticsAPstort
, K.forhandlersider, K.valuta, IsNull(K.valuta2, K.valuta) AS valuta2
, K.valutamodul, K.zoommodul, K.mail, K.https, K.web, K.dir, K.fotoSmallx, K.fotoLargeX, smallzoom, egetKatPaaAntikUrl
, K.kurvAktiv, K.kurvLagerCheck, K.lagerAlleEen, K.emneeksternlink, K.emneeksternlinksprog
, K.apLokationKort, K.apLokationLang, visRobots, visOphavsretFoto, modersprog, sp049 AS sprogAktivt, K.UANddAktivPris
, K.headbesk145 AS headbesk1, K.headno1
, K.headbesk245 AS headbesk2, K.headno2
, K.headbesk345 AS headbesk3, K.headno3
, K.headbesk445 AS headbesk4, K.headno4
, K.headbesk545 AS headbesk5, K.headno5
, K.headbesk645 AS headbesk6, K.headno6
, K.headbesk745 AS headbesk7, K.headno7
FROM emner AS E INNER JOIN kategori AS Ka ON E.kukat = Ka.kukat INNER JOIN kunde AS K ON Ka.kunr = K.kunr
WHERE E.binr = 0 AND K.kunr=167