Lost Abbey Angel's Share

Sergio Curti
Updated 18 de Novembro de 2016
 
4.1 (6)
2663 0 4

Avaliações dos usuários

4 avaliações mencionando "
6 avaliações
 
17%
 
83%
3 estrelas
 
0%
2 estrelas
 
0%
1 estrela
 
0%
Avaliação Geral
 
4.1
Aroma
 
9/10(6)
Aparência
 
4/5(6)
Sabor
 
17/20(6)
Sensação
 
4/5(6)
Conjunto
 
8/10(6)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
4 resultados - mostrando 1 - 4
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.2
Aroma
 
9/10
Aparência
 
4/5
Sabor
 
17/20
Sensação
 
4/5
Conjunto
 
8/10
Garrafa de 375ml da safra de 2008.
Cor castanho escura,brilhante com leves reflexos avermelhados.
Líquido licoroso e com alta turbidez.
Espuma de cor bege escura com baixa densidade,de média formação
e baixa duração.Permanece apenas um fino colar após algum tempo.
Aroma lembrando vinho do porto,carvalho,ameixas,passas ao rum,
baunilha e álccol.Complexo.
Paladar com amargor da maturação no carvalho,malte e rum.Quente devido
ao álcool,mas bem inserido para os 12,5%ABV.
Uma cerveja com bastante personalidade,o aroma é espetacular e o álcool
muitíssimo bem inserido.Na minha opinião só peca pelo amargor um pouco
desequilibrado no paladar.

Detalhes

Degustada em
21/Outubro/2010
Envasamento
Volume em ml
375 ml
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.3
Aroma
 
9/10
Aparência
 
4/5
Sabor
 
17/20
Sensação
 
5/5
Conjunto
 
8/10
Degustada a 6,6 graus de temperatura. Validade não informada.
Essa barley wine americana é tão especial e complexa que nem parece cerveja.
Sua cor é marrom opaca e seu creme bege tem pouquíssima formação e duração.
Seu aroma lembra muito vermute de vinho tinto, deixando os aromas amadeirados
e do malte em segundo plano. O álcool presente no aroma fica sutil devido à essa
característica. No sabor essa sensação de destilado com vinho tinto (vermute)
também domina e encobre um pouco os sabores maltados marcantes tradicionais do
estilo. Licorosa e com pouca carbonatação. A presença dos 12,5% de álcool não
incomoda. Um conjunto marcante e muito interessante para ser apreciado com
atenção e em pequenas doses.

Destaque: Degustada na ilustre presença dos confrades Sangion e Marcussi.

Detalhes

Degustada em
29/Setembro/2010
Envasamento
Volume em ml
375 ml
Onde comprou
eBay
Preço
U$ 24,99
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.9
Aroma
 
8/10
Aparência
 
4/5
Sabor
 
15/20
Sensação
 
4/5
Conjunto
 
8/10
Com certeza essa breja vai dar muito o que falar.
De característica ímpar, eu dificilmente diria que é uma cerveja se não soubesse.

Traz referências muito fortes de outras bebidas alcoólicas, como whisky, brandy, Vinho do Porto e Xerez. Há quem goste mais destas experiências extremas de um lado, e de outro há aqueles que são mais puristas. Eu diria que fico no meio, já que gosto das diferentes experiências com a cerveja, mas desde que ela continue sendo vista como tal, o que acredito que ficou um pouco fora neste caso.

Mas vamos à cerveja:

Lançada ao copo, mostrou uma coloração preta não translucida de quase zero espuma.

O álcool é muito bem inserido não chega nem a parecer, nem em aroma, nem em sabor. Sente-se obviamente, na sensação de boca, mas até que gostei. Ponto pra breja! O lúpulo aparece de forma mentolada no aroma e ainda mais presente no sabor. Interessante, pois não é tão comum em cerveja. Novamente, ponto pra breja.

No mais, aromas e sabores complexos, amadeirados, licorosos, destilados, que já citei anteriormente. Aqui, acho que a breja acaba ficando um tanto quanto perdida, com muitas referências que a tiram do caminho de cerveja.

Retrogosto super intenso, da pra ficar lembrando da breja por vários minutos depois do gole. Digamos que é daquelas cervejas que se bebe com pouca frequência, em momentos bem específicos.

Conclusão: breja difícil de ser interpretada. Recomendo que faça sua degustação e compartilhe suas impressões com a gente.

Detalhes

Degustada em
29/Setembro/2010
Envasamento
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.7
Aroma
 
10/10
Aparência
 
4/5
Sabor
 
19/20
Sensação
 
4/5
Conjunto
 
