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 = 001306/info

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 = 001306/info
	GROUP BY
		tag_group.nome,
		tag.nome
	ORDER BY
		grp, tag

SELECT
			'I' AS tipo_midia,
			id,
			titulo,
			arquivo,
			credito,
			NULL AS tag,
			NULL AS duracao,
			NULL AS suporte,
			NULL AS data,
			ordem
		FROM imagem
		WHERE
			id_obra = 001306/info AND
			ativo = 1
	UNION
	SELECT
			'V' AS tipo_midia,
			id,
			titulo,
			thumb AS arquivo,
			NULL AS credito,
			tag,
			duracao,
			suporte,
			ano AS data,
			ordem
		FROM video
		WHERE
			id_obra = 001306/info AND
			ativo = 1
	ORDER BY
		ordem, id

SELECT texto.id, texto.titulo, texto.ano, texto.autor
	FROM texto
	INNER JOIN texto_obra ON texto_obra.id_texto = texto.id
	WHERE
		texto_obra.id_obra = 001306/info
	ORDER BY
		ano, titulo, autor

SELECT obra.id, obra.titulo, obra.ano
	FROM obra
	INNER JOIN obra_ref ON obra_ref.id_ref = obra.id
	WHERE
		obra_ref.id_obra = 001306/info
	ORDER BY
		ano, titulo

SOBRE / ABOUT / À PROPOS ensino de arte / classes / cours Cadernos de Prática Contato / Contact

Adalgisa Campos Paulo Camillo Penna

Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obra.php on line 217

Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obra.php on line 226

Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obra.php on line 240