Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "User:Snuxoll/sandbox/cargo"

From PCGamingWiki, the wiki about fixing PC games
 
Line 1: Line 1:
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=Infobox_game
+
tables=Infobox_game,Tags
−
|fields=_pageName,Cover,_pageTitle
+
|fields=Infobox_game._pageName,Infobox_game.Cover
−
|order by=RAND()
+
|where=Tags.Article_state_is_stub='true'
−
|limit=3
+
|join on=Infobox_game._pageName=Tags._pageName
 
|format=template
 
|format=template
 
|template=:Home/ask/t
 
|template=:Home/ask/t
 +
|limit=3
 +
|order by=RAND()
 +
|more results text=
 
}}
 
}}

Latest revision as of 21:46, 26 March 2019

Error 1054: Unknown column 'cargo__Tags.Article_state_is_stub' in 'where clause' (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

Function: CargoSQLQuery::run Query: SELECT `cargo__Tags`.`_pageID` AS `cargo_backlink_page_id_Tags`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,`cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Cover` AS `Cover` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Tags`.`Article_state_is_stub`='true' ORDER BY RAND() LIMIT 100