Rogue Morimoto Soba Ale

Brejas
Updated 13 de Março de 2016
 
3.4 (21)
4000 0 2

Avaliações dos usuários

12 avaliações com 4 estrelas
21 avaliações
5 estrelas
 
0%
 
57%
 
43%
2 estrelas
 
0%
1 estrela
 
0%
Avaliação Geral
 
3.4
Aroma
 
6/10(21)
Aparência
 
4/5(21)
Sabor
 
13/20(21)
Sensação
 
4/5(21)
Conjunto
 
7/10(21)
Para escrever uma avaliação por favor registre-se ou .
De volta ao item
12 resultados - mostrando 1 - 5
1 2 3
Ordenar
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.5
Aroma
 
6/10
Aparência
 
3/5
Sabor
 
16/20
Sensação
 
3/5
Conjunto
 
7/10
​Aroma pão, biscoito, arroz e massa de yakisoba. Sabor levemente frutado, nozes, castanha, mel, leve floral, trigo e um agradável doce no fim.
Cervejinha leve, facil e bem gostosa.
Harmonizo super bem com um peixe frito no fuba. Talvez por isso o gosto de semente esteve em destaque.
Se achasse mais com certeza comprava.

Detalhes

Degustada em
28/Janeiro/2016
Envasamento
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
(Atualizado: 24 de Fevereiro de 2026)
Avaliação Geral
 
3.5
Aroma
 
6/10
Aparência
 
4/5
Sabor
 
14/20
Sensação
 
4/5
Conjunto
 
7/10
A cervejaria "Rogue Ales" iniciou suas atividades em 1988 como um pequeno brewpub às margens do riacho "Lithia Creek", na pequena cidade de Ashland, Estado de Oregon. O sucesso foi tão grande que em menos de um ano os proprietários perceberam a necessidade de abrir um novo Pub em outra localidade, com maior espaço para a instalação de uma fábrica e consequente expansão da produção. Foi assim que em 1989 inauguraram sua nova sede na cidade de Newport, também em Oregon. Atualmente seus Pubs vão além do estado de origem, com unidades em Washington e California. Suas cervejas não são pasteurizadas e nem levam conservantes.
A " Rogue Morimoto Soba Ale" é uma cerveja especial lançada em 2003 com auxílio do renomado chef Masaharu Morimotoe e tem como diferencial a adição de "soba" - também conhecido como "trigo sarraceno" (ou ainda "mourisco") - em sua receita. Na verdade, este curioso ingrediente, bastante comum na culinária japonesa, não é um cereal e sim a semente seca de um fruto parente do ruibarbo e rico em rutina (Vitamina P).

Líquido de coloração âmbar - puxado para o dourado - de baixa turbidez. O colarinho branco tem formação modesta, com média duração.

O aroma surge com notas de malte levemente tostado e peculiar acidez (provavelmente advinda do trigo sarraceno?), além de lúpulo herbáceo e suave toque frutado. Ao fundo, um sutil traço de 'skunk' incomodou um pouco, lembrando o cheiro de 'mijo' em banheiro de rodoviária.

Felizmente, na boca ela não traz este fétido atributo. De corpo leve e bem carbonatada, ela combina nuances de malte ligeiramente tostado com bom amargor dos lúpulos e moderado salgado, engendrando sabores que vão do pão-de-alho temperado com ervas ao pretzel. O final é quase seco, com uma interessante pegada salobra. O retrogosto é lupulado, meio cítrico, de média persistência.

Cerveja fácil de beber - pede goles rápidos - ótima "session beer".




Detalhes

Degustada em
08/Maio/2013
Envasamento
Volume em ml
650 ml
Onde comprou
Beer4u
Preço
R$19,90
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
O visual dessa Morimoto Soba Ale da norte-americana Rogue é belo, tradicional, com cara de Pale Ale. Ela possui uma tonalidade alaranjada, um pouco escura, tendendo para o castanho, âmbar opaco. Ela não possui sedimentos e demonstra alguns filetes de efervescência. Formou uma camada média de espuma clara, cremosa, que assentou rapidamente, repousando sob a forma de fina película sobre o líquido. Deixa rastros de lacing pelas laterais.

O aroma é muito saboroso, mais destacado do que o de sua irmã Black Obi. Sensações bem equilibradas entre malte e lúpulo. Tem-se notas de casca de pão/pão branco, biscoito, caramelo, toffee/butterscotch, um pouco de defumação, castanhas/nozes, frutas secas (tâmaras/damascos), traços herbais e cítricos. Pouquíssimo off-flavor relevante. Talvez um pouco de oxidação, mas que não chega a incomodar. Conjunto harmonioso e saboroso que melhora conforme o líquido esquenta.

