Unknown column 'obras' in 'where clause'
SELECT obra.id AS id_obra, obra.titulo, obra.material, obra.dimensoes, obra.colecao, obra.texto, obra.ano, obra.valor, obra.pagseguro, obra.ck_venda, artista.nome AS artista, artista.email FROM obra INNER JOIN artista ON artista.id = obra.id_artista WHERE obra.id = 001164/obras/conjunto/obras/conjunto
SELECT tag_group.nome AS grp, tag.nome AS tag, COUNT(DISTINCT obra_ref.id) AS total FROM obra INNER JOIN obra_tag ON obra_tag.id_obra = obra.id INNER JOIN tag ON tag.id = obra_tag.id_tag INNER JOIN tag_group ON tag_group.id = tag.id_group LEFT JOIN obra_tag ref ON ref.id_tag = obra_tag.id_tag LEFT JOIN obra obra_ref ON obra_ref.id = ref.id_obra AND obra_ref.ativo = 1 WHERE obra.id = 001164/obras/conjunto/obras/conjunto GROUP BY tag_group.nome, tag.nome ORDER BY grp, tag