S2Framework Debug Console

Database Queries (37)

1. SET SQL_BIG_SELECTS=1
2. SHOW TABLES LIKE '%_jreviews_config'
3. SELECT value FROM j25_jreviews_config WHERE id = 'cms_secret'
4. SELECT name FROM j25_jreviews_addons WHERE state = 1 ORDER BY ordering
5. SELECT params FROM j25_community_config WHERE name = 'config'
6. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value` FROM j25_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.location = 'content' AND Field.published = 1 AND Field.search = 1 )
7. SELECT ListingType.id AS `ListingType.listing_type_id`, ListingType.title AS `ListingType.title`, ListingType.groupid AS `ListingType.group_id`, ListingType.state AS `ListingType.state`, ListingType.search AS `ListingType.search`, ListingType.config AS `ListingType.config` FROM j25_jreviews_criteria AS ListingType WHERE 1 = 1 AND ( ListingType.id in (8) )
8. 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 IN (8) ) ORDER BY CriteriaRating.ordering
9. SELECT name, type FROM j25_jreviews_fields WHERE name IN ('jr_disponibilidade')
10. 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 )
11. SELECT count(DISTINCT groupid) FROM j25_jreviews_criteria WHERE groupid != ''
12. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (19) AND type = 'content'
13. 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)
14. SELECT JreviewsCategory.id FROM j25_jreviews_categories AS JreviewsCategory LEFT JOIN j25_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.criteriaid IN (8) AND JreviewsCategory.`option`= "com_content" AND Category.published = 1 AND Category.access IN ( 1,4)
15. 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 ( (Field.jr_disponibilidade = '*tem-e-nao-tem-no-brasil*') 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 40, 10
16. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 19)
17. SELECT Listing.contentid AS element_id,jr_nacionalidade,jr_disponibilidade,jr_tipodelista,jr_cervejasdalista FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (7627,7135,8713,7391,11322,10109,9086,9066,8353,8561)
18. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'nacionais-e-importadas','tem-e-nao-tem-no-brasil','degustacao','lista-pessoal','desejadas','adega-pessoal','importadas','recomendacao','comercial','guia-de-estilo') ORDER BY ordering ASC ,optionid ASC
19. 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)
20. 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 (771,48,160,4714,1929,3354,43,185,1271,6636,801,2647,4090,489,488,696,3083,4780,2548,44,189,420,6558,2527,4942,6748,5434,5018,157,5379,4235,4988,265,2965,3442,450,79,1111,491,492,4417,6496,4107,3533,6547,5994,3624,4456,89,5762,680,679,847,468,453,1422,84,5433,7083,413,1349,69,70,103,410,477,903,1137,2058,2160,2432,2714,3025,3686,5612,5638,6207,6353,6467,6735,7213,7236,7365,2159,475,3993,155,467,469,539,540,558,2204,400,105,115,154,612,613,246,1084,552,168,316,124,61,145,331,611,86,85,944,254,550,441,2549,2626,3255,473,156,2550,549,353,2270,1940,2170,544,601,655,879,942,2343,66,461,1088,1087,698,324,471,323,241,548,7379,347,322,240,239,579,522,538,1802,2844,120,4216,402,55,2306,2506,2378,2376,2377,2297,3018,4285,401,3673,619,72,71,403,4595,4594,1363,537,541,671,615,248,2811,3705,100,107,117,142,326,328,500,1223,1286,3199,3514,5390,5893,6530,6772,6980,7045,7221,7222,7223,7454,8086,1482,4023,6966,2324,49,2715,384,1858,714,275,3509,7592,7713,7559,448,3014,2205,3657,8502,1231,2192,7526,3873,3498,3266,8445,7576,421,7773,8355,5289,5575,3689,2628,2399,2988,5308,3519,5307,47,146,231,283,325,794,843,851,1106,1269,2420,2526,2562,3062,3903,3980,4718,4729,4984,5068,5098,5144,5359,5565,5791,6064,6083,6455,6747,7508,8027,8178,229,293,300,361,530,531,532,684,1037,2191,2313,2445,2449,2643,2966,3113,3212,3609,3988,5533,5897,6185,6984,7940,8285,8470,8637,8851,8987,56,77,80,112,125,192,193,194,330,419,525,632,686,717,913,1335,1342,1628,1629,1756,1772,1776,1804,1857,1934,1945,1960,2005,2021,2149,2173,2661,2743,3276,3284,3288,3312,3399,3424,3447,3542,3822,4152,4241,4451,4521,4625,4731,4739,5080,5183,5184,5734,5817,5925,6043,6181,6208,6230,6475,6481,6560,6608,6615,6750,6987,7318,7772,7841,7954,7990,8007,8180,8241,8260,8356,8462,8697,8734,8893,9031,51,6362,720,141,6056,144,2658,6027,163,2541,8606,783)) 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) )
21. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
22. 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)
23. 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,47,48,49,51,55,56,61,66,69,70,71,72,77,79,80,84,85,86,89,100,103,105,107,112,115,117,120,124,125,141,142,144,145,146,154,155,156,157,160,163,168,185,189,192,193,194,229,231,239,240,241,246,248,254,265,275,283,293,300,316,322,323,324,325,326,328,330,331,347,353,361,384,400,401,402,403,410,413,419,420,421,441,448,450,453,461,467,468,469,471,473,475,477,488,489,491,492,500,522,525,530,531,532,537,538,539,540,541,544,548,549,550,552,558,579,601,611,612,613,615,619,632,655,671,679,680,684,686,696,698,714,717,720,771,783,794,801,843,847,851,879,903,913,942,944,1037,1084,1087,1088,1106,1111,1137,1223,1231,1269,1271,1286,1335,1342,1349,1363,1422,1482,1628,1629,1756,1772,1776,1802,1804,1857,1858,1929,1934,1940,1945,1960,2005,2021,2058,2149,2159,2160,2170,2173,2191,2192,2204,2205,2270,2297,2306,2313,2324,2343,2376,2377,2378,2399,2420,2432,2445,2449,2506,2526,2527,2541,2548,2549,2550,2562,2626,2628,2643,2647,2658,2661,2714,2715,2743,2811,2844,2965,2966,2988,3014,3018,3025,3062,3083,3113,3199,3212,3255,3266,3276,3284,3288,3312,3354,3399,3424,3442,3447,3498,3509,3514,3519,3533,3542,3609,3624,3657,3673,3686,3689,3705,3822,3873,3903,3980,3988,3993,4023,4090,4107,4152,4216,4235,4241,4285,4417,4451,4456,4521,4594,4595,4625,4714,4718,4729,4731,4739,4780,4942,4984,4988,5018,5068,5080,5098,5144,5183,5184,5289,5307,5308,5359,5379,5390,5433,5434,5533,5565,5575,5612,5638,5734,5762,5791,5817,5893,5897,5925,5994,6027,6043,6056,6064,6083,6181,6185,6207,6208,6230,6353,6362,6455,6467,6475,6481,6496,6530,6547,6560,6608,6615,6636,6735,6747,6748,6750,6772,6966,6980,6984,6987,7045,7083,7213,7221,7222,7223,7236,7318,7365,7379,7454,7508,7526,7559,7576,7592,7713,7772,7773,7841,7940,7954,7990,8007,8027,8086,8178,8180,8241,8260,8285,8355,8356,8445,8462,8470,8502,8606,8637,8697,8734,8851,8893,8987,9031)
24. 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','SpatenFranziskanerBräu','german-weizen','weizen','quinsa','standard-american-lager','1-4','chope','caldereta','baden-baden','Schincariol','barleywine','tulipa','conhaque','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','budejovicky-mestansky-pivovar','bierwein','bohemian-pilsener','pilsner','Caneca','trappistenabdij-de-achelse-kluis','belgian-strong-golden-ale','8-12','dubbel','cervejaria-heineken','heineken','sweet-stout','taca','belgian-strong-dark-ale','belgian-specialty-ale','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','bayerische-staatsbrauerei-weihenstephan','ontrade','weizenbock','greene-king','boxer','cream-ale','pint','wells-youngs','esb','warsteiner-brauerei','german-pilsner','dunkel','cervejaria-wals','cervejaria-sudbrack','amber-lager','outros','schwarzbier','kolsch','cilindrico','belgian-pale-ale','premium-american-lager','rauchbier','special-bitter','traditional-bock','specialty-beer','natal','flauta','Damm','brazilways','cervejaria-colorado','ipa','porter','foreign-extra-stout','Cervejaria Bamberg','tucher-brau-furth','Oetker','anunciada','Bosteels','nono','abbaye-notre-dame-de-saint-remy','Bitburger Brauerei Th Simon','bitburger','Petrópolis','dark-american-lager','inbev','st-james-gate','Diageo','dry-stout','brouwerij-van-honsebrouck','budweiser-budvar-ceske-budejovice','uniland','Cantillon','lambic-fruit','cervejaria-sankt-gallen','Stella Artois','Cuauhtémoc Moctezuma','Chimay','BindingBrauerei','Weissbierbrauerei G Schneider Sohn','Stuttgart','kristallweizen','compania-industrial-cerveceria-sa','ibeer','fnc-sa','Carlsberg','carlsberg','Cerpa','Dubuisson','belgian-blond-ale','Devassa','american-brown-ale','Huyghe','Palm','flanders-red-ale','FEMSA','Verhaeghe','best-beers-importadora','brouwerij-moortgat','duvel-moortgart','brasserie-d-orval','oettinger-bier-gruppe','Dunston','english-brown-ale','erdinger-weissbrau','dunkelweizen','hijos-de-rivera','Falke Bier','Fantôme','saison','Fuller´s','brouwerij-achouffe','grolsch','sabmiller','brouwerij-van-steenberge','abbaye-de-leffe','de-koningshoeven','Birra Peroni Industriale','Murphy´s','irish-red-ale','AlkenMaes','birra-moretti','hofbrauhaus-munchen','helles','Miller Brewing Company','san-miguel','Licher','Henninger Bräu','paulaner-brauerei-munchen','casa-flora','vienna','sapporo','japanese-rice-lager','oktoberfest-marzen','oktober','doppelbock','inverno','AnheuserBusch','De-Bora-Bier','fruit-beer','Dogfish','imperial-double-ipa','rogue','tarantino','helles-bock','DAB','dortmunder-export','karavelle','opa-bier','american-pale-ale','baltika','confece','bierland','Du Bocq','cerveja-sem-gluten','schornstein','fischer-dalsace','kaiserdom-privatbrauerei','Hofbräu Kaltenhausen','dama-bier','brewdog','bodebrown','standard-bitter','american-amber-ale','lambic-gueuze','founders-brewing','strongscotale','samuel-smith','oatmeal-stout','dum-cervejaria','russian-imperial-stout','wood-aged','bernard','de-leyerth-brouwerijen','casa-di-conti','john-martin','cervejaria-way','Brouwerij-de-Molen','bier-hoff','saint-bier-cervejaria','classic-american-pilsner','Brouwerij Bockor','lund','Cervejaria Backer','american-wheat-rye','klein-bier','lambic-straight','old-ale','comemorativa','ballast-point','invicta','cervejaria-premium','cervejaria-insana','faxe','royalunibrew','mikkeller','wensky-beer','Harboes-Bryggeri','Ayinger','pivovar-platan','beer-legends','f-boon','black-ipa','brauerei-riegele','Halve Maan','brouwerij-t-ij','benediktiner-weissbrau','cervejaria-ouropretana','Anchor Brewing Company','blondine-microbrewery','wychwood','stift-engelszell-trappistenbier-brauerei','Zehn-Bier','amazon-beer','2cabecas','epic-brewing','mistura-classica','beers-on-the-table','american-stout','gaudenbier','de-dochter-van-de-korenaar','barco','cervejaria-dortmund','karlsberg-brauerei','bs-maui','robinsons','Germânia','cervejaria-jupiter','joseph-holt','cervejaria-tupiniquim','nogne','belgian-ipa','anual-safrada','brassagem-unica','verao','american-ipa','sem-alcool','Compania-Cervecerias-Unidas','colaborativa','evil-twin-brewing','North-Coast','cervejaria-serra-de-tres-pontas','crew-alewerkstatt','interfood','imperial-strong-porter','schweiger','alameda-brewing','pumpkin-ale','Burgman','north-peak-brewing','north-american-breweries','de-proefbrouwerij','cervepar','american-wild-ale','outono','moocabier','three-floyds','joia-mesquita','huisbrouwerij-de-halve-maan','brotas-beer','blue-moon','molsoncoors') ORDER BY ordering ASC ,optionid ASC
25. 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,2970,5686,3830,2972,3942,3787,3717,3661,3828,4014,6012,3877,3764,4147,3835,3829,3667,3763,3827,6049,6410,3983,3854,3937,5574,5014,6443,3876,6418,3935,3668,8316)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
26. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (43,44,47,48,49,51,55,56,61,66,69,70,71,72,77,79,80,84,85,86,89,100,103,105,107,112,115,117,120,124,125,141,142,144,145,146,154,155,156,157,160,163,168,185,189,192,193,194,229,231,239,240,241,246,248,254,265,275,283,293,300,316,322,323,324,325,326,328,330,331,347,353,361,384,400,401,402,403,410,413,419,420,421,441,448,450,453,461,467,468,469,471,473,475,477,488,489,491,492,500,522,525,530,531,532,537,538,539,540,541,544,548,549,550,552,558,579,601,611,612,613,615,619,632,655,671,679,680,684,686,696,698,714,717,720,771,783,794,801,843,847,851,879,903,913,942,944,1037,1084,1087,1088,1106,1111,1137,1223,1231,1269,1271,1286,1335,1342,1349,1363,1422,1482,1628,1629,1756,1772,1776,1802,1804,1857,1858,1929,1934,1940,1945,1960,2005,2021,2058,2149,2159,2160,2170,2173,2191,2192,2204,2205,2270,2297,2306,2313,2324,2343,2376,2377,2378,2399,2420,2432,2445,2449,2506,2526,2527,2541,2548,2549,2550,2562,2626,2628,2643,2647,2658,2661,2714,2715,2743,2811,2844,2965,2966,2988,3014,3018,3025,3062,3083,3113,3199,3212,3255,3266,3276,3284,3288,3312,3354,3399,3424,3442,3447,3498,3509,3514,3519,3533,3542,3609,3624,3657,3673,3686,3689,3705,3822,3873,3903,3980,3988,3993,4023,4090,4107,4152,4216,4235,4241,4285,4417,4451,4456,4521,4594,4595,4625,4714,4718,4729,4731,4739,4780,4942,4984,4988,5018,5068,5080,5098,5144,5183,5184,5289,5307,5308,5359,5379,5390,5433,5434,5533,5565,5575,5612,5638,5734,5762,5791,5817,5893,5897,5925,5994,6027,6043,6056,6064,6083,6181,6185,6207,6208,6230,6353,6362,6455,6467,6475,6481,6496,6530,6547,6560,6608,6615,6636,6735,6747,6748,6750,6772,6966,6980,6984,6987,7045,7083,7213,7221,7222,7223,7236,7318,7365,7379,7454,7508,7526,7559,7576,7592,7713,7772,7773,7841,7940,7954,7990,8007,8027,8086,8178,8180,8241,8260,8285,8355,8356,8445,8462,8470,8502,8606,8637,8697,8734,8851,8893,8987,9031) GROUP BY listing_id
27. 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,47,48,49,51,55,56,61,66,69,70,71,72,77,79,80,84,85,86,89,100,103,105,107,112,115,117,120,124,125,141,142,144,145,146,154,155,156,157,160,163,168,185,189,192,193,194,229,231,239,240,241,246,248,254,265,275,283,293,300,316,322,323,324,325,326,328,330,331,347,353,361,384,400,401,402,403,410,413,419,420,421,441,448,450,453,461,467,468,469,471,473,475,477,488,489,491,492,500,522,525,530,531,532,537,538,539,540,541,544,548,549,550,552,558,579,601,611,612,613,615,619,632,655,671,679,680,684,686,696,698,714,717,720,771,783,794,801,843,847,851,879,903,913,942,944,1037,1084,1087,1088,1106,1111,1137,1223,1231,1269,1271,1286,1335,1342,1349,1363,1422,1482,1628,1629,1756,1772,1776,1802,1804,1857,1858,1929,1934,1940,1945,1960,2005,2021,2058,2149,2159,2160,2170,2173,2191,2192,2204,2205,2270,2297,2306,2313,2324,2343,2376,2377,2378,2399,2420,2432,2445,2449,2506,2526,2527,2541,2548,2549,2550,2562,2626,2628,2643,2647,2658,2661,2714,2715,2743,2811,2844,2965,2966,2988,3014,3018,3025,3062,3083,3113,3199,3212,3255,3266,3276,3284,3288,3312,3354,3399,3424,3442,3447,3498,3509,3514,3519,3533,3542,3609,3624,3657,3673,3686,3689,3705,3822,3873,3903,3980,3988,3993,4023,4090,4107,4152,4216,4235,4241,4285,4417,4451,4456,4521,4594,4595,4625,4714,4718,4729,4731,4739,4780,4942,4984,4988,5018,5068,5080,5098,5144,5183,5184,5289,5307,5308,5359,5379,5390,5433,5434,5533,5565,5575,5612,5638,5734,5762,5791,5817,5893,5897,5925,5994,6027,6043,6056,6064,6083,6181,6185,6207,6208,6230,6353,6362,6455,6467,6475,6481,6496,6530,6547,6560,6608,6615,6636,6735,6747,6748,6750,6772,6966,6980,6984,6987,7045,7083,7213,7221,7222,7223,7236,7318,7365,7379,7454,7508,7526,7559,7576,7592,7713,7772,7773,7841,7940,7954,7990,8007,8027,8086,8178,8180,8241,8260,8285,8355,8356,8445,8462,8470,8502,8606,8637,8697,8734,8851,8893,8987,9031) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
28. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (63,71,72,14386,62,1763,875,523,4752,352,4880,2968,6469,5659,2565,5410,41667,7110,326,6459,4379,7757,2437,8203,4592,8368,967,171,10085,4976,324,10554,9469,184,9779,10547,6535,10831,733,8525,9528,4794,9346,5156,2887,14579,12954,14043,15204,4953,12658,6874,16512,2080,14634,12562,13168,20227,20560,19339,5267,19475,8661,9280,7704,484,9268,19622,16197,8358,11738,25735,14999,17687,30057,1378,20239,13280,22043,15367,12093,20825,19434,24358,15739,19817,10060,19701,5375) )
29. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (62,63,71,72,171,184,324,326,352,484,523,733,875,967,1378,1763,2080,2437,2565,2887,2968,4379,4592,4752,4794,4880,4953,4976,5156,5267,5375,5410,5659,6459,6469,6535,6874,7110,7704,7757,8203,8358,8368,8525,8661,9268,9280,9346,9469,9528,9779,10060,10085,10547,10554,10831,11738,12093,12562,12658,12954,13168,13280,14043,14386,14579,14634,14999,15204,15367,15739,16197,16512,17687,19339,19434,19475,19622,19701,19817,20227,20239,20560,20825,22043,24358,25735,30057,41667) WHERE field.published = 1 AND field.visible >= 1
30. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (7627,7135,8713,7391,11322,10109,9086,9066,8353,8561) GROUP BY listing_id
31. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM j25_jreviews_media AS media WHERE listing_id IN (9086,9066,8353,8561) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
32. 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 (6168,30266,34482,26935,29257,28028,23214,35054,33433,32381) )
33. 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 (6168,23214,26935,28028,29257,30266,32381,33433,34482,35054) WHERE field.published = 1 AND field.visible >= 1
34. SELECT COUNT(*) FROM j25_content AS Listing LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id WHERE 1 = 1 AND ( (Field.jr_disponibilidade = '*tem-e-nao-tem-no-brasil*') 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) )
35. SELECT fieldid, type, metatitle, options, metakey, metadesc FROM j25_jreviews_fields WHERE name = 'jr_disponibilidade' AND `location` = 'content'
36. SELECT FieldOption.optionid, FieldOption.text, FieldOption.description, FieldOption.control_field, FieldOption.control_value, Field.fieldid AS control_fieldid FROM j25_jreviews_fieldoptions AS FieldOption LEFT JOIN j25_jreviews_fields AS Field ON FieldOption.control_field = Field.name WHERE FieldOption.fieldid = 119 AND FieldOption.value = 'tem-e-nao-tem-no-brasil'
37. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value` FROM j25_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.location = 'content' AND Field.published = 1 )