Template:ParentSatelliteEvent

From Edd's Almanac
Revision as of 21:27, 12 February 2024 by Edd (talk | contribs) (Created page with "== Iterations == {| class="wikitable sortable" style="text-align: center;" |- ! During !! Date !! Time !! Location !! Host(s) {{#cargo_query: tables=SatelliteEvents |fields=MainEvent,Year,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory1,']]')=EventCategory1,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory2,']]')=EventCategory2,CONCAT('Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory3...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Iterations

During Date Time Location Host(s)
Error 1054: Unknown column 'm_SatelliteEvents._EventName' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `m_SatelliteEvents`.`_pageID` AS `cargo_backlink_page_id_SatelliteEvents`,`MainEvent` AS `MainEvent`,`Year` AS `Year`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory1,']]') AS `EventCategory1`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory2,']]') AS `EventCategory2`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory3,']]') AS `EventCategory3`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory4,']]') AS `EventCategory4`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory5,']]') AS `EventCategory5`,`StartDate` AS `StartDate`,`StartTime` AS `StartTime`,`EndTime` AS `EndTime`,`Duration` AS `Duration`,`EventName` AS `EventName`,`EventCategoryEmojis` AS `EventCategoryEmojis`,`URL` AS `URL`,CONCAT('',LocationName,'') AS `LocationName`,`Address1` AS `Address1`,`Address2` AS `Address2`,`City` AS `City`,`ZipCode` AS `ZipCode`,`MapLink` AS `MapLink`,`RSVP` AS `RSVP`,`StartingTicketPrice` AS `StartingTicketPrice`,`FBOptions` AS `FBOptions`,CONCAT('',Host1,'') AS `Host1`,CONCAT('',Host2,'') AS `Host2`,CONCAT('',Host3,'') AS `Host3`,CONCAT('',Host4,'') AS `Host4`,CONCAT('',Host5,'') AS `Host5`,CONCAT('',Host6,'') AS `Host6`,CONCAT('',Host7,'') AS `Host7`,CONCAT('',Host8,'') AS `Host8`,CONCAT('',Host9,'') AS `Host9`,CONCAT('',Host10,'') AS `Host10`,CONCAT('',Host11,'') AS `Host11`,CONCAT('',Host12,'') AS `Host12`,CONCAT('',Host13,'') AS `Host13`,CONCAT('',Host14,'') AS `Host14`,CONCAT('',Host15,'') AS `Host15`,`Notes` AS `Notes`,`StartDate__precision` AS `StartDate__precision` FROM `m_SatelliteEvents` WHERE `m_SatelliteEvents`.`_EventName`= 'ParentSatelliteEvent' ORDER BY `m_SatelliteEvents`.`_pageID`,`MainEvent`,`Year`,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory1,']]'),CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory2,']]') LIMIT 100