Magic Book: Difference between revisions
(→List) |
(→List) |
||
| Line 12: | Line 12: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Contact | tables=Contact | ||
|fields= CONCAT("[[",_pageName,"|",_pageTitle,"]]")=Name,CONCAT("[http://www.mentalhealthlaw.co.uk/Special:Drilldown/Contact?Type=", REPLACE(Type," ","_"), " ", Type, "]")=Type,Address | |fields= CONCAT("[[",_pageName,"|",_pageTitle,"]]")=Name,CONCAT("<span class='plainlinks'>[http://www.mentalhealthlaw.co.uk/Special:Drilldown/Contact?Type=", REPLACE(Type," ","_"), " ", Type, "]</span>")=Type,Address | ||
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
Revision as of 01:01, 5 December 2016
This is all still in draft format. The Magic Book is named after an old database of hospitals, experts etc, which I used in a previous job.
Create or edit
(1) Hospitals/places: please add everything from your address book! The Magic Book will only be a success if everyone joins in. (2) People: add personal information (e.g. experts) with permission, unless publicly available already; no opinions; inclusion does not imply recommendation.
Type a place (e.g. hospital) or person (e.g. independent expert) name in the box below. If it exists already, it will be auto-completed for you: just click on the blue text to view/edit that page.
List
Click on a name to see further details - including maps and a link to find directions on Google.
Function: CargoSQLQuery::run Query: SELECT `wm_cargo__Contact`.`_pageID` AS `cargo_backlink_page_id_Contact`,CONCAT("",_pageTitle,"") AS `Name`,CONCAT("<span class='plainlinks'>", REPLACE(Type," ","_"), " ", Type, "</span>") AS `Type`,`Address` AS `Address` FROM `wm_cargo__Contact` ORDER BY `wm_cargo__Contact`.`_pageID`,CONCAT("",_pageTitle,""),CONCAT("<span class='plainlinks'>", REPLACEContact.Type__full " ","_"), " ",`wm_cargo__Contact`.`Type__full` "</span>"),`Address` LIMIT 100
Search
You can search using the table above, or for a more detailed search click here: Special:Drilldown/Contact.
Google Map
This shows every place. Click on the red marker to see what it is, then click on the place name to view its details.