Brejas Brejas

Lista de Cervejas Nacionais e Importadas

Lista de cervejas Nacionais e Importadas escolhidas pelos usuários do Brejas
 Busca avançada
Filtros
204 resultados - mostrando 61 - 70
« 1 2 3 4 5 6 7 8 9 10 11 ... »
Seguindo a maravilhosa idéia de desgustar pelo menos 1.000 cervejas especiais, vou aos poucos acrescentado cada cerveja a minha lista...
1000 Cervejas - Erika Silva
Comparar
Degustadas - Vitor Meireles
Comparar
Minhas Desejadas
Comparar
Degustadas, com garrafa guardada e avaliação em caderno
Comparar
Lista de cervejas com cadastro problemático aqui no Brejas, repetidas ou grafadas incorretamente.
Cervejas com cadastro repetido ou nomes errados no Brejas Hot
Comparar
Brejas bebidas
Comparar
Brejas Degustadas pelo Rafão
Comparar
As minhas eleitas para tomar sempre
Comparar
Lista 1
Comparar
Check
Comparar
204 resultados - mostrando 61 - 70
« 1 2 3 4 5 6 7 8 9 10 11 ... »


Copyright ® 2007-2024 BREJAS - Todos os Direitos Reservados

Lembre-se: Beba com moderação e responsabilidade. Se beber, não dirija.

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 params FROM j25_community_config WHERE name = 'config'
  6. 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 = 'content' AND Field.published = 1 AND Field.search = 1 )
  7. SELECT name, type FROM j25_jreviews_fields WHERE name IN ('jr_nacionalidade')
  8. 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)
  9. 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_jreviews_listing_totals AS Totals USE KEY (user_rating_rank) LEFT JOIN j25_content AS Listing 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 ( (Field.jr_nacionalidade = '*nacionais-e-importadas*') 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) ) ORDER BY Totals.user_rating_rank DESC, Totals.listing_id DESC LIMIT 60, 10
  10. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (19) AND type = 'content'
  11. 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 ( 19)
  12. SELECT Listing.contentid AS element_id,jr_nacionalidade,jr_disponibilidade,jr_tipodelista,jr_cervejasdalista FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (10077,9932,9840,9836,9818,9749,9713,9671,9661,9641)
  13. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'nacionais-e-importadas','tem-e-nao-tem-no-brasil','adega-pessoal','degustacao','tem-no-brasil','lista-pessoal') ORDER BY ordering ASC ,optionid ASC
  14. 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 IN (80,468,767,156,155,157,4718,737,141,573,283,6138,1680,539,100,105,112,117,120,124,125,486,530,531,43,115,168,231,235,293,373,472,473,579,728,2378,2449,3242,7045,8942,8943,1088,48,87,89,138,139,140,154,159,204,278,361,420,441,467,469,471,532,533,536,718,847,869,964,965,1023,1154,1222,1283,1325,1326,1451,1528,2043,2295,2534,2549,2576,2635,2643,2661,2743,2793,2962,3196,3418,3907,3939,3995,4023,4181,4418,4564,4565,4614,4793,5184,5470,5531,5595,5839,6056,6085,6137,6185,6425,6530,6703,6713,6725,6747,6772,6980,6983,7221,7222,7318,7518,7567,7993,8697,8893,9519,2548,7991,44,265,289,408,873,1109,1209,1275,1284,2031,2119,2155,2184,2709,2781,2899,3043,3083,3172,3304,3955,4018,4128,4527,4585,4687,5390,6119,6968,7100,7503,7846,8057,8177,8178,8203,8204,8408,8602,8785,8786,8904,8972,9054,9073,9093,9370,9453,9506,9746,9747,9808,9816,10014,10098,10254,10336,10428,10504,10607,10701,10722,10723,10806,11266,11497,11526,11541,11565,11592,11743,11814,11824,11879,11958,12040,12053,12322,12495,12535,12772,12825,12850,12983,13182,13950,14093,14094,14153,14237,15196,15200,15699,15767,16450,16451,17055,18610,4550,12038,11903,12158,7198,19806,14730,21452,21313,14871,9888,16976,20023,18055,20598,20879,20359,27103,27000,2149,4227,2497,1643,1576,5303,1342,3630,1363,5068,3201,1032,2165,2401,4506,1835,3287,3219,601,851,537,353,844,7095,1340,717,2166,684,146,942,94,2729,544,1330,514,2550,876,987,5455,1934,540,1286,2403,410,511,1628,1772,2909,7402,8032,5060,5699,1792,437,229,398,783,466,319,399,4308,615,400,51,433,246,1349,2101,612,1407,843,8997)) 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) )
  15. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
  16. 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)
  17. 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 (43,44,48,51,80,87,89,94,100,105,112,115,117,120,124,125,138,139,140,141,146,154,155,156,157,159,168,204,229,231,235,246,265,278,283,289,293,319,353,361,373,398,399,400,408,410,420,433,437,441,466,467,468,469,471,472,473,486,511,514,530,531,532,533,536,537,539,540,544,573,579,601,612,615,684,717,718,728,737,767,783,843,844,847,851,869,873,876,942,964,965,987,1023,1032,1088,1109,1154,1209,1222,1275,1283,1284,1286,1325,1326,1330,1340,1342,1349,1363,1407,1451,1528,1576,1628,1643,1680,1772,1792,1835,1934,2031,2043,2101,2119,2149,2155,2165,2166,2184,2295,2378,2401,2403,2449,2497,2534,2548,2549,2550,2576,2635,2643,2661,2709,2729,2743,2781,2793,2899,2909,2962,3043,3083,3172,3196,3201,3219,3242,3287,3304,3418,3630,3907,3939,3955,3995,4018,4023,4128,4181,4227,4308,4418,4506,4527,4550,4564,4565,4585,4614,4687,4718,4793,5060,5068,5184,5303,5390,5455,5470,5531,5595,5699,5839,6056,6085,6119,6137,6138,6185,6425,6530,6703,6713,6725,6747,6772,6968,6980,6983,7045,7095,7100,7198,7221,7222,7318,7402,7503,7518,7567,7846,7991,7993,8032,8057,8177,8178,8203,8204,8408,8602,8697,8785,8786,8893,8904,8942,8943,8972,8997,9054,9073,9093,9370,9453,9506,9519,9746,9747,9808,9816,9888,10014,10098,10254,10336,10428,10504,10607,10701,10722,10723,10806,11266,11497,11526,11541,11565,11592,11743,11814,11824,11879,11903,11958,12038,12040,12053,12158,12322,12495,12535,12772,12825,12850,12983,13182,13950,14093,14094,14153,14237,14730,14871,15196,15200,15699,15767,16450,16451,16976,17055,18055,18610,19806,20023,20359,20598,20879,21313,21452,27000,27103)
  18. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,22,24,6,13,12,28,19) AND value IN ( 'brouwerij-hoegaarden','dubinbev','AmBev','witbier','sim','nao','5-7','tumbler','SpatenFranziskanerBräu','german-weizen','weizen','baden-baden','Schincariol','barleywine','tulipa','conhaque','budejovicky-mestansky-pivovar','bierwein','bohemian-pilsener','pilsner','Caneca','wells-youngs','ontrade','esb','8-12','pint','cervejaria-wals','tripel','taca','dubbel','Damm','brazilways','oktoberfest-marzen','1-4','cervejaria-sudbrack','amber-lager','caldereta','schwarzbier','belgian-pale-ale','premium-american-lager','chope','rauchbier','cilindrico','belgian-strong-golden-ale','calice','weizenbock','Cervejaria Backer','standard-american-lager','special-bitter','cervejaria-colorado','ipa','porter','Cervejaria Bamberg','altbier','inverno','cervejaria-heineken','heineken','Krug','Bitburger Brauerei Th Simon','bitburger','german-pilsner','Petrópolis','dark-american-lager','inbev','sweet-stout','budweiser-budvar-ceske-budejovice','uniland','cervejaria-sankt-gallen','Struise','belgian-strong-dark-ale','13-15','Stella Artois','Carlsberg','carlsberg','Cerpa','Modelo','modelo','anunciada','Devassa','american-pale-ale','american-brown-ale','Badische Staatsbrauerei Rothaus AG','Palm','flanders-red-ale','brouwerij-moortgat','duvel-moortgart','paulaner-brauerei-munchen','casa-flora','doppelbock','erdinger-weissbrau','dunkelweizen','hijos-de-rivera','Het Anker','nono','abbaye-de-leffe','belgian-blond-ale','de-koningshoeven','belgian-quadrupel','Birra Peroni Industriale','sabmiller','sem-alcool','Miller Brewing Company','san-miguel','vienna','oktober','Pfungstadter','kirin-brewery','japanese-rice-lager','kristallweizen','AnheuserBusch','BindingBrauerei','Oetker','De-Bora-Bier','opa-bier','belgian-specialty-ale','DAB','dortmunder-export','Zehn-Bier','Coopers','old-ale','cervesur','schornstein','bierland','casa-di-conti','traditional-bock','Union-de-Cervecerias-Peruanas','outros','flensburger','Krombacher Privatbrauerei Kreuztal','fischer-dalsace','specialty-beer','kaiserdom-privatbrauerei','austral','solex-brasil','brasserie-saverne','brewdog','tarantino','brouwerij-achouffe','Alte Brauerei Triest 1766','Casa da Cerveja','bodebrown','imperial-double-ipa','fruit-beer','heidelberg','Burgman','weltenburg','boon-rawd','american-amber-ale','new-holland','russian-imperial-stout','flensburger-brauerei','coruja','helles','daniel-thwaites','cervejaria-way','karlsberg-brauerei','classic-american-pilsner','Halve Maan','helles-bock','american-wheat-rye','gaudenbier','blond-ale','comemorativa','invicta','allston-brew','dunkel','dama-bier','foreign-extra-stout','cervejaria-insana','anderson-valley','saint-bier-cervejaria','badger','HackerPschorr','radeberger','keller','saison','black-ipa','dresden-cervejaria','amazon-beer','irish-red-ale','lund','other-smoked','bier-hoff','pumpkin-ale','pivovar-protivin','cervejaria-nacional','colaborativa','bs-maui','morada-cia-etilica','session-ipa','american-ipa','tormenta','cervejaria-dortmund','cervejaria-palta','Ayinger','interfood','cervejaria-furst-bier','cervejaria-urbana','stillwater-artisanal-ales','brassagem-unica','mikkeller','le-trou-du-diable','anual-safrada','blondine-microbrewery','india-pale-lager','wood-aged','cervejaria-cathedral','cervejaria-aeon','cervejaria-tupiniquim','barco','dieu-du-ciel','cervejaria-antuerpia','standard-bitter','cevada-pura','van-pur','cervejaria-blumenau','cervejaria-everbrew','cbbp','lite-american-lager','hocus-pocus','cervejaria-campinas','novo-brazil-brewing','new-belgium','Germânia','prussia-bier','flauta','verao','5-elementos','cervejaria-octopus','norte-do-paraná-bebidas','faroeste','new-england-ipa','hofbrauhaus-munchen') ORDER BY ordering ASC ,optionid ASC
  19. 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 IN (3659,3629,3829,2968,2970,3671,5686,3830,3787,3661,3717,3877,4014,3668,3702,3764,3937,3763,3828,6049,3835,3793,4147,3762,6221,5014,5412,6110,3983,6418,3918,9008,5574,6839,3876,16431)) 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) )
  20. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (43,44,48,51,80,87,89,94,100,105,112,115,117,120,124,125,138,139,140,141,146,154,155,156,157,159,168,204,229,231,235,246,265,278,283,289,293,319,353,361,373,398,399,400,408,410,420,433,437,441,466,467,468,469,471,472,473,486,511,514,530,531,532,533,536,537,539,540,544,573,579,601,612,615,684,717,718,728,737,767,783,843,844,847,851,869,873,876,942,964,965,987,1023,1032,1088,1109,1154,1209,1222,1275,1283,1284,1286,1325,1326,1330,1340,1342,1349,1363,1407,1451,1528,1576,1628,1643,1680,1772,1792,1835,1934,2031,2043,2101,2119,2149,2155,2165,2166,2184,2295,2378,2401,2403,2449,2497,2534,2548,2549,2550,2576,2635,2643,2661,2709,2729,2743,2781,2793,2899,2909,2962,3043,3083,3172,3196,3201,3219,3242,3287,3304,3418,3630,3907,3939,3955,3995,4018,4023,4128,4181,4227,4308,4418,4506,4527,4550,4564,4565,4585,4614,4687,4718,4793,5060,5068,5184,5303,5390,5455,5470,5531,5595,5699,5839,6056,6085,6119,6137,6138,6185,6425,6530,6703,6713,6725,6747,6772,6968,6980,6983,7045,7095,7100,7198,7221,7222,7318,7402,7503,7518,7567,7846,7991,7993,8032,8057,8177,8178,8203,8204,8408,8602,8697,8785,8786,8893,8904,8942,8943,8972,8997,9054,9073,9093,9370,9453,9506,9519,9746,9747,9808,9816,9888,10014,10098,10254,10336,10428,10504,10607,10701,10722,10723,10806,11266,11497,11526,11541,11565,11592,11743,11814,11824,11879,11903,11958,12038,12040,12053,12158,12322,12495,12535,12772,12825,12850,12983,13182,13950,14093,14094,14153,14237,14730,14871,15196,15200,15699,15767,16450,16451,16976,17055,18055,18610,19806,20023,20359,20598,20879,21313,21452,27000,27103) GROUP BY listing_id
  21. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM j25_jreviews_media AS media WHERE listing_id IN (43,44,48,51,80,87,89,94,100,105,112,115,117,120,124,125,138,139,140,141,146,154,155,156,157,159,168,204,229,231,235,246,265,278,283,289,293,319,353,361,373,398,399,400,408,410,420,433,437,441,466,467,468,469,471,472,473,486,511,514,530,531,532,533,536,537,539,540,544,573,579,601,612,615,684,717,718,728,737,767,783,843,844,847,851,869,873,876,942,964,965,987,1023,1032,1088,1109,1154,1209,1222,1275,1283,1284,1286,1325,1326,1330,1340,1342,1349,1363,1407,1451,1528,1576,1628,1643,1680,1772,1792,1835,1934,2031,2043,2101,2119,2149,2155,2165,2166,2184,2295,2378,2401,2403,2449,2497,2534,2548,2549,2550,2576,2635,2643,2661,2709,2729,2743,2781,2793,2899,2909,2962,3043,3083,3172,3196,3201,3219,3242,3287,3304,3418,3630,3907,3939,3955,3995,4018,4023,4128,4181,4227,4308,4418,4506,4527,4550,4564,4565,4585,4614,4687,4718,4793,5068,5184,5303,5390,5455,5470,5531,5595,5699,5839,6056,6085,6119,6137,6138,6185,6425,6530,6703,6713,6725,6747,6772,6968,6980,6983,7045,7095,7100,7198,7221,7222,7318,7402,7503,7518,7567,7846,7991,7993,8032,8057,8177,8178,8203,8204,8408,8602,8697,8785,8786,8893,8904,8942,8943,8972,8997,9054,9073,9093,9370,9453,9506,9519,9746,9747,9808,9816,9888,10014,10098,10254,10336,10428,10504,10607,10701,10722,10723,10806,11266,11497,11526,11541,11565,11592,11743,11814,11879,11903,11958,12038,12040,12158,12322,12495,12535,12772,12825,12850,12983,13182,13950,14093,14094,14153,14237,14730,14871,15196,15200,15699,15767,16450,16451,16976,17055,18055,18610,19806,20023,20359,20598,20879,21313,21452,27000,27103) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
  22. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (63,72,71,62,1763,4478,523,41667,2565,4083,6469,7110,234,171,4794,4592,8585,1616,4379,2437,7410,4976,9528,9779,6116,5156,9227,5267,6276,12853,12749,12658,8769,16512,2887,1512,6535,12954,13168,12562,12886,14634,20645,21584,15008,28991,19622,9564,6874,18658,11738,1378,14999,16197,30057,13280,19817,24358,15975,15739,20825,15054,5375,26121,9280,12093,11690,35871,40285,35035,8155,15357,37527,41970,36402) )
  23. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (62,63,71,72,171,234,523,1378,1512,1616,1763,2437,2565,2887,4083,4379,4478,4592,4794,4976,5156,5267,5375,6116,6276,6469,6535,6874,7110,7410,8155,8585,8769,9227,9280,9528,9564,9779,11690,11738,12093,12562,12658,12749,12853,12886,12954,13168,13280,14634,14999,15008,15054,15357,15739,15975,16197,16512,18658,19622,19817,20645,20825,21584,24358,26121,28991,30057,35035,35871,36402,37527,40285,41667,41970) WHERE field.published = 1 AND field.visible >= 1
  24. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (10077,9932,9840,9836,9818,9749,9713,9671,9661,9641) GROUP BY listing_id
  25. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM j25_jreviews_media AS media WHERE listing_id IN (10077,9818) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
  26. 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 (37662,1914,37086,733,5156,26950,36661,35871,36450,36312) )
  27. 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 (733,1914,5156,26950,35871,36312,36450,36661,37086,37662) WHERE field.published = 1 AND field.visible >= 1
  28. SELECT COUNT(*) FROM j25_jreviews_listing_totals AS Totals LEFT JOIN j25_content AS Listing ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id WHERE 1 = 1 AND ( (Field.jr_nacionalidade = '*nacionais-e-importadas*') 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) )
  29. SELECT fieldid, type, metatitle, options, metakey, metadesc FROM j25_jreviews_fields WHERE name = 'jr_nacionalidade' AND `location` = 'content'
  30. SELECT FieldOption.optionid, FieldOption.text, FieldOption.description, FieldOption.control_field, FieldOption.control_value, Field.fieldid AS control_fieldid FROM j25_jreviews_fieldoptions AS FieldOption LEFT JOIN j25_jreviews_fields AS Field ON FieldOption.control_field = Field.name WHERE FieldOption.fieldid = 116 AND FieldOption.value = 'nacionais-e-importadas'
  31. 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 = 'content' AND Field.published = 1 )