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 100, 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 (9069,7328,6536,10109,11292,7645,9086,9427,7310,9066)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,121,119) AND value IN ( 'nacionais-e-importadas','lista-pessoal','tem-no-brasil','adega-pessoal','nacionais','degustacao','tem-e-nao-tem-no-brasil','comercial','desejadas') 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 (701,238,163,293,579,320,169,401,489,43,46,61,105,115,120,222,246,248,265,325,402,403,413,420,436,468,469,487,491,499,510,523,530,531,532,539,552,611,619,641,696,728,920,1084,1111,1349,1407,2343,2743,2755,2793,2865,3196,3512,3985,4023,4718,4742,5235,5247,5320,5619,5897,7013,429,5760,4461,2476,3580,2313,5759,463,808,4447,4595,689,85,117,124,145,157,160,229,300,361,473,558,601,684,771,1037,1223,2170,2191,2445,2449,2526,2643,2966,3113,3212,3609,3988,5533,5791,6185,6984,7221,7222,7508,7940,8285,8470,8637,8851,8987,323,55,56,71,72,77,80,84,112,125,192,193,194,322,324,330,419,448,467,525,612,613,632,686,717,801,847,913,1335,1342,1628,1629,1756,1772,1776,1804,1857,1934,1945,1960,2005,2021,2149,2173,2647,2661,3276,3284,3288,3312,3399,3424,3447,3542,3822,4152,4241,4451,4521,4594,4625,4731,4739,5080,5183,5184,5734,5817,5925,6043,6181,6208,6230,6475,6481,6530,6560,6608,6615,6750,6987,7318,7365,7772,7841,7954,7990,8007,8180,8241,8260,8356,8462,8697,8734,8893,9031,48,51,62,111,122,141,142,154,156,240,309,466,498,526,537,538,540,607,680,796,1275,1367,1792,2057,2204,2332,2677,2740,2874,3023,3514,3622,5356,6056,6138,6248,8619,457,839,10322,316,783,319,8944)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
18. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'content'
19. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 2,18,20)
20. SELECT Listing.contentid AS element_id,jr_cervejaria,jr_detalhesdacervejaria,jr_grupo,jr_importadora,jr_estilo,jr_alcool,jr_ibu,jr_srm,jr_ingredientes,jr_semglutem,jr_ativa,jr_sazonal,jr_temperatura,jr_copo,jr_site,jr_referencias FROM j25_jreviews_content AS Listing WHERE Listing.contentid IN (43,46,48,51,55,56,61,62,71,72,77,80,84,85,105,111,112,115,117,120,122,124,125,141,142,145,154,156,157,160,163,169,192,193,194,222,229,238,240,246,248,265,293,300,309,316,319,320,322,323,324,325,330,361,401,402,403,413,419,420,429,436,448,457,463,466,467,468,469,473,487,489,491,498,499,510,523,525,526,530,531,532,537,538,539,540,552,558,579,601,607,611,612,613,619,632,641,680,684,686,689,696,701,717,728,771,783,796,801,808,839,847,913,920,1037,1084,1111,1223,1275,1335,1342,1349,1367,1407,1628,1629,1756,1772,1776,1792,1804,1857,1934,1945,1960,2005,2021,2057,2149,2170,2173,2191,2204,2313,2332,2343,2445,2449,2476,2526,2643,2647,2661,2677,2740,2743,2755,2793,2865,2874,2966,3023,3113,3196,3212,3276,3284,3288,3312,3399,3424,3447,3512,3514,3542,3580,3609,3622,3822,3985,3988,4023,4152,4241,4447,4451,4461,4521,4594,4595,4625,4718,4731,4739,4742,5080,5183,5184,5235,5247,5320,5356,5533,5619,5734,5759,5760,5791,5817,5897,5925,6043,6056,6138,6181,6185,6208,6230,6248,6475,6481,6530,6560,6608,6615,6750,6984,6987,7013,7221,7222,7318,7365,7508,7772,7841,7940,7954,7990,8007,8180,8241,8260,8285,8356,8462,8470,8619,8637,8697,8734,8851,8893,8944,8987,9031,10322)
21. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,22,24,6,13,12,28,19) AND value IN ( 'brouwerij-hoegaarden','dubinbev','AmBev','witbier','sim','nao','5-7','tumbler','fnc-sa','standard-american-lager','1-4','chope','caldereta','baden-baden','Schincariol','barleywine','tulipa','conhaque','budejovicky-mestansky-pivovar','bierwein','bohemian-pilsener','pilsner','Caneca','trappistenabdij-de-achelse-kluis','belgian-strong-golden-ale','8-12','calice','dubbel','13-15','cervejaria-heineken','heineken','sweet-stout','taca','brauerei-heller-trum','Stuttgart','rauchbier','pint','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','bayerische-staatsbrauerei-weihenstephan','ontrade','weizenbock','weizen','wells-youngs','esb','german-weizen','warsteiner-brauerei','german-pilsner','cervejaria-sudbrack','schwarzbier','belgian-pale-ale','premium-american-lager','cilindrico','american-amber-ale','natal','special-bitter','traditional-bock','cream-ale','cervejaria-colorado','ipa','porter','foreign-extra-stout','Cervejaria Bamberg','inbev','abbaye-notre-dame-de-saint-remy','belgian-strong-dark-ale','Grain dÓrge','Bitburger Brauerei Th Simon','bitburger','st-james-gate','Diageo','dry-stout','budweiser-budvar-ceske-budejovice','uniland','Stella Artois','brouwerij-van-honsebrouck','lambic-fruit','flauta','st-bernard-brouwerij','belgian-quadrupel','Cuauhtémoc Moctezuma','Chimay','Weissbierbrauerei G Schneider Sohn','kristallweizen','Cerpa','Huyghe','nono','belgian-specialty-ale','FEMSA','Verhaeghe','best-beers-importadora','flanders-red-ale','brouwerij-moortgat','duvel-moortgart','plzensky-prazdroj','sabmiller','Bosteels','yard','brasserie-d-orval','Primo Schincariol','Eggenberg','erdinger-weissbrau','dunkelweizen','hijos-de-rivera','SpatenFranziskanerBräu','Fuller´s','boxer','Coopers','brouwerij-achouffe','Het Anker','grolsch','altbier','brouwerij-van-steenberge','HackerPschorr','abbaye-de-leffe','belgian-blond-ale','de-koningshoeven','birra-moretti','hofbrauhaus-munchen','helles','Miller Brewing Company','Licher','paulaner-brauerei-munchen','casa-flora','vienna','Heineken Nederland','specialty-beer','Petrópolis','oktoberfest-marzen','oktober','kirin-brewery','japanese-rice-lager','AnheuserBusch','harviestoun','brazilways','Brauerei Schloss Eggenberg','doppelbock','rogue','tarantino','helles-bock','coruja','karavelle','opa-bier','cervejaria-sankt-gallen','dunkel','bierland','casa-di-conti','fischer-dalsace','faxe','royalunibrew','brewdog','imperial-double-ipa','bodebrown','american-brown-ale','fruit-beer','strongscotale','american-pale-ale','samuel-smith','oatmeal-stout','dum-cervejaria','russian-imperial-stout','outros','dama-bier','bernard','saint-bier-cervejaria','classic-american-pilsner','kozel','quinsa','old-ale','comemorativa','invicta','irish-red-ale','anner-bier','brooklyn','pumpkin-ale','anunciada','Harboes-Bryggeri','cervejaria-wals','inverno','black-ipa','sem-alcool','benediktiner-weissbrau','bier-hoff','amber-lager','blondine-microbrewery','Zehn-Bier','2cabecas','dark-american-lager','cervejaria-way','mistura-classica','beers-on-the-table','american-stout','de-dochter-van-de-korenaar','cervejaria-riograndense','mikkeller','malt-liquor','cervejaria-tupiniquim','Carlsberg','carlsberg','american-wheat-rye','Královský Pivovar Krušovice','Staropramen Breweries','verao','american-ipa','colaborativa','cervejaria-serra-de-tres-pontas','anual-safrada','crew-alewerkstatt','Ayinger','interfood','imperial-strong-porter','north-peak-brewing','north-american-breweries','saison','joia-mesquita','quinta-do-malte','brotas-beer','blue-moon','molsoncoors','Devassa') ORDER BY ordering ASC ,optionid ASC
22. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j25_content AS Listing LEFT JOIN j25_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j25_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j25_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j25_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j25_users AS User ON User.id = Listing.created_by LEFT JOIN j25_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( (Listing.id IN (3629,2968,2970,3702,3942,3787,5686,3717,3877,4014,6012,3828,3835,3763,3659,4147,6410,3983,3764,3854,6418,3935,8316,3830)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
23. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (43,46,48,51,55,56,61,62,71,72,77,80,84,85,105,111,112,115,117,120,122,124,125,141,142,145,154,156,157,160,163,169,192,193,194,222,229,238,240,246,248,265,293,300,309,316,319,320,322,323,324,325,330,361,401,402,403,413,419,420,429,436,448,457,463,466,467,468,469,473,487,489,491,498,499,510,523,525,526,530,531,532,537,538,539,540,552,558,579,601,607,611,612,613,619,632,641,680,684,686,689,696,701,717,728,771,783,796,801,808,839,847,913,920,1037,1084,1111,1223,1275,1335,1342,1349,1367,1407,1628,1629,1756,1772,1776,1792,1804,1857,1934,1945,1960,2005,2021,2057,2149,2170,2173,2191,2204,2313,2332,2343,2445,2449,2476,2526,2643,2647,2661,2677,2740,2743,2755,2793,2865,2874,2966,3023,3113,3196,3212,3276,3284,3288,3312,3399,3424,3447,3512,3514,3542,3580,3609,3622,3822,3985,3988,4023,4152,4241,4447,4451,4461,4521,4594,4595,4625,4718,4731,4739,4742,5080,5183,5184,5235,5247,5320,5356,5533,5619,5734,5759,5760,5791,5817,5897,5925,6043,6056,6138,6181,6185,6208,6230,6248,6475,6481,6530,6560,6608,6615,6750,6984,6987,7013,7221,7222,7318,7365,7508,7772,7841,7940,7954,7990,8007,8180,8241,8260,8285,8356,8462,8470,8619,8637,8697,8734,8851,8893,8944,8987,9031,10322) GROUP BY listing_id
24. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM j25_jreviews_media AS media WHERE listing_id IN (43,46,48,51,55,56,61,62,71,72,77,80,84,85,105,111,112,115,117,120,122,124,125,141,142,145,154,156,157,160,163,169,192,193,194,222,229,238,240,246,248,265,293,300,309,316,319,320,322,323,324,325,330,361,401,402,403,413,419,420,429,436,448,457,463,466,467,468,469,473,487,489,491,498,499,510,523,525,526,530,531,532,537,538,539,540,552,558,579,601,607,611,612,613,619,632,641,680,684,686,689,696,701,717,728,771,783,796,801,808,839,847,913,920,1037,1084,1111,1223,1275,1335,1342,1349,1367,1407,1628,1629,1756,1772,1776,1792,1804,1857,1934,1945,1960,2005,2021,2057,2149,2170,2173,2191,2204,2313,2332,2343,2445,2449,2476,2526,2643,2647,2661,2677,2740,2743,2755,2793,2865,2874,2966,3023,3113,3196,3212,3276,3284,3288,3312,3399,3424,3447,3512,3514,3542,3580,3609,3622,3822,3985,3988,4023,4152,4241,4447,4451,4461,4521,4594,4595,4625,4718,4731,4739,4742,5080,5183,5184,5235,5247,5320,5356,5533,5619,5734,5759,5760,5791,5817,5897,5925,6043,6056,6138,6181,6185,6208,6230,6248,6475,6481,6530,6560,6608,6615,6750,6984,6987,7013,7221,7222,7318,7365,7508,7772,7841,7940,7954,7990,8007,8180,8241,8260,8285,8356,8462,8470,8619,8637,8697,8734,8851,8893,8944,8987,9031,10322) 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,72,71,14386,62,41667,875,523,4752,352,5796,7110,7239,326,2565,8203,4592,6465,4876,4379,7326,9528,967,1616,324,9469,2633,10547,4083,733,12954,5156,171,8525,4308,12658,6469,15204,4953,16512,12856,13168,20560,6874,20546,16197,8661,22043,9280,16173,484,9268,2887,19622,8358,11738,14999,17687,1378,13280,12093,20825,19817,24358,19701,5375,26121) )
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,171,324,326,352,484,523,733,875,967,1378,1616,2565,2633,2887,4083,4308,4379,4592,4752,4876,4953,5156,5375,5796,6465,6469,6874,7110,7239,7326,8203,8358,8525,8661,9268,9280,9469,9528,10547,11738,12093,12658,12856,12954,13168,13280,14386,14999,15204,16173,16197,16512,17687,19622,19701,19817,20546,20560,20825,22043,24358,26121,41667) WHERE field.published = 1 AND field.visible >= 1
27. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (9069,7328,6536,10109,11292,7645,9086,9427,7310,9066) 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 (9086,9066) 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 (33199,4125,28140,28028,40046,31886,23214,33623,30825,35054) )
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 (4125,23214,28028,28140,30825,31886,33199,33623,35054,40046) 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 )