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-03-26' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired IN (1 , 2)) OR (i.dato_start >= '2018-04-25' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired NOT IN (1 , 2)) OR i.pameldingsfrist >= '2018-04-25', 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 LEFT JOIN kg_Place s ON s.idPlace=i.idSted WHERE p.aktiv='Ja' and l.aktiv='Ja' and p.idProdukt NOT IN (46646,1776,1813,22337,13827,13394,17296,18733,14655,16662,16596,16622,23061,23911,4874,23717,21856,22095,22096,23627,23696,23276,22742,22524,22865,23215,23623,42443,42444,46777,46845,46479,44056,44089,44065,45710,44471,45712,45912,45913,21327,13329,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,13571,13695,45191,46608,26415,46609,21269,42930,45193,14952,14946,14947,14950,14951,43264,23529,23589,23597,23598,23599,23604,23600,23605,23607,23603,23606,23637,23921,23693,23712,23826,44242,23883,23898,24046,24066,24686,24103,24104,24620,27849,27850,29067,29069,44644,42691,35251,37353,38487,41766,42024,42140,42141,42651,42660,44189,44151,44364,44888,45548,46115,46492,46512,15253,15264,15265,15266,15267,15272,15273,46791,45652,45653,45654,45655,45706,46481,46482,46486,46495,46496,46497,46792,46803,46819,46820,46821,46822,46825,23220,22840,22841,22842,22843,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15415,15416,15417,15419,15420,15422,15423,15424,22823,23527,21086,22778,22514,22517,22519,22518,22520,22859,22858,22857,22906,23639,23085,23105,23121,23223,28840,42405,42537,42560,43229,43228,43693,43695,44181,44201,44636,45414,45639,45714,24073,46655,23082,46533,46501,46527,46513,46515,46518,46519,46530,46531,46541,46542,46547,46552,46553,46554,46555,46556,46613,46616,46622,46645,46658,46671,46673,46674,46680,46681,46695,46730,46732,46742,46755,46756,46768,46770,46780,46781,46786,46787,46788,46789,46790,46804,46806,46807,46808,46809,46810,46811,46812,46814,46815,46816,46817,46818,46828,46835,46849,46851,46852,46855,46856,46857,46863,46865,46866,16137,24671,24672,26550,21286,22523,23019,23280,43266,46213,23631,22401,23722,23260,23602,23792,23933,46847,46848,43394,27858,42992,46067,19518,27859,22930,23835,21055,21904,45282,21161,21457,24153,39573,31714,34544,44036,25509,25511,26438,26439,44030,44029,38374,46860,46862,46864,46867,33828,34375,34742,34741,34743,31719,46277,42331,42332,43622,43618,44618,44204,45389,45390,45391,45392,45696,45697,45698,46028,46276,46148,42574,42484,42485,42645,42566,42565,42567,42568,42569,42570,42572,42647,42648,42649,43236,43599,43240,44380,45723,45522,45808,43439,43508,43524,43658,43664,43678,44603,44606,44227,45843,44547,44548,44546,46703,44647,45235,46318,45244,45241,46272,45252,45225,45259,45260,45261,45326,46438,46500,46516,46560,46572,46573,46574,46575,46576,46577,46578,46579,46600,46617,46618,46619,46620,46621,46638,46640,46641,46642,46643,46644,46802,46162,46150,46152,46565,46546,46548,46550,46551,46566,46567,46568,46569,46893,46868,46682,46683,46684,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46696,46700,46846,46869,46870,46871,46872,46873,46875,46876,46877,46878,46879,46880,46881,46883,46884,46885,46886,46887,46888,46889,46890,46891,46892,46895,46896,46897,46898,46900,46901,46902,46903,46905,46726,46662,46660,46663,46664,46665,46666,46667,46668) and p.idLeverandor=l.idLeverandor and l.idPakke=pa.idPakke and p.visningssted IN ('Kursguiden','Begge') and ( p.alltid_instans != 'Nei' or ( ( ( vis_ved_passert_pameldingsfrist = 'Ja' and idExpired IN (1,2)) or (i.dato_start >= '2018-04-25' and vis_ved_passert_pameldingsfrist = 'Ja' and idExpired NOT IN (1,2)) ) or i.pameldingsfrist >= '2018-04-25' ) or (( p.alltid_instans = 'Nei' ) AND i.dato_start IS NULL ) ) and pk.idProdukt=p.idProdukt and ( pk.idKategori='15' or pk.idKategori = '1936' or pk.idKategori = '1937' or pk.idKategori = '2024' or pk.idKategori = '2563' or pk.idKategori = '2535' or pk.idKategori = '253' or pk.idKategori = '255' or pk.idKategori = '256' or pk.idKategori = '257' or pk.idKategori = '258' or pk.idKategori = '259' or pk.idKategori = '260' or pk.idKategori = '262' or pk.idKategori = '264' or pk.idKategori = '266' or pk.idKategori = '267' or pk.idKategori = '1880' or pk.idKategori = '541' or pk.idKategori = '540' or pk.idKategori = '502' or pk.idKategori = '2030' or pk.idKategori = '2029' or pk.idKategori = '1453' or pk.idKategori = '1454' or pk.idKategori = '1455' or pk.idKategori = '1813' or pk.idKategori = '2053' or pk.idKategori = '2071' or pk.idKategori = '2072' or pk.idKategori = '2091' or pk.idKategori = '2092' or pk.idKategori = '2101' or pk.idKategori = '2127' or pk.idKategori = '2132' or pk.idKategori = '2295' or pk.idKategori = '2357' or pk.idKategori = '2626' or pk.idKategori = '2713' or pk.idKategori = '2863' or pk.idKategori = '2911' or pk.idKategori = '2968' ) GROUP BY p.idProdukt ORDER BY s.sted DESC LIMIT 15) called at [/data/kursguiden/www/sok_main_query_2012.inc.php:430] #1 include(/data/kursguiden/www/sok_main_query_2012.inc.php) called at [/data/kursguiden/www/views/listing.inc.php:368] #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:354] 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-03-26' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired IN (1 , 2)) OR (i.dato_start >= '2018-04-25' AND vis_ved_passert_pameldingsfrist = 'Ja' AND idExpired NOT IN (1 , 2)) OR i.pameldingsfrist >= '2018-04-25', 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 LEFT JOIN kg_Place s ON s.idPlace=i.idSted WHERE p.aktiv='Ja' and l.aktiv='Ja' and p.idProdukt NOT IN (46646,1776,1813,22337,13827,13394,17296,18733,14655,16662,16596,16622,23061,23911,4874,23717,21856,22095,22096,23627,23696,23276,22742,22524,22865,23215,23623,42443,42444,46777,46845,46479,44056,44089,44065,45710,44471,45712,45912,45913,21327,13329,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,13571,13695,45191,46608,26415,46609,21269,42930,45193,14952,14946,14947,14950,14951,43264,23529,23589,23597,23598,23599,23604,23600,23605,23607,23603,23606,23637,23921,23693,23712,23826,44242,23883,23898,24046,24066,24686,24103,24104,24620,27849,27850,29067,29069,44644,42691,35251,37353,38487,41766,42024,42140,42141,42651,42660,44189,44151,44364,44888,45548,46115,46492,46512,15253,15264,15265,15266,15267,15272,15273,46791,45652,45653,45654,45655,45706,46481,46482,46486,46495,46496,46497,46792,46803,46819,46820,46821,46822,46825,23220,22840,22841,22842,22843,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15415,15416,15417,15419,15420,15422,15423,15424,22823,23527,21086,22778,22514,22517,22519,22518,22520,22859,22858,22857,22906,23639,23085,23105,23121,23223,28840,42405,42537,42560,43229,43228,43693,43695,44181,44201,44636,45414,45639,45714,24073,46655,23082,46533,46501,46527,46513,46515,46518,46519,46530,46531,46541,46542,46547,46552,46553,46554,46555,46556,46613,46616,46622,46645,46658,46671,46673,46674,46680,46681,46695,46730,46732,46742,46755,46756,46768,46770,46780,46781,46786,46787,46788,46789,46790,46804,46806,46807,46808,46809,46810,46811,46812,46814,46815,46816,46817,46818,46828,46835,46849,46851,46852,46855,46856,46857,46863,46865,46866,16137,24671,24672,26550,21286,22523,23019,23280,43266,46213,23631,22401,23722,23260,23602,23792,23933,46847,46848,43394,27858,42992,46067,19518,27859,22930,23835,21055,21904,45282,21161,21457,24153,39573,31714,34544,44036,25509,25511,26438,26439,44030,44029,38374,46860,46862,46864,46867,33828,34375,34742,34741,34743,31719,46277,42331,42332,43622,43618,44618,44204,45389,45390,45391,45392,45696,45697,45698,46028,46276,46148,42574,42484,42485,42645,42566,42565,42567,42568,42569,42570,42572,42647,42648,42649,43236,43599,43240,44380,45723,45522,45808,43439,43508,43524,43658,43664,43678,44603,44606,44227,45843,44547,44548,44546,46703,44647,45235,46318,45244,45241,46272,45252,45225,45259,45260,45261,45326,46438,46500,46516,46560,46572,46573,46574,46575,46576,46577,46578,46579,46600,46617,46618,46619,46620,46621,46638,46640,46641,46642,46643,46644,46802,46162,46150,46152,46565,46546,46548,46550,46551,46566,46567,46568,46569,46893,46868,46682,46683,46684,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46696,46700,46846,46869,46870,46871,46872,46873,46875,46876,46877,46878,46879,46880,46881,46883,46884,46885,46886,46887,46888,46889,46890,46891,46892,46895,46896,46897,46898,46900,46901,46902,46903,46905,46726,46662,46660,46663,46664,46665,46666,46667,46668) and p.idLeverandor=l.idLeverandor and l.idPakke=pa.idPakke and p.visningssted IN ('Kursguiden','Begge') and ( p.alltid_instans != 'Nei' or ( ( ( vis_ved_passert_pameldingsfrist = 'Ja' and idExpired IN (1,2)) or (i.dato_start >= '2018-04-25' and vis_ved_passert_pameldingsfrist = 'Ja' and idExpired NOT IN (1,2)) ) or i.pameldingsfrist >= '2018-04-25' ) or (( p.alltid_instans = 'Nei' ) AND i.dato_start IS NULL ) ) and pk.idProdukt=p.idProdukt and ( pk.idKategori='15' or pk.idKategori = '1936' or pk.idKategori = '1937' or pk.idKategori = '2024' or pk.idKategori = '2563' or pk.idKategori = '2535' or pk.idKategori = '253' or pk.idKategori = '255' or pk.idKategori = '256' or pk.idKategori = '257' or pk.idKategori = '258' or pk.idKategori = '259' or pk.idKategori = '260' or pk.idKategori = '262' or pk.idKategori = '264' or pk.idKategori = '266' or pk.idKategori = '267' or pk.idKategori = '1880' or pk.idKategori = '541' or pk.idKategori = '540' or pk.idKategori = '502' or pk.idKategori = '2030' or pk.idKategori = '2029' or pk.idKategori = '1453' or pk.idKategori = '1454' or pk.idKategori = '1455' or pk.idKategori = '1813' or pk.idKategori = '2053' or pk.idKategori = '2071' or pk.idKategori = '2072' or pk.idKategori = '2091' or pk.idKategori = '2092' or pk.idKategori = '2101' or pk.idKategori = '2127' or pk.idKategori = '2132' or pk.idKategori = '2295' or pk.idKategori = '2357' or pk.idKategori = '2626' or pk.idKategori = '2713' or pk.idKategori = '2863' or pk.idKategori = '2911' or pk.idKategori = '2968' ) GROUP BY p.idProdukt ORDER BY s.sted DESC ) called at [/data/kursguiden/www/sok_main_query_2012.inc.php:458] #1 include(/data/kursguiden/www/sok_main_query_2012.inc.php) called at [/data/kursguiden/www/views/listing.inc.php:368] #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:354] Juridiske kurs - Klikk her for kurs i juss - Kursguiden.no 2018
Alle kategorier
Du har valgt: Juridiske kurs
Nullstill
Filter
Ferdig

-

0 treff i Juridiske kurs
 


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.