Thomas Hardy's Ale

Hot
Mauricio Beltramelli
Updated 05 de Maio de 2024
 
4.4 (45)
19793 0 8

Avaliações dos usuários

45 avaliações
 
42%
 
58%
3 estrelas
 
0%
2 estrelas
 
0%
1 estrela
 
0%
Avaliação Geral
 
4.4
Aroma
 
9/10(45)
Aparência
 
4/5(45)
Sabor
 
18/20(45)
Sensação
 
4/5(45)
Conjunto
 
9/10(45)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
45 resultados - mostrando 41 - 45
1 2 3 4 5 6 7 8 9
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.4
Aroma
 
10/10
Aparência
 
2/5
Sabor
 
18/20
Sensação
 
4/5
Conjunto
 
10/10
Pela quantidade de locais de compra citados nota-se que se trata de uma cerveja a qual sempre bebo quando tenho a oportunidade.
O relato remonta a ultima vez que eu e meus confrades a degustamos.
Trata-se de uma cerveja bastante incomum. Pouco gás, NENHUMA espuma, bastante turva e muito cremosa.
Aparentemente seu aspecto é bem desagradável ao olhos por apresentar uma notável formação de sedimentos.
Um aroma amadeirado puxado para o carvalho.
Sua coloração e consistência assemelham-se a do mel e seu sabor é bastante complexo. Nos tres exemplares degustados foram sentidas três sensações diferentes. Um sabor de inicio acentuadamente adocicado lembrando mel com notáveis traços de maltes torrados, que ao final puxava pra um amargo bastante intenso.

Boa drinkabillity. Creio que nao se trata de uma cerveja para ser tomada mas sim apreciada a cada gole com extrema atenção.
Não tive a oportunidade de tomar um exemplar da safra de 2005.


Detalhes

Degustada em
06/Dezembro/2008
Envasamento
Volume em ml
330 ml
Onde comprou
Cervejarium/Vila Dionisio - Ribeirão Preto (tenho um exemplar comprado no Emporio BierGarten que ficará guardado pelos proximos 3 anos)
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
4.4
Aroma
 
9/10
Aparência
 
2/5
Sabor
 
19/20
Sensação
 
5/5
Conjunto
 
9/10
SAFRA 2007 - Ladino como só ele, o Marcelo trouxe também, para comparação, a Thomas Hardy´s Ale 2007 que, inclusive, é vendida hoje no próprio Cervejarium e no Empório Biergarten. Só então, com as duas brejas, uma em cada copo, pudemos perceber a real dimensão da complexidade que a guarda da cerveja pôde proporcionar. Essa mais jovem, embora igualmente fantástica, tinha menos cor, turbidez, corpo e as notas amadeiradas e vinificadas da mais “coroa”, de 2005. De impressionar.

Detalhes

Degustada em
31/Outubro/2008
Envasamento
Volume em ml
330 ml
Onde comprou
Cervejarium - Ribeirão Preto
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
 
2/5
Sabor
 
20/20
Sensação
 
5/5
Conjunto
 
10/10
Agora a safra 2007.Dois anos mais nova que a safra 2005,mas a diferença é grande.
A 2007 é mais clara que a 2005 e também não apresenta espuma,no aroma o alcool é mais perceptivel e no sabor também, e o amargor é muito mais forte pelo tempo de guarda ser menor.
Mas esta cerveja é tão complexa quanto a safra mais antiga.Vale a pena guarda-la e esperar envelhecer.

Detalhes

Degustada em
31/Outubro/2008
Envasamento
Volume em ml
250 ml
Onde comprou
Cervejarium
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
 
2/5
Sabor
 
20/20
Sensação
 
5/5
Conjunto
 
10/10
Marcelo Carneiro da Colorado sabe mesmo como agradar seus convidados,além da extrema alegria com que nos recebeu, ainda nos presenteou com uma raridade de sua adega de cervejas:a Thomas Hardy's Ale.
Esqueça tudo que sabe sobre cerveja.Essa é diferente em tudo.
A cor é Ocre e a leve carbonatação quase não apresenta espuma,no aroma sensações incriveis de madeira, vinho, e principalmente ameixa,mas não a passa, e sim a fresca.No sabor,a presença de maltes tostados,vinho doce e amendoas.Ela ao mesmo tempo que tem um bom amargor, também tem um doce que chega a doer.Para alguns desavisados vai parecer muito forte, mas pra mim é FANTÁSTICA!!!!!

Detalhes

Degustada em
31/Outubro/2008
Envasamento
Volume em ml
330 ml
Onde comprou
Cervejarium
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
 
2/5
Sabor
 
20/20
Sensação
 
5/5
Conjunto
 
10/10
SAFRA 2005 - O que o leitor vê na imagem acima é uma lenda das cervejas. Todas as garrafas são safradas e -- charme dos charmes -- numeradas uma a uma. Inglesa, o estilo é o barley wine. Os apreciadores, porém, costumam definir esta e outras poucas brejas como vintage ales, uma categoria de cerveja dentro da qual as amostras podem ser guardadas por vários anos, a ressaltar algumas de suas características sensoriais. Nobres leitores, apresento-lhes a Thomas Hardy´s Ale. E a que este escriba teve a honra de provar foi precisamente a breja de número 70478, da safra de 2005.

O local da degustação foi o excelente bar Cervejarium, em Ribeirão Preto, cujo proprietário é o dono da Cervejaria Colorado, o amigo Marcelo Carneiro da Rocha. E foi ele mesmo quem nos presenteou com um baldinho cheio de gelo e das raridades, que ele guardava na adega.

Produzida desde 1968 pela O´Hanlon´s Brewing Co., a breja é maturada durante nove meses em barris de Xerez. A própria cervejaria, durante os anos 80, estimulou a guarda da breja, colocando nos rótulos a inscrição "Não beba ainda", o que fez com que os apreciadores colecionasem seus exemplares para vendê-los anos depois a preços exorbitantes, prática que até hoje ainda persiste. Diz-se que pode ser guardada por períodos superiores a nada menos que 25 anos, cada dia dos quais se tornando ainda mais complexa.

Elegante, rara e sutil, a Thomas Hardy´s Ale 2005 é o equivalente cervejeiro à sofisticação dos melhores conhaques. De coloração ocre-escura, a breja quase não apresenta espuma. Encostando o copo no nariz se tem a dimensão da sua nobreza, numa verdadeira festa de aromas. Percebem-se madeira de carvalho, vinho do Porto, ameixas e uma pitada de anis. No sabor, os aromas se completam com a presença do malte torrado, nozes e amêndoas. O álcool (11,7%) é absolutamente bem inserido.

A Thomas Hardy´s Ale 2005 já deixou de ser vendida há tempos, e apenas poucos e bons colecionadores a possuem.

Detalhes

Degustada em
31/Outubro/2008
Envasamento
Volume em ml
330 ml
Onde comprou
Coleção particular
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
45 resultados - mostrando 41 - 45
1 2 3 4 5 6 7 8 9

S2Framework Debug Console

Database Queries (31)

  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 = 777
  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 = 777) 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 (777)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,6,13,12,28,19) AND value IN ( 'thomashardy','barleywine','sim','outros','8-12','tulipa','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 (777) 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 = 71) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 71) 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 = 71) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 71) 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 (777) 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 (71) )
  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 (71) 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 = 777 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 = 777 AND main_media = 1 ORDER BY media_id ASC LIMIT 1
  19. UPDATE j25_jreviews_media SET main_media = 0 WHERE listing_id = 777 and review_id = 0 and media_id != 976
  20. 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 = 777) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 40, 5
  21. 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 (347,71,91) )
  22. 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 (71,91,347) WHERE field.published = 1 AND field.visible >= 1
  23. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (3273,2679,2677,2665,2663)
  24. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
  25. 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)
  26. 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 (3273,2679,2677,2665,2663)
  27. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'garrafa') ORDER BY ordering ASC ,optionid ASC
  28. SELECT COUNT(*) FROM j25_jreviews_comments AS Review WHERE 1 = 1 AND ( (Review.pid = 777) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) )
  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.text ASC
  30. 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
  31. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1