Logga in

Tisdag 21 september

Konto

Konton skapas av studenter inom odontologin.

Konton är personliga och används endast av en person.

Fotografier

Foton laddas upp av kontoinnehavaren eller mailas till oss om hjälp önskas.

Nyhetsbrev

Nyhetsbrev kan skickas till e-post adresser kopplade till kontot.

Dessa nyhetsbrev kan innehålla reklam.

Sekretess

Person uppgifter på söktandvård.se förmedlas inte vidare.

Överträdelse

Söktandvård.se kan utan förvarning radera eller ändra profiler som inte följer ovanstående regler.

Vi förbehåller oss rätten att ta bort konton om det framkommer missbruk av bilder eller innehåll.

Tillbaka

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;