S2Framework Debug Console

Database Queries (32)

1. SET SQL_BIG_SELECTS=1
2. SHOW TABLES LIKE '%_jreviews_config'
3. SELECT value FROM j25_jreviews_config WHERE id = 'cms_secret'
4. SELECT name FROM j25_jreviews_addons WHERE state = 1 ORDER BY ordering
5. SELECT params FROM j25_community_config WHERE name = 'config'
6. SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`, CriteriaRating.title AS `CriteriaRating.title`, CriteriaRating.required AS `CriteriaRating.required`, CriteriaRating.weight AS `CriteriaRating.weight`, CriteriaRating.description AS `CriteriaRating.description`, CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`, CriteriaRating.ordering AS `CriteriaRating.ordering`, ListingType.state AS `CriteriaRating.listing_type_state` FROM j25_jreviews_criteria_ratings AS CriteriaRating LEFT JOIN j25_jreviews_criteria AS ListingType ON ListingType.id = CriteriaRating.listing_type_id WHERE 1 = 1 AND ( CriteriaRating.listing_type_id = 8 )
7. SELECT count(DISTINCT groupid) FROM j25_jreviews_criteria WHERE groupid != ''
8. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (19) AND type = 'content'
9. SELECT Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access FROM j25_jreviews_fields AS Field WHERE Field.location = 'content' AND Field.listsort = 1 AND Field.groupid IN (19)
10. SELECT Category.id FROM j25_categories AS Category, j25_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1,4) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 157
11. SELECT id FROM j25_jreviews_categories WHERE `option` = "com_content"
12. 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 USE KEY (jr_hits) 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.catid IN (157) 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 Listing.hits DESC LIMIT 40, 10
13. 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)
14. SELECT Listing.contentid AS element_id,jr_nacionalidade,jr_disponibilidade,jr_tipodelista,jr_cervejasdalista FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (6319,7268,6939,8173,6306,7458,7593,9548,7248,15546)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'importadas','tem-e-nao-tem-no-brasil','mais','nacionais-e-importadas','recomendacao','lista-pessoal','tem-no-brasil','degustacao','guia-de-estilo','melhores','nacionais') ORDER BY ordering ASC ,optionid ASC
16. 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)
17. 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 (2161,2160,903,908,2547,6402,6401,6400,6398,6399,6396,6405,6404,5079,1096,1153,5530,4509,4314,4167,4415,970,5888,4638,2950,156,1839,1045,5134,1318,3486,5344,6207,3171,1726,3223,5562,4459,1157,2882,3884,1957,596,2138,1508,5700,1771,5191,3476,3746,5287,6089,5867,737,145,48,3110,3111,231,238,4330,169,173,872,264,783,246,353,373,1848,402,401,1349,413,105,117,120,248,2291,5158,579,6560,5460,2852,6888,43,3955,728,2888,1292,3770,5197,679,433,4553,6154,47,320,319,5320,293,4145,187,1142,3196,4418,61,1342,6592,3536,5390,4417,2057,2661,4362,4574,4621,5165,5184,6191,6735,13386,4130,4325,4521,6201,6345,6731,7133,7181,13292,13307,7127,5123,46,62,84,87,89,115,124,138,141,142,154,155,160,229,420,440,467,468,472,473,486,498,552,601,607,686,815,938,1051,1084,1088,1144,1155,1162,1275,1283,1367,1422,1480,1482,1484,1639,1640,1936,2021,2173,2236,2265,2306,2378,2397,2449,2549,2622,2743,2965,3103,3150,3514,3630,3658,3903,3907,3934,4235,4241,4464,4550,4594,4718,4942,5068,5248,5280,5512,5739,5741,5791,5994,6056,6185,6369,6470,6533,6748,7221,7222,7223,7450,7535,7538,8028,8057,8086,8138,8244,8285,8356,8485,8552,8571,8606,8619,8944,8997,9200,9600,9751,9929,9977,10199,10301,10486,10653,10808,11509,11779,7025,65,85,111,167,168,170,235,325,347,399,406,442,584,585,612,632,651,701,760,839,843,866,892,922,1075,1368,1674,1932,4782,5392,6103,7045,7508,532,2916,6124,100,107,112,125,157,240,241,283,361,377,378,380,702,720,771,806,1111,1287,1602,2183,2184,2185,2308,2445,2506,2531,2532,2585,2677,2793,3212,3316,3396,3520,3623,3938,3939,4595,4950,5018,5359,5537,5595,6321,6772,6980,7407,7940,8524,8558,8603,8943,549,2003,4625,4968,5097,6416,7984,8121,8632,8939,8989,9150,11758,11969,11993,12128,12236,12503,13345,14740,487,44,526,6530,77,847,560,6248,326,11608,680)) 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) )
18. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
19. 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)
20. 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,61,62,65,77,84,85,87,89,100,105,107,111,112,115,117,120,124,125,138,141,142,145,154,155,156,157,160,167,168,169,170,173,187,229,231,235,238,240,241,246,248,264,283,293,319,320,325,326,347,353,361,373,377,378,380,399,401,402,406,413,420,433,440,442,467,468,472,473,486,487,498,526,532,549,552,560,579,584,585,596,601,607,612,632,651,679,680,686,701,702,720,728,737,760,771,783,806,815,839,843,847,866,872,892,903,908,922,938,970,1045,1051,1075,1084,1088,1096,1111,1142,1144,1153,1155,1157,1162,1275,1283,1287,1292,1318,1342,1349,1367,1368,1422,1480,1482,1484,1508,1602,1639,1640,1674,1726,1771,1839,1848,1932,1936,1957,2003,2021,2057,2138,2160,2161,2173,2183,2184,2185,2236,2265,2291,2306,2308,2378,2397,2445,2449,2506,2531,2532,2547,2549,2585,2622,2661,2677,2743,2793,2852,2882,2888,2916,2950,2965,3103,3110,3111,3150,3171,3196,3212,3223,3316,3396,3476,3486,3514,3520,3536,3623,3630,3658,3746,3770,3884,3903,3907,3934,3938,3939,3955,4130,4145,4167,4235,4241,4314,4325,4330,4362,4415,4417,4418,4459,4464,4509,4521,4550,4553,4574,4594,4595,4621,4625,4638,4718,4782,4942,4950,4968,5018,5068,5079,5097,5123,5134,5158,5165,5184,5191,5197,5248,5280,5287,5320,5344,5359,5390,5392,5460,5512,5530,5537,5562,5595,5700,5739,5741,5791,5867,5888,5994,6056,6089,6103,6124,6154,6185,6191,6201,6207,6248,6321,6345,6369,6396,6398,6399,6400,6401,6402,6404,6405,6416,6470,6530,6533,6560,6592,6731,6735,6748,6772,6888,6980,7025,7045,7127,7133,7181,7221,7222,7223,7407,7450,7508,7535,7538,7940,7984,8028,8057,8086,8121,8138,8244,8285,8356,8485,8524,8552,8558,8571,8603,8606,8619,8632,8939,8943,8944,8989,8997,9150,9200,9600,9751,9929,9977,10199,10301,10486,10653,10808,11509,11608,11758,11779,11969,11993,12128,12236,12503,13292,13307,13345,13386,14740)
21. 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','cervejaria-heineken','heineken','sweet-stout','8-12','taca','brauerei-heller-trum','Stuttgart','rauchbier','Caneca','pint','inbev','pilsner','bayerische-staatsbrauerei-weihenstephan','ontrade','weizenbock','warsteiner-brauerei','bierwein','german-pilsner','cervejaria-wals','tripel','dubbel','cervejaria-sudbrack','amber-lager','schwarzbier','kolsch','cilindrico','belgian-pale-ale','premium-american-lager','belgian-strong-golden-ale','calice','Cervejaria Backer','esb','special-bitter','traditional-bock','cream-ale','cervejaria-colorado','ipa','porter','foreign-extra-stout','dark-american-lager','Carlsberg','carlsberg','Bitburger Brauerei Th Simon','bitburger','Petrópolis','st-james-gate','Diageo','dry-stout','budweiser-budvar-ceske-budejovice','bohemian-pilsener','cervejaria-sankt-gallen','Stella Artois','BindingBrauerei','Oetker','Cerpa','Modelo','modelo','anunciada','DaDo Bier','american-amber-ale','Devassa','american-pale-ale','Huyghe','nono','belgian-strong-dark-ale','Bosteels','biere-de-champagne-biere-brut','flauta','Cuauhtémoc Moctezuma','FEMSA','brouwerij-moortgat','duvel-moortgart','paulaner-brauerei-munchen','casa-flora','helles','erdinger-weissbrau','Damm','brazilways','hijos-de-rivera','dunkelweizen','kristallweizen','Coopers','uniland','HackerPschorr','abbaye-de-leffe','Murphy´s','birra-moretti','hofbrauhaus-munchen','mistura-classica','american-stout','Miller Brewing Company','sabmiller','Cervejaria Bamberg','belgian-blond-ale','Licher','Konig','Weissbierbrauerei G Schneider Sohn','doppelbock','inverno','kirin-brewery','japanese-rice-lager','AnheuserBusch','unicer','Alentejana','lite-american-lager','brooklyn','Dogfish','imperial-double-ipa','outros','Boston Beer Company','wood-aged','polar','goose-island','russian-imperial-stout','schornstein','opa-bier','anderson-valley','tarantino','oatmeal-stout','dunkel','barbarian','belgian-specialty-ale','gaudenbier','meantime','cervejaria-imperial','casa-di-conti','de-landtsheer','Corsario Negro','wells-youngs','fischer-dalsace','specialty-beer','faxe','royalunibrew','Hofbräu Kaltenhausen','vienna','dama-bier','brasserie-saverne','malt_liquor','brouwerij-van-steenberge','flanders-brown-ale','cervejaria-ravache','cerveceria-valdivia-sa','saint-bier-cervejaria','classic-american-pilsner','brouwerij-affligem-de-smedt','greenpoint','rogue','13-15','cervejaria-bierbaum','mill-street-brewery','Burgman','dum-cervejaria','mondi-beer','brewdog','coruja','baltika','cervejaria-way','irish-red-ale','het-koelschip','seasons-craft-brewery','invicta','karavelle','arcense-bierbrouwerij','mendocino','brouwerij-liefmans','lambic-fruit','cervejaria-caseira','benedith','cervejaria-dortmund','extraomnes','steamworks','cervejaria-roter','american-brown-ale','southerntier-brewing','primavera','birrificio-del-ducato-','benediktiner-weissbrau','fruit-beer','amazon-beer','malt-liquor','cervejaria-nacional','mikkeller','comemorativa','keller','bier-hoff','saison','black-ipa','natal','brewerkz','2cabecas','cervejaria-kud','speakeasy-ales-lagers','cervejaria-britannica','Ayinger','flying-dog','lund','Bavik','bodebrown','beers-on-the-table','chelarte','verao','microcervejaria-irmaos-ferraro','karlsberg-brauerei','bs-maui','lost-coast-brewery-cafe','wensky-beer','cervejaria-maniba','coronado-brewing','cervejaria-noi','cervejaria-cruz-de-malta','evil-twin-brewing','Germânia','cervejaria-insana','pivovar-regent','flying-monkeys','geht-trade','bear-republic','black-isle-brewery','new-holland','cervejaria-goyaz','to-ol','colaborativa','cape-horn','pyramid','brassagem-unica','cervejaria-urbana','cervejaria-heilige','eisbock','schorschbrau','hakusekikan','outono','best-beers-importadora','interfood','kiuchi','shv','tormenta','aegean','alameda-brewing','great-heck-brewing','weird-barrel-brewing-co','cervejaria-providencia','belgian-ipa','bastards-brewery','moocabier','india-pale-lager','american-ipa','cervejaria-tupiniquim','imperial-strong-porter','session-ipa','quinta-do-malte','cervejaria-babel','cevada-pura','cervejaria-crazy-rocker','roleta-russa','blondine-microbrewery','cervejaria-dádiva','hausen-bier','cervejaria-lola','leuven','maniacs-brewing','cervejaria-von-borstel','pumpkin-ale','memminger-brauerei','farra-bier','eden-beer','hocus-pocus','3-cariocas','cervejaria-motim','brewlab-cervejas-experimentais','quatro-graus','cervejaria-molinarius','soul-terê') ORDER BY ordering ASC ,optionid ASC
22. 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,5686,3627,3830,3854,2970,3661,3787,3937,3877,3828,3990,3835,3668,6012,3702,3764,3638,3763,3942,4038,5014,11455,3793,3762,4147,3983,4360,4014,5187,6443,3562,4658,3876,6049,6110,6367,7185,4607,6170,6418,6410,10198,3765,6839,7226)) 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) )
23. 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,61,62,65,77,84,85,87,89,100,105,107,111,112,115,117,120,124,125,138,141,142,145,154,155,156,157,160,167,168,169,170,173,187,229,231,235,238,240,241,246,248,264,283,293,319,320,325,326,347,353,361,373,377,378,380,399,401,402,406,413,420,433,440,442,467,468,472,473,486,487,498,526,532,549,552,560,579,584,585,596,601,607,612,632,651,679,680,686,701,702,720,728,737,760,771,783,806,815,839,843,847,866,872,892,903,908,922,938,970,1045,1051,1075,1084,1088,1096,1111,1142,1144,1153,1155,1157,1162,1275,1283,1287,1292,1318,1342,1349,1367,1368,1422,1480,1482,1484,1508,1602,1639,1640,1674,1726,1771,1839,1848,1932,1936,1957,2003,2021,2057,2138,2160,2161,2173,2183,2184,2185,2236,2265,2291,2306,2308,2378,2397,2445,2449,2506,2531,2532,2547,2549,2585,2622,2661,2677,2743,2793,2852,2882,2888,2916,2950,2965,3103,3110,3111,3150,3171,3196,3212,3223,3316,3396,3476,3486,3514,3520,3536,3623,3630,3658,3746,3770,3884,3903,3907,3934,3938,3939,3955,4130,4145,4167,4235,4241,4314,4325,4330,4362,4415,4417,4418,4459,4464,4509,4521,4550,4553,4574,4594,4595,4621,4625,4638,4718,4782,4942,4950,4968,5018,5068,5079,5097,5123,5134,5158,5165,5184,5191,5197,5248,5280,5287,5320,5344,5359,5390,5392,5460,5512,5530,5537,5562,5595,5700,5739,5741,5791,5867,5888,5994,6056,6089,6103,6124,6154,6185,6191,6201,6207,6248,6321,6345,6369,6396,6398,6399,6400,6401,6402,6404,6405,6416,6470,6530,6533,6560,6592,6731,6735,6748,6772,6888,6980,7025,7045,7127,7133,7181,7221,7222,7223,7407,7450,7508,7535,7538,7940,7984,8028,8057,8086,8121,8138,8244,8285,8356,8485,8524,8552,8558,8571,8603,8606,8619,8632,8939,8943,8944,8989,8997,9150,9200,9600,9751,9929,9977,10199,10301,10486,10653,10808,11509,11608,11758,11779,11969,11993,12128,12236,12503,13292,13307,13345,13386,14740) GROUP BY listing_id
24. 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,61,62,65,77,84,85,87,89,100,105,107,111,112,115,117,120,124,125,138,141,142,145,154,155,156,157,160,167,168,169,170,173,187,229,231,235,238,240,241,246,248,264,283,293,319,320,325,326,347,353,361,373,377,378,380,399,401,402,406,413,420,433,440,442,467,468,472,473,486,487,498,526,532,549,552,560,579,584,585,596,601,607,612,632,651,679,680,686,701,702,720,728,737,760,771,783,806,815,839,843,847,866,872,892,903,908,922,938,970,1045,1051,1075,1084,1088,1096,1111,1142,1144,1153,1155,1157,1162,1275,1283,1287,1292,1318,1342,1349,1367,1368,1422,1480,1482,1484,1508,1602,1639,1640,1674,1726,1771,1839,1848,1932,1936,1957,2003,2021,2057,2138,2160,2161,2173,2183,2184,2185,2236,2265,2291,2306,2308,2378,2397,2445,2449,2506,2531,2532,2547,2549,2585,2622,2661,2677,2743,2793,2852,2882,2888,2916,2950,2965,3103,3110,3111,3150,3171,3196,3212,3316,3396,3476,3486,3514,3520,3536,3623,3630,3658,3746,3770,3884,3903,3907,3934,3938,3939,3955,4130,4145,4167,4235,4241,4325,4330,4362,4417,4418,4459,4464,4509,4521,4550,4553,4574,4594,4595,4621,4625,4638,4718,4782,4942,4950,4968,5018,5068,5079,5097,5123,5134,5158,5165,5184,5191,5197,5248,5280,5287,5320,5344,5359,5390,5392,5460,5512,5530,5537,5562,5595,5700,5739,5741,5791,5867,5888,5994,6056,6089,6103,6124,6154,6185,6191,6201,6207,6248,6321,6345,6369,6396,6398,6399,6400,6401,6402,6416,6470,6530,6533,6560,6592,6731,6735,6748,6772,6888,6980,7025,7045,7127,7133,7181,7221,7222,7223,7407,7450,7508,7535,7538,7940,7984,8028,8057,8086,8121,8138,8244,8285,8356,8485,8524,8552,8558,8571,8603,8606,8619,8632,8939,8943,8944,8989,8997,9150,9200,9600,9751,9929,9977,10199,10301,10486,10653,10808,11509,11608,11758,11779,11969,11993,12128,12236,12503,13292,13307,13345,13386,14740) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
25. 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,73,62,46999,41667,875,1338,988,352,1099,3180,101,6469,2565,4752,7110,8203,4592,6465,4379,2307,6050,5875,8368,9033,1527,10440,10554,9469,7985,40316,6535,10547,4454,6276,6874,12749,523,13702,12853,2968,12658,8525,12954,5829,5156,12059,9528,9117,16512,16721,15204,4953,326,2080,14790,12562,16197,17687,10598,18471,9280,19475,18696,20239,21584,15008,7704,2887,9564,5555,21875,171,19622,19701,16173,24358,18202,11738,10060,28991,14999,30057,13957,12093,29093,19817,20825,15054,26121,30097,38024,34508,14834,40285) )
26. 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,101,171,326,352,523,875,988,1099,1338,1527,2080,2307,2565,2887,2968,3180,4379,4454,4592,4752,4953,5156,5555,5829,5875,6050,6276,6465,6469,6535,6874,7110,7704,7985,8203,8368,8525,9033,9117,9280,9469,9528,9564,10060,10440,10547,10554,10598,11738,12059,12093,12562,12658,12749,12853,12954,13702,13957,14790,14834,14999,15008,15054,15204,16173,16197,16512,16721,17687,18202,18471,18696,19475,19622,19701,19817,20239,20825,21584,21875,24358,26121,28991,29093,30057,30097,34508,38024,40285,40316,41667,46999) WHERE field.published = 1 AND field.visible >= 1
27. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (6319,7268,6939,8173,6306,7458,7593,9548,7248,15546) GROUP BY listing_id
28. 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 (6319,7268,8173,6306,7458,7593,9548,7248,15546) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
29. 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 (16197,11738,29498,33252,63,30097,29799) )
30. 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,11738,16197,29498,29799,30097,33252) WHERE field.published = 1 AND field.visible >= 1
31. SELECT COUNT(*) FROM j25_content AS Listing WHERE 1 = 1 AND ( Listing.catid IN (157) 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) )
32. SELECT Directory.id AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.slug AS `Directory.name`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description`, Directory.tmpl_suffix AS `Directory.tmpl_suffix` FROM j25_jreviews_directories AS Directory WHERE 1 = 1 AND ( Directory.id = 5 )