Ola Dubh Special Reserve 18

Hot
Daniel Calicchio
Updated 15 de Junho de 2019
 
4.2 (51)
11729 0 5

Avaliações dos usuários

44 avaliações mencionando "
51 avaliações
 
12%
 
86%
 
2%
2 estrelas
 
0%
1 estrela
 
0%
Avaliação Geral
 
4.2
Aroma
 
8/10(51)
Aparência
 
4/5(51)
Sabor
 
17/20(51)
Sensação
 
4/5(51)
Conjunto
 
8/10(51)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
44 resultados - mostrando 31 - 35
1 2 3 4 5 6 7 8 9
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.1
Aroma
 
8/10
Aparência
 
4/5
Sabor
 
17/20
Sensação
 
4/5
Conjunto
 
8/10
Menos marcante que sua irmã 40 porém muito mais complexa do que seu embrião a old engine oil. Coloração preta também lembra petroleo e nanquim, espuma de bolhas medianas cuja formação e duração é bem pequena. No aroma notas de baunilha, whisky, toffee, chocolate torrefação, café bem complexa. Na boca é uma explosão de sabores, café, torrefação, baunilha, toffee, chocolate leve amadeirado e tabaco. A dirença principal esta no corpo, a 40 é mais licorosa e aveludada, já a 18 é mais leve um pouco mais carbonatada. Outra cerveja complexa de escelente drinkability e complexidade.

Detalhes

Degustada em
16/Junho/2010
Envasamento
Volume em ml
330 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.2
Aroma
 
8/10
Aparência
 
4/5
Sabor
 
18/20
Sensação
 
4/5
Conjunto
 
8/10
Com uma coloração preto turvo, espuma bege medianamente formada de media/baixa persistencia. No aorma notas de madeira, caramelo, chocolate, café, baunilha mates tostados e defumados e um toque de wisky burbon. Na boca essas notas explodem em diversos momentos, o whisky eh bem notado no meio da boca o final eh levemente adocicado e amargo. A textura ehlevemnete licorosa, o corpo eh medio, juntando sabor e drinkability. SEM DUVIDA uma cerveja IMPAR, TOP 10 NA CABEÇA

Detalhes

Degustada em
30/Julho/2010
Envasamento
Volume em ml
330 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.0
Aroma
 
8/10
Aparência
 
3/5
Sabor
 
16/20
Sensação
 
5/5
Conjunto
 
8/10
Que delícia de cerveja, acho que me apaixonei! rs
Cerveja oferecida generosamente pelo confrade Paulo Gomes numa reunião informal da CCC aqui em casa. Coloração negra, opaca, que no contra-luz revela bordas castanhas. Baixa formação de espuma marrom, de curta persistência. O aroma é bastante complexo, sendo que consegui identificar: malte defumado, dando aquele toque esfumaçado; e também torrado, dando uma sensação de queimado, que longe de desagradar, é muito gostosa; algo adocicado, talvez toffee ou baunilha; café e chocolate amargo e, claro, notas sutis de whisky, que no caso não é qualquer um, é o Highland Park Single Malt 18 anos, só um dos melhores whiskys do mundo (senão o melhor) e ficar maturando nos barris de carvalho dele fez toda a diferença. O sabor segue o aroma, delicioso, repetindo todas as notas presentes naquele, inclusive as notas amadeiradas de whisky; tem final doce e amargo, seco, queimado e alcoólico. Carbonatação baixa. Textura viscosa. Álcool perceptível, principalmente na finalização do gole, mas muito bem inserido, jamais agressivo. O que me impressionou é a leveza do corpo, estava esperando uma cerveja ultra-encorpada, pesada, mas que nada, é bem leve, fácil de beber! Essa cerveja ainda por cima tem uma boa drinkability, não empapuça, deu vontade de beber mais e mais copos, pena que acabou e que seja tão cara. Para quem gosta de whisky (meu caso), é a combinação perfeita entre cerveja e este nobre destilado. Deu até vontade de beber whisky depois. Recomendadíssima!

Detalhes

Degustada em
01/Julho/2010
Envasamento
Volume em ml
330 ml
Preço
cortesia do confrade Paulo Gomes
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.6
Aroma
 
7/10
Aparência
 
4/5
Sabor
 
14/20
Sensação
 
4/5
Conjunto
 
7/10
Coloração negra, com creme marrom de longa duração. No aroma, café, chocolate e baunilha. O sabor segue o aroma, com final prolongado equilibrando doce e amargo. Álcool bem inserido no conjunto. Boa cerveja, mas o preço judia.

Detalhes

Degustada em
26/Maio/2010
Envasamento
Volume em ml
330 ml
Onde comprou
Presente
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.2
Aroma
 
8/10
Aparência
 
4/5
Sabor
 
17/20
Sensação
 
4/5
Conjunto
 
9/10
Para comemorar minha centésima avaliação no ranking do Brejas, nada melhor do que esta bela Old Ale. Desta vez fui conferir as diferenças entre as sua irmã mais velha, Ola Dubh 40 e acabei descobrindo que são bem notáveis. Está daqui é a própria Old Engine oil, maturada em barris do delicioso Single Malt, Highland Park 18 Year

Sua coloração é negra, das mais escuras que eu já vi e o creme de coloração bege, forma-se numa proporção baixa, até menor do que a própria Ola Dubh 40.
O aroma é muito diferente, porém não deixando de ser delicioso. Aquelas notas do carvalho,já não são tão intensas, mas também não se deixam passar despercebidas. As notas da torrefação do malte, sugerindo chocolate e café, combatem de igual pra igual com o amadeirado, dando características que ficam exatamente entre a Old Engine Oil e a Ola Dubh 40. O álcool já vai se fazendo presente no aroma, como é de ser esperado pelo seu teor de 8%. Com atenção, ainda é possível perceber notas discretas de baunilha.

É no paladar que sente-se aquele amadeirado, somado a toques de defumados, que lembram uísque. Obviamente não é tão pronunciado quanto a Ola Dubh 40, mas pelo aroma esperava bem menos potência. Ao longo do gole, vai aparecendo o café, com suas notas amargas, não durando muito porém, e vai abrindo espaço para um dulçor característico de chocolate e toffe. Álcool presente, mas obviamente balanceado, como era de se esperar destes escoceses.

Como comentário final, a sensação que esta cerveja me passou, é uma cerveja com praticamente todas as características da Ola Dubh 40, porém com menos intensidade (principalmente o amadeirado), e é bem aconselhável para quem quer ter apenas uma idéia da paulada que é a estrela da cervejaria (já que esta é bem mais acessível quando se fala de preço) e para quem tem paladares mais sensíveis.

Detalhes

Degustada em
08/Maio/2010
Envasamento
Volume em ml
330 ml
Onde comprou
Mestre-Cervejeiro
Preço
R$32
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
44 resultados - mostrando 31 - 35
1 2 3 4 5 6 7 8 9

S2Framework Debug Console

Database Queries (37)

  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 = 1136
  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 = 1136) 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 (1136)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,24,6,13,12,28,19) AND value IN ( 'harviestoun','brazilways','wood-aged','sim','outros','8-12','conhaque') 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 (1136) 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 = 72) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 72) 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 = 72) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 72) 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 (1136) 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 (72) )
  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 (72) 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 = 1136 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range
  18. SELECT media_id from j25_jreviews_media WHERE listing_id = 1136 AND main_media = 1 ORDER BY media_id ASC LIMIT 1
  19. UPDATE j25_jreviews_media SET main_media = 0 WHERE listing_id = 1136 and review_id = 0 and media_id != 1375
  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 )
  21. SELECT name, type FROM j25_jreviews_fields WHERE name IN ('jr_envase')
  22. 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') )
  23. 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 = 1136) 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 30, 5
  24. 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 (92,352,2307,171,2565) )
  25. 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 (92,171,352,2307,2565) WHERE field.published = 1 AND field.visible >= 1
  26. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (19492,19448,18341,17253,16786)
  27. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
  28. 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)
  29. 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 (19492,19448,18341,17253,16786)
  30. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'garrafa') ORDER BY ordering ASC ,optionid ASC
  31. 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 = 1136) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) AND (ReviewField.jr_envase = '*garrafa*') )
  32. 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 )
  33. SELECT fieldid, name, title, type FROM j25_jreviews_fields WHERE name IN ('jr_envase')
  34. 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')
  35. 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
  36. 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
  37. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1