Images: Difference between revisions

Revision as of 21:52, 2023 October 6

image	Description	Collections
	Image of an abandoned Metis home on Lafleche property west of Perimeter Highway In Charleswood, Winnipeg, Manitoba. The house was built in 1860 by the Branconnier family	Homes/Farms,Lafleche family,Charleswood Pioneers
	An image of the exterior of Andrew's Store, which was called Craig's Store in the 1920s and the 1930s and was originally called Kelly's Store, located in Charleswood, Winnipeg, Manitoba	Businesses,Kelly family
	Image of the exterior of the barn on Caron's Farm, Charleswood, Winnipeg, Manitoba	Caron family,Homes/Farms

@@ Line 1: / Line 1: @@
 {{#cargo_query:
 tables=Image_description, CollectedIn
-|fields=CONCAT("[[", Image_description._pageName,"| 200px]]")=image,CollectedIn.Collection, Description
+|fields=CONCAT("[[", Image_description._pageName,"| 200px]]")=image, Description, GROUP_CONCAT(Collection)=Collections
 |join on=Image_description._pageName = CollectedIn._pageName
+|group by=Image_description._pageName
 |limit=3
 |format=table
-}}
-<!--
----
-{{#cargo_query:
-tables=Image_description
-|fields=CONCAT("[[", Image_description._pageName,"| 200px]]")=image, Description,
-CONCAT("x{""}x", _pageName)=test,
-CONCAT("cargo_query:
-tables=CollectedIn
-|fields=Collection
-|limit=3
-|format=table
-}}
----
-CONCAT("{#cargo_query:
-tables=CollectedIn
-|fields=Collection
-|where=CollectedIn._pageName=File:\"", CollectedIn.Collection, "\"}") = Collections
----
-{{#cargo_query:
-tables=CollectedIn
-|fields=Collection
-|where=_pageName="File:Abandoned Metis home on Lafleche property, Charleswood, Winnipeg, Manitoba.jpg"
 }}
--->