Alenda Bier Weizenbock

Mauricio Beltramelli
Updated 16 de Setembro de 2017
 
3.6 (11)
4698 0 2

Avaliações dos usuários

11 avaliações
5 estrelas
 
0%
 
73%
 
18%
 
9%
1 estrela
 
0%
Avaliação Geral
 
3.6
Aroma
 
7/10(11)
Aparência
 
4/5(11)
Sabor
 
14/20(11)
Sensação
 
4/5(11)
Conjunto
 
7/10(11)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
11 resultados - mostrando 1 - 5
1 2 3
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.8
Aroma
 
7/10
Aparência
 
4/5
Sabor
 
15/20
Sensação
 
4/5
Conjunto
 
8/10
No copo: coloração marrom escuro, turva, com média formação de creme de cor bege e média persistência.
Aroma: banana caramelizada, torrefação, especiarias.
Sabor: acompanha o aroma, com Dulçor moderado e Amargor leve.
Sensação: Carbonatação média e Corpo médio.
Drinkability: média.

Ótima ceva. Bem maltada, e com bom equilíbrio de suas caracteristicas.

Detalhes

Degustada em
15/Setembro/2017
Envasamento
Volume em ml
500 ml
Onde comprou
Regional Cervejas Artesanais (POA)
Preço
R$ 22,00
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.7
Aroma
 
7/10
Aparência
 
4/5
Sabor
 
15/20
Sensação
 
4/5
Conjunto
 
7/10
A aparência dessa Weizenbock é bastante escura, marrom, acobreada, cor de chocolate mesmo. Possui leve efervescência, com aspecto bem denso e profundo. Com o final da garrafa, veio um fermento que turvou completamente a cerveja, deixando muitas partículas em suspensão. Forma uma camada imensa de creme bege, fofo, disforme e com bolhas grandes, que permanece bastante tempo no copo e traz boa aderência.

O aroma é bem forte e desprende sem dificuldades. Inicialmente, percebe-se muito fenólico de cravo. E há também intensa presença floral de lúpulo. Possui um off-flavor de sabão bem intenso, mas que dissipa após um tempo. Sensações periféricas de malte, como tostado, café, chocolate, toffee, são sutis e acabam encobertas pelas demais sensações, mas podem ser percebidas à medida que a cerveja vai esquentando. Traz também um pouco de sensação de doce de banana. Apresenta forte álcool volatilizado.

Paladar bastante intenso, predominando as sensações tostadas, além de frutas escuras e secas e um vinoso/alcóolico bastante forte, como no aroma. Cerveja com notas bem nítidas de café/chocolate, ameixas/passas, com forte picância alcóolica e um amargor residual bastante saboroso, principalmente no denso final do gole. Retrogosto seco, quente/picante, prolongado, com leve adstringência e notas de frutado seco e tostado, defumação, madeira e café. Cerveja de corpo médio, sedoso e macio. Possui carbonatação mediana e precisa para o estilo, com crocância adequada. Apesar do teor alcóolico, traz um álcool que parece mais forte e, portanto, destoa em certos momentos. A drinkability é mediana, pois é uma cerveja potente demais, que chega a ser um pouquinho enjoativa.

Essa foi a terceira Alenda que degustei, terminando no estilo mais potente da cervejaria. Surpreendeu pela potência. Achei ela desequilibrada em determinados momentos, mas extremamente marcante em termos de retrogosto e sensações tostadas. Traz álcool muito forte e não muito bem encaixado no conjunto. Mas no geral, agradou. É uma Weizenbock de muito respeito. Recomendo sim, sem pudores.

Detalhes

Degustada em
20/Novembro/2011
Envasamento
Volume em ml
600 ml
Onde comprou
Produtor
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.8
Aroma
 
7/10
Aparência
 
3/5
Sabor
 
16/20
Sensação
 
4/5
Conjunto
 
8/10
COR: chocolate escuro, turva.
ESPUMA: bege claro, média formação, baixa sustentação, mantém película final.
AROMA: chocolate, frutas escuras, especiarias, vinho tinto, fermento, frutas vermelhas, álcool leve, bananada, lúpulo herbal, tostado, malte.
SABOR: frutas vermelhas e escuras, bolo de frutas, álcool, bananada, vinho tinto, chocolate, leve tostado, caramelo, malte, fermento, carbonatação média-baixa, corpo médio-alto, doce médio-alto, amargor alto. Fim doce e frutado.

