See the tables structure here.
I have this sql:
SELECT `feed_entries` . *
FROM `feed_entries`
WHERE
id
IN (
SELECT `e`.`id`
FROM `feed_entries` AS `e`
INNER JOIN `feeds` AS `f` ON e.feed_id = f.id
INNER JOIN `entries_categorias` AS `ec` ON ec.entry_id = e.id
INNER JOIN `categorias` AS `c` ON ec.categoria_id = c.id
WHERE
e.deleted =0
AND
c.slug
IN ('manchete', 'google')
GROUP BY `e`.`id`
HAVING COUNT( DISTINCT ec.id ) =2
)
ORDER BY `date` DESC
LIMIT 1
And I want to add these fields:
`f`.`titulo` AS `feedTitulo` , `f`.`url` AS `feedUrl`
How can I do that? Without get this error:
#1241 - Operand should contain 1 column(s)