Evil Twin Even More Jesus Port

Jota Fanchin Queiroz
Updated 01 de Novembro de 2016
 
4.6 (3)
2824 0 1

Avaliações dos usuários

3 avaliações
Avaliação Geral
 
4.6
Aroma
 
9/10(3)
Aparência
 
4/5(3)
Sabor
 
18/20(3)
Sensação
 
5/5(3)
Conjunto
 
10/10(3)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
3 resultados - mostrando 1 - 3
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.6
Aroma
 
9/10
Aparência
 
4/5
Sabor
 
18/20
Sensação
 
5/5
Conjunto
 
10/10
2 anos de guarda que fizeram muito bem para a Cerveja.
Tenho um gosto muito particular e indivídual em relação a brejas envelhecidas em barril, degustei essa breja logo após tomar um exemplar da Even More Jeus Bourbon Barrel Aged e mesmo achando que as caracteristicas de bourbon combinem mais com uma Imperial Stout em geral, neste caso foi diferente.
O vinho do porto é presente, amadeirado com um 'corte' ao longo da degustação ficando muito evidente as barricas que proporcionam além de notas amadeiradas um suave retrogosto de vinho do porto adocicado que combina perfeitamente com a licorosidade da breja.

Simplismente íncrivel, uma das maiores notas que já dei no site e com certeza uma das melhores brejas que tomei da minha adega para envelhecimento

Detalhes

Degustada em
01/Novembro/2016
Envasamento
Onde comprou
Londres
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.6
Aroma
 
9/10
Aparência
 
4/5
Sabor
 
18/20
Sensação
 
5/5
Conjunto
 
10/10
Esta Evil Twin Even More Jesus Port é do estilo Stout, sub-estilo Russian Imperial Stout, este caracterizador de cervejas de alta fermentação, geralmente com pouco gás e bastante álcool, forte sabor de chocolate, café e maltes torrados, coloração muito escura e grande complexidade tanto no aroma quanto no sabor, com frutado e amargor salientes. A história do estilo remonta ao século XVIII época em que a Corte Imperial da Rússia teria viajado a Londres e, tendo gostado das Stouts locais, encomendou barris daquela cerveja. Entretanto, a longa viagem através do mar Báltico terminava por estragar a cerveja. A solução foi desenvolver uma stout robusta e alcoólica o suficiente para suportar a viagem, preservando a cerveja e impedindo que ela congelasse. Esse tipo de stout foi batizada de Russian Imperial Stout, ou simplesmente Imperial Stout.

É produzida pela Cervejaria Evil Twin, instalada na cidade de Copenhagen/Dinamarca. Sua história recente remonta ao ano de 2010, tendo sido fundada por Jeppe Jarnit-Bjergsø (irmão de Mikkel Borg Bjergsø, da Mikkeller). Jeppe, então professor de Física e Inglés, já era dono do famosíssimo bar/loja Ølbutikken (aberto em 2005). Após a abertura da cervejaria vem seguindo os passos nômades do irmão brassando suas obras de arte em cervejarias mundo afora. Por exemplo, a Aún Más Café Jesús é brassada na Companyia Cervesera del Montseny, Espanha e a Even More Café Jesus é brassada na Cervejaria Westbrook, nos EUA. O portfólio da Evil Twin é vasto e este é o segundo rótulo que degusto.

Esta versão maturou em barris de carvalho nos quais anteriormente estagiou vinho do porto.

Lote (?); validade (?); vintage 2013. A garrafa é de 330 ml, cor marrom, tampa dourada e o rótulo (versão de exportação para os EUA) é exatamente este que vem ilustrado pelo Brejas, trazendo em letras grandes e douradas os nomes da cervejaria e da breja. No contra-rótulo, além da informação de que a cerveja foi produzida e engarrafada por Evil Twin nas instalações da Cervejara Fano Bryghus, bem como o o seguinte texto:
- ‘Few times in the history of craft beer it has happened that a highly praised beer rises beyond mortal stardom into a higher godly league. Usually the recipe to make such heavenly drops is thick fudge-like body, pitch black color, amazingly overwhelming aromas of chocolate, coffee, dark fruits and muscovado sugar, obviously only made in limited amounts and most crucial of all – it must taste rare!'

Vertida na taça revelou um líquido de coloração negra, opaco e não translúcido, com espuma de cor marrom de tímida formação, com bolhas pequenas e de manutenção exígua. Algumas poucas rendas se formaram e ao girar a taça as paredes laterais do vidro ficaram tomadas pelo líquido viscoso, mais ou menos como bolinhas de sagu escorrendo - as tais 'lágrimas'. Perlage (bolhas) praticamente imperceptível.

Degustada por volta dos 12ºC devo registrar que o aroma desta cerveja foi evoluindo à medida em que a temperatura aumentava, revelando pouco a pouco uma intensidade e uma complexidade mais acentuadas do que aquelas de pronto percebidas. De perfil maltado descortinou um verdadeiro festival olfativo com notas salientes de maltes torrados com percepções de chocolate amargo e café, além de baunilha, madeira, açúcar mascavo, frutado de ameixas, lúpulo herbal saliente e álcool vínico bem volátil.

No paladar o líquido se revelou viscoso, licoroso mesmo; no palato se mostrou altamente complexo e com equilíbrio que surpreendeu. O carro chefe são as intensas notas de torrefação com nuances de café e chocolate amargo, mas também estão lá açúcar mascavo, madeira, baunilha, caramelo e sensações de vinho do porto. Há também frutado de ameixas e uma expressiva base de lúpulo com pefil herbal que acompanha a degustação, mas sem aspereza, ainda que reste potencializado pelo amargor inerente à torrefação. Não percebi alcatrão, comum em outras RIS que já degustei (Emelisse e Struise Kabert). O álcool de ABV 12% é potente e bem perceptível, aquecendo agradavelmente a garganta. O final se apresenta seco e agridoce e o retrogosto é torrado, alcoólico e persistente. A carbonatação é média-baixa e o corpo é denso. A palatabilidade (drinkability) é ótima e em que pese a robustez do exemplar com parcimônia bebe-se fácil.

Degustação prazerosa, fruto de uma cerveja potente, equilibrada e muito complexa. Não é a toa que muitos tem a RIS como seu estilo predileto.

Imperdível!

Detalhes

Degustada em
27/Setembro/2014
Envasamento
Volume em ml
330 ml
Onde comprou
Preço
€ 6,00
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.5
Aroma
 
9/10
Aparência
 
3/5
Sabor
 
18/20
Sensação
 
5/5
Conjunto
 
10/10
Essa Even More Jesus Port Barrels é uma Russian Imperial Stout envelhecida em barris de carvalho que armazenaram e maturaram vinho do Porto. O resultado é uma cerveja incrivelmente agressiva, complexa e equilibrada. Destaque absoluto para as notas licorosas e vinificadas e a agressividade das notas da torrefação.
Vertida apresentou um líquido absolutamente negro viscoso, denso, opaco, de baixa carbonatação e que forma apenas um anel de creme marrom.
Aroma intenso, complexo e licoroso. Muito chocolate amargo, frutas escuras, frutas vermelhas caramelizadas e baunilha. Ao fundo cinzas e tabaco dão um toque rústico. Mas o destaque que cresce ao longo da degustação são as notas de vinho do porto.
Na boca a intensidade confirma a excepcionalidade da cerveja. Caramelo assado, chocolate, baunilha e frutas vermelhas abrem. Aos poucos notas licorosas do vinho do porto aparecem e conduzem a um final quente e com notas amargas de cinza e tabaco. Intenso e marcante. O aftertaste é deliciosamente licoroso com notas de vinho do porto, frutas vermelhas e chocolate amargo.
Corpo viscoso, carbonatação baixa e grande complexidade.
Uma cerveja de tirar o fôlego.
#ocontadordecervejas.com.br

Detalhes

Envasamento
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
3 resultados - mostrando 1 - 3

S2Framework Debug Console

Database Queries (30)

  1. SET SQL_BIG_SELECTS=1
  2. SHOW TABLES LIKE '%_jreviews_config'
  3. SELECT value FROM j25_jreviews_config WHERE id = 'cms_secret'
  4. SELECT name FROM j25_jreviews_addons WHERE state = 1 ORDER BY ordering
  5. SELECT Listing.catid FROM j25_content AS Listing RIGHT JOIN j25_jreviews_categories AS Category ON Listing.catid = Category.id AND Category.option = 'com_content' WHERE Listing.id = 6207
  6. SELECT params FROM j25_community_config WHERE name = 'config'
  7. SELECT JreviewsCategory.id FROM j25_jreviews_categories AS JreviewsCategory LEFT JOIN j25_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.`option`= "com_content" AND Category.published = 1 AND Category.access IN ( 1,4)
  8. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j25_content AS Listing LEFT JOIN j25_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j25_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j25_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j25_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j25_users AS User ON User.id = Listing.created_by LEFT JOIN j25_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( (Listing.id = 6207) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
  9. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
  10. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 2,18,20)
  11. SELECT Listing.contentid AS element_id,jr_cervejaria,jr_detalhesdacervejaria,jr_grupo,jr_importadora,jr_estilo,jr_alcool,jr_ibu,jr_srm,jr_ingredientes,jr_semglutem,jr_ativa,jr_sazonal,jr_temperatura,jr_copo,jr_site,jr_referencias FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (6207)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,6,13,12) AND value IN ( 'evil-twin-brewing','russian-imperial-stout','sim','brassagem-unica') ORDER BY ordering ASC ,optionid ASC
  13. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (6207) GROUP BY listing_id
  14. SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != listing_id AND media_type = 'photo' AND ((review_id = 0 AND user_id = 523) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 523) OR main_media = 1),@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != listing_id AND media_type = 'video' AND ((review_id = 0 AND user_id = 523) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 523) OR main_media = 1),@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != listing_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != listing_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := listing_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM j25_jreviews_media WHERE listing_id IN (6207) AND published = 1 AND approved = 1 AND access IN (1,4) AND extension = 'com_content' ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, listing_id, media_type, created DESC ) tmp JOIN j25_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank BETWEEN 1 AND 7) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.created DESC
  15. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (523) )
  16. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (523) WHERE field.published = 1 AND field.visible >= 1
  17. SELECT rating_range, count(*) AS count FROM (SELECT CASE WHEN ROUND(rating,1) > 0 AND rating < 1.5 THEN 1 WHEN ROUND(rating,1) >= 1.5 AND ROUND(rating,1) < 2.5 THEN 2 WHEN ROUND(rating,1) >= 2.5 AND ROUND(rating,1) < 3.5 THEN 3 WHEN ROUND(rating,1) >= 3.5 AND ROUND(rating,1) < 4.5 THEN 4 WHEN ROUND(rating,1) >= 4.5 THEN 5 END as rating_range FROM j25_jreviews_comments WHERE pid = 6207 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range
  18. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id` FROM j25_jreviews_comments AS Review LEFT JOIN j25_users AS User ON Review.userid = User.id LEFT JOIN j25_jreviews_reviewer_ranks AS ReviewerRank ON Review.userid = ReviewerRank.user_id LEFT JOIN j25_content AS Listing ON Listing.id = Review.pid LEFT JOIN j25_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( (Review.pid = 6207) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 5
  19. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (34698,9564,523) )
  20. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (523,9564,34698) WHERE field.published = 1 AND field.visible >= 1
  21. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (119544,85606,79911)
  22. SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != review_id AND media_type = 'photo' THEN @photo := 1 ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != review_id AND media_type = 'video' THEN @video := 1 ELSE IF(media_type = 'video' ,@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != review_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != review_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := review_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM j25_jreviews_media WHERE review_id IN (79911) AND published = 1 AND approved = 1 AND access IN (1,4) ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, review_id, media_type, created DESC ) tmp JOIN j25_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank BETWEEN 1 AND 3) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.review_id, tmp.media_type, tmp.created DESC
  23. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
  24. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'review' AND Field.groupid IN ( 1)
  25. SELECT Review.reviewid AS element_id,jr_data,jr_envase,jr_volume,jr_comprou,jr_ondebebeu,jr_preco FROM j25_jreviews_review_fields AS Review WHERE Review.reviewid IN (119544,85606,79911)
  26. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'garrafa') ORDER BY ordering ASC ,optionid ASC
  27. SELECT COUNT(*) FROM j25_jreviews_comments AS Review WHERE 1 = 1 AND ( (Review.pid = 6207) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) )
  28. SELECT FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.value, FieldValue.image, FieldValue.ordering FROM j25_jreviews_fieldoptions AS FieldValue WHERE FieldValue.fieldid IN (23) ORDER BY FieldValue.text ASC
  29. SELECT FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.value, FieldValue.image, FieldValue.ordering FROM j25_jreviews_fieldoptions AS FieldValue WHERE FieldValue.fieldid IN (23) ORDER BY FieldValue.ordering ASC
  30. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1