Unknown column 's.sted' in 'order clause'#0 db::q(SELECT SQL_CALC_FOUND_ROWS i.dato_start, p.alltid_instans,pa.pakkenavn_for_kunde, p.pris_verdi, p.idProdukt,p.tittel,p.beskrivelse_kort,p.innleveringer,p.varighet,p.forkunnskaper,p.malgruppe,p.studiepoeng,p.beskrivelse,p.pris_kommentar,p.sokeord,l.leverandor,p.prioritet,priority_boost,priority_calc ,IF(l.leverandor='',1,IF(IF(p.priority_calc>0,p.priority_calc,0)=0,default_prioritet,p.priority_calc)) AS prioritet_plukket ,pa.default_prioritet AS priority_school , IF(p.alltid_instans != 'Nei', 2, IF((i.dato_start >= '2018-12-19' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired IN (1 , 2)) OR (i.dato_start >= '2019-01-18' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired NOT IN (1 , 2)) OR i.pameldingsfrist >= '2019-01-18', 1, 2)) AS date_order FROM kg_Leverandor l, kg_Pakke pa , kg_ProduktKategori pk , kg_Produkt p LEFT JOIN kg_Instans i ON i.idProdukt=p.idProdukt WHERE p.aktiv='Ja' and l.aktiv='Ja' and i.deleted != 'Yes' and p.idProdukt NOT IN (46947,46479,48727,1776,20957,13827,47615,23220,47391,46469,42930,45191,45193,14952,1813,47388,47390,24277,24278,45244,48262,47134,14946,4268,4269,4270,4271,18733,4874,14947,13329,48976,13394,20252,10519,48112,23276,10520,10521,48369,44235,49368,49139,45241,48714,48963,22742,43016,46726,49171,13234,13235,13236,13249,13237,13238,13239,13240,13242,13243,13244,13245,13246,13247,13248,13252,13253,13255,13259,13266,13261,13262,13263,13264,13265,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13284,13286,13287,13288,13289,13290,13292,13294,13295,13296,13297,13298,13301,13302,13303,13304,13305,13306,13307,13308,13309,13327,13332,13333,13334,13335,22840,22841,22842,22843,13571,46272,13695,14950,23722,14616,14655,14951,22369,49058,21286,16662,15409,15410,44056,17691,47816,47817,16028,16029,16031,16139,16140,16144,48886,21856,24108,16596,16622,20253,47741,17296,17328,17665,17692,22267,17666,17667,48271,17693,31837,23019,46277,46655,49079,19271,22930,34544,43264,48938,48940,43236,20385,20386,49017,49152,22370,23527,20384,20383,22401,48289,20500,20501,20506,21161,21269,21327,44036,31834,21457,49030,23260,22095,22096,46162,22271,22272,22273,22274,22337,48536,49211,22524,22523,46791,44236,24110,22859,42574,22858,22865,23639,23061,23082,23089,23121,49096,23215,23280,47135,47136,47137,48148,47138,23627,23529,23589,23597,23598,23599,23604,23600,23602,23605,23607,23603,23606,23637,23835,23623,23921,24073,23693,23696,23712,23792,23826,44242,49012,23883,23898,23911,23933,48385,48403,48611,24046,24066,24686,24103,24104,24119,24153,24409,49124,48567,48466,46608,24620,48377,48447,48338,24671,24672,24740,24857,46470,48939,25509,25511,49154,25693,25731,26415,26438,26439,26445,26550,31714,48686,48458,47734,48003,27849,27850,27876,27877,47393,43391,47015,28840,29067,29069,43599,47206,31700,29943,46921,31719,44644,32707,32910,32909,32914,32911,32912,32913,32916,32917,32918,32919,32934,33828,34375,47392,42691,34742,34741,34743,45646,35251,35335,35863,37028,37029,37353,38374,47951,47947,47948,49150,47949,38487,41785,39573,39771,41450,47316,41766,41774,41850,42024,47730,42140,42141,48770,49004,42325,42327,42331,42332,42484,42485,42645,42379,42405,42443,42444,49329,49128,42560,42566,42565,42567,42568,42569,42570,42572,49174,49153,42639,42647,42648,42649,42651,42660,43019,43021,43229,43228,43266,43240,43328,43329,44189,43382,43394,48593,48594,48120,44030,44029,43622,43618,43658,43678,44618,43693,43695,44603,44606,43987,43989,44089,44068,44060,49151,44065,45710,44151,44181,44201,44204,44227,44723,44364,44380,44888,44471,45252,44636,44547,44548,44546,45259,45260,45261,45326,45327,48449,45723,45389,45392,45399,45696,48443,45522,45548,45639,45682,45684,45697,45698,48248,45712,46049,45808,45843,45912,45913,46028,46048,46047,46533,46276,48264,46115,46150,46152,48574,47009,46213,49235,46565,48610,46486,46492,46495,46496,46497,46500,46501,46893,47606,46527,46512,46513,46515,46516,46518,46519,46530,46531,46541,46542,46546,46547,46548,46550,46551,46552,46553,46554,46555,46556,46560,46572,46566,46567,46568,46569,46573,46574,46575,46576,46577,46578,46579,47733,46600,46868,46609,46613,46616,46617,46618,46619,46620,46621,46622,48340,46638,46640,46641,46642,46643,46644,46645,46646,47814,46916,46662,46748,46853,46658,46660,46663,46664,46665,46666,46667,46668,46671,46673,46674,47010,46680,46681,46682,46683,46684,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46695,46696,46700,49375,46703,48715,46730,46732,46742,46755,46756,46764,46765,46768,48465,46770,46777,46780,46781,46786,46787,46788,46789,46790,46792,49057,46802,46803,46804,46806,46807,46808,46809,46810,46811,46812,46814,46815,46816,46817,46818,46819,46820,46821,46822,46823,46824,46825,46827,46828,46830,46831,46832,46834,46835,46836,46837,46845,46846,46847,46848,46849,46851,46852,46854,46855,46856,46857,46858,46859,46860,46861,46862,46863,46865,46866,46867,46869,46870,46871,46872,46873,46875,46876,46877,46878,46879,46880,46881,46882,46883,46884,46885,46886,46887,46888,46889,46890,46891,46892,46894,46895,46896,46897,46898,46900,46899,46901,46902,46903,46905,46909,46910,46911,46912,46913,46942,46914,46915,46917,46918,46919,46920,46922,46923,46924,46925,46926,46927,46928,46929,46930,46931,46932,46933,46934,46935,46943,46945,46946,49015,46949,46950,48363,46952,46953,46954,46955,46956,46962,46963,46964,46965,46966,46967,47423,46968,46970,46971,46972,46973,46974,46975,46976,46977,46978,46981,47360,46983,47200,46988,46991,46992,46993,46994,46995,47265,47405,47016,47017,47018,47019,47020,47021,47022,47026,47027,47032,47035,47060,47061,47063,47065,47068,47070,47072,47079,47081,47083,47084,47089,48463,47090,47091,47094,47095,47096,47104,47105,47106,47108,47110,47109,47111,47112,47113,47115,47116,47117,47122,47123,47124,47126,47127,47128,47129,47130,47131,47132,47133,47324,47642,49177,47141,49026,47515,48464,47148,47151,47152,47177,47158,47159,47161,47160,47162,47163,47165,47166,47167,47168,47169,47173,47172,47175,47178,47179,47180,47181,47182,47183,47317,47185,47188,47323,49009,47190,47191,47194,47195,47196,47199,47207,47209,47241,47384,48263,47217,47218,47219,47221,47223,47225,47226,47611,47227,47228,47229,47735,47230,47236,47240,47244,47245,47248,47246,47247,47249,47250,47252,47253,47254,47255,47256,47257,47258,47259,47260,47261,47262,47263,47264,47266,47267,47268,47275,47276,47277,47278,47279,47280,47281,47282,47283,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47307,47308,47309,47310,47311,47313,47318,47357,47320,47322,47325,47326,47327,47330,47332,47334,47335,47340,47341,47342,47343,47344,47347,47348,47349,47350,47354,47356,48013,47361,47363,47371,47372,47516,47373,47374,47375,47376,47377,47378,47379,47380,47381,47382,47394,47395,47396,47397,47398,47399,47400,47401,47402,47403,47404,47406,47407,47408,47409,47410,47411,47412,47413,47414,48419,47417,47418,47421,47422,47424,47425,47426,47731,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47441,47442,47443,47444,47445,47446,47447,47448,47449,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47596,47486,47487,47488,47489,47490,47491,47492,47493,47494,47495,47496,47497,47498,47499,47500,47501,47502,47503,47504,47505,47506,47507,47508,47509,47510,47511,47512,47513,47514,47517,47518,47519,47520,47521,47522,47523,47524,47525,47526,47527,47528,47529,47530,47531,47532,47533,47534,47535,47536,47537,47538,47539,47540,47541,47542,47543,47544,47545,47546,47547,47548,47549,47550,47551,47552,47553,47554,47555,47556,47557,47558,47559,47560,47561,47562,47563,47564,47565,47566,47567,47568,47569,47570,47571,47572,47573,47574,47575,47576,47577,47578,47579,47580,47581,47582,47583,47584,47585,47586,47587,47588,47589,47590,47591,47592,47593,47594,47595,47597,47634,47602,47603,47604,47607,47608,47609,47610,47612,47613,47616,47618,47624,47626,47627,47628,47629,47630,47631,47632,47633,48432,47815,47645,48566,47651,47652,47653,47654,47655,47656,47661,47679,47732,47920,48030,47701,47708,47724,48847,49166,48866,47736,47737,47738,47739,49028,49039,47748,49146,47758,47757,47765,47767,47768,47771,47772,47773,47774,47788,47779,47780,47784,47787,47789,48732,47797,47799,47800,47801,47802,47803,47808,47819,47820,47821,47822,47823,47824,47825,47826,47827,47828,47829,47830,47831,47837,47839,47840,48071,47851,47855,48637,48254,47908,47987,47916,47943,47946,48064,47964,47965,48423,47972,47985,47990,48246,47994,48359,47999,48000,48004,48249,48005,48006,48007,48247,48018,48031,48028,48029,48279,48032,48033,48036,48041,48044,48045,48046,48047,48048,48049,48050,48051,48052,48053,48054,48055,48056,48057,48058,48059,48060,48061,48062,48063,48065,48066,48072,48073,48074,48076,48077,48078,48079,48081,48094,48105,48334,48161,48162,48163,48164,48165,48173,48209,48211,48212,48219,48220,48221,48222,48223,48224,48225,48226,48399,48554,48569,48570,48621,48734,48767,48955,48780,48856,48848,48951,49020,48929,48933,48930,48934,48935,48936,48937,48948,48949,49213,48992,48994,48995,49102,49125,49005,49006,49007,49008,49018,49019,49021,49022,49023,49024,49025,49027,49034,49196,49036,49037,49071,49073,49074,49178,49081,49083,49412,49251,49111,49131,49132,49135,49136,49137,49141,49142,49149,49155,49156,49157,49158,49159,49160,49161,49162,49164,49165,49167,49168,49169,49170,49175,49172,49176,49179,49208,49210,49214,49212,49236,49256,49261,49319,49328,49397,49315) and p.idLeverandor=l.idLeverandor and l.idPakke=pa.idPakke and p.visningssted IN ('Kursguiden','Begge') and ( i.idCountry='159' or (i.idCountry IS NULL and l.idCountry='159')) and ( idExpired IN (1,2) or ( idExpired IN (3,4) and ( (i.pameldingsfrist >= '2019-01-18' and i.deleted='No') or (i.dato_start >= '2019-01-18' and i.vis_ved_passert_pameldingsfrist = 'Ja' and i.deleted='No') or (i.dato_start >= '2019-01-18' and i.pameldingsfrist IS NULL and i.deleted='No') or (i.idInstans IS NULL) ))) and pk.idProdukt=p.idProdukt and ( pk.idKategori='556' ) GROUP BY p.idProdukt ORDER BY s.sted LIMIT 15) called at [/data/kursguiden/www/sok_main_query_2012.inc.php:387] #1 include(/data/kursguiden/www/sok_main_query_2012.inc.php) called at [/data/kursguiden/www/views/listing.inc.php:400] #2 include(/data/kursguiden/www/views/listing.inc.php) called at [/data/kursguiden/www/index.php:226] #3 include(/data/kursguiden/www/index.php) called at [/data/kursguiden/www/kurs/index.php:370] Unknown column 's.sted' in 'order clause'#0 db::q(SELECT SQL_CALC_FOUND_ROWS i.dato_start, p.alltid_instans,pa.pakkenavn_for_kunde, max(p.pris_verdi) as max_price, p.idProdukt,p.tittel,p.beskrivelse_kort,p.innleveringer,p.varighet,p.forkunnskaper,p.malgruppe,p.studiepoeng,p.beskrivelse,p.pris_kommentar,p.sokeord,l.leverandor,p.prioritet,priority_boost,priority_calc ,IF(l.leverandor='',1,IF(IF(p.priority_calc>0,p.priority_calc,0)=0,default_prioritet,p.priority_calc)) AS prioritet_plukket ,pa.default_prioritet AS priority_school , IF(p.alltid_instans != 'Nei', 2, IF((i.dato_start >= '2018-12-19' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired IN (1 , 2)) OR (i.dato_start >= '2019-01-18' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired NOT IN (1 , 2)) OR i.pameldingsfrist >= '2019-01-18', 1, 2)) AS date_order FROM kg_Leverandor l, kg_Pakke pa , kg_ProduktKategori pk , kg_Produkt p LEFT JOIN kg_Instans i ON i.idProdukt=p.idProdukt WHERE p.aktiv='Ja' and l.aktiv='Ja' and i.deleted != 'Yes' and p.idProdukt NOT IN (46947,46479,48727,1776,20957,13827,47615,23220,47391,46469,42930,45191,45193,14952,1813,47388,47390,24277,24278,45244,48262,47134,14946,4268,4269,4270,4271,18733,4874,14947,13329,48976,13394,20252,10519,48112,23276,10520,10521,48369,44235,49368,49139,45241,48714,48963,22742,43016,46726,49171,13234,13235,13236,13249,13237,13238,13239,13240,13242,13243,13244,13245,13246,13247,13248,13252,13253,13255,13259,13266,13261,13262,13263,13264,13265,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13284,13286,13287,13288,13289,13290,13292,13294,13295,13296,13297,13298,13301,13302,13303,13304,13305,13306,13307,13308,13309,13327,13332,13333,13334,13335,22840,22841,22842,22843,13571,46272,13695,14950,23722,14616,14655,14951,22369,49058,21286,16662,15409,15410,44056,17691,47816,47817,16028,16029,16031,16139,16140,16144,48886,21856,24108,16596,16622,20253,47741,17296,17328,17665,17692,22267,17666,17667,48271,17693,31837,23019,46277,46655,49079,19271,22930,34544,43264,48938,48940,43236,20385,20386,49017,49152,22370,23527,20384,20383,22401,48289,20500,20501,20506,21161,21269,21327,44036,31834,21457,49030,23260,22095,22096,46162,22271,22272,22273,22274,22337,48536,49211,22524,22523,46791,44236,24110,22859,42574,22858,22865,23639,23061,23082,23089,23121,49096,23215,23280,47135,47136,47137,48148,47138,23627,23529,23589,23597,23598,23599,23604,23600,23602,23605,23607,23603,23606,23637,23835,23623,23921,24073,23693,23696,23712,23792,23826,44242,49012,23883,23898,23911,23933,48385,48403,48611,24046,24066,24686,24103,24104,24119,24153,24409,49124,48567,48466,46608,24620,48377,48447,48338,24671,24672,24740,24857,46470,48939,25509,25511,49154,25693,25731,26415,26438,26439,26445,26550,31714,48686,48458,47734,48003,27849,27850,27876,27877,47393,43391,47015,28840,29067,29069,43599,47206,31700,29943,46921,31719,44644,32707,32910,32909,32914,32911,32912,32913,32916,32917,32918,32919,32934,33828,34375,47392,42691,34742,34741,34743,45646,35251,35335,35863,37028,37029,37353,38374,47951,47947,47948,49150,47949,38487,41785,39573,39771,41450,47316,41766,41774,41850,42024,47730,42140,42141,48770,49004,42325,42327,42331,42332,42484,42485,42645,42379,42405,42443,42444,49329,49128,42560,42566,42565,42567,42568,42569,42570,42572,49174,49153,42639,42647,42648,42649,42651,42660,43019,43021,43229,43228,43266,43240,43328,43329,44189,43382,43394,48593,48594,48120,44030,44029,43622,43618,43658,43678,44618,43693,43695,44603,44606,43987,43989,44089,44068,44060,49151,44065,45710,44151,44181,44201,44204,44227,44723,44364,44380,44888,44471,45252,44636,44547,44548,44546,45259,45260,45261,45326,45327,48449,45723,45389,45392,45399,45696,48443,45522,45548,45639,45682,45684,45697,45698,48248,45712,46049,45808,45843,45912,45913,46028,46048,46047,46533,46276,48264,46115,46150,46152,48574,47009,46213,49235,46565,48610,46486,46492,46495,46496,46497,46500,46501,46893,47606,46527,46512,46513,46515,46516,46518,46519,46530,46531,46541,46542,46546,46547,46548,46550,46551,46552,46553,46554,46555,46556,46560,46572,46566,46567,46568,46569,46573,46574,46575,46576,46577,46578,46579,47733,46600,46868,46609,46613,46616,46617,46618,46619,46620,46621,46622,48340,46638,46640,46641,46642,46643,46644,46645,46646,47814,46916,46662,46748,46853,46658,46660,46663,46664,46665,46666,46667,46668,46671,46673,46674,47010,46680,46681,46682,46683,46684,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46695,46696,46700,49375,46703,48715,46730,46732,46742,46755,46756,46764,46765,46768,48465,46770,46777,46780,46781,46786,46787,46788,46789,46790,46792,49057,46802,46803,46804,46806,46807,46808,46809,46810,46811,46812,46814,46815,46816,46817,46818,46819,46820,46821,46822,46823,46824,46825,46827,46828,46830,46831,46832,46834,46835,46836,46837,46845,46846,46847,46848,46849,46851,46852,46854,46855,46856,46857,46858,46859,46860,46861,46862,46863,46865,46866,46867,46869,46870,46871,46872,46873,46875,46876,46877,46878,46879,46880,46881,46882,46883,46884,46885,46886,46887,46888,46889,46890,46891,46892,46894,46895,46896,46897,46898,46900,46899,46901,46902,46903,46905,46909,46910,46911,46912,46913,46942,46914,46915,46917,46918,46919,46920,46922,46923,46924,46925,46926,46927,46928,46929,46930,46931,46932,46933,46934,46935,46943,46945,46946,49015,46949,46950,48363,46952,46953,46954,46955,46956,46962,46963,46964,46965,46966,46967,47423,46968,46970,46971,46972,46973,46974,46975,46976,46977,46978,46981,47360,46983,47200,46988,46991,46992,46993,46994,46995,47265,47405,47016,47017,47018,47019,47020,47021,47022,47026,47027,47032,47035,47060,47061,47063,47065,47068,47070,47072,47079,47081,47083,47084,47089,48463,47090,47091,47094,47095,47096,47104,47105,47106,47108,47110,47109,47111,47112,47113,47115,47116,47117,47122,47123,47124,47126,47127,47128,47129,47130,47131,47132,47133,47324,47642,49177,47141,49026,47515,48464,47148,47151,47152,47177,47158,47159,47161,47160,47162,47163,47165,47166,47167,47168,47169,47173,47172,47175,47178,47179,47180,47181,47182,47183,47317,47185,47188,47323,49009,47190,47191,47194,47195,47196,47199,47207,47209,47241,47384,48263,47217,47218,47219,47221,47223,47225,47226,47611,47227,47228,47229,47735,47230,47236,47240,47244,47245,47248,47246,47247,47249,47250,47252,47253,47254,47255,47256,47257,47258,47259,47260,47261,47262,47263,47264,47266,47267,47268,47275,47276,47277,47278,47279,47280,47281,47282,47283,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47307,47308,47309,47310,47311,47313,47318,47357,47320,47322,47325,47326,47327,47330,47332,47334,47335,47340,47341,47342,47343,47344,47347,47348,47349,47350,47354,47356,48013,47361,47363,47371,47372,47516,47373,47374,47375,47376,47377,47378,47379,47380,47381,47382,47394,47395,47396,47397,47398,47399,47400,47401,47402,47403,47404,47406,47407,47408,47409,47410,47411,47412,47413,47414,48419,47417,47418,47421,47422,47424,47425,47426,47731,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47441,47442,47443,47444,47445,47446,47447,47448,47449,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47596,47486,47487,47488,47489,47490,47491,47492,47493,47494,47495,47496,47497,47498,47499,47500,47501,47502,47503,47504,47505,47506,47507,47508,47509,47510,47511,47512,47513,47514,47517,47518,47519,47520,47521,47522,47523,47524,47525,47526,47527,47528,47529,47530,47531,47532,47533,47534,47535,47536,47537,47538,47539,47540,47541,47542,47543,47544,47545,47546,47547,47548,47549,47550,47551,47552,47553,47554,47555,47556,47557,47558,47559,47560,47561,47562,47563,47564,47565,47566,47567,47568,47569,47570,47571,47572,47573,47574,47575,47576,47577,47578,47579,47580,47581,47582,47583,47584,47585,47586,47587,47588,47589,47590,47591,47592,47593,47594,47595,47597,47634,47602,47603,47604,47607,47608,47609,47610,47612,47613,47616,47618,47624,47626,47627,47628,47629,47630,47631,47632,47633,48432,47815,47645,48566,47651,47652,47653,47654,47655,47656,47661,47679,47732,47920,48030,47701,47708,47724,48847,49166,48866,47736,47737,47738,47739,49028,49039,47748,49146,47758,47757,47765,47767,47768,47771,47772,47773,47774,47788,47779,47780,47784,47787,47789,48732,47797,47799,47800,47801,47802,47803,47808,47819,47820,47821,47822,47823,47824,47825,47826,47827,47828,47829,47830,47831,47837,47839,47840,48071,47851,47855,48637,48254,47908,47987,47916,47943,47946,48064,47964,47965,48423,47972,47985,47990,48246,47994,48359,47999,48000,48004,48249,48005,48006,48007,48247,48018,48031,48028,48029,48279,48032,48033,48036,48041,48044,48045,48046,48047,48048,48049,48050,48051,48052,48053,48054,48055,48056,48057,48058,48059,48060,48061,48062,48063,48065,48066,48072,48073,48074,48076,48077,48078,48079,48081,48094,48105,48334,48161,48162,48163,48164,48165,48173,48209,48211,48212,48219,48220,48221,48222,48223,48224,48225,48226,48399,48554,48569,48570,48621,48734,48767,48955,48780,48856,48848,48951,49020,48929,48933,48930,48934,48935,48936,48937,48948,48949,49213,48992,48994,48995,49102,49125,49005,49006,49007,49008,49018,49019,49021,49022,49023,49024,49025,49027,49034,49196,49036,49037,49071,49073,49074,49178,49081,49083,49412,49251,49111,49131,49132,49135,49136,49137,49141,49142,49149,49155,49156,49157,49158,49159,49160,49161,49162,49164,49165,49167,49168,49169,49170,49175,49172,49176,49179,49208,49210,49214,49212,49236,49256,49261,49319,49328,49397,49315) and p.idLeverandor=l.idLeverandor and l.idPakke=pa.idPakke and p.visningssted IN ('Kursguiden','Begge') and ( i.idCountry='159' or (i.idCountry IS NULL and l.idCountry='159')) and ( idExpired IN (1,2) or ( idExpired IN (3,4) and ( (i.pameldingsfrist >= '2019-01-18' and i.deleted='No') or (i.dato_start >= '2019-01-18' and i.vis_ved_passert_pameldingsfrist = 'Ja' and i.deleted='No') or (i.dato_start >= '2019-01-18' and i.pameldingsfrist IS NULL and i.deleted='No') or (i.idInstans IS NULL) ))) and pk.idProdukt=p.idProdukt and ( pk.idKategori='556' ) GROUP BY p.idProdukt ORDER BY s.sted ) called at [/data/kursguiden/www/sok_main_query_2012.inc.php:405] #1 include(/data/kursguiden/www/sok_main_query_2012.inc.php) called at [/data/kursguiden/www/views/listing.inc.php:400] #2 include(/data/kursguiden/www/views/listing.inc.php) called at [/data/kursguiden/www/index.php:226] #3 include(/data/kursguiden/www/index.php) called at [/data/kursguiden/www/kurs/index.php:370] Reklame - Kurs over hele landet på kursguiden.no 2019
Markedsføringskurs
Du har valgt: Reklame
Nullstill
Filter
Ferdig

-

Mer enn 100 treff i Reklame
 


Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.