SQL ERROR 1054: Onbekende kolom 'p.FacebookPixelID' in field list
SQL:
SELECT
p.ProjectID,
p.Name,
p.Selected,
p.GoogleAnalyticsTrackingCode,
p.GoogleTag,
p.FacebookPixelID,
p.FacebookDomainVerification
FROM
projects AS p
SQL ERROR 1054: Onbekende kolom 'c.PaginationParameter' in field list
SQL:
SELECT DISTINCT
c.PageID,
c.Name,
c.Title,
c.PageContainers,
c.ExtraParameters,
c.PaginationParameter,
c.InternalName
FROM
pages AS c
JOIN page_versions AS v ON
v.PageID = c.PageID AND
v.Version = c.Published AND
v.Deleted = 0
WHERE
c.PageContainerID = 0 AND
c.ProjectID = 0
ORDER BY
c.PageOrder ASC
SQL ERROR 1054: Onbekende kolom 'v.Deleted' in on clause
SQL:
SELECT DISTINCT
c.Name,
c.PageContainerID,
c.PageContainers,
c.DisplayAction,
c.Title,
c.Description,
v.Content
FROM
pages AS c
JOIN page_versions AS v ON
v.PageID = c.PageID AND
v.Version = c.Published AND
v.Deleted = 0
WHERE
c.ProjectID = 0 AND
c.PageID = ''
LIMIT 1