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 90, 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 (9086,9076,9069,9066,9061,8844,8795,8735,8723,8720)
13. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'nacionais-e-importadas','tem-no-brasil','lista-pessoal','adega-pessoal','degustacao','recomendacao','tem-e-nao-tem-no-brasil','comercial') 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 (43,46,47,66,100,105,107,112,115,117,120,124,125,169,170,172,229,231,239,246,283,293,315,319,320,325,343,373,380,413,420,433,438,454,468,469,473,486,530,531,532,566,579,584,585,601,679,684,728,729,737,771,783,815,866,892,916,938,1142,1480,1663,2175,2449,2785,2965,3060,3242,3658,4081,4116,4405,4718,5247,5359,5689,7221,7222,7223,7508,7940,8033,8086,8603,8608,9287,8942,8943,533,437,8552,168,1298,44,5925,145,160,1376,614,1335,328,467,240,77,2442,5080,323,322,7365,324,6362,720,142,48,692,2793,3255,6942,7765,49,55,84,189,192,193,194,209,306,307,309,361,401,406,448,450,489,492,514,516,537,538,539,540,541,552,558,619,696,796,1383,1628,1657,1927,2325,2349,2658,3666,3673,3995,4090,4144,4739,5068,5144,5433,5565,6070,6188,6836,8060,8104,8714,5731,5587,5681,85,157,300,1037,1223,2170,2191,2313,2445,2526,2643,2966,3113,3212,3609,3988,5533,5791,5897,6185,6984,8285,8470,8637,8851,8987,61,62,65,74,139,140,141,154,156,241,347,399,402,442,466,549,607,1051,1075,1342,1569,1703,1760,1772,2021,2057,2070,2548,2549,2550,3196,3386,3520,3630,3955,4181,4924,5018,5097,5390,5524,5839,6181,6475,6675,6785,6786,6994,7061,7073,7080,7188,7198,7261,7272,7459,7460,7482,7784,7826,7871,7872,7907,7969,8057,8265,8289,8567,8610,8985,6016,6112,2265,6056,2538,3064,3199,56,71,72,80,330,419,525,611,612,613,632,686,717,801,847,913,1629,1756,1776,1804,1857,1934,1945,1960,2005,2149,2173,2647,2661,2743,3276,3284,3288,3312,3399,3424,3447,3542,3822,4152,4241,4451,4521,4594,4625,4731,5183,5184,5734,5817,6043,6208,6230,6481,6530,6560,6608,6615,6750,6987,7318,7772,7841,7954,7990,8007,8180,8241,8260,8356,8462,8697,8734,8893,9031)) 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,46,47,48,49,55,56,61,62,65,66,71,72,74,77,80,84,85,100,105,107,112,115,117,120,124,125,139,140,141,142,145,154,156,157,160,168,169,170,172,189,192,193,194,209,229,231,239,240,241,246,283,293,300,306,307,309,315,319,320,322,323,324,325,328,330,343,347,361,373,380,399,401,402,406,413,419,420,433,437,438,442,448,450,454,466,467,468,469,473,486,489,492,514,516,525,530,531,532,533,537,538,539,540,541,549,552,558,566,579,584,585,601,607,611,612,613,614,619,632,679,684,686,692,696,717,720,728,729,737,771,783,796,801,815,847,866,892,913,916,938,1037,1051,1075,1142,1223,1298,1335,1342,1376,1383,1480,1569,1628,1629,1657,1663,1703,1756,1760,1772,1776,1804,1857,1927,1934,1945,1960,2005,2021,2057,2070,2149,2170,2173,2175,2191,2265,2313,2325,2349,2442,2445,2449,2526,2538,2548,2549,2550,2643,2647,2658,2661,2743,2785,2793,2965,2966,3060,3064,3113,3196,3199,3212,3242,3255,3276,3284,3288,3312,3386,3399,3424,3447,3520,3542,3609,3630,3658,3666,3673,3822,3955,3988,3995,4081,4090,4116,4144,4152,4181,4241,4405,4451,4521,4594,4625,4718,4731,4739,4924,5018,5068,5080,5097,5144,5183,5184,5247,5359,5390,5433,5524,5533,5565,5587,5681,5689,5731,5734,5791,5817,5839,5897,5925,6016,6043,6056,6070,6112,6181,6185,6188,6208,6230,6362,6475,6481,6530,6560,6608,6615,6675,6750,6785,6786,6836,6942,6984,6987,6994,7061,7073,7080,7188,7198,7221,7222,7223,7261,7272,7318,7365,7459,7460,7482,7508,7765,7772,7784,7826,7841,7871,7872,7907,7940,7954,7969,7990,8007,8033,8057,8060,8086,8104,8180,8241,8260,8265,8285,8289,8356,8462,8470,8552,8567,8603,8608,8610,8637,8697,8714,8734,8851,8893,8942,8943,8985,8987,9031,9287)
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','fnc-sa','standard-american-lager','1-4','chope','caldereta','quinsa','baden-baden','Schincariol','barleywine','tulipa','conhaque','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','trappistenabdij-de-achelse-kluis','belgian-strong-golden-ale','8-12','dubbel','cervejaria-heineken','heineken','sweet-stout','taca','brauerei-heller-trum','Stuttgart','rauchbier','Caneca','pint','inbev','pilsner','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','St Sylvestre','biere-garde','bayerische-staatsbrauerei-weihenstephan','ontrade','weizenbock','wells-youngs','esb','warsteiner-brauerei','bierwein','german-pilsner','cervejaria-sudbrack','amber-lager','schwarzbier','kolsch','cilindrico','belgian-pale-ale','premium-american-lager','Cervejaria Backer','special-bitter','traditional-bock','cream-ale','cervejaria-colorado','ipa','porter','foreign-extra-stout','malzbier','Bosteels','nono','abbaye-notre-dame-de-saint-remy','belgian-strong-dark-ale','Lefebvre','Bitburger Brauerei Th Simon','bitburger','Petrópolis','dark-american-lager','cervejaria-sankt-gallen','Stella Artois','brouwerij-van-honsebrouck','lambic-fruit','flauta','st-bernard-brouwerij','Chimay','Weissbierbrauerei G Schneider Sohn','kristallweizen','Boston Beer Company','walmart','vienna','Cerpa','Modelo','modelo','anunciada','DaDo Bier','Devassa','american-pale-ale','Huyghe','biere-de-champagne-biere-brut','Cuauhtémoc Moctezuma','FEMSA','Verhaeghe','best-beers-importadora','flanders-red-ale','brouwerij-moortgat','duvel-moortgart','paulaner-brauerei-munchen','casa-flora','doppelbock','Central de Cervejas e Bebidas','brasserie-d-orval','belgian-specialty-ale','greene-king','boxer','oettinger-bier-gruppe','uniland','malt-liquor','erdinger-weissbrau','dunkelweizen','hijos-de-rivera','Fuller´s','Het Anker','standard-bitter','brouwerij-van-steenberge','abbaye-de-leffe','belgian-blond-ale','de-koningshoeven','Murphy´s','dry-stout','birra-moretti','hofbrauhaus-munchen','helles','sem-alcool','Miller Brewing Company','sabmiller','Cervejaria Bamberg','Gebrüder Maisel Bayreuth','beer-legends','Licher','Wernesgruner','specialty-beer','oktoberfest-marzen','oktober','inverno','kirin-brewery','japanese-rice-lager','HackerPschorr','keller','AnheuserBusch','harviestoun','brazilways','unicer','carlsberg','Alentejana','brooklyn','rogue','tarantino','helles-bock','goose-island','karavelle','schornstein','russian-imperial-stout','outros','bierland','anderson-valley','dunkel','norrebro-bryghus','brewdog','imperial-double-ipa','Lindemans','eschweger-klosterbrauerei','charlevoix','verao','bodebrown','american-brown-ale','american-amber-ale','green-flash','fruit-beer','strongscotale','samuel-smith','oatmeal-stout','dum-cervejaria','founders-brewing','outono','dama-bier','cervejaria-krill','bernard','bohemian-pilsener','opa-bier','brouwerij-liefmans','amazon-beer','saint-bier-cervejaria','classic-american-pilsner','badger','american-wheat-rye','old-ale','comemorativa','ballast-point','invicta','faxe','royalunibrew','shv','Harboes-Bryggeri','cervejaria-wals','Ayinger','irish-red-ale','casa-di-conti','pivovar-platan','black-ipa','birra-del-borgo','coruja','bier-hoff','cervejaria-urbana','john-martin','blondine-microbrewery','cervejaria-premium','sixpoint','lorch-importadora','2cabecas','mistura-classica','beers-on-the-table','american-stout','de-dochter-van-de-korenaar','gaudenbier','cervejaria-dortmund','karlsberg-brauerei','bs-maui','wensky-beer','robinsons','mikkeller','Germânia','cervejaria-insana','cervejaria-jupiter','morada-cia-etilica','cervejaria-tupiniquim','brasserie-debly','tormenta','american-ipa','anual-safrada','Anchor Brewing Company','colaborativa','st-james-gate','Diageo','cervejaria-serra-de-tres-pontas','crew-alewerkstatt','interfood','imperial-strong-porter','saison','barco','north-peak-brewing','north-american-breweries','nomada-brewing','braustelle','altbier','le-trou-du-diable','buxton-brewery','flying-monkeys','les-trois-mousquetaires','lohn-bier','beavertown-brewery','berliner','gypsy-inc','india-pale-lager','Bavik','primavera','joia-mesquita','aegean','to-ol','american-wild-ale','brotas-beer','blue-moon','molsoncoors') 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 (3629,3829,2968,5686,3627,3830,2970,3942,3661,3717,4014,6012,3828,3787,3793,3835,3763,3659,3877,3702,4147,6110,6410,3983,3854,3937,6443,3876,6049,6418,6221,3935,5574,6422,6077,8316)) 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,46,47,48,49,55,56,61,62,65,66,71,72,74,77,80,84,85,100,105,107,112,115,117,120,124,125,139,140,141,142,145,154,156,157,160,168,169,170,172,189,192,193,194,209,229,231,239,240,241,246,283,293,300,306,307,309,315,319,320,322,323,324,325,328,330,343,347,361,373,380,399,401,402,406,413,419,420,433,437,438,442,448,450,454,466,467,468,469,473,486,489,492,514,516,525,530,531,532,533,537,538,539,540,541,549,552,558,566,579,584,585,601,607,611,612,613,614,619,632,679,684,686,692,696,717,720,728,729,737,771,783,796,801,815,847,866,892,913,916,938,1037,1051,1075,1142,1223,1298,1335,1342,1376,1383,1480,1569,1628,1629,1657,1663,1703,1756,1760,1772,1776,1804,1857,1927,1934,1945,1960,2005,2021,2057,2070,2149,2170,2173,2175,2191,2265,2313,2325,2349,2442,2445,2449,2526,2538,2548,2549,2550,2643,2647,2658,2661,2743,2785,2793,2965,2966,3060,3064,3113,3196,3199,3212,3242,3255,3276,3284,3288,3312,3386,3399,3424,3447,3520,3542,3609,3630,3658,3666,3673,3822,3955,3988,3995,4081,4090,4116,4144,4152,4181,4241,4405,4451,4521,4594,4625,4718,4731,4739,4924,5018,5068,5080,5097,5144,5183,5184,5247,5359,5390,5433,5524,5533,5565,5587,5681,5689,5731,5734,5791,5817,5839,5897,5925,6016,6043,6056,6070,6112,6181,6185,6188,6208,6230,6362,6475,6481,6530,6560,6608,6615,6675,6750,6785,6786,6836,6942,6984,6987,6994,7061,7073,7080,7188,7198,7221,7222,7223,7261,7272,7318,7365,7459,7460,7482,7508,7765,7772,7784,7826,7841,7871,7872,7907,7940,7954,7969,7990,8007,8033,8057,8060,8086,8104,8180,8241,8260,8265,8285,8289,8356,8462,8470,8552,8567,8603,8608,8610,8637,8697,8714,8734,8851,8893,8942,8943,8985,8987,9031,9287) 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,46,47,48,49,55,56,61,62,65,66,71,72,74,77,80,84,85,100,105,107,112,115,117,120,124,125,139,140,141,142,145,154,156,157,160,168,169,170,172,189,192,193,194,209,229,231,239,240,241,246,283,293,300,306,307,309,315,319,320,322,323,324,325,328,330,343,347,361,373,380,399,401,402,406,413,419,420,433,437,438,442,448,450,454,466,467,468,469,473,486,489,492,514,516,525,530,531,532,533,537,538,539,540,541,549,552,558,566,579,584,585,601,607,611,612,613,614,619,632,679,684,686,692,696,717,720,728,729,737,771,783,796,801,815,847,866,892,913,916,938,1037,1051,1075,1142,1223,1298,1335,1342,1376,1383,1480,1569,1628,1629,1657,1663,1703,1756,1760,1772,1776,1804,1857,1927,1934,1945,1960,2005,2021,2057,2070,2149,2170,2173,2175,2191,2265,2313,2325,2349,2442,2445,2449,2526,2538,2548,2549,2550,2643,2647,2658,2661,2743,2785,2793,2965,2966,3060,3064,3113,3196,3199,3212,3242,3255,3276,3284,3288,3312,3386,3399,3424,3447,3520,3542,3609,3630,3658,3666,3673,3822,3955,3988,3995,4081,4090,4116,4144,4152,4181,4241,4405,4451,4521,4594,4625,4718,4731,4739,4924,5018,5068,5080,5097,5144,5183,5184,5247,5359,5390,5433,5524,5533,5565,5587,5681,5689,5731,5734,5791,5817,5839,5897,5925,6016,6043,6056,6070,6112,6181,6185,6188,6208,6230,6362,6475,6481,6530,6560,6608,6615,6675,6750,6785,6786,6836,6942,6984,6987,6994,7061,7073,7080,7188,7198,7221,7222,7223,7261,7272,7318,7365,7459,7460,7482,7508,7765,7772,7784,7826,7841,7871,7872,7907,7940,7954,7969,7990,8007,8033,8057,8060,8086,8104,8180,8241,8260,8265,8285,8289,8356,8462,8470,8552,8567,8603,8608,8610,8637,8697,8714,8734,8851,8893,8942,8943,8985,8987,9031,9287) 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,71,72,14386,73,62,875,523,4752,352,4976,3180,5659,171,41667,7110,326,2565,8203,4592,4379,2437,8368,967,4454,10133,324,10554,9469,5156,184,6469,733,6276,6874,9094,6535,9528,12749,2887,12954,8525,15204,4953,16512,484,12562,13168,20227,20560,20546,19475,14634,5115,8661,85,9280,28991,9268,17374,8776,19622,17687,8358,11738,23633,14999,1378,12658,23123,15357,13280,22043,2080,12093,20825,11690,10060,19817,19701,16197,24358,5375,26121,3185) )
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,73,85,171,184,324,326,352,484,523,733,875,967,1378,2080,2437,2565,2887,3180,3185,4379,4454,4592,4752,4953,4976,5115,5156,5375,5659,6276,6469,6535,6874,7110,8203,8358,8368,8525,8661,8776,9094,9268,9280,9469,9528,10060,10133,10554,11690,11738,12093,12562,12658,12749,12954,13168,13280,14386,14634,14999,15204,15357,16197,16512,17374,17687,19475,19622,19701,19817,20227,20546,20560,20825,22043,23123,23633,24358,26121,28991,41667) 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 (9086,9076,9069,9066,9061,8844,8795,8735,8723,8720) 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 (9086,9066,9061) 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 (23214,35082,33199,35054,34660,34576,6386,34510,33623) )
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 (6386,23214,33199,33623,34510,34576,34660,35054,35082) 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 )