mike_brandt

Hi
same problem here

WordPress database error: [Operand should contain 1 column(s)]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate , wp_p2p.* FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate') LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') INNER JOIN wp_p2p LEFT JOIN wp_p2pmeta AS p2pm_order ON ( wp_p2p.p2p_id = p2pm_order.p2p_id AND p2pm_order.meta_key = '_order_to' ) WHERE 1=1 AND wp_posts.post_type IN ('play') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND (wp_p2p.p2p_type = 'plays_to_events' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate') LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') WHERE 1=1 AND wp_posts.ID IN (213) AND wp_posts.post_type IN ('tribe_events') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') ORDER BY wp_posts.post_date DESC )) ORDER BY p2pm_order.meta_value+0 ASC, wp_posts.post_date DESC LIMIT 0, 10

woa that frightens me.
no really that much into SQL
anyone ?