Logga in

Måndag 18 oktober

PUL

Detta är Söktandvård.se:s villkor för behandling av personuppgifter enligt PUL (personuppgiftslagen).

Alla personuppgifter som du direkt eller indirekt lämnar till Söktandvård.se behandlas med modern informationsteknik. Syftet med detta är framför allt att vi ska kunna uppfylla de åtaganden som vi som utgivare har gentemot dig t ex genom att hålla oss uppdaterade gällande dina adressuppgifter.

Du samtycker därför också till att Söktandvård.se kan komma att behandla dina personuppgifter för att kunna tillhandahålla dig relevant information, erbjudanden samt intressanta tjänster, som kommer från Söktandvård.se eller någon av dess externa samarbetspartners.

Du har rätt att en gång om året, kostnadsfritt, få information om vilka personuppgifter Söktandvård.se har om dig, och hur dessa används. Detta ska göras skriftligen. Du har också alltid rätt att skriftligen begära rättelse av felaktiga personuppgifter. För begäran om information, rättelse etc kan du vända dig till Söktandvård.se (kontaktsidan).

poc_database.php

1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'soktandv_db.bliss_articles_items.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `bliss_articles_master`.id as article_id,`bliss_articles_items`.id as item_id,`bliss_articles_items`.title,`bliss_articles_items`.first_line,`bliss_articles_items`.alias,text,excerpt,category_id,`bliss_articles_categories`.alias AS category_alias,`bliss_articles_items`.created_date,`bliss_articles_items`.created_by,start_date,end_date,active,allow_comments,display_image,`bliss_articles_master`.image,`bliss_articles_master`.image_size,count(bliss_articles_items.id) as num_of_languages,`bliss_users`.userId,`bliss_users`.userName,`bliss_users`.firstName as first_name,`bliss_users`.lastName as last_name,link_url,link_directly FROM `bliss_articles_master` JOIN `bliss_articles_items` ON (`bliss_articles_master`.id=`bliss_articles_items`.article_id) LEFT JOIN `bliss_users` ON `bliss_users`.userId=`bliss_articles_items`.created_by LEFT JOIN `bliss_articles_categories` ON `bliss_articles_categories`.id=`bliss_articles_master`.category_id WHERE `bliss_articles_items`.language='sv' AND `bliss_articles_master`.active = '1' AND category_id IN (1) AND start_date < unix_timestamp() AND (end_date > unix_timestamp() OR end_date IS NULL) GROUP BY `bliss_articles_master`.id ORDER BY start_date DESC LIMIT 0, 1;

poc_database.php

1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'soktandv_db.bliss_articles_items.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `bliss_articles_master`.id as article_id,`bliss_articles_items`.id as item_id,`bliss_articles_items`.title,`bliss_articles_items`.first_line,`bliss_articles_items`.alias,text,excerpt,category_id,`bliss_articles_categories`.alias AS category_alias,`bliss_articles_items`.created_date,`bliss_articles_items`.created_by,start_date,end_date,active,allow_comments,display_image,`bliss_articles_master`.image,`bliss_articles_master`.image_size,count(bliss_articles_items.id) as num_of_languages,`bliss_users`.userId,`bliss_users`.userName,`bliss_users`.firstName as first_name,`bliss_users`.lastName as last_name,link_url,link_directly FROM `bliss_articles_master` JOIN `bliss_articles_items` ON (`bliss_articles_master`.id=`bliss_articles_items`.article_id) LEFT JOIN `bliss_users` ON `bliss_users`.userId=`bliss_articles_items`.created_by LEFT JOIN `bliss_articles_categories` ON `bliss_articles_categories`.id=`bliss_articles_master`.category_id WHERE `bliss_articles_items`.language='sv' AND `bliss_articles_master`.active = '1' AND category_id IN (1) AND start_date < unix_timestamp() AND (end_date > unix_timestamp() OR end_date IS NULL) GROUP BY `bliss_articles_master`.id ORDER BY start_date DESC LIMIT 1, 4;