Na boca, ela mantém um perfil amargo desde o início, realmente tendendo a uma Bitter moderada, com pontadas herbais e salgadas. Lúpulo cumpre seu papel. Mesmo com toda a sua carga de malte, a doçura é muito tímida; a base maltada remete a cereais, um pouco de tostado e castanhas/nozes. Retrogosto refrescante, mas não muito prolongado ou contundente; ocorrem sutis sensações de secura e salgado, com notas de lúpulo, cereal, malte leve, tostado e frutas secas. O corpo dessa cerveja é leve e sedoso. A carbonatação é mediana, com uma crocância que colabora com o frescor. Álcool totalmente discreto, sem interferir. Drinkability muito boa, pois é uma cerveja leve, refrescante e fácil de beber, sem um caráter muito intenso ou enjoativo, bem descompromissada.

Comparativamente a sua irmã negra, gostei mais desta Morimoto Soba Ale. Ela é uma cerveja realmente muito saborosa e destacada dentro de sua proposta (uma Ale clara com forte amargor). O aroma já me prendeu a atenção e o paladar surpreendeu com toda sua carga amarga. O trigo sarraceno (soba) é discreto e aparece na forma de cereal, em sensações mais rústicas no aroma e paladar. Gostei muito. Recomendo com total facilidade. Vale a pena experimentar.

Detalhes

Degustada em
23/Março/2013
Envasamento
Volume em ml
650 ml
Onde comprou
EAP
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
 
4/5
Sabor
 
15/20
Sensação
 
5/5
Conjunto
 
8/10
Âmbar com espuma branca e de longa duração. Aroma lembra um pouco mel, com um toque acido, que me lembrou hidromel, com um toque floral.
O sabor comprovou um pouco da acidez, do mel e também do lupulo mais floral. Amargor eh médio e a breja eh levemente picante na língua.
Bem refrescante com esse toque meio azedinho, ótima session beer.

Detalhes

Degustada em
20/Maio/2012
Envasamento
Onde comprou
Rogue Ale House - SF
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
 
16/20
Sensação
 
3/5
Conjunto
 
8/10
Dourada pálida, turva e esbranquiçada, apresenta espuma fina.
Senti aroma de um malte diferente, mas leve, e lúpulo aromático. Cheirosa.
No sabor o malte lembra algum cereal fino, com apenas uma nuance de molho de yakisoba. Tem lúpulo gostoso no fim, mais potente que o malte.
Corpo médio e espuma leve.
Boa, original, com encaixe equilibrado. É leve e tem boa drinkability!

Detalhes

Degustada em
06/Maio/2012
Envasamento
Volume em ml
750 ml
Denunciar esta avaliação Comentários (0) | Considera esta avaliação útil? 0 0
12 resultados - mostrando 1 - 5
1 2 3

S2Framework Debug Console

Database Queries (33)

  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 = 1863
  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 = 1863) 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 (1863)
  12. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,24,6,13,12,28,19) AND value IN ( 'rogue','tarantino','shv','sim','nao','8-12','pint','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 (1863) 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 = 62) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 62) 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 = 62) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 62) 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 (1863) 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 (62) )
  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 (62) 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 = 1863 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 = 1863 AND main_media = 1 ORDER BY media_id ASC LIMIT 1
  19. UPDATE j25_jreviews_media SET main_media = 0 WHERE listing_id = 1863 and review_id = 0 and media_id != 2282
  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 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') )
  22. 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 = 1863) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) AND (Review.rating >= 3.5 AND Review.rating < 4.5) ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 5
  23. 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 (14999,5156,2080,63,8450) )
  24. 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,2080,5156,8450,14999) WHERE field.published = 1 AND field.visible >= 1
  25. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (109605,60704,58704,47564,47154)
  26. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
  27. 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)
  28. 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 (109605,60704,58704,47564,47154)
  29. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'garrafa','pressao') ORDER BY ordering ASC ,optionid ASC
  30. SELECT COUNT(*) FROM j25_jreviews_comments AS Review WHERE 1 = 1 AND ( (Review.pid = 1863) AND (Review.mode = 'com_content') AND (Review.author = 0) AND (Review.published = 1) AND (Review.rating >= 3.5 AND Review.rating < 4.5) )
  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.text ASC
  32. 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
  33. SELECT FieldOption.optionid, FieldOption.fieldid, FieldOption.value FROM j25_jreviews_fieldoptions AS FieldOption WHERE FieldOption.fieldid IN (23) AND FieldOption.default = 1