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 110, 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 (8578,11619,7323,8561,8353,10823,10530,6944,10812,8687)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'nacionais-e-importadas','tem-e-nao-tem-no-brasil','adega-pessoal','lista-pessoal','tem-no-brasil','degustacao','importadas','desejadas','nacionais','guia-de-estilo','melhores','recomendacao') 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 (46,47,105,124,293,579,723,783,1109,1640,2167,6075,1932,1890,2257,2293,2294,3944,3961,347,1088,5791,4984,1155,8002,8174,473,145,737,645,169,170,172,65,682,457,413,680,679,437,440,729,1111,6185,283,2793,1407,616,420,612,1934,80,2056,3818,353,43,614,3514,231,441,4506,3536,4235,4308,728,2965,213,57,60,59,58,238,320,1585,319,5320,7022,442,218,507,1368,398,399,2370,100,107,117,142,326,328,401,453,468,500,1223,1286,1422,2506,2647,3199,5390,5893,6530,6772,6980,7045,7221,7222,7223,7454,8086,44,1482,4023,6966,403,2324,49,2715,384,1858,714,275,3509,7592,7713,7559,448,3014,2205,69,3657,8502,1231,2192,7526,3873,3498,3266,8445,7576,421,7773,8355,5289,2159,5575,3689,2628,2399,2988,5308,3519,5307,4889,1051,869,6557,7974,184,343,710,711,771,1271,1297,1367,2964,3104,3495,5999,6043,6259,8607,4461,1474,66,794,87,89,112,115,125,130,137,139,140,154,157,160,205,214,316,486,487,499,552,561,578,601,717,767,806,847,938,1032,1055,1275,1792,2046,2074,2101,2449,2526,2548,2580,2626,2635,2652,3196,3418,3508,3658,3939,4564,4718,4816,5000,5006,5101,5144,5177,5340,5531,5853,6056,6684,6788,7247,7521,7567,7581,7582,7808,7972,8083,8170,8171,8387,8389,8390,8448,8552,8599,8863,8945,9584,9758,9805,9806,9807,9930,9976,10012,10083,10143,10193,3995,5818,10150,9783,10641,8944,8943,7161,6158,9221,536,534,532,325,3242,10447,2207,1195,5261,5932,7031,5908,9929,9928,5641,1020,1848,6138,1835,1054,632,144,8532,1284,1144,5356,48,51,84,120,122,141,155,156,189,248,322,381,530,531,549,681,684,860,892,1488,1628,1629,2057,2149,2183,2184,2240,2378,2442,2575,3060,3173,3630,3656,4748,5252,5925,6085,6278,6761,6972,7508,8619,8874,10244,10301,10486,10672,11521,12508,9095,11285,8128,4714,246,323)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
18. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
19. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 2,18,20)
20. SELECT Listing.contentid AS element_id,jr_cervejaria,jr_detalhesdacervejaria,jr_grupo,jr_importadora,jr_estilo,jr_alcool,jr_ibu,jr_srm,jr_ingredientes,jr_semglutem,jr_ativa,jr_sazonal,jr_temperatura,jr_copo,jr_site,jr_referencias FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (43,44,46,47,48,49,51,57,58,59,60,65,66,69,80,84,87,89,100,105,107,112,115,117,120,122,124,125,130,137,139,140,141,142,144,145,154,155,156,157,160,169,170,172,184,189,205,213,214,218,231,238,246,248,275,283,293,316,319,320,322,323,325,326,328,343,347,353,381,384,398,399,401,403,413,420,421,437,440,441,442,448,453,457,468,473,486,487,499,500,507,530,531,532,534,536,549,552,561,578,579,601,612,614,616,632,645,679,680,681,682,684,710,711,714,717,723,728,729,737,767,771,783,794,806,847,860,869,892,938,1020,1032,1051,1054,1055,1088,1109,1111,1144,1155,1195,1223,1231,1271,1275,1284,1286,1297,1367,1368,1407,1422,1474,1482,1488,1585,1628,1629,1640,1792,1835,1848,1858,1890,1932,1934,2046,2056,2057,2074,2101,2149,2159,2167,2183,2184,2192,2205,2207,2240,2257,2293,2294,2324,2370,2378,2399,2442,2449,2506,2526,2548,2575,2580,2626,2628,2635,2647,2652,2715,2793,2964,2965,2988,3014,3060,3104,3173,3196,3199,3242,3266,3418,3495,3498,3508,3509,3514,3519,3536,3630,3656,3657,3658,3689,3818,3873,3939,3944,3961,3995,4023,4235,4308,4461,4506,4564,4714,4718,4748,4816,4889,4984,5000,5006,5101,5144,5177,5252,5261,5289,5307,5308,5320,5340,5356,5390,5531,5575,5641,5791,5818,5853,5893,5908,5925,5932,5999,6043,6056,6075,6085,6138,6158,6185,6259,6278,6530,6557,6684,6761,6772,6788,6966,6972,6980,7031,7045,7161,7221,7222,7223,7247,7454,7508,7521,7526,7559,7567,7576,7581,7582,7592,7713,7773,7808,7972,7974,8002,8083,8086,8128,8170,8171,8174,8355,8387,8389,8390,8445,8448,8502,8532,8552,8599,8607,8619,8863,8874,8943,8944,8945,9095,9221,9584,9758,9783,9805,9806,9807,9928,9929,9930,9976,10012,10083,10143,10150,10193,10244,10301,10447,10486,10641,10672,11285,11521,12508)
21. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,22,24,6,13,12,28,19) AND value IN ( 'brouwerij-hoegaarden','dubinbev','AmBev','witbier','sim','nao','5-7','tumbler','SpatenFranziskanerBräu','german-weizen','weizen','fnc-sa','standard-american-lager','1-4','chope','caldereta','quinsa','baden-baden','Schincariol','barleywine','tulipa','conhaque','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','budejovicky-mestansky-pivovar','bierwein','bohemian-pilsener','pilsner','Caneca','Grolsche Bierbrouwerij Ned SABMiller','sabmiller','walmart','malt-liquor','taca','malt_liquor','premium-american-lager','inbev','cervejaria-heineken','heineken','belgian-strong-dark-ale','wells-youngs','ontrade','esb','8-12','pint','bayerische-staatsbrauerei-weihenstephan','cervejaria-wals','tripel','dubbel','cervejaria-sudbrack','amber-lager','schwarzbier','kolsch','cilindrico','belgian-pale-ale','rauchbier','belgian-strong-golden-ale','american-amber-ale','natal','weizenbock','unibroue','sapporo','Cervejaria Backer','specialty-beer','special-bitter','traditional-bock','flauta','cream-ale','cervejaria-colorado','ipa','porter','foreign-extra-stout','malzbier','Brouwerij Van Steenberge','Bosteels','nono','Krug','bavaria-brouwerij','Belco','Petrópolis','dark-american-lager','sweet-stout','st-james-gate','Diageo','dry-stout','Cantillon','lambic-fruit','cervejaria-sankt-gallen','Stella Artois','Cuauhtémoc Moctezuma','Chimay','Casa da Cerveja','BindingBrauerei','Oetker','Weissbierbrauerei G Schneider Sohn','Stuttgart','Boston Beer Company','vienna','Carlsberg','carlsberg','DaDo Bier','Dubuisson','belgian-blond-ale','Devassa','american-pale-ale','Huyghe','belgian-specialty-ale','FEMSA','brouwerij-moortgat','duvel-moortgart','paulaner-brauerei-munchen','casa-flora','doppelbock','helles','brasserie-d-orval','oettinger-bier-gruppe','uniland','Primo Schincariol','erdinger-weissbrau','hijos-de-rivera','dunkelweizen','kristallweizen','brouwerij-achouffe','abbaye-de-leffe','shv','Murphy´s','birra-moretti','hofbrauhaus-munchen','oktoberfest-marzen','oktober','Miller Brewing Company','Gebrüder Maisel Bayreuth','beer-legends','san-miguel','Licher','bitburger','les-brasseurs-de-gayant','beers-on-the-table','choppfritz','coruja','kirin-brewery','japanese-rice-lager','HackerPschorr','keller','AnheuserBusch','Damm','brazilways','fruh','brooklyn','goose-island','reloco','sem-alcool','schornstein','russian-imperial-stout','Falke Bier','opa-bier','dunkel','gaudenbier','cerveceria-valdivia-sa','bierland','Du Bocq','tucher-brau-furth','anunciada','casa-di-conti','inverno','faxe','royalunibrew','Hofbräu Kaltenhausen','heineken-nederland','dama-bier','american-brown-ale','comemorativa','brewdog','tarantino','imperial-double-ipa','saint-bier-cervejaria','classic-american-pilsner','fruit-beer','Modelo','lite-american-lager','lambic-gueuze','cervejaria-bierbaum','weltenburg','outros','North-Coast','wood-aged','strauss-bier','de-leyerth-brouwerijen','saison','wychwood','cbbp','cervejaria-way','Brouwerij-de-Molen','amazon-beer','irish-red-ale','american-wheat-rye','Anchor Brewing Company','lambic-straight','blond-ale','Fantôme','de-koningshoeven','standard-bitter','Lefebvre','Ayinger','f-boon','old-ale','Halve Maan','taberna-do-vale','brouwerij-t-ij','benediktiner-weissbrau','AlkenMaes','english-brown-ale','Zehn-Bier','budweiser-budvar-ceske-budejovice','founders-brewing','Shepherd-Neame','strangeways','invicta','colaborativa','cervejaria-caseira','kona-brewing','robinsons','american-ipa','cervejaria-capa-preta','cervejaria-insana','nogne','evil-twin-brewing','imperial-strong-porter','verao','bulmers-ireland','catarina-produtos-premium','specialty-cider-and-perry','cervejaria-tupiniquim','session-ipa','Burgman','interfood','cervejaria-jupiter','Cervejaria Ashby','brassagem-unica','cervejaria-dortmund','belgian-ipa','mikkeller','american-wild-ale','pumpkin-ale','outono','german-pilsner','sierra-nevada-brewing-company','north-peak-brewing','cervejaria-loba','three-floyds','huisbrouwerij-de-halve-maan','anual-safrada','aegean','quinta-do-malte','american-stout','camale-brewery','prussia-bier','oatmeal-stout','berliner','Vinil','la-grand','Bavik','cervejaria-sumeria','leuven','cervejaria-verace','lohn-bier','ekaut','debron') ORDER BY ordering ASC ,optionid ASC
22. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j25_content AS Listing LEFT JOIN j25_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j25_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j25_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j25_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j25_users AS User ON User.id = Listing.created_by LEFT JOIN j25_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( (Listing.id IN (3659,3629,3829,2968,3671,5686,3830,3702,3661,2972,3787,3937,3717,3877,3828,3835,3764,3793,3465,3763,5339,6049,6418,6048,3668,3627,5014,10152,6108,3765,10525,7677)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
23. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (43,44,46,47,48,49,51,57,58,59,60,65,66,69,80,84,87,89,100,105,107,112,115,117,120,122,124,125,130,137,139,140,141,142,144,145,154,155,156,157,160,169,170,172,184,189,205,213,214,218,231,238,246,248,275,283,293,316,319,320,322,323,325,326,328,343,347,353,381,384,398,399,401,403,413,420,421,437,440,441,442,448,453,457,468,473,486,487,499,500,507,530,531,532,534,536,549,552,561,578,579,601,612,614,616,632,645,679,680,681,682,684,710,711,714,717,723,728,729,737,767,771,783,794,806,847,860,869,892,938,1020,1032,1051,1054,1055,1088,1109,1111,1144,1155,1195,1223,1231,1271,1275,1284,1286,1297,1367,1368,1407,1422,1474,1482,1488,1585,1628,1629,1640,1792,1835,1848,1858,1890,1932,1934,2046,2056,2057,2074,2101,2149,2159,2167,2183,2184,2192,2205,2207,2240,2257,2293,2294,2324,2370,2378,2399,2442,2449,2506,2526,2548,2575,2580,2626,2628,2635,2647,2652,2715,2793,2964,2965,2988,3014,3060,3104,3173,3196,3199,3242,3266,3418,3495,3498,3508,3509,3514,3519,3536,3630,3656,3657,3658,3689,3818,3873,3939,3944,3961,3995,4023,4235,4308,4461,4506,4564,4714,4718,4748,4816,4889,4984,5000,5006,5101,5144,5177,5252,5261,5289,5307,5308,5320,5340,5356,5390,5531,5575,5641,5791,5818,5853,5893,5908,5925,5932,5999,6043,6056,6075,6085,6138,6158,6185,6259,6278,6530,6557,6684,6761,6772,6788,6966,6972,6980,7031,7045,7161,7221,7222,7223,7247,7454,7508,7521,7526,7559,7567,7576,7581,7582,7592,7713,7773,7808,7972,7974,8002,8083,8086,8128,8170,8171,8174,8355,8387,8389,8390,8445,8448,8502,8532,8552,8599,8607,8619,8863,8874,8943,8944,8945,9095,9221,9584,9758,9783,9805,9806,9807,9928,9929,9930,9976,10012,10083,10143,10150,10193,10244,10301,10447,10486,10641,10672,11285,11521,12508) GROUP BY listing_id
24. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM j25_jreviews_media AS media WHERE listing_id IN (43,44,46,47,48,49,51,57,58,59,60,65,66,69,80,84,87,89,100,105,107,112,115,117,120,122,124,125,130,137,139,140,141,142,144,145,154,155,156,157,160,169,170,172,184,189,205,213,214,218,231,238,246,248,275,283,293,316,319,320,322,323,325,326,328,343,347,353,381,384,398,399,401,403,413,420,421,437,440,441,442,448,453,457,468,473,486,487,499,500,507,530,531,532,534,536,549,552,561,578,579,601,612,614,616,632,645,679,680,681,682,684,710,711,714,717,723,728,729,737,767,771,783,794,806,847,860,869,892,938,1020,1032,1051,1054,1055,1088,1109,1111,1144,1155,1195,1223,1231,1271,1275,1284,1286,1297,1367,1368,1407,1422,1474,1482,1488,1585,1628,1629,1640,1792,1835,1848,1858,1890,1932,1934,2046,2056,2057,2074,2101,2149,2159,2167,2183,2184,2192,2205,2207,2240,2257,2293,2294,2324,2370,2378,2399,2442,2449,2506,2526,2548,2575,2580,2626,2628,2635,2647,2652,2715,2793,2964,2965,2988,3014,3060,3104,3173,3196,3199,3242,3266,3418,3495,3498,3508,3509,3514,3519,3536,3630,3656,3657,3658,3689,3818,3873,3939,3944,3961,3995,4023,4235,4308,4461,4506,4564,4714,4718,4748,4816,4889,4984,5000,5006,5101,5144,5177,5252,5261,5289,5307,5308,5320,5340,5356,5390,5531,5575,5641,5791,5818,5853,5893,5908,5925,5932,5999,6043,6056,6075,6085,6138,6158,6185,6259,6278,6530,6557,6684,6761,6772,6788,6966,6972,6980,7031,7045,7161,7221,7222,7223,7247,7454,7508,7521,7526,7559,7567,7576,7581,7582,7592,7713,7773,7808,7972,7974,8002,8083,8086,8128,8170,8171,8174,8355,8387,8389,8390,8445,8448,8502,8532,8552,8599,8607,8619,8863,8874,8943,8944,8945,9095,9221,9584,9758,9783,9805,9806,9807,9928,9929,9930,9976,10012,10083,10143,10150,10193,10244,10301,10447,10486,10641,10672,11285,11521,12508) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
25. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (63,71,72,73,62,41667,695,1338,523,875,369,4880,352,6050,5659,5267,2565,5410,7110,6469,326,4379,2437,4794,8203,8368,4454,10554,5156,10547,6535,6276,6874,9528,12853,8678,13481,171,9469,12658,8769,2887,15357,9346,16197,20227,15204,12954,19339,13752,21584,4953,484,8661,19622,11738,1378,24358,17687,30057,14999,12093,20825,19434,15975,33543,10060,26121,42732,19817,37878,34508) )
26. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (62,63,71,72,73,171,326,352,369,484,523,695,875,1338,1378,2437,2565,2887,4379,4454,4794,4880,4953,5156,5267,5410,5659,6050,6276,6469,6535,6874,7110,8203,8368,8661,8678,8769,9346,9469,9528,10060,10547,10554,11738,12093,12658,12853,12954,13481,13752,14999,15204,15357,15975,16197,17687,19339,19434,19622,19817,20227,20825,21584,24358,26121,30057,33543,34508,37878,41667,42732) 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 (8578,11619,7323,8561,8353,10823,10530,6944,10812,8687) 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 (8561,8353,10823,8687) 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 (16814,40626,30879,32381,33433,17520,38900,29508,39425,34442) )
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 (16814,17520,29508,30879,32381,33433,34442,38900,39425,40626) 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 )