LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Media_with_Macros.odb
File actual save date2018-06-27 15:23:25
Scanning done on2018-08-21 17:45:34
Documentation generated on2018-08-21 17:45:45
Table of contents
Media_with_Macros
List of tables
Table name Used by Relationships List of fields Number of records Table data (sample) SQL
Adress View_Report_Recall (Table)
Maintenance|Postcode|Adress (Control)
Maintenance|Adress (Control)
Reader_Admission|Form|Adress (Control)
Reader_Admission|Form|Adress|Combofield 1 (Control)		 Postcode (Table)
Reader (Table)
Street (Table)		 Details 4 Data  
Author rel_Media_Author (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
View_MediaID_Title_Author (Table)
Maintenance (Form)
Maintenance|rel_Media_Author|Tablecontrol 1|Numeric Field 2 (Control)
Maintenance|rel_Media_Author|Tablecontrol 1|Numeric Field 2 (Control)
Media|Author|comAut (Control)
Media|Author|Tablecontrol|NumericField1 (Control)		   Details 10 Data  
Author_Add rel_Media_Author (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
Maintenance (Form)
Maintenance|rel_Media_Author|Tablecontrol 1|Numeric Field 3 (Control)
Media|Author|comAdd (Control)
Media|Author|Tablecontrol|NumericField3 (Control)		   Details 4 Data  
Category Media (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
Maintenance (Form)
Maintenance|Media|Tablecontrol 1|Listfield 1 (Control)
Media|comCat (Control)		   Details 3 Data  
Class Schoolclass (Table)
Maintenance (Form)
Maintenance|Schoolclass|Tablecontrol 1|Listfield 1 (Control)
Reader_Admission|Form|Schoolclass|Listfield 1 (Control)		   Details 8 Data  
Filter Reader_Input_Filter (Query)
Loan (Form)
Loan_Barcode (Form)
Reader_Admission (Form)
LoanRefresh (Procedure)
LoanWindowRefresh (Procedure)
ReturnRefresh (Procedure)		   Details 1 Data  
Gender Reader (Table)
View_Report_Recall (Table)
Reader_Admission|Form|Tablecontrol|Listfield 1 (Control)		   Details 2 Data  
Grade Schoolclass (Table)
Maintenance (Form)
Maintenance|Schoolclass|Tabellen-Kontrollfeld 1|Listfield 1 (Control)
Reader_Admission|Form|Schoolclass|Listfield 1 (Control)		   Details 13 Data  
Loan Recall (Table)
View_Media_Charts (Table)
View_Recall_current (Table)
View_Reminder (Table)
View_Report_Recall (Table)
Listbox_Title_MediaID_not_loan (Query)
Loan_not_locked (Query)
Media_Chart (Query)
Media_Loan_Balance_Time (Query)
Media_Loan_Balance_Time_Recall (Query)
Media_Recall_Reader (Query)
Loan|Choose_Reader|Show_Reader|Loan|Input (Control)
Loan_Barcode|Form|Loan|Form (Control)
Loan_Barcode|Form|Loan|Form|Form (Control)
LoanRefresh (Procedure)
LoanWindowRefresh (Procedure)		 Media (Table)
Reader (Table)		 Details 21 Data  
Media Loan (Table)
rel_Media_Author (Table)
Subtitle (Table)
View_Label_Media (Table)
View_Media_complete (Table)
View_MediaID_Title_Author (Table)
View_Reminder (Table)
View_Report_Recall (Table)
ISBN_Test (Query)
Listbox_Title_MediaID_not_loan (Query)
Loan_not_locked (Query)
Media_Input_Search_Result (Query)
Media_Loan_Balance_Time (Query)
Media_Loan_Balance_Time_Recall (Query)
Media_Recall_Reader (Query)
Maintenance|rel_Media_Author|Media (Control)
Maintenance|rel_Media_Author|Media (Control)
Maintenance|Media (Control)
Maintenance|Media (Control)
Maintenance|Media (Control)
Maintenance|Media (Control)
MainformOpen (Procedure)		 Category (Table)
Mediastyle (Table)
Publisher (Table)
Town (Table)		 Details 9 Data  
Mediastyle Media (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
View_Reminder (Table)
View_Report_Recall (Table)
Loan_not_locked (Query)
Media_Loan_Balance_Time (Query)
Media_Loan_Balance_Time_Recall (Query)
Media_Recall_Reader (Query)
Maintenance (Form)
Maintenance|Media|Tablecontrol 1|Listfield 1 (Control)
Media|comMed (Control)		   Details 3 Data  
Postcode Adress (Table)
View_Report_Recall (Table)
Maintenance|Postcode (Control)
Maintenance|Adress|Tablecontrol 1|Listfield 1 (Control)
Reader_Admission|Form|Adress|comPosTow (Control)		 Town (Table) Details 6 Data  
Preferences View_Reminder (Table)
View_Report_Recall (Table)
Current_Date (Query)
Loan_not_locked (Query)
Media_Loan_Balance_Time (Query)
Media_Loan_Balance_Time_Recall (Query)
Media_Recall_Reader (Query)		   Details 1 Data  
Publisher Media (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
Maintenance (Form)
Maintenance|Media|Tablecontrol 1|Listfield 1 (Control)
Media|comPub (Control)		   Details 0 Data  
Reader Adress (Table)
Loan (Table)
rel_Reader_Schoolclass (Table)
View_Report_Recall (Table)
Loan_not_locked (Query)
Media_Recall_Reader (Query)
Reader_Input_Filter (Query)		 Gender (Table) Details 10 Data  
Recall View_Recall_current (Table)
View_Reminder (Table)
Recall_Recallnumber (Query)
ReportStart (Procedure)		 Loan (Table) Details 21 Data  
rel_Media_Author View_Media_complete (Table)
View_MediaID_Title_Author (Table)
Maintenance|rel_Media_Author (Control)
Maintenance|rel_Media_Author (Control)
Media|Author (Control)		 Author (Table)
Author_Add (Table)
Media (Table)		 Details 9 Data  
rel_Reader_Schoolclass Reader_Admission|Form|Schoolclass (Control) Reader (Table)
Schoolclass (Table)		 Details 0 Data  
Schoolclass rel_Reader_Schoolclass (Table)
Maintenance|Schoolclass (Control)
Maintenance|Schoolclass (Control)
Reader_Admission|Form|Schoolclass|Listfield 1 (Control)		 Class (Table)
Grade (Table)		 Details 9 Data  
Search View_Media_Search_Result (Table)
Media (Form)		   Details 1 Data  
Street Adress (Table)
View_Report_Recall (Table)
Maintenance (Form)
Reader_Admission|Form|Adress|comStr (Control)		   Details 4 Data  
Subtitle View_Media_complete (Table)
View_Media_Search_Result (Table)
Media|Subtitle (Control)		 Media (Table) Details 8 Data  
Town Media (Table)
Postcode (Table)
View_Media_complete (Table)
View_Media_Search_Result (Table)
View_Report_Recall (Table)
Maintenance (Form)
Maintenance|Postcode|Tablecontrol 1|Listfield 1 (Control)
Maintenance|Media|Tabellen-Kontrollfeld 1|Listfield 1 (Control)
Maintenance|Adress|Tablecontrol 1|Listfield 1 (Control)
Media|comTow (Control)
Reader_Admission|Form|Adress|comPosTow (Control)		   Details 4 Data  
View_EAN13_Labels View_EAN13_Substring (Table)   Details 3 Data 
SELECT 
	SUBSTRING (
		CONCAT(
			'00000000000', 
			CONVERT ("Barcode_EAN13_ID", CHAR)), 
		- 13) AS "Column_1", 
	(
		SELECT 
			SUBSTRING (
				CONCAT(
					'00000000000', 
					CONVERT ("Barcode_EAN13_ID", CHAR)), 
				- 13) 
		FROM 
			"View_Label_Media" 
		WHERE 
			"Count_3" = 1 
			AND "No" = "a"."No" + 1) AS "Column_2", 
	(
		SELECT 
			SUBSTRING (
				CONCAT(
					'00000000000', 
					CONVERT ("Barcode_EAN13_ID", CHAR)), 
				- 13) 
		FROM 
			"View_Label_Media" 
		WHERE 
			"Count_3" = 2 
			AND "No" = "a"."No" + 2) AS "Column_3" 
FROM 
	"View_Label_Media" AS "a" 
WHERE 
	"Count_3" = 0 
ORDER BY 
	"ID"
View_EAN13_Substring Barcode_EAN13_ttf_Report (Query)   Details 3 Data 
SELECT 
	SUBSTRING ("Column_1", - 13, 1) AS "1_1", 
	SUBSTRING ("Column_1", - 12, 1) AS "1_2", 
	SUBSTRING ("Column_1", - 11, 1) AS "1_3", 
	SUBSTRING ("Column_1", - 10, 1) AS "1_4", 
	SUBSTRING ("Column_1", - 9, 1) AS "1_5", 
	SUBSTRING ("Column_1", - 8, 1) AS "1_6", 
	SUBSTRING ("Column_1", - 7, 1) AS "1_7", 
	SUBSTRING ("Column_1", - 6, 1) AS "1_8", 
	SUBSTRING ("Column_1", - 5, 1) AS "1_9", 
	SUBSTRING ("Column_1", - 4, 1) AS "1_10", 
	SUBSTRING ("Column_1", - 3, 1) AS "1_11", 
	SUBSTRING ("Column_1", - 2, 1) AS "1_12", 
	SUBSTRING ("Column_1", - 1, 1) AS "1_13", 
	SUBSTRING ("Column_2", - 13, 1) AS "2_1", 
	SUBSTRING ("Column_2", - 12, 1) AS "2_2", 
	SUBSTRING ("Column_2", - 11, 1) AS "2_3", 
	SUBSTRING ("Column_2", - 10, 1) AS "2_4", 
	SUBSTRING ("Column_2", - 9, 1) AS "2_5", 
	SUBSTRING ("Column_2", - 8, 1) AS "2_6", 
	SUBSTRING ("Column_2", - 7, 1) AS "2_7", 
	SUBSTRING ("Column_2", - 6, 1) AS "2_8", 
	SUBSTRING ("Column_2", - 5, 1) AS "2_9", 
	SUBSTRING ("Column_2", - 4, 1) AS "2_10", 
	SUBSTRING ("Column_2", - 3, 1) AS "2_11", 
	SUBSTRING ("Column_2", - 2, 1) AS "2_12", 
	SUBSTRING ("Column_2", - 1, 1) AS "2_13", 
	SUBSTRING ("Column_3", - 13, 1) AS "3_1", 
	SUBSTRING ("Column_3", - 12, 1) AS "3_2", 
	SUBSTRING ("Column_3", - 11, 1) AS "3_3", 
	SUBSTRING ("Column_3", - 10, 1) AS "3_4", 
	SUBSTRING ("Column_3", - 9, 1) AS "3_5", 
	SUBSTRING ("Column_3", - 8, 1) AS "3_6", 
	SUBSTRING ("Column_3", - 7, 1) AS "3_7", 
	SUBSTRING ("Column_3", - 6, 1) AS "3_8", 
	SUBSTRING ("Column_3", - 5, 1) AS "3_9", 
	SUBSTRING ("Column_3", - 4, 1) AS "3_10", 
	SUBSTRING ("Column_3", - 3, 1) AS "3_11", 
	SUBSTRING ("Column_3", - 2, 1) AS "3_12", 
	SUBSTRING ("Column_3", - 1, 1) AS "3_13" 
FROM 
	"View_EAN13_Labels"
View_Label_Media View_EAN13_Labels (Table)   Details 9 Data 
SELECT 
	"ID", 
	(
		SELECT 
			COUNT("ID") 
		FROM 
			"Media" 
		WHERE 
			"ID" <= "a"."ID") AS "No", 
	MOD(
		(
			SELECT 
				COUNT("ID") 
			FROM 
				"Media" 
			WHERE 
				"ID" < "a"."ID"), 
		3) AS "Count_3", 
	"ID" || MOD(
		10 - MOD(
			(
				(
					TRUNCATE("ID", - 11) / 100000000000 - TRUNCATE("ID", - 12) / 100000000000) + 3 * (
					TRUNCATE("ID", - 10) / 10000000000 - TRUNCATE("ID", - 11) / 10000000000) + (
					TRUNCATE("ID", - 9) / 1000000000 - TRUNCATE("ID", - 10) / 1000000000) + 3 * (
					TRUNCATE("ID", - 8) / 100000000 - TRUNCATE("ID", - 9) / 100000000) + (
					TRUNCATE("ID", - 7) / 10000000 - TRUNCATE("ID", - 8) / 10000000) + 3 * (
					TRUNCATE("ID", - 6) / 1000000 - TRUNCATE("ID", - 7) / 1000000) + (
					TRUNCATE("ID", - 5) / 100000 - TRUNCATE("ID", - 6) / 100000) + 3 * (
					TRUNCATE("ID", - 4) / 10000 - TRUNCATE("ID", - 5) / 10000) + (
					TRUNCATE("ID", - 3) / 1000 - TRUNCATE("ID", - 4) / 1000) + 3 * (
					TRUNCATE("ID", - 2) / 100 - TRUNCATE("ID", - 3) / 100) + (
					TRUNCATE("ID", - 1) / 10 - TRUNCATE("ID", - 2) / 10) + 3 * (
					"ID" - TRUNCATE("ID", - 1))), 
			10), 
		10) AS "Barcode_EAN13_ID" 
FROM 
	"Media" AS "a" 
ORDER BY 
	"ID"
View_Media_Charts     Details 9 Data 
SELECT 
	"Media_ID", 
	COUNT("ID") AS "Count", 
	(
		SELECT 
			"ID_Title_Author" 
		FROM 
			"View_MediaID_Title_Author" 
		WHERE 
			"ID" = "Chart_Start"."Media_ID") AS "Medium" 
FROM 
	(
		SELECT 
			IFNULL(
				"Media_ID", 
				CEILING("Media_ID_BC" / 10)) AS "Media_ID", 
			"ID" 
		FROM 
			"Loan") AS "Chart_Start" 
GROUP BY 
	"Media_ID" 
ORDER BY 
	COUNT("ID") DESC 
LIMIT 
	10
View_Media_complete View_Media_Search_Result (Table)   Details 17 Data 
SELECT 
	"Media"."ID", 
	"Media"."Title", 
	"Subtitle"."No", 
	"Subtitle"."Subtitle", 
	"Subtitle"."Length", 
	"Media"."Edition", 
	"Media"."Pub_Year", 
	"Media"."Comment", 
	"Media"."Price", 
	"Mediastyle"."Mediastyle", 
	"Mediastyle"."Loantime", 
	"Category"."Category", 
	"Category"."Description", 
	"rel_Media_Author"."Author_Sort", 
	"Author"."LastName" || IFNULL(
		', ' || "Author"."FirstName", ''
	) AS "Author", 
	"Author_Add"."Author_Add", 
	"Town"."Town", 
	"Publisher"."Publisher" 
FROM 
	"Media" 
	LEFT JOIN "Subtitle" ON "Media"."ID" = "Subtitle"."Media_ID" 
	LEFT JOIN "Category" ON "Media"."Category_ID" = "Category"."ID" 
	LEFT JOIN "Mediastyle" ON "Media"."Mediastyle_ID" = "Mediastyle"."ID" 
	LEFT JOIN "Town" ON "Media"."Town_ID" = "Town"."ID" 
	LEFT JOIN "rel_Media_Author" ON "rel_Media_Author"."Media_ID" = "Media"."ID" 
	LEFT JOIN "Author_Add" ON "rel_Media_Author"."Author_Add_ID" = "Author_Add"."ID" 
	LEFT JOIN "Author" ON "rel_Media_Author"."Author_ID" = "Author"."ID" 
	LEFT JOIN "Publisher" ON "Media"."Publisher_ID" = "Publisher"."ID"
View_Media_Search_Result Media_Input_Search_Result (Query)   Details 9 Data 
SELECT 
	DISTINCT "ID", 
	"Title" 
FROM 
	"View_Media_complete" 
WHERE 
	UCASE("Title") LIKE IFNULL(
		(
			SELECT 
				'%' || UCASE("SearchItem") || '%' 
			FROM 
				"Search"), 
		UCASE("Title")) 
	OR UCASE("Subtitle") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Edition") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Comment") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Mediastyle") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Category") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Description") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Author") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Author_Add") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Town") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search") 
	OR UCASE("Publisher") LIKE (
		SELECT 
			'%' || UCASE("SearchItem") || '%' 
		FROM 
			"Search")
View_MediaID_Title_Author View_Media_Charts (Table)
View_Report_Recall (Table)
Listbox_Title_MediaID_not_loan (Query)
Media_Chart (Query)
Media_Loan_Balance_Time (Query)
Media_Loan_Balance_Time_Recall (Query)		   Details 9 Data 
SELECT 
	"Media"."ID" || ' - ' || "Media"."Title" || ' - by ' || IFNULL("Author"."LastName", '?') || IFNULL(
		', ' || "Author"."FirstName", ''
	) AS "ID_Title_Author", 
	"Media"."ID" 
FROM 
	"Media" 
	LEFT JOIN (
		SELECT 
			"Media_ID", 
			MIN("Author_ID") AS "Author_ID_Min" 
		FROM 
			"rel_Media_Author" 
		WHERE 
			"Author_Sort" < 2 
		GROUP BY 
			"Media_ID") AS "Media_MainAuthor" ON "Media"."ID" = "Media_MainAuthor"."Media_ID" 
	LEFT JOIN "Author" ON "Media_MainAuthor"."Author_ID_Min" = "Author"."ID" 
ORDER BY 
	"Title" ASC
View_Recall_current View_Report_Recall (Table)   Details 4 Data 
SELECT 
	"Recall"."Loan_ID", 
	COUNT("Recall"."Loan_ID") AS "Recall_Count", 
	MAX("Recall"."Date") AS "Recall_Date" 
FROM 
	"Recall", 
	"Loan" 
WHERE 
	"Recall"."Loan_ID" = "Loan"."ID" 
	AND "Loan"."Return_Date" IS NULL 
GROUP BY 
	"Recall"."Loan_ID"
View_Reminder     Details 6 Data 
SELECT 
	"a"."ID", 
	CURDATE() AS "Today", 
	"a"."Reader_ID" 
FROM 
	"Loan" AS "a" 
WHERE 
	"Return_Date" IS NULL 
	AND (
		SELECT 
			"Mediastyle"."Loantime" 
		FROM 
			"Mediastyle", 
			"Media" 
		WHERE 
			"Media"."Mediastyle_ID" = "Mediastyle"."ID" 
			AND (
				"Media_ID" = "Media"."ID" 
				OR "Media"."ID" = TRUNCATE("Media_ID_BC", - 1) / 10)) + IFNULL("Extension", 0) * (
		SELECT 
			"ExtensionDays" 
		FROM 
			"Preferences") - DATEDIFF(
		'dd', 
		"Loan_Date", 
		CURDATE()) < (
		SELECT 
			"MinRecallDays" 
		FROM 
			"Preferences" 
		WHERE 
			"ID" = True) 
	AND (
		DATEDIFF(
			'dd', 
			(
				SELECT 
					MAX("Date") 
				FROM 
					"Recall" 
				WHERE 
					"Loan_ID" = "a"."ID"), 
			CURDATE()) > (
			SELECT 
				"MinRecallDays" 
			FROM 
				"Preferences" 
			WHERE 
				"ID" = True) 
		OR (
			SELECT 
				MAX("Date") 
			FROM 
				"Recall" 
			WHERE 
				"Loan_ID" = "a"."ID") IS NULL)
View_Report_Recall     Details 4 Data 
SELECT 
	"View_MediaID_Title_Author"."ID_Title_Author" AS "Medium", 
	"a"."Reader_ID", 
	"Reader"."FirstName" || ' ' || "Reader"."LastName" AS "Reader_Name", 
	"a"."Loan_Date", 
	"a"."Extension", 
	IFNULL("a"."Extension", 0) * (
		SELECT 
			"ExtensionDays" 
		FROM 
			"Preferences") AS "extended_for", 
	DATEDIFF(
		'dd', 
		"a"."Loan_Date", 
		CURDATE()) AS "LoanDays", 
	ABS(
		(
			SELECT 
				"Mediastyle"."Loantime" 
			FROM 
				"Mediastyle", 
				"Media" 
			WHERE 
				"Media"."Mediastyle_ID" = "Mediastyle"."ID" 
				AND (
					"a"."Media_ID" = "Media"."ID" 
					OR "Media"."ID" = TRUNCATE("a"."Media_ID_BC", - 1) / 10)) + IFNULL("a"."Extension", 0) * (
			SELECT 
				"ExtensionDays" 
			FROM 
				"Preferences") - DATEDIFF(
			'dd', 
			"a"."Loan_Date", 
			CURDATE())) AS "RemainTime", 
	FLOOR(
		ABS(
			(
				SELECT 
					"Mediastyle"."Loantime" 
				FROM 
					"Mediastyle", 
					"Media" 
				WHERE 
					"Media"."Mediastyle_ID" = "Mediastyle"."ID" 
					AND (
						"a"."Media_ID" = "Media"."ID" 
						OR "Media"."ID" = TRUNCATE("a"."Media_ID_BC", - 1) / 10)) + IFNULL("a"."Extension", 0) * (
				SELECT 
					"ExtensionDays" 
				FROM 
					"Preferences") - DATEDIFF(
				'dd', 
				"a"."Loan_Date", 
				CURDATE())) / (
			SELECT 
				("OverdraftDays") 
			FROM 
				"Preferences")) * (
		SELECT 
			("OverdraftCharge") 
		FROM 
			"Preferences") AS "Charge", 
	"View_Recall_current"."Recall_Count", 
	"View_Recall_current"."Recall_Date", 
	"Reader_Adress"."Adress", 
	"Reader_Adress"."LetterTitle" 
FROM 
	"View_MediaID_Title_Author", 
	"Loan" AS "a", 
	"View_Recall_current", 
	"Reader", 
	(
		SELECT 
			"Reader"."ID", 
			IFNULL("Gender"."Salutation", '') || CHAR(13) || "Reader"."FirstName" || ' ' || "Reader"."LastName" || CHAR(13) || IFNULL(
				"Street"."Street" || ' ' || "Adress"."No", 
				''
			) || CHAR(13) || IFNULL(
				"Adress"."Country" || ' ', ''
			) || IFNULL(
				"Postcode"."Postcode" || ' ', ''
			) || IFNULL("Town"."Town", '') AS "Adress", 
			IFNULL("Gender"."Title" || ' ', '') || "Reader"."LastName" || ',' AS "LetterTitle" 
		FROM 
			"Reader" 
			LEFT JOIN "Gender" ON "Gender"."ID" = "Reader"."Gender_ID" 
			LEFT JOIN "Adress" ON "Adress"."ID" = "Reader"."ID" 
			LEFT JOIN "Street" ON "Street"."ID" = "Adress"."Street_ID" 
			LEFT JOIN "Postcode" ON "Postcode"."ID" = "Adress"."Postcode_ID" 
			LEFT JOIN "Town" ON "Town"."ID" = "Postcode"."Town_ID") AS "Reader_Adress" 
WHERE 
	"View_MediaID_Title_Author"."ID" = IFNULL(
		"a"."Media_ID", 
		TRUNCATE("a"."Media_ID_BC", - 1) / 10) 
	AND "a"."Return_Date" IS NULL 
	AND "a"."ID" = "View_Recall_current"."Loan_ID" 
	AND "a"."Reader_ID" = "Reader"."ID" 
	AND "a"."Reader_ID" = "Reader_Adress"."ID" 
	AND (
		SELECT 
			"Mediastyle"."Loantime" 
		FROM 
			"Mediastyle", 
			"Media" 
		WHERE 
			"Media"."Mediastyle_ID" = "Mediastyle"."ID" 
			AND (
				"a"."Media_ID" = "Media"."ID" 
				OR "Media"."ID" = TRUNCATE("a"."Media_ID_BC", - 1) / 10)) + IFNULL("a"."Extension", 0) * (
		SELECT 
			"ExtensionDays" 
		FROM 
			"Preferences") - DATEDIFF(
		'dd', 
		"a"."Loan_Date", 
		CURDATE()) < 0