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 60, 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 (6291,12505,6310,7438,8249,6315,6509,7489,7205,6686)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'importadas','tem-e-nao-tem-no-brasil','guia-de-estilo','nacionais','tem-no-brasil','concurso','nacionais-e-importadas','lista-pessoal','adega-pessoal','melhores') 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 (68,2686,216,552,872,783,2271,1851,373,942,1330,485,2597,1976,3201,579,2857,728,870,3959,601,4711,2869,5226,414,1114,2119,314,293,2109,3985,2147,5983,3100,5602,4326,4988,4521,4621,2658,2668,3944,3071,1772,1629,1628,468,4618,1929,3924,696,2622,729,4966,5184,4585,2661,4985,4943,3387,3770,5165,3009,2082,2380,3630,4362,4565,88,2081,5015,4594,4197,5500,2409,2589,2963,4431,2657,4591,5487,3299,4789,4991,2617,3886,2568,4249,1966,4510,4996,2566,2096,5938,6438,3138,4999,2058,4432,4053,4740,5799,4961,274,290,4533,4509,4442,4969,1574,859,1052,1840,2277,2636,2814,3107,3451,3891,4054,4345,4397,4482,4512,5637,5638,6465,6466,6600,6692,7150,7682,7683,7684,7686,8176,8357,8358,1231,401,1808,420,44,490,189,6608,84,124,130,154,265,413,498,530,531,549,771,1106,1349,1663,1956,2279,2286,2567,3044,4701,5136,5247,5741,7022,5158,145,48,241,246,157,767,1407,6772,6980,2793,61,1342,1480,140,169,235,453,473,1112,1965,3514,5359,6530,7454,49,1135,2148,69,194,2097,190,777,512,2070,1625)) 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 (44,48,49,61,68,69,84,88,124,130,140,145,154,157,169,189,190,194,216,235,241,246,265,274,290,293,314,373,401,413,414,420,453,468,473,485,490,498,512,530,531,549,552,579,601,696,728,729,767,771,777,783,859,870,872,942,1052,1106,1112,1114,1135,1231,1330,1342,1349,1407,1480,1574,1625,1628,1629,1663,1772,1808,1840,1851,1929,1956,1965,1966,1976,2058,2070,2081,2082,2096,2097,2109,2119,2147,2148,2271,2277,2279,2286,2380,2409,2566,2567,2568,2589,2597,2617,2622,2636,2657,2658,2661,2668,2686,2793,2814,2857,2869,2963,3009,3044,3071,3100,3107,3138,3201,3299,3387,3451,3514,3630,3770,3886,3891,3924,3944,3959,3985,4053,4054,4197,4249,4326,4345,4362,4397,4431,4432,4442,4482,4509,4510,4512,4521,4533,4565,4585,4591,4594,4618,4621,4701,4711,4740,4789,4943,4961,4966,4969,4985,4988,4991,4996,4999,5015,5136,5158,5165,5184,5226,5247,5359,5487,5500,5602,5637,5638,5741,5799,5938,5983,6438,6465,6466,6530,6600,6608,6692,6772,6980,7150,7454,7682,7683,7684,7686,8176,8357,8358)
21. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 8,22,24,6,13,12,28,19) AND value IN ( 'SpatenFranziskanerBräu','dubinbev','AmBev','german-weizen','sim','nao','5-7','weizen','baden-baden','Schincariol','barleywine','tulipa','conhaque','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','cervejaria-heineken','heineken','sweet-stout','8-12','taca','caldereta','heineken-nederland','lite-american-lager','1-4','chope','pilsner','belgian-strong-dark-ale','bayerische-staatsbrauerei-weihenstephan','ontrade','cervejaria-wals','bohemian-pilsener','Caneca','cervejaria-sudbrack','unibroue','sapporo','bierwein','tripel','Cervejaria Backer','cream-ale','cervejaria-colorado','ipa','inbev','standard-american-lager','Bosteels','nono','Brouwerij Van Steenberge','abbaye-notre-dame-de-saint-remy','beck-co','premium-american-lager','Petrópolis','dubbel','budweiser-budvar-ceske-budejovice','uniland','Cantillon','lambic-gueuze','comemorativa','flauta','Struise','russian-imperial-stout','Stella Artois','helles','Modelo','modelo','anunciada','Huyghe','belgian-strong-golden-ale','Cuauhtémoc Moctezuma','FEMSA','desnoes-and-geddes','Diageo','ibeer','brouwerij-moortgat','duvel-moortgart','oettinger-bier-gruppe','erdinger-weissbrau','hijos-de-rivera','Foster´s','Fuller´s','boxer','old-ale','pint','Coopers','foreign-extra-stout','Het Anker','abbaye-de-leffe','belgian-blond-ale','Murphy´s','dry-stout','birra-moretti','Miller Brewing Company','sabmiller','specialty-beer','kirin-brewery','japanese-rice-lager','HackerPschorr','keller','paulaner-brauerei-munchen','kristallweizen','thomashardy','outros','AnheuserBusch','labatt','DAB','dortmunder-export','great-divide','baltika','carlsberg','porter','inverno','Boston Beer Company','harviestoun','brazilways','wood-aged','Du Bocq','witbier','tumbler','flensburger','wells-youngs','fischer-dalsace','cervejaria-sankt-gallen','brooklyn','vienna','goose-island','Cervejaria Bamberg','brewdog','tarantino','imperial-double-ipa','eschweger-klosterbrauerei','bodebrown','dieu-du-ciel','best-beers-importadora','stone-brewing-co','primavera','coors','molsoncoors','founders-brewing','steam-whistle','lost-abbey','great-lakes','Dogfish','oatmeal-stout','outono','bear-republic','american-amber-ale','jw-lees','russian-river','stoudts','boon-rawd','cervejaria-caseira','bierland','rogue','avery-brewing','american-stout','De Dolle','belgian-specialty-ale','natal','innis-gunn','gordon-biersch','seasons-craft-brewery','Traquair','melograno','strongscotale','firestone-walker','ballast-point','invicta','traditional-bock','sierra-nevada-brewing-company','imperial-strong-porter','North-Coast','molson','flanders-red-ale','mistura-classica','fiftyfifty-brewing','casa-flora','oskar-blues-brewing-company','american-pale-ale','cigar-city','irish-red-ale','benediktiner-weissbrau','schornstein','cervejaria-nacional','alesmith-brewing','cervejaria-bierbaum','amber-lager','alaskan-brewing-company','rauchbier','deschutes-brewery','cervejaria-kud','esb','high-water-brewing','speakeasy-ales-lagers','cascade-brewery','american-wild-ale','hill-farmstead-brewery','the-upland-brewing','evil-twin-brewing','2cabecas','black-ipa','gaudenbier','german-pilsner','the-bruery','three-floyds','cervejaria-jupiter','colaborativa','dum-cervejaria','cervejaria-dortmund','american-brown-ale','thornbridge','english-brown-ale','central-city-brewing','native-brewery','st-james-gate','cervejaria-noi','pabst-brewing','fruit-beer','Germânia','brassagem-unica','cervejaria-goyaz','verao','flanders-brown-ale','shv','Ayinger','interfood','cervejaria-tupiniquim','Burgman','shipyard','heretic-brewing','saison','boulevard-brewing') 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,5686,2970,4014,3717,3638,3763,3854,3661,3762,4360,3983,3937,5014,3562,3876,6012,3668)) 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 (44,48,49,61,68,69,84,88,124,130,140,145,154,157,169,189,190,194,216,235,241,246,265,274,290,293,314,373,401,413,414,420,453,468,473,485,490,498,512,530,531,549,552,579,601,696,728,729,767,771,777,783,859,870,872,942,1052,1106,1112,1114,1135,1231,1330,1342,1349,1407,1480,1574,1625,1628,1629,1663,1772,1808,1840,1851,1929,1956,1965,1966,1976,2058,2070,2081,2082,2096,2097,2109,2119,2147,2148,2271,2277,2279,2286,2380,2409,2566,2567,2568,2589,2597,2617,2622,2636,2657,2658,2661,2668,2686,2793,2814,2857,2869,2963,3009,3044,3071,3100,3107,3138,3201,3299,3387,3451,3514,3630,3770,3886,3891,3924,3944,3959,3985,4053,4054,4197,4249,4326,4345,4362,4397,4431,4432,4442,4482,4509,4510,4512,4521,4533,4565,4585,4591,4594,4618,4621,4701,4711,4740,4789,4943,4961,4966,4969,4985,4988,4991,4996,4999,5015,5136,5158,5165,5184,5226,5247,5359,5487,5500,5602,5637,5638,5741,5799,5938,5983,6438,6465,6466,6530,6600,6608,6692,6772,6980,7150,7454,7682,7683,7684,7686,8176,8357,8358) 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 (44,48,49,61,68,69,84,88,124,130,140,145,154,157,169,189,190,194,216,235,241,246,265,274,290,293,314,373,401,413,414,420,453,468,473,485,490,498,512,530,531,549,552,579,601,696,728,729,767,771,777,783,859,870,872,942,1052,1106,1112,1114,1135,1231,1330,1342,1349,1407,1480,1574,1625,1628,1629,1663,1772,1808,1840,1851,1929,1956,1965,1966,1976,2058,2070,2081,2082,2096,2097,2109,2119,2147,2148,2271,2277,2279,2286,2380,2409,2566,2567,2568,2589,2597,2617,2622,2636,2657,2658,2661,2668,2686,2793,2814,2857,2869,2963,3009,3044,3071,3100,3107,3138,3201,3299,3387,3451,3514,3630,3770,3886,3891,3924,3944,3959,3985,4053,4054,4197,4249,4326,4345,4362,4397,4431,4432,4442,4482,4509,4510,4512,4521,4533,4565,4585,4591,4594,4618,4621,4701,4711,4740,4789,4943,4961,4966,4969,4985,4988,4991,4996,4999,5015,5136,5158,5165,5184,5226,5247,5359,5487,5500,5602,5637,5638,5741,5799,5938,5983,6438,6465,6466,6530,6600,6608,6692,6772,6980,7150,7454,7682,7683,7684,7686,8176,8357,8358) AND published = 1 AND approved = 1 AND access IN (1,4) AND main_media = 1
25. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (63,71,72,62,14386,875,367,4478,5115,5410,1378,6561,6459,695,2437,8203,4592,2565,1338,10025,4386,3552,9779,6469,10547,6276,12749,13367,8678,171,12954,12658,5829,9117,15204,2887,1512,6983,13506,2080,484,5156,17264,14634,4379,16197,10598,18471,16512,20546,19475,18256,22043,15008,523,8450,16173,6874,11738,14999,29093) )
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,367,484,523,695,875,1338,1378,1512,2080,2437,2565,2887,3552,4379,4386,4478,4592,5115,5156,5410,5829,6276,6459,6469,6561,6874,6983,8203,8450,8678,9117,9779,10025,10547,10598,11738,12658,12749,12954,13367,13506,14386,14634,14999,15008,15204,16173,16197,16512,17264,18256,18471,19475,20546,22043,29093) 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 (6291,12505,6310,7438,8249,6315,6509,7489,7205,6686) 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 (6291,6310,7438,8249,6509,7205) 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,41814,31121,33433,16814,4379,30652,28585) )
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,4379,16814,28585,30652,31121,33433,41814) 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 )