10/10
Angelical? Eu diria que esta excelente barley wine está mais para um néctar deliciosamente demoníaco, com sua enorme potência, seu perfil vinificado e licoroso e sua assombrosa complexidade advinda da longa maturação de barris de carvalho. Derramada na taça (cálice sagrado!), ela praticamente não faz espuma (o que se espera pelo estilo); deixa antes uma fina e celestial névoa esbranquiçada sobre um líquido de aspecto licoroso e coloração marrom escura e opaca. Tanto no aroma quanto no sabor, sua potência mostra-se extraordinária, com destaque para a intensidade dos aromas terciários, advindos da maturação, que podem até chegar a assustar num primeiro momento. Predomina um perfil vinificado remetendo a vinhos fortificados, com notas evidentes de vinho do porto acompanhadas de vermute tinto, carpano, madeira e até algo de panettone, de uma forma que eu nunca havia sentido em nenhuma outra cerveja. Isso se explica, suponho, pelo emprego de barris de carvalho antes usados na maturação de brandy (destilado de vinho). O malte também se faz perceptível, embora um pouco menos, com notas de chocolate, licor de cacau e toques caramelados. Além disso tudo, ainda se sentem aromas secundários da fermentação, com ésteres remetendo a uvas passas bem integrados ao conjunto e um toque de xarope ou remédio. O lúpulo aromático se mostrou pouco evidente - em parte, a longa maturação do estilo o explica. O conjunto é muito impressionante, com uma intensidade de aromas terciários como poucas vezes eu havia sentido, a ponto de algumas pessoas que dividiram comigo a garrafinha ficarem com a impressão de que esta Angel's Share pouco parecia uma cerveja. Eu não chegaria a dizer tanto. O paladar é também muito marcante, com uma doçura predominante bem equilibrada por uma acidez vinificada e licorosa e por um correto amargor. Enquanto a entrada se mostra bastante doce, o amargor vai evoluindo com o tempo na boca, conduzindo a um final em que o amargor quase alcança a doçura, com um longo retrogosto vinificado remetendo a vinho do porto, carpano e panettone. O corpo é denso, licoroso, o que é ressaltado pela baixa carbonatação. O teor alcoólico de 12,5% não é brincadeira, mostrando-se bem perceptível na boca - embora isso se harmonize bem com seu perfil mais vinificado e intenso, diminui-lhe consideravelmente a drinkability, sendo talvez seu ponto mais fraco. Por conta disso, achei que a garrafinha de 375 ml, dividida em três pessoas, nos proporcionou uma dose já suficiente. Trata-se sem dúvida de uma bebida marcante, para ser degustada com calma e moderação, quem sabe como um digestivo ao fim do jantar. É preciso fazer justiça a esta cerveja: é algo realmente próximo a uma epifania, com características de maturação em carvalho absolutamente evidentes e marcantes. Se isso quase chega a sobrepujar os aromas primários e secundários a que estamos habituados na maior parte das nossas cervejas, também lhe dá uma complexidade impressionante. Tenho a impressão de que é o tipo de cerveja que se ama ou se odeia - eu posso dizer que a amei, e espero poder sorver novamente seus mistérios angélicos.

Detalhes

Degustada em
29/Setembro/2010
Envasamento
Volume em ml
375 ml
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
4 resultados - mostrando 1 - 4

S2Framework Debug Console

Database Queries (35)

  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 = 1966
  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 = 1966) 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 (1966)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,6,13,12,28,19) AND value IN ( 'lost-abbey','barleywine','sim','outros','8-12','caldereta') 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 (1966) 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 = 875) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 875) 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 = 875) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 875) 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 (1966) 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 (875) )
  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 (875) 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 = 1966 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range
  18. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value` FROM j25_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.location = 'review' AND Field.published = 1 AND Field.search = 1 )
  19. SELECT name, type FROM j25_jreviews_fields WHERE name IN ('jr_envase')
  20. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value` FROM j25_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.location = 'review' AND Field.published = 1 AND Field.search = 1 AND Field.type IN ('formbuilder','select','selectmultiple','text','textarea','radiobuttons','checkboxes') )
  21. 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' LEFT JOIN j25_jreviews_review_fields AS ReviewField ON Review.id = ReviewField.reviewid WHERE 1 = 1 AND ( (Review.pid = 1966) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) AND (ReviewField.jr_envase = '*garrafa*') ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 5
  22. 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 (5410,875,63,484) )
  23. 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 (63,484,875,5410) WHERE field.published = 1 AND field.visible >= 1
  24. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (24695,23344,23167,22408)
  25. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
  26. 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)
  27. 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 (24695,23344,23167,22408)
  28. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'garrafa') ORDER BY ordering ASC ,optionid ASC
  29. SELECT COUNT(*) FROM j25_jreviews_comments AS Review LEFT JOIN j25_jreviews_review_fields AS ReviewField ON Review.id = ReviewField.reviewid WHERE 1 = 1 AND ( (Review.pid = 1966) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) AND (ReviewField.jr_envase = '*garrafa*') )
  30. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value` FROM j25_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.location = 'review' AND Field.published = 1 )
  31. SELECT fieldid, name, title, type FROM j25_jreviews_fields WHERE name IN ('jr_envase')
  32. SELECT Field.name, FieldOption.text FROM j25_jreviews_fieldoptions AS FieldOption LEFT JOIN j25_jreviews_fields AS Field ON Field.fieldid = FieldOption.fieldid WHERE FieldOption.fieldid IN (23) AND FieldOption.value IN ('garrafa')
  33. 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
  34. 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
  35. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1