WITH `filtered_Conferences` AS (SELECT `Conferences`.* FROM `customquery` AS `Conferences` WHERE (`Conferences`.`conference_doi` = ?)
AND ((`Conferences`.`active_yn` = 1 AND `Conferences`.`customquerytype_id` IN (0,5) AND `Conferences`.`tablename` = 'title'))) SELECT DISTINCT `Conferences`.`shorttitle`,`Conferences`.`conference_doi`,`Conferences`.`location`,`Conferences`.`period`,`Conferences`.`discount` AS `discount_percentage`,`Conferences`.`discountcode`,NULL AS `create_discountcode`,`Conferences`.`valid_from`,`Conferences`.`valid_until`,`Conferences`.`title`,`Conferences`.`subtitle`,`Conferences`.`conference_url`,`Conferences`.`description_atx`,`Conferences`.`name`,`Conferences`.`gebruiker_id`,`Conferences`.`create_date`,`Conferences`.`creator`,`Conferences`.`customquery_id`,`Conferences`.`customquerytype_id`,`Conferences`.`active_yn`,`gebruiker_id_lkp`.`naam` AS `jb-editor`,`customquerytype_id_lkp`.`name` AS `querytype` FROM `filtered_Conferences` AS `Conferences` LEFT JOIN `gebruiker` AS `gebruiker_id_lkp` ON `Conferences`.`gebruiker_id` = `gebruiker_id_lkp`.`gebruiker_id` LEFT JOIN `customquerytype` AS `customquerytype_id_lkp` ON `Conferences`.`customquerytype_id` = `customquerytype_id_lkp`.`customquerytype_id` WHERE ((`Conferences`.`active_yn` = 1 AND `Conferences`.`customquerytype_id` IN (0,5) AND `Conferences`.`tablename` = 'title')) ORDER BY `Conferences`.`name` ASC LIMIT 25ichols.2021
In this view a 'custom query' intended for conferences can be edited. Please make sure that the following fields are filled out:
Conference title
Conference acronym, if different from title, e.g. DGfS 2021
Conference doi, to be used as the code in the URL and for the file name of the order form. e.g. dgfs.2021
Location and Period, use Online when the conference is online-only.
Discount and Valid until.
Conference URL: a web link leading to the site where the conference information can be found.
05
Can be used for discount codes
Internal id, to be used for the site url and the link to the order form