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 = 156
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 (156,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 20, 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 (10348,12354,7249,7440,9132,6280,7287,6308,7893,6317)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,121,119) AND value IN ( 'nacionais-e-importadas','desejadas','tem-e-nao-tem-no-brasil','concurso','mais','nacionais','tem-no-brasil','recomendacao','degustacao','guia-de-estilo','melhores','adega-pessoal','lista-pessoal','evento','pra-trocar','premiadas') 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 (2658,2963,5245,3500,3453,3452,2337,4534,1304,1574,2366,1052,4432,3510,4311,1135,2081,410,1152,4195,1688,777,190,49,69,6608,6043,3199,829,1293,3264,4718,607,761,142,141,2279,159,771,125,117,145,100,4786,2743,1482,609,2022,2265,2305,2397,2442,2549,3052,3520,3536,3939,4235,4241,4308,4594,5010,5247,5379,5911,6102,6198,6199,6259,6276,6334,6408,6445,6743,7182,7214,7223,7508,7580,7643,7856,7868,7987,7990,8086,8157,8169,8180,8238,8239,8276,8356,8393,8405,8468,8600,8639,8658,8704,8945,9107,9192,9323,9603,11645,11993,12128,12450,12488,12503,13169,12069,13080,2378,2899,3387,3604,3656,4034,4943,6193,7573,8103,8204,8241,8374,8511,8699,8737,9311,9634,9679,13654,76,210,530,612,885,6502,8156,13734,537,43,51,65,105,112,115,156,167,169,238,283,319,320,380,398,399,413,455,457,473,552,558,573,579,584,585,614,684,783,839,1088,1100,1342,1349,1407,1422,1470,1595,1640,1835,1848,2046,2185,2793,3255,3479,4023,4024,4297,4742,4779,5235,5242,5596,6185,6772,7022,7360,728,5320,3682,7013,1376,601,107,138,869,1839,2184,2308,2577,2622,2689,2740,3284,3904,3961,4625,4633,4646,4727,5103,5177,6021,6052,6191,6377,6557,6786,6946,6962,7035,7066,7294,7929,45,66,80,97,124,176,193,203,216,223,309,373,411,438,443,470,486,499,500,524,531,536,538,550,564,616,626,648,651,691,692,812,814,1269,1278,1643,1913,1955,2049,2203,2323,2339,2349,2548,2678,2962,3060,3252,3490,3509,3646,3954,4017,4749,5484,5931,5932,6085,6124,6472,6760,6932,6984,7031,7034,7447,7792,7976,8143,8373,8481,8524,8571,8943,8973,8974,9246,9250,9280,9301,9481,9516,9976,10007,10096,10469,11068,10531,160,11497,7975,6358,532,154,79,1032,9221,2445,3023,3822,3770,2677,4116,48)) 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,45,48,49,51,65,66,69,76,79,80,97,100,105,107,112,115,117,124,125,138,141,142,145,154,156,159,160,167,169,176,190,193,203,210,216,223,238,283,309,319,320,373,380,398,399,410,411,413,438,443,455,457,470,473,486,499,500,524,530,531,532,536,537,538,550,552,558,564,573,579,584,585,601,607,609,612,614,616,626,648,651,684,691,692,728,761,771,777,783,812,814,829,839,869,885,1032,1052,1088,1100,1135,1152,1269,1278,1293,1304,1342,1349,1376,1407,1422,1470,1482,1574,1595,1640,1643,1688,1835,1839,1848,1913,1955,2022,2046,2049,2081,2184,2185,2203,2265,2279,2305,2308,2323,2337,2339,2349,2366,2378,2397,2442,2445,2548,2549,2577,2622,2658,2677,2678,2689,2740,2743,2793,2899,2962,2963,3023,3052,3060,3199,3252,3255,3264,3284,3387,3452,3453,3479,3490,3500,3509,3510,3520,3536,3604,3646,3656,3682,3770,3822,3904,3939,3954,3961,4017,4023,4024,4034,4116,4195,4235,4241,4297,4308,4311,4432,4534,4594,4625,4633,4646,4718,4727,4742,4749,4779,4786,4943,5010,5103,5177,5235,5242,5245,5247,5320,5379,5484,5596,5911,5931,5932,6021,6043,6052,6085,6102,6124,6185,6191,6193,6198,6199,6259,6276,6334,6358,6377,6408,6445,6472,6502,6557,6608,6743,6760,6772,6786,6932,6946,6962,6984,7013,7031,7034,7035,7066,7182,7214,7223,7294,7447,7508,7573,7580,7643,7792,7856,7868,7929,7975,7976,7987,7990,8086,8103,8143,8156,8157,8169,8180,8204,8238,8239,8241,8276,8356,8373,8374,8393,8405,8468,8481,8511,8524,8571,8600,8639,8658,8699,8704,8737,8943,8945,8973,8974,9107,9192,9221,9246,9250,9280,9301,9311,9323,9481,9516,9603,9634,9679,9976,10007,10096,10469,10531,11068,11497,11645,11993,12069,12128,12450,12488,12503,13080,13169,13654,13734)
21. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,22,24,6,13,12,28,19,92) AND value IN ( 'brouwerij-hoegaarden','dubinbev','AmBev','witbier','sim','nao','5-7','tumbler','Löwenbräu Munich','helles','1-4','chope','baden-baden','Schincariol','barleywine','tulipa','conhaque','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','budejovicky-mestansky-pivovar','bierwein','bohemian-pilsener','pilsner','Caneca','inbev','standard-american-lager','caldereta','cervejaria-heineken','heineken','belgian-strong-dark-ale','brouwerij-affligem-de-smedt','belgian-blond-ale','taca','greene-king','boxer','cream-ale','8-12','pint','wells-youngs','ontrade','esb','brouwerij-moortgat','duvel-moortgart','premium-american-lager','cervejaria-sudbrack','amber-lager','schwarzbier','kolsch','cilindrico','belgian-pale-ale','rauchbier','german-weizen','weizen','weizenbock','Cervejaria Backer','special-bitter','traditional-bock','cervejaria-colorado','ipa','porter','Cervejaria Bamberg','altbier','inverno','foreign-extra-stout','Locher','Brouwerij Van Steenberge','tripel','abbaye-notre-dame-de-saint-remy','dubbel','Augustiner','Lefebvre','beck-co','berliner-kindl-schultheiss-brauerei','Oetker','german-pilsner','cervejaria-sankt-gallen','st-bernard-brouwerij','Modelo','modelo','anunciada','DaDo Bier','Devassa','american-pale-ale','Palm','flanders-red-ale','fischer-dalsace','shv','Cuauhtémoc Moctezuma','FEMSA','Central de Cervejas e Bebidas','molsoncoors','Primo Schincariol','dunkel','erdinger-weissbrau','hijos-de-rivera','SpatenFranziskanerBräu','dunkelweizen','brouwerij-achouffe','belgian-specialty-ale','st-james-gate','Diageo','abbaye-de-leffe','belgian-strong-golden-ale','de-koningshoeven','AlkenMaes','lambic-fruit','flauta','birra-moretti','hofbrauhaus-munchen','beer-paradise','sem-alcool','Miller Brewing Company','sabmiller','Gebrüder Maisel Bayreuth','beer-legends','san-miguel','carlsberg','Lindemans','Krombacher Privatbrauerei Kreuztal','Konig','bitburger','Stuttgart','vienna','HerzoglichesTegernsee','Wernesgruner','kirin-brewery','japanese-rice-lager','thomashardy','outros','AnheuserBusch','unicer','Alentejana','dry-stout','fruit-beer','nachod','ibeer','cervejaria-wals','Brouwerij Palm','great-divide','russian-imperial-stout','opa-bier','inab','harviestoun','brazilways','wood-aged','sierra-nevada-brewing-company','Damm','cerveja-sem-gluten','Poznan-Brewery','de-landtsheer','tarantino','flying-dog','imperial-strong-porter','sweet-stout','specialty-beer','Petrópolis','Hofbräu Kaltenhausen','jever','dama-bier','goose-island','united-dutch-breweries','saint-bier-cervejaria','classic-american-pilsner','stone-brewing-co','BindingBrauerei','lite-american-lager','helles-bock','dieu-du-ciel','best-beers-importadora','bodebrown','weltenburg','Weissbierbrauerei G Schneider Sohn','eisbock','bear-republic','coruja','kiuchi','bierland','mondi-beer','belgian-ipa','Brouwerij-de-Molen','Carlsberg','brouwerij-liefmans','cervejaria-way','amazon-beer','american-wheat-rye','gaudenbier','seasons-craft-brewery','ballast-point','karavelle','irish-red-ale','biere-de-champagne-biere-brut','heidelberg','sauber-beer','standard-bitter','Ayinger','doppelbock','pivovar-platan','black-ipa','mistura-classica','cigar-city','saison','borhgouti-borgouthi-bebidas','brouwerij-t-ij','verao','confraria-do-marques','arcense-bierbrouwerij','cervejaria-edelbrau','cervejaria-nacional','blondine-microbrewery','cevada-pura','dark-american-lager','lake-side-beer','cervejaria-bierbaum','Zehn-Bier','moa-brewing-company','sixpoint','lorch-importadora','2cabecas','DAB','dortmunder-export','butternuts-beer-ale','hill-farmstead-brewery','firestone-walker','beers-on-the-table','american-stout','cervejaria-providencia','comemorativa','cervejaria-urbana','cervejaria-riograndense','salitos-brewing','cervejaria-jupiter','ogre-beer','malt-liquor','american-amber-ale','cervejaria-tupiniquim','brassagem-unica','english-brown-ale','bulmers-ireland','specialty-cider-and-perry','morada-cia-etilica','blond-ale','session-ipa','microcervejaria-irmaos-ferraro','imperial-double-ipa','klein-bier','colaborativa','bastards-brewery','beer-concept','stillwater-artisanal-ales','cervejaria-heilige','cervejaria-itajahy','cervejaria-premium-paulista','fraga','Cervejaria Ashby','barco','cervejaria-maniba','cervejaria-urwald','haus-dreizehn','north-peak-brewing','north-american-breweries','cervejaria-noi','hocus-pocus','brewdog','bier-hoff','asgard-cervejaria','cervejaria-imigracao','three-monkeys-beer','strongscotale','american-ipa','perro-libre','cervejaria-noturna','cervejaria-lumberjack','tropica-brewing','mild-ale','weird-barrel-brewing-co','baldhead','american-brown-ale','tormenta','euphoria','schornstein','3-cariocas','moocabier','cervejaria-dogma','green-lab-craft-brewery','berliner','grodziskie-gose-lichtenhainer','cervejaria-beertoon','india-pale-lager','cervejaria-buzios','jeffrey-beer','cervejaria-insana','brassaria-ampolis','cervejaria-labirinto','cerveja-oceanica','passarola-brewing','cerveja-praya','naocadastrada','cervejaria-octopus','quatro-graus','cervejaria-old-school','brewlab-cervejas-experimentais') 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 (3629,3829,2968,2970,5686,3627,3830,3659,3787,3828,3835,4014,3702,3717,3764,3793,3937,3638,3942,3854,4765,3675,3762,6410,3918,3983,4607,6110,6418,3855,5187,3667,6170,6367,5720,6421,5574,3562,6839,4147,5639,4142,7185,6053,6221,6657,3661,7226,6422,6049,13092)) 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,45,48,49,51,65,66,69,76,79,80,97,100,105,107,112,115,117,124,125,138,141,142,145,154,156,159,160,167,169,176,190,193,203,210,216,223,238,283,309,319,320,373,380,398,399,410,411,413,438,443,455,457,470,473,486,499,500,524,530,531,532,536,537,538,550,552,558,564,573,579,584,585,601,607,609,612,614,616,626,648,651,684,691,692,728,761,771,777,783,812,814,829,839,869,885,1032,1052,1088,1100,1135,1152,1269,1278,1293,1304,1342,1349,1376,1407,1422,1470,1482,1574,1595,1640,1643,1688,1835,1839,1848,1913,1955,2022,2046,2049,2081,2184,2185,2203,2265,2279,2305,2308,2323,2337,2339,2349,2366,2378,2397,2442,2445,2548,2549,2577,2622,2658,2677,2678,2689,2740,2743,2793,2899,2962,2963,3023,3052,3060,3199,3252,3255,3264,3284,3387,3452,3453,3479,3490,3500,3509,3510,3520,3536,3604,3646,3656,3682,3770,3822,3904,3939,3954,3961,4017,4023,4024,4034,4116,4195,4235,4241,4297,4308,4311,4432,4534,4594,4625,4633,4646,4718,4727,4742,4749,4779,4786,4943,5010,5103,5177,5235,5242,5245,5247,5320,5379,5484,5596,5911,5931,5932,6021,6043,6052,6085,6102,6124,6185,6191,6193,6198,6199,6259,6276,6334,6358,6377,6408,6445,6472,6502,6557,6608,6743,6760,6772,6786,6932,6946,6962,6984,7013,7031,7034,7035,7066,7182,7214,7223,7294,7447,7508,7573,7580,7643,7792,7856,7868,7929,7975,7976,7987,7990,8086,8103,8143,8156,8157,8169,8180,8204,8238,8239,8241,8276,8356,8373,8374,8393,8405,8468,8481,8511,8524,8571,8600,8639,8658,8699,8704,8737,8943,8945,8973,8974,9107,9192,9221,9246,9250,9280,9301,9311,9323,9481,9516,9603,9634,9679,9976,10007,10096,10469,10531,11068,11497,11645,11993,12069,12128,12450,12488,12503,13080,13169,13654,13734) 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,45,48,49,51,65,66,69,76,79,80,97,100,105,107,112,115,117,124,125,138,141,142,145,154,156,159,160,167,169,176,190,193,203,210,216,223,238,283,309,319,320,373,380,398,399,410,411,413,438,443,455,457,470,473,486,499,500,524,530,531,532,536,537,538,550,552,558,564,573,579,584,585,601,607,609,612,614,616,626,648,651,684,691,692,728,761,771,777,783,812,814,829,839,869,885,1032,1052,1088,1100,1135,1152,1269,1278,1293,1304,1342,1349,1376,1407,1422,1470,1482,1574,1595,1640,1643,1688,1835,1839,1848,1913,1955,2022,2046,2049,2081,2184,2185,2203,2265,2279,2305,2308,2323,2337,2339,2349,2366,2378,2397,2442,2445,2548,2549,2577,2622,2658,2677,2678,2689,2740,2743,2793,2899,2962,2963,3023,3052,3060,3199,3252,3255,3264,3284,3387,3452,3453,3479,3490,3500,3509,3510,3520,3536,3604,3646,3656,3682,3770,3822,3904,3939,3954,3961,4017,4023,4024,4034,4116,4195,4235,4241,4297,4308,4311,4432,4534,4594,4625,4633,4646,4718,4727,4742,4749,4779,4786,4943,5010,5103,5177,5235,5242,5245,5247,5320,5379,5484,5596,5911,5931,5932,6021,6043,6052,6085,6102,6124,6185,6191,6193,6198,6199,6259,6276,6334,6358,6377,6408,6445,6472,6502,6557,6608,6743,6760,6772,6786,6932,6946,6962,6984,7013,7031,7034,7035,7066,7182,7214,7223,7294,7447,7508,7573,7580,7643,7792,7856,7868,7929,7975,7976,7987,7990,8086,8103,8143,8156,8157,8169,8180,8204,8238,8239,8241,8276,8356,8373,8374,8393,8405,8468,8511,8524,8571,8600,8639,8658,8699,8704,8737,8943,8945,8973,8974,9107,9192,9221,9246,9250,9280,9301,9311,9323,9481,9516,9603,9634,9679,9976,10007,10096,10469,10531,11068,11497,11645,11993,12069,12128,12450,12488,12503,13080,13169,13654,13734) 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,41667,875,1338,14386,1742,3180,6561,1378,5659,5410,7138,171,2565,4752,8203,6465,8612,4876,4379,523,1616,4454,10554,184,6469,8801,10547,367,8525,6050,12972,12749,9528,101,12853,2080,13481,5156,12954,9469,13969,5267,12658,15204,4953,13957,16082,12856,326,8769,13168,15739,6874,20546,95,5684,9268,6535,8661,19475,16173,21875,19622,19701,18202,11738,13280,16197,17687,29141,14999,7704,15367,12093,20825,14634,30341,33452,33960,15054,32885,32008,26121,14085,24358,33826,1512,19817) )
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,95,101,171,184,326,367,523,875,1338,1378,1512,1616,1742,2080,2565,3180,4379,4454,4752,4876,4953,5156,5267,5410,5659,5684,6050,6465,6469,6535,6561,6874,7138,7704,8203,8525,8612,8661,8769,8801,9268,9469,9528,10547,10554,11738,12093,12658,12749,12853,12856,12954,12972,13168,13280,13481,13957,13969,14085,14386,14634,14999,15054,15204,15367,15739,16082,16173,16197,17687,18202,19475,19622,19701,19817,20546,20825,21875,24358,26121,29141,30341,32008,32885,33452,33826,33960,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 (10348,12354,7249,7440,9132,6280,7287,6308,7893,6317) 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 (10348,7249,6280,7287,6308,7893,6317) 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 (33043,41578,11738,31104,26113,16197,63,30341) )
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,26113,30341,31104,33043,41578) WHERE field.published = 1 AND field.visible >= 1
31. SELECT COUNT(*) FROM j25_content AS Listing WHERE 1 = 1 AND ( Listing.catid IN (156,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 )