User warning: Unknown column 'cte.field_event_date_value' in 'field list'
query:
SELECT n.*, cte.*, (UNIX_TIMESTAMP(cte.field_event_date_value) < UNIX_TIMESTAMP()) as past
FROM node n
LEFT JOIN content_field_event_images cfei USING(nid)
LEFT JOIN content_type_event cte USING(nid)
LEFT JOIN content_field_documents cfd USING(nid)
WHERE (cfei.field_event_images_data IS NOT NULL OR cfd.field_documents_fid IS NOT NULL)
AND n.type = 'event'
AND n.status = 1 AND n.language = 'en'
GROUP BY n.nid
ORDER BY cte.field_event_date_value DESC
in _db_query() (line 169 of /opt/appdata00/www/www/includes/database.mysqli.inc).
There are currently no posts in this category.
