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 25sle.2022

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.
0 5
Can be used for discount codes Internal id, to be used for the site url and the link to the order form create discount code customquery_idcustomquery_idintNOPRItrueactive_yntinyintNOfalsegebruiker_idintNOtruetablenamevarchar(50)NO50falsenamevarchar(50)NO50falsecontextvarchar(10)YES10falsesystem_ynchar(1)NO1falsefor_all_ynchar(1)NO1falseallow_edit_ynchar(1)NO1falsetitlevarchar(250)YES250falsesubtitlevarchar(250)YES250falselocationvarchar(50)YES50falseperiodvarchar(50)YES50falsediscountdecimal(12,0)YESfalsediscountcodevarchar(50)YES50falsevalid_fromdatetimeYESfalsevalid_untildatetimeYESfalselistpricedecimal(10,2)YESfalseexpected_qtyintYEStruecreate_datedatetimeYESfalsecreatorvarchar(50)YES50falseseries_idintYEStruecustomquerytype_idintYEStrueshorttitlevarchar(50)YES50falseonsale_yntinyintNOfalsedescription_atxvarchar(8000)YES8000falseconference_doivarchar(20)YES20falseconference_urlvarchar(255)YES255falsesequence_numberintYEStrue
Our catalog returns no results for sle.2022