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 80, 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 (7068,9322,14169,7302,17361,8148,11091,12212,8084,11810)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,121,119) AND value IN ( 'nacionais-e-importadas','adega-pessoal','degustacao','lista-pessoal','tem-no-brasil','tem-e-nao-tem-no-brasil','importadas','comercial','melhores','recomendacao','nacionais','mais') 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 (530,43,107,1474,141,4718,737,145,48,160,771,552,229,231,4330,171,353,866,378,380,401,1349,2021,105,112,115,117,467,468,469,473,1367,492,5359,248,6188,729,579,561,558,537,531,619,549,46,679,440,437,47,1350,325,3127,293,815,1111,283,3196,85,84,1792,1376,5390,7772,3969,6615,5995,1298,6893,4594,2587,6985,6711,3218,49,192,194,193,448,324,322,323,56,3276,72,71,1629,1628,3447,1342,6526,1839,3354,1929,6927,1276,185,1297,5634,5131,6694,2005,4768,2720,3624,2575,5595,869,87,89,931,2975,2750,5587,3399,1772,1945,2231,3288,3670,321,4259,1683,1664,892,2528,6847,1096,500,499,6479,613,612,611,2888,2349,308,3284,713,2647,2049,328,5046,4930,5228,5183,7803,7460,5545,7459,5512,2100,3542,5681,490,991,488,491,489,2768,5604,5434,3049,420,1292,189,1643,4285,2626,2550,2549,2548,427,509,3524,783,7501,6182,1335,614,77,120,7222,154,4241,6761,240,7223,9301,4451,9805,9679,125,155,157,316,347,373,398,399,400,414,441,601,680,728,773,839,916,987,1032,1286,1756,2032,2170,2223,3062,3076,3242,4128,6778,7589,8089,8331,8363,8562,8942,8944,9287,9601,9972,10091,10181,10322,11318,235,897,61,66,124,167,169,172,239,246,320,433,456,581,651,684,964,966,1075,1131,1634,1640,2086,2187,2232,2257,2370,2722,2962,4779,5247,6056,6747,7221,7765,8412,8945,9233,9516,9928,9929,9930,10131,10259,10518,10703,11358,11497,11538,11602,1733,7856,5235,69,70,113,190,290,306,309,390,512,514,540,630,859,896,930,1117,1338,1527,1759,1808,1840,2058,2070,2097,2148,2155,2521,2565,2566,2568,2589,2976,3087,3158,3159,3199,3296,3299,3324,3448,3688,4018,4026,4510,4612,4700,4791,5123,5331,5638,5698,5818,6260,6333,6475,6730,6744,7017,7038,7117,7178,7228,7294,7465,7466,7468,7469,7476,7503,7526,7531,7560,7579,7615,7818,7861,7990,8072,8074,8136,8142,8539,8543,8544,8658,8710,8898,9295,9310,9387,9449,9594,9610,9672,9762,10315,10381,10399,10405,10606,10608,10609,10621,10623,10662,10874,11171,11483,11678,11694,11877,12086,12112,12128,12284,12434,12450,12503,12504,12725,12824,12834,12981,12994,13002,13003,13008,13009,13012,13024,13081,13168,13169,13285,13352,13386,13561,13589,13595,13908,13942,14375,14376,14466,14545,14548,14551,14560,14600,14605,14633,14656,14916,14952,15218,15320,15365,15484,15490,15491,15492,15504,15592,15186,15210,13927,8603,5890,5320,1585,319)) 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,46,47,48,49,56,61,66,69,70,71,72,77,84,85,87,89,105,107,112,113,115,117,120,124,125,141,145,154,155,157,160,167,169,171,172,185,189,190,192,193,194,229,231,235,239,240,246,248,283,290,293,306,308,309,316,319,320,321,322,323,324,325,328,347,353,373,378,380,390,398,399,400,401,414,420,427,433,437,440,441,448,456,467,468,469,473,488,489,490,491,492,499,500,509,512,514,530,531,537,540,549,552,558,561,579,581,601,611,612,613,614,619,630,651,679,680,684,713,728,729,737,771,773,783,815,839,859,866,869,892,896,897,916,930,931,964,966,987,991,1032,1075,1096,1111,1117,1131,1276,1286,1292,1297,1298,1335,1338,1342,1349,1350,1367,1376,1474,1527,1585,1628,1629,1634,1640,1643,1664,1683,1733,1756,1759,1772,1792,1808,1839,1840,1929,1945,2005,2021,2032,2049,2058,2070,2086,2097,2100,2148,2155,2170,2187,2223,2231,2232,2257,2349,2370,2521,2528,2548,2549,2550,2565,2566,2568,2575,2587,2589,2626,2647,2720,2722,2750,2768,2888,2962,2975,2976,3049,3062,3076,3087,3127,3158,3159,3196,3199,3218,3242,3276,3284,3288,3296,3299,3324,3354,3399,3447,3448,3524,3542,3624,3670,3688,3969,4018,4026,4128,4241,4259,4285,4330,4451,4510,4594,4612,4700,4718,4768,4779,4791,4930,5046,5123,5131,5183,5228,5235,5247,5320,5331,5359,5390,5434,5512,5545,5587,5595,5604,5634,5638,5681,5698,5818,5890,5995,6056,6182,6188,6260,6333,6475,6479,6526,6615,6694,6711,6730,6744,6747,6761,6778,6847,6893,6927,6985,7017,7038,7117,7178,7221,7222,7223,7228,7294,7459,7460,7465,7466,7468,7469,7476,7501,7503,7526,7531,7560,7579,7589,7615,7765,7772,7803,7818,7856,7861,7990,8072,8074,8089,8136,8142,8331,8363,8412,8539,8543,8544,8562,8603,8658,8710,8898,8942,8944,8945,9233,9287,9295,9301,9310,9387,9449,9516,9594,9601,9610,9672,9679,9762,9805,9928,9929,9930,9972,10091,10131,10181,10259,10315,10322,10381,10399,10405,10518,10606,10608,10609,10621,10623,10662,10703,10874,11171,11318,11358,11483,11497,11538,11602,11678,11694,11877,12086,12112,12128,12284,12434,12450,12503,12504,12725,12824,12834,12981,12994,13002,13003,13008,13009,13012,13024,13081,13168,13169,13285,13352,13386,13561,13589,13595,13908,13927,13942,14375,14376,14466,14545,14548,14551,14560,14600,14605,14633,14656,14916,14952,15186,15210,15218,15320,15365,15484,15490,15491,15492,15504,15592)
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','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','dubbel','cervejaria-heineken','heineken','sweet-stout','8-12','taca','pilsner','belgian-strong-dark-ale','belgian-specialty-ale','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','bayerische-staatsbrauerei-weihenstephan','ontrade','weizenbock','weizen','german-weizen','warsteiner-brauerei','bierwein','german-pilsner','Caneca','cervejaria-wals','cervejaria-sudbrack','schwarzbier','kolsch','cilindrico','belgian-pale-ale','pint','de-leyerth-brouwerijen','premium-american-lager','rauchbier','belgian-strong-golden-ale','special-bitter','cream-ale','cervejaria-colorado','ipa','foreign-extra-stout','inbev','dark-american-lager','malzbier','tucher-brau-furth','Oetker','anunciada','Bosteels','nono','Brouwerij Van Steenberge','abbaye-notre-dame-de-saint-remy','Bitburger Brauerei Th Simon','bitburger','Petrópolis','st-james-gate','Diageo','dry-stout','cervejaria-sankt-gallen','Struise','russian-imperial-stout','Stella Artois','st-bernard-brouwerij','Cuauhtémoc Moctezuma','sierra-nevada-brewing-company','american-pale-ale','Chimay','Weissbierbrauerei G Schneider Sohn','Stuttgart','Carlsberg','carlsberg','Modelo','modelo','DaDo Bier','american-amber-ale','De Dolle','Devassa','american-brown-ale','Huyghe','desnoes-and-geddes','ibeer','brouwerij-moortgat','duvel-moortgart','brouwerij-van-steenberge','paulaner-brauerei-munchen','casa-flora','doppelbock','helles','brasserie-d-orval','Primo Schincariol','erdinger-weissbrau','dunkelweizen','hijos-de-rivera','Fuller´s','boxer','esb','old-ale','porter','brouwerij-achouffe','Het Anker','comemorativa','abbaye-de-leffe','belgian-blond-ale','de-koningshoeven','Murphy´s','FEMSA','birra-moretti','hofbrauhaus-munchen','oktoberfest-marzen','oktober','Miller Brewing Company','sabmiller','Gebrüder Maisel Bayreuth','beer-legends','brouwerij-liefmans','flanders-brown-ale','Konig','vienna','Brauerei Schloss Eggenberg','outros','kirin-brewery','japanese-rice-lager','HackerPschorr','keller','AnheuserBusch','unicer','Alentejana','brooklyn','brazilways','cerveceria-valdivia-sa','Sabores-do-Chile','Cerpa','harviestoun','wood-aged','Zehn-Bier','Rasen','Coopers','uniland','Cervejaria Backer','anderson-valley','tarantino','oatmeal-stout','dunkel','dortmunder-export','schornstein','traditional-bock','de-landtsheer','inverno','Anchor Brewing Company','wells-youngs','fischer-dalsace','specialty-beer','fabrica-do-chope','faxe','royalunibrew','heineken-nederland','Bavik','flanders-red-ale','brewdog','imperial-double-ipa','saint-bier-cervejaria','classic-american-pilsner','cervejaria-malta','mcauslan','bodebrown','dieu-du-ciel','best-beers-importadora','stone-brewing-co','primavera','founders-brewing','strongscotale','samuel-smith','dum-cervejaria','ogre-beer','eisbock','Dogfish','outono','cervejaria-riograndense','russian-river','bear-republic','new-holland','kalena','baltika','Central de Cervejas e Bebidas','cervejaria-bierbaum','fruit-beer','flauta','cbbp','Hanssens Artisanaal','lambic-gueuze','lost-coast-brewery-cafe','american-wheat-rye','natal','Cantillon','birrificio-del-ducato-','emelisse','hook-norton','lambic-fruit','great-divide','joseph-holt','english-brown-ale','wensky-beer','cervejaria-noi','southerntier-brewing','St-Francis-Abbey ','irish-red-ale','Ayinger','le-baladin','casa-di-conti','black-ipa','oskar-blues-brewing-company','Brouwerij-de-Molen','cigar-city','Harboes-Bryggeri','mikkeller','brauerei-heller-trum','other-smoked','boon-rawd','2cabecas','ballast-point','john-martin','evil-twin-brewing','green-flash','sem-alcool','hornbeer','stillwater-artisanal-ales','cervejaria-maniba','schmucker-','saison','malt-liquor','nogne','american-stout','Germânia','cervejaria-insana','flying-monkeys','geht-trade','brasserie-debly','hambleton-ales','brassagem-unica','imperial-strong-porter','lite-american-lager','anual-safrada','cervejaria-serra-de-tres-pontas','dundee-brewing','north-american-breweries','cervejaria-tupiniquim','biermanufaktur-engel','amager-bryghus','bier-hoff','pumpkin-ale','Cervejaria Ashby','mad-river-brewing','boulevard-brewing','colaborativa','brasseurs-du-monde','the-kernel-brewery','brauerei-paffgen','brouwerij-van-honsebrouck','hocus-pocus','Fantôme','morada-cia-etilica','biere-de-champagne-biere-brut','barco','lohn-bier','verao','container-british-beer','cervejaria-dogma','american-wild-ale','moocabier','cervejaria-blumenau','american-ipa','cervejaria-premium','jeffrey-beer','bohemian-pilsener','brewfist','thisted-bryghus','three-floyds','cervejaria-louvada','Krug','cervejaria-jupiter','cerveja-tokai','berghain-cervejaria','Brasserie StFeuillien','cervejaria-dádiva','cervejaria-blauer-berg','beer-concept','destroyer-beer','belgian-ipa','cervejaria-imigracao','catharina-sour','cervejaria-everbrew','buena-beer','3-cariocas','omnipollo','quatro-graus','cervejaria-octopus','christmas-winter','toppling-goliath-brewing','Du Bocq','brasserie-des-garrigues','cervejaria-old-school','cervejaria-molinarius','wonderland-brewery','sun-hop-brewery','bold-brewing','cervejaria-antuerpia','overhop-brewing-co','cervejaria-odin','5-elementos','dr-otto','fiftyfifty-brewing','jackie-os-pub-brewery','dark-horse-brewing','central-waters-brewing','prairie-artisan-ales') 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,2968,5686,3627,3830,3917,3829,3661,3835,4014,6012,3562,3877,3983,3876,6049,3935,6418,4147,6839,5574,6443,7271,9008,7677,7226,14148,13850,10321)) 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,46,47,48,49,56,61,66,69,70,71,72,77,84,85,87,89,105,107,112,113,115,117,120,124,125,141,145,154,155,157,160,167,169,171,172,185,189,190,192,193,194,229,231,235,239,240,246,248,283,290,293,306,308,309,316,319,320,321,322,323,324,325,328,347,353,373,378,380,390,398,399,400,401,414,420,427,433,437,440,441,448,456,467,468,469,473,488,489,490,491,492,499,500,509,512,514,530,531,537,540,549,552,558,561,579,581,601,611,612,613,614,619,630,651,679,680,684,713,728,729,737,771,773,783,815,839,859,866,869,892,896,897,916,930,931,964,966,987,991,1032,1075,1096,1111,1117,1131,1276,1286,1292,1297,1298,1335,1338,1342,1349,1350,1367,1376,1474,1527,1585,1628,1629,1634,1640,1643,1664,1683,1733,1756,1759,1772,1792,1808,1839,1840,1929,1945,2005,2021,2032,2049,2058,2070,2086,2097,2100,2148,2155,2170,2187,2223,2231,2232,2257,2349,2370,2521,2528,2548,2549,2550,2565,2566,2568,2575,2587,2589,2626,2647,2720,2722,2750,2768,2888,2962,2975,2976,3049,3062,3076,3087,3127,3158,3159,3196,3199,3218,3242,3276,3284,3288,3296,3299,3324,3354,3399,3447,3448,3524,3542,3624,3670,3688,3969,4018,4026,4128,4241,4259,4285,4330,4451,4510,4594,4612,4700,4718,4768,4779,4791,4930,5046,5123,5131,5183,5228,5235,5247,5320,5331,5359,5390,5434,5512,5545,5587,5595,5604,5634,5638,5681,5698,5818,5890,5995,6056,6182,6188,6260,6333,6475,6479,6526,6615,6694,6711,6730,6744,6747,6761,6778,6847,6893,6927,6985,7017,7038,7117,7178,7221,7222,7223,7228,7294,7459,7460,7465,7466,7468,7469,7476,7501,7503,7526,7531,7560,7579,7589,7615,7765,7772,7803,7818,7856,7861,7990,8072,8074,8089,8136,8142,8331,8363,8412,8539,8543,8544,8562,8603,8658,8710,8898,8942,8944,8945,9233,9287,9295,9301,9310,9387,9449,9516,9594,9601,9610,9672,9679,9762,9805,9928,9929,9930,9972,10091,10131,10181,10259,10315,10322,10381,10399,10405,10518,10606,10608,10609,10621,10623,10662,10703,10874,11171,11318,11358,11483,11497,11538,11602,11678,11694,11877,12086,12112,12128,12284,12434,12450,12503,12504,12725,12824,12834,12981,12994,13002,13003,13008,13009,13012,13024,13081,13168,13169,13285,13352,13386,13561,13589,13595,13908,13927,13942,14375,14376,14466,14545,14548,14551,14560,14600,14605,14633,14656,14916,14952,15186,15210,15218,15320,15365,15484,15490,15491,15492,15504,15592) 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,46,47,48,49,56,61,66,69,70,71,72,77,84,85,87,89,105,107,112,113,115,117,120,124,125,141,145,154,155,157,160,167,169,171,172,185,189,190,192,193,194,229,231,235,239,240,246,248,283,290,293,306,308,309,316,319,320,321,322,323,324,325,328,347,353,373,378,380,390,398,399,400,401,414,420,427,433,437,440,441,448,456,467,468,469,473,488,489,490,491,492,499,500,509,512,514,530,531,537,540,549,552,558,561,579,581,601,611,612,613,614,619,630,651,679,680,684,713,728,729,737,771,773,783,815,839,859,866,869,892,896,897,916,930,931,964,966,987,991,1032,1075,1096,1111,1117,1131,1276,1286,1292,1297,1298,1335,1338,1342,1349,1350,1367,1376,1474,1527,1585,1628,1629,1634,1640,1643,1664,1683,1733,1756,1759,1772,1792,1808,1839,1840,1929,1945,2005,2021,2032,2049,2058,2070,2086,2097,2100,2148,2155,2170,2187,2223,2231,2232,2257,2349,2370,2521,2528,2548,2549,2550,2565,2566,2568,2575,2587,2589,2626,2647,2720,2722,2750,2768,2888,2962,2975,2976,3049,3062,3076,3087,3127,3158,3159,3196,3199,3218,3242,3276,3284,3288,3296,3299,3324,3354,3399,3447,3448,3524,3542,3624,3670,3688,3969,4018,4026,4128,4241,4259,4285,4330,4451,4510,4594,4612,4700,4718,4768,4779,4791,4930,5046,5123,5131,5183,5228,5235,5247,5320,5331,5359,5390,5434,5512,5545,5587,5595,5604,5634,5638,5681,5698,5818,5890,5995,6056,6182,6188,6260,6333,6475,6479,6526,6615,6694,6711,6730,6744,6747,6761,6778,6847,6893,6927,6985,7017,7038,7117,7178,7221,7222,7223,7228,7294,7459,7460,7465,7466,7468,7469,7476,7501,7503,7526,7531,7560,7579,7589,7615,7765,7772,7803,7818,7856,7861,7990,8072,8074,8089,8136,8142,8331,8363,8412,8539,8543,8544,8562,8603,8658,8710,8898,8942,8944,8945,9233,9287,9295,9301,9310,9387,9449,9516,9594,9601,9610,9672,9679,9762,9805,9928,9929,9930,9972,10091,10131,10181,10259,10315,10322,10381,10399,10405,10518,10606,10608,10609,10621,10623,10662,10703,10874,11171,11318,11358,11483,11497,11538,11602,11678,11694,11877,12086,12112,12128,12284,12434,12450,12503,12504,12725,12824,12834,12981,12994,13002,13003,13008,13009,13012,13024,13081,13168,13169,13285,13352,13386,13561,13589,13595,13908,13927,13942,14375,14376,14466,14545,14548,14551,14560,14600,14605,14633,14656,14916,14952,15186,15210,15218,15320,15365,15484,15490,15491,15492,15504,15592) 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,62,695,41667,875,14386,5410,4752,4454,523,6050,171,2437,2565,4379,8203,5881,2307,9469,10085,8525,367,1338,10554,6469,5156,1512,12658,9117,15204,12953,7985,16173,17687,15010,20560,14634,6874,20546,4953,19475,12954,18696,15008,21584,20435,22139,85,484,2887,9280,8358,11738,24358,14999,1378,28727,3569,2080,20825,20239,19622,11690,29093,26121,3185,15718,16197,37723,35871,19817,15357,15739,37527,26779) )
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,85,171,367,484,523,695,875,1338,1378,1512,2080,2307,2437,2565,2887,3185,3569,4379,4454,4752,4953,5156,5410,5881,6050,6469,6874,7985,8203,8358,8525,9117,9280,9469,10085,10554,11690,11738,12658,12953,12954,14386,14634,14999,15008,15010,15204,15357,15718,15739,16173,16197,17687,18696,19475,19622,19817,20239,20435,20546,20560,20825,21584,22139,24358,26121,26779,28727,29093,35871,37527,37723,41667) 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 (7068,9322,14169,7302,17361,8148,11091,12212,8084,11810) 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 (14169,11091,12212,11810) 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 (30051,34510,11738,30754,46397,33153,39626,41343,23214,40870) )
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 (11738,23214,30051,30754,33153,34510,39626,40870,41343,46397) 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 )