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 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 (6273,6352,6304,6348,17501,6284,7483,6311,6460,6309)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,121,119) AND value IN ( 'nacionais','recomendacao','importadas','tem-e-nao-tem-no-brasil','mais','tem-no-brasil','concurso','melhores','nao-tem-no-brasil','nacionais-e-importadas','guia-de-estilo') 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 (115,164,168,170,238,283,325,441,579,737,1275,2449,3242,6321,7594,8603,8942,9287,10322,11279,11520,12103,13927,822,872,2855,5992,783,2271,1851,1314,4711,2869,5226,1584,6303,6302,6301,6300,6297,6299,6298,6296,49,55,56,69,70,71,72,192,193,194,322,323,324,448,537,538,539,540,541,736,1216,1245,2143,2322,2738,3014,3276,3941,3993,4710,5080,5864,5946,6156,6305,9036,88,2294,3196,2689,2506,1904,2622,1069,2257,2550,3886,1551,3492,2001,2148,1574,910,2189,2097,2606,713,1840,2468,2065,1617,6448,6447,2194,4361,1015,1043,6349,2413,3342,6350,3996,1107,6124,684,2626,2548,2549,2442,3536,137,138,139,140,552,229,1488,1480,866,377,1481,2743,1482,413,100,105,107,112,117,120,122,124,125,466,472,473,43,728,651,530,531,532,2204,3622,966,343,293,1111,6185,2793,6138,86,85,2378,2306,2376,692,157,208,268,341,696,950,1195,1731,2056,2328,2523,3229,3648,3789,4169,4352,4609,4941,5075,6153,6664,10180,10431,52,274,275,321,476,477,676,714,723,729,850,920,1085,1118,1152,1175,1230,1374,1415,1503,1508,1583,1685,1686,1699,1858,1895,1907,1908,1967,1980,2061,2073,2074,2075,2077,2099,2113,2117,2195,2274,2313,2365,2432,2520,2521,2568,2607,2608,2628,2633,2682,2714,2715,2814,2817,2833,2924,2925,3006,3009,3156,3157,3200,3257,3265,3266,3322,3470,3495,3571,3689,4049,4183,4219,4249,4356,4387,4442,4476,4591,4593,4647,4648,4657,4730,4733,4819,4874,4901,5022,5101,5149,5155,5156,5236,5239,5244,5246,5351,5541,5546,5892,5971,6031,6154,6438,6467,6482,6632,6807,6813,6930,7033,7121,7393,7410,7443,7787,5754,165,166,218,232,236,287,319,368,369,398,442,506,507,575,585,638,649,760,761,1019,1041,1044,1075,1348,1353,1465,1585,1710,1716,1735,1947,2370,2827,5151,6940,8331,8425,11328,11387,11623,13491,13492,13762,17287,423)) 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,49,52,55,56,69,70,71,72,85,86,88,100,105,107,112,115,117,120,122,124,125,137,138,139,140,157,164,165,166,168,170,192,193,194,208,218,229,232,236,238,268,274,275,283,287,293,319,321,322,323,324,325,341,343,368,369,377,398,413,423,441,442,448,466,472,473,476,477,506,507,530,531,532,537,538,539,540,541,552,575,579,585,638,649,651,676,684,692,696,713,714,723,728,729,736,737,760,761,783,822,850,866,872,910,920,950,966,1015,1019,1041,1043,1044,1069,1075,1085,1107,1111,1118,1152,1175,1195,1216,1230,1245,1275,1314,1348,1353,1374,1415,1465,1480,1481,1482,1488,1503,1508,1551,1574,1583,1584,1585,1617,1685,1686,1699,1710,1716,1731,1735,1840,1851,1858,1895,1904,1907,1908,1947,1967,1980,2001,2056,2061,2065,2073,2074,2075,2077,2097,2099,2113,2117,2143,2148,2189,2194,2195,2204,2257,2271,2274,2294,2306,2313,2322,2328,2365,2370,2376,2378,2413,2432,2442,2449,2468,2506,2520,2521,2523,2548,2549,2550,2568,2606,2607,2608,2622,2626,2628,2633,2682,2689,2714,2715,2738,2743,2793,2814,2817,2827,2833,2855,2869,2924,2925,3006,3009,3014,3156,3157,3196,3200,3229,3242,3257,3265,3266,3276,3322,3342,3470,3492,3495,3536,3571,3622,3648,3689,3789,3886,3941,3993,3996,4049,4169,4183,4219,4249,4352,4356,4361,4387,4442,4476,4591,4593,4609,4647,4648,4657,4710,4711,4730,4733,4819,4874,4901,4941,5022,5075,5080,5101,5149,5151,5155,5156,5226,5236,5239,5244,5246,5351,5541,5546,5754,5864,5892,5946,5971,5992,6031,6124,6138,6153,6154,6156,6185,6296,6297,6298,6299,6300,6301,6302,6303,6305,6321,6349,6350,6438,6447,6448,6467,6482,6632,6664,6807,6813,6930,6940,7033,7121,7393,7410,7443,7594,7787,8331,8425,8603,8942,9036,9287,10180,10322,10431,11279,11328,11387,11520,11623,12103,13491,13492,13762,13927,17287)
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','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','3-fonteinen','lambic-gueuze','tulipa','flauta','trappistenabdij-de-achelse-kluis','belgian-strong-golden-ale','8-12','dubbel','belgian-strong-dark-ale','belgian-specialty-ale','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','warsteiner-brauerei','bierwein','german-pilsner','1-4','pilsner','Caneca','dunkel','caldereta','cervejaria-wals','bohemian-pilsener','cervejaria-sudbrack','Schincariol','amber-lager','taca','schwarzbier','kolsch','cilindrico','belgian-pale-ale','pint','premium-american-lager','chope','rauchbier','american-amber-ale','natal','german-weizen','weizen','weizenbock','Cervejaria Backer','specialty-beer','esb','standard-american-lager','cervejaria-colorado','cervejaria-premium','cervejaria-heineken','heineken','inbev','abbaye-notre-dame-de-saint-remy','Lefebvre','Belco','Bitburger Brauerei Th Simon','bitburger','Petrópolis','Buller','Cantillon','comemorativa','lambic-fruit','cervejaria-sankt-gallen','Stella Artois','sierra-nevada-brewing-company','american-pale-ale','Chimay','Boston Beer Company','porter','walmart','vienna','Primo Schincariol','casa-di-conti','DaDo Bier','Devassa','Cuauhtémoc Moctezuma','FEMSA','brasserie-d-orval','erdinger-weissbrau','Damm','brazilways','hijos-de-rivera','Fantôme','saison','best-beers-importadora','Germânia','abbaye-de-leffe','belgian-blond-ale','de-koningshoeven','birra-moretti','sem-alcool','traditional-bock','brok','cervejaria-krill','Konig','Stuttgart','Hanssens Artisanaal','Wernesgruner','Fuller´s','boxer','Brauerei Schloss Eggenberg','doppelbock','outros','coruja','kirin-brewery','japanese-rice-lager','HackerPschorr','keller','outono','baden-baden','AnheuserBusch','blue-moon','molsoncoors','brasart','f-boon','lite-american-lager','hair-of-the-dog','Antares','Rasen','eurobrau','nectar-ales','shv','saidera','bierland','widmer-brothers','bier-company','cerveceria-valdivia-sa','North-Coast','russian-imperial-stout','inab','pyramid','fruit-beer','girardin','cervejaria-malta','brooklyn','dama-bier','american-brown-ale','kona-brewing','brouwerij-van-steenberge','flanders-brown-ale','conhaque','bells-brewery','inverno','goose-island','wood-aged','yuengling','three-floyds','imperial-double-ipa','helles-bock','frevo-brasil','inbeb','greenpoint','zanni','stone-brewing-co','primavera','coors','de-ranke','cervejaria-mauritzstad','professor-fritz-briem','berliner','deschutes-brewery','wells-youngs','classic-american-pilsner','barleywine','russian-river','ipa','verao','jolly-pumpkin','pumpkin-ale','founders-brewing','american-wild-ale','cervejaria-bierbaum','cervejaria-way','bernard','tarantino','bourganel','melograno','cbbp','lagunitas','amazon-beer','surly','irish-red-ale','sauber-beer','american-wheat-rye','the-bruery','seasons-craft-brewery','lambic-straight','biere-de-champagne-biere-brut','mont-des-cats','foreign-extra-stout','loverbeer','kraemerfass','Miller Brewing Company','sabmiller','granville-island-brewing','flanders-red-ale','brew-miga','old-ale','birra-del-borgo','random-drei-adler','big-rock-brewery','alesmith-brewing','stift-engelszell-trappistenbier-brauerei','klosterbrauerei-weissenohe','american-stout','brewerkz','almanac-beer','howe-sound-inn-brewing-company','brauerei-nemo-namenlos','the-upland-brewing','strongscotale','bogota-beer','blond-ale','dry-stout','sierra-madre','le-baladin','colaborativa','5-seasons-brewing','black-ipa','pabst-brewing','hors-concours','brassagem-unica','montegioco','pivovar-svijany','christmas-winter','cerveja-sem-gluten','malt-liquor','dundee-brewing','trappistenbrouwerij-de-kievit','spencer-brewery','redhook-brewery','dark-horse-brewing','anual-safrada','penedon-brew-pub','brouwerij-van-honsebrouck','trinity-brewing-company','sweet-stout','abbazia-delle-tre-fontane','paraphernalia-craft-ales','cervejaria-tupiniquim','american-ipa','naocadastrada','cervejaria-rio-negro','Imperial Premium Bier','femsa','bluebev','kilsen','malzbier','bicuda-cerveja-artesanal') 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,3827,5686,3877,3830,3876,14055,3702,3917,3717,3828,3764,3793,3638,6418,16666)) 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,49,52,55,56,69,70,71,72,85,86,88,100,105,107,112,115,117,120,122,124,125,137,138,139,140,157,164,165,166,168,170,192,193,194,208,218,229,232,236,238,268,274,275,283,287,293,319,321,322,323,324,325,341,343,368,369,377,398,413,423,441,442,448,466,472,473,476,477,506,507,530,531,532,537,538,539,540,541,552,575,579,585,638,649,651,676,684,692,696,713,714,723,728,729,736,737,760,761,783,822,850,866,872,910,920,950,966,1015,1019,1041,1043,1044,1069,1075,1085,1107,1111,1118,1152,1175,1195,1216,1230,1245,1275,1314,1348,1353,1374,1415,1465,1480,1481,1482,1488,1503,1508,1551,1574,1583,1584,1585,1617,1685,1686,1699,1710,1716,1731,1735,1840,1851,1858,1895,1904,1907,1908,1947,1967,1980,2001,2056,2061,2065,2073,2074,2075,2077,2097,2099,2113,2117,2143,2148,2189,2194,2195,2204,2257,2271,2274,2294,2306,2313,2322,2328,2365,2370,2376,2378,2413,2432,2442,2449,2468,2506,2520,2521,2523,2548,2549,2550,2568,2606,2607,2608,2622,2626,2628,2633,2682,2689,2714,2715,2738,2743,2793,2814,2817,2827,2833,2855,2869,2924,2925,3006,3009,3014,3156,3157,3196,3200,3229,3242,3257,3265,3266,3276,3322,3342,3470,3492,3495,3536,3571,3622,3648,3689,3789,3886,3941,3993,3996,4049,4169,4183,4219,4249,4352,4356,4361,4387,4442,4476,4591,4593,4609,4647,4648,4657,4710,4711,4730,4733,4819,4874,4901,4941,5022,5075,5080,5101,5149,5151,5155,5156,5226,5236,5239,5244,5246,5351,5541,5546,5754,5864,5892,5946,5971,5992,6031,6124,6138,6153,6154,6156,6185,6296,6297,6298,6299,6300,6301,6302,6303,6305,6321,6349,6350,6438,6447,6448,6467,6482,6632,6664,6807,6813,6930,6940,7033,7121,7393,7410,7443,7594,7787,8331,8425,8603,8942,9036,9287,10180,10322,10431,11279,11328,11387,11520,11623,12103,13491,13492,13762,13927,17287) 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,49,52,55,56,69,70,71,72,85,86,88,100,105,107,112,115,117,120,122,124,125,137,138,139,140,157,164,165,166,168,170,192,193,194,208,218,229,232,236,238,268,274,275,283,287,293,319,321,322,323,324,325,341,343,368,369,377,398,413,423,441,442,448,466,472,473,476,477,506,507,530,531,532,537,538,539,540,541,552,575,579,585,649,651,676,684,692,696,713,714,723,728,729,736,737,760,761,783,822,850,866,872,910,920,950,966,1015,1019,1041,1043,1044,1069,1075,1085,1107,1111,1118,1152,1175,1195,1216,1230,1245,1275,1314,1348,1353,1374,1415,1465,1480,1481,1482,1488,1503,1508,1551,1574,1583,1584,1585,1617,1685,1686,1699,1710,1716,1731,1735,1840,1851,1858,1895,1904,1907,1908,1947,1967,1980,2001,2056,2061,2065,2073,2074,2075,2077,2097,2099,2113,2117,2143,2148,2189,2194,2195,2204,2257,2271,2274,2294,2306,2313,2322,2328,2365,2370,2376,2378,2413,2432,2442,2449,2468,2506,2520,2521,2523,2548,2549,2550,2568,2606,2607,2608,2622,2626,2628,2633,2682,2689,2714,2715,2738,2743,2793,2814,2817,2827,2833,2855,2869,2924,2925,3006,3009,3014,3156,3157,3196,3200,3229,3242,3257,3265,3266,3276,3322,3342,3470,3492,3495,3536,3571,3622,3648,3689,3789,3886,3941,3993,3996,4049,4169,4183,4219,4249,4352,4356,4361,4387,4442,4476,4591,4593,4609,4647,4648,4657,4710,4711,4730,4733,4819,4874,4901,4941,5022,5075,5080,5101,5149,5151,5155,5156,5226,5236,5239,5244,5246,5351,5541,5546,5754,5864,5892,5946,5971,5992,6031,6124,6138,6153,6154,6156,6185,6296,6297,6298,6299,6300,6301,6302,6303,6305,6321,6349,6350,6438,6447,6448,6467,6482,6632,6664,6807,6813,6930,6940,7033,7121,7393,7410,7443,7594,7787,8331,8425,8603,8942,9036,9287,10180,10322,10431,11279,11328,11387,11520,11623,12103,13491,13492,13762,13927,17287) 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,14386,62,34472,41667,875,367,5410,523,1378,5267,6469,5659,2080,2565,695,7110,2437,8203,4379,1369,4752,1338,9779,7985,5156,4454,8315,9469,4386,10554,12658,12954,16082,15204,6983,15216,4953,13168,16197,484,171,16173,967,8450,19701,21875,17374,19622,24358,9280,11738,6874,30409,20825,26121,3185,15739,15357,14999,14085,35035,42863,37527,46397) )
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,367,484,523,695,875,967,1338,1369,1378,2080,2437,2565,3185,4379,4386,4454,4752,4953,5156,5267,5410,5659,6469,6874,6983,7110,7985,8203,8315,8450,9280,9469,9779,10554,11738,12658,12954,13168,14085,14386,14999,15204,15216,15357,15739,16082,16173,16197,17374,19622,19701,20825,21875,24358,26121,30409,34472,35035,37527,41667,42863,46397) 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 (6273,6352,6304,6348,17501,6284,7483,6311,6460,6309) 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 (6273,6352,6304,6348,6284,6311,6460,6309) 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 (63,46397,30341,11738) )
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,30341,46397) 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 )