Partindo do princípio que o estilo Weizenbock é um dos meus preferidos, era com alta expectativa que provava essa caseira. De pronto, só me recordava de apenas uma vez ter provado outra caseira também desse estilo num curso de cerveja artesanal, que o professor tinha levado para bebermos. A Alenda, da mesma forma que em sua Weizen, não faz feio, ao contrário, criou uma excelente opção do estilo para fazer frente as já difundidas do gênero. O líquido fez um balé dentro do copo, nadando por todas as bordas até o fundo tornando sua coloração amarronzada como chocolate escuro, cacau. Sua espuma peca ao não formar-se esplendorosamente, mas assenta bem ao topo por um breve momento, finalizando em apenas uma fina película. Seu cheiro tinha uma carga inicial de leve chocolate e frutas escuras, seguido de notas de especiarias, em especial o cravo da índia, um leve vinoso, para vir mais potencializados o fermento, álcool presente, uma enxurrada de banana (banana passa e bananada). Um agradável aroma de frutas vermelhas também estava lá, sem ser muito perceptível descobrir em específico quais. A carga maltada potencializada pelo torrado e o lúpulo herbal, picante, eram harmoniosamente casados. O sabor pode ser descrito como um mix de salada de frutas mais doces caseiros: figo, ameixa, cereja, morango, passas, banana, banana caramelada, bolo de frutas, banana passa, bananada, chocolate, caramelo; mas encontrar tudo isso não a tornou agressivamente doce, enjoativa. Seu teor alcoólico é bem sentido, trazendo um pouco de licorosidade, o lúpulo herbal trouxe frescor e picância, o amargor é alto, mas não de todo agressivo. Ela termina esplendorosamente num final doce e frutado que perdura na boca. Imediatamente tornei-me fã, provando que independente de ser caseira isso que é cerveja de verdade!

Detalhes

Degustada em
04/Novembro/2011
Envasamento
Volume em ml
600 ml
Onde comprou
Empório Gourmet
Preço
11,70
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.8
Aroma
 
7/10
Aparência
 
4/5
Sabor
 
16/20
Sensação
 
4/5
Conjunto
 
7/10
No copo verteu um líquido marrom turvo com um creme de boa formação e persistência.
No olfato, trouxe notas frutadas, condimentadas e torradas.
No paladar, apresentou sabores de melado, café, frutas escuras, banana, cravo.
Possui, ainda, toques terrosos e picantes.
Ela é adocicada, levemente ácida e mais amarga no fim.
O retrogosto é seco, picante, alcoólico e amargo.
É encorpada e sua carbonatação média.
O álcool se mostrou presente, mas não mascarou os aromas e sabores agradáveis apresentados.
Enfim, boa cerveja. Um excelente exemplar do estilo. Vale a degustação!

Detalhes

Degustada em
29/Outubro/2011
Envasamento
Volume em ml
600 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
 
5/5
Sabor
 
15/20
Sensação
 
4/5
Conjunto
 
8/10
Coloração marrom de alta turbidez. Alta formação de creme bege claro de alta persistência e bem denso. Aliás, o creme dessa Weizenbock é um show à parte. No aroma, percebe-se um frutado bem ativo que enfatiza notas de banana, cravo, caramelo e ao fundo, uma leve presença alcoólica. Aroma bem condimentado e bem agradável. O paladar reforça o frutado demonstrado no aroma e o forte condimentado. O retrogosto traz um leve amargor e ainda uma perceptível ação alcoólica. O que é esperado para o estilo. Cerveja muito balanceada, encorpada e com personalidade. Recomendo! Principalmente nesses dias de inverno.

Detalhes

Degustada em
02/Julho/2011
Envasamento
Volume em ml
600 ml
Onde comprou
Cervejoteca
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
11 resultados - mostrando 1 - 5
1 2 3

S2Framework Debug Console

Database Queries (32)

  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 = 2212
  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 = 2212) 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 (2212)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,6,13,12,28,19) AND value IN ( 'alenda-weisse','weizenbock','sim','nao','5-7','weizen') 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 (2212) 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 (2212) 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 = 2212 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 = 2212 AND main_media = 1 ORDER BY media_id ASC LIMIT 1
  19. UPDATE j25_jreviews_media SET main_media = 0 WHERE listing_id = 2212 and review_id = 0 and media_id != 2701
  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 = 2212) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 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 (34538,2080,2958,2437,4379) )
  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 (2080,2437,2958,4379,34538) 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 (129005,38639,37955,37654,32883)
  24. 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 (129005) 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
  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 (129005,38639,37955,37654,32883)
  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 WHERE 1 = 1 AND ( (Review.pid = 2212) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) )
  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.text ASC
  31. 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
  32. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1