User:Teltura/cardimages - Revision history

Teltura at 17:25, 18 August 2023

2023-08-18T17:25:22Z

← Older revision		Revision as of 17:25, 18 August 2023
Line 3:		Line 3:
	\|fields=		\|fields=
	,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image		,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image
	\|where= CR.LanguageCode = 'EN' AND CR.Subset = 'S' AND CR.Revision = 0 AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140')		\|where= CR.LanguageCode = 'EN' AND CR.Subset = 'S' AND CR.Revision = 0 AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140', '1U274', '3U100', '1R272', '15C120', '2R93', '12C93', '11C120', '1C266', '2C90', '11U114', '1R246', '3U96', '3C95', '11R141', '11U118', '13C107', '1R247', '11C122', '18C91', '3R99', '1R250', '13C107', '11C140', '1U249', '1R240', '1C255', '1U241', '12C84', '1U257', '2C95', '1C248', '1R265', '11U139', '1R256', '1U63', '1R62', '9R+15', '1R66', '11R17' )
	\|order by= CR.SiteNum, CR.Title		\|order by= CR.SiteNum, CR.Title
	\|limit=400		\|limit=400

Teltura at 17:22, 18 August 2023

2023-08-18T17:22:19Z

← Older revision		Revision as of 17:22, 18 August 2023
Line 1:		Line 1:
	{{#cargo_query:tables=Cards=C,CardReleases=CR~~,CardReleases=EN~~		{{#cargo_query:tables=Cards=C,CardReleases=CR
	\|join on=C.ID = CR.BaseCardID~~, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID~~		\|join on=C.ID = CR.BaseCardID
	\|fields=		\|fields=
	,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image		,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image
	\|where= EN.LanguageCode = 'EN' AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140')		\|where= CR.LanguageCode = 'EN' AND CR.Subset = 'S' AND CR.Revision = 0 AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140')
	\|order by= CR.SiteNum, CR.Title		\|order by= CR.SiteNum, CR.Title
	\|limit=400		\|limit=400

Teltura: Created page with "{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID |fields= ,CONCAT('File:', CR.ImageFi..."

2023-08-18T16:54:47Z

Created page with "{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID |fields= ,CONCAT('File:', CR.ImageFi..."

New page

{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID
|fields=
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image
|where= EN.LanguageCode = 'EN' AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140')
|order by= CR.SiteNum, CR.Title
|limit=400
|format= list
|rows per page=400
}}