docsPHP Tester
Details
Last Updated: Monday, July 08, 2019; 5:16 PM
initDocs
SELECT files.id, files.published, files.title, files.alias, files.project_name as nickname
FROM #__phocadownload AS files
LEFT JOIN #__phocadownload_categories AS cats ON cats.id = files.catid
WHERE
(CASE
WHEN
EXISTS (SELECT * FROM #__phocadownload_categories
WHERE cats.alias = 'board-of-directors-2019-2020')
THEN
cats.alias = 'board-of-directors-2019-2020'
ELSE
cats.alias = 'board-of-directors'
END)
Coming back
meetMinutes Document
-
id : "714"
published : "1"
title : "2020 RFSC Annual Meeting Minutes"
alias : "rfsc-annual-meeting-minutes-2020"
nickname : "meetMinutes"
aprMinutes Document
-
id : "715"
published : "1"
title : "April 2020 Board Meeting Minutes"
alias : "april-board-meeting-minutes-2020"
nickname : "aprMinutes"
augMinutes Document
-
id : "716"
published : "1"
title : "August 2019 Board Meeting Minutes"
alias : "august-board-meeting-minutes-2019"
nickname : "augMinutes"
decMinutes Document
-
id : "717"
published : "1"
title : "December 2019 Board Meeting Minutes"
alias : "december-board-meeting-minutes-2019"
nickname : "decMinutes"
febMinutes Document
-
id : "718"
published : "1"
title : "February 2020 Board Meeting Minutes"
alias : "february-board-meeting-minutes-2020"
nickname : "febMinutes"
janMinutes Document
-
id : "719"
published : "0"
title : "January 2020 Board Meeting Minutes"
alias : "january-board-meeting-minutes-2020"
nickname : "janMinutes"
julMinutes Document
-
id : "720"
published : "0"
title : "July 2019 Board Meeting Minutes"
alias : "july-board-meeting-minutes-2019"
nickname : "julMinutes"
junMinutes Document
-
id : "721"
published : "1"
title : "June 2019 Board Meeting Minutes"
alias : "june-board-meeting-minutes-2019"
nickname : "junMinutes"
marMinutes Document
-
id : "722"
published : "1"
title : "March 2020 Board Meeting Minutes"
alias : "march-board-meeting-minutes-2020"
nickname : "marMinutes"
mayMinutes Document
-
id : "723"
published : "1"
title : "May 2019 Board Meeting Minutes"
alias : "may-board-meeting-minutes-2019"
nickname : "mayMinutes"
novMinutes Document
-
id : "724"
published : "0"
title : "November 2019 Board Meeting Minutes"
alias : "november-board-meeting-minutes-2019"
nickname : "novMinutes"
octMinutes Document
-
id : "725"
published : "1"
title : "October 2019 Board Meeting Minutes"
alias : "october-board-meeting-minutes-2019"
nickname : "octMinutes"
sepMinutes Document
-
id : "726"
published : "0"
title : "September 2019 Board Meeting Minutes"
alias : "september-board-meeting-minutes-2019"
nickname : "sepMinutes"
