You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/ AND contact AND
obra.ativo = 1
ORDER BY
CASE WHEN artista ' at line 46
SELECT
obra.id AS id_obra,
obra.titulo,
obra.material,
obra.dimensoes,
obra.colecao,
CASE WHEN obra.pagseguro IS NOT NULL THEN obra.valor END AS valor,
artista.id AS id_artista,
artista.nome AS artista,
artista.ck_helper,
vw_midia.tipo AS tipo_midia,
vw_midia.url AS thumb
FROM obra
INNER JOIN (SELECT
vw_midia.*,
@curRank := if (@previous != id_obra, @curRank := 1, @total := @curRank + 1) AS rank,
@previous := id_obra AS temp
FROM (SELECT
id_obra,
CONCAT('admin/arquivos/midia/', LPAD(id_obra,6,'0'), '/thumb/', arquivo) COLLATE latin1_general_ci AS url,
'I' AS tipo,
ordem,
id
FROM imagem
WHERE ativo = 1
UNION
SELECT
id_obra,
thumb COLLATE latin1_general_ci AS url,
'V' AS tipo,
ordem,
id
FROM video
WHERE ativo = 1) vw_midia, (SELECT @curRank := 0, @previous:=null) r
ORDER BY
id_obra,
ordem,
tipo DESC,
id) vw_midia ON
vw_midia.id_obra = obra.id AND
vw_midia.rank = 1
INNER JOIN artista ON artista.id = obra.id_artista
WHERE
obra.ano BETWEEN info/contato-/ AND contact AND
obra.ativo = 1
ORDER BY
CASE WHEN artista = 1 THEN obra.ano END DESC,
obra.titulo,
obra.id DESC
Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obras.php on line 124
Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obras.php on line 150
Warning: count(): Parameter must be an array or an object that implements Countable in /home/storage/3/5b/78/acasatelie/public_html/obras.php on line 240