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 30, 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 (6327,7340,6450,6546,7515,7243,6282,6290,6307,7245)
15. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 116,119,121) AND value IN ( 'importadas','tem-no-brasil','comercial','nao-tem-no-brasil','adega-pessoal','degustacao','tem-e-nao-tem-no-brasil','concurso','melhores','nacionais-e-importadas','recomendacao','lista-pessoal','guia-de-estilo','mais') 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 (5960,4731,2752,419,4446,6230,2714,5351,2432,477,6050,5731,5587,4112,5488,7014,2356,6730,5848,1822,1817,7029,6893,1955,1808,5746,2060,2520,2521,676,53,3886,4263,2963,3167,6287,4509,274,714,6288,3500,2001,3138,5916,4545,4053,4740,3496,2148,1574,910,6289,6285,2096,2143,3510,2840,2276,3024,1469,2468,5821,4961,1618,2065,47,531,908,296,2046,71,2223,1664,328,2055,2941,3144,3355,3907,4778,4828,5305,7083,7117,7221,7232,7435,7508,8536,8639,9616,15504,17151,16958,829,1293,6433,6434,6435,3264,6436,6437,6438,4718,607,761,142,2279,141,159,771,125,117,145,100,4786,2743,1482,609,56,1945,322,2057,401,1230,194,192,3196,49,6051,211,402,511,525,532,13312,1051,2021,2517,4469,4739,6526,7318,9149,11259,11441,11868,11993,12128,12236,12450,12503,13285,15532,14863,14796,6406,2161,6407,6431,6399,6412,6396,6413,399,124,468,472,473,7360,43,530,85,84)) 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,47,49,53,56,71,84,85,100,117,124,125,141,142,145,159,192,194,211,274,296,322,328,399,401,402,419,468,472,473,477,511,525,530,531,532,607,609,676,714,761,771,829,908,910,1051,1230,1293,1469,1482,1574,1618,1664,1808,1817,1822,1945,1955,2001,2021,2046,2055,2057,2060,2065,2096,2143,2148,2161,2223,2276,2279,2356,2432,2468,2517,2520,2521,2714,2743,2752,2840,2941,2963,3024,3138,3144,3167,3196,3264,3355,3496,3500,3510,3886,3907,4053,4112,4263,4446,4469,4509,4545,4718,4731,4739,4740,4778,4786,4828,4961,5305,5351,5488,5587,5731,5746,5821,5848,5916,5960,6050,6051,6230,6285,6287,6288,6289,6396,6399,6406,6407,6412,6413,6431,6433,6434,6435,6436,6437,6438,6526,6730,6893,7014,7029,7083,7117,7221,7232,7318,7435,7508,8536,8639,9149,9616,11259,11441,11868,11993,12128,12236,12450,12503,13285,13312,14796,14863,15504,15532,16958,17151)
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','quinsa','standard-american-lager','1-4','chope','caldereta','westvleteren-abdij-st-sixtus','belgian-quadrupel','13-15','calice','Brasserie de l’Abbaye des Rocs','solex-brasil','belgian-strong-dark-ale','taca','trappistenabdij-de-achelse-kluis','dubbel','Brouwerij der Trappisten van Westmalle','Casa da Cerveja','tripel','8-12','bayerische-staatsbrauerei-weihenstephan','ontrade','german-weizen','weizen','warsteiner-brauerei','bierwein','german-pilsner','pilsner','Caneca','cervejaria-sudbrack','Schincariol','amber-lager','rauchbier','cilindrico','weizenbock','baden-baden','special-bitter','traditional-bock','cream-ale','tulipa','Cervejaria Bamberg','altbier','inverno','abbaye-notre-dame-de-saint-remy','Lefebvre','Cantillon','lambic-gueuze','comemorativa','flauta','Starobrno Brewery','heineken','ibeer','bohemian-pilsener','Chimay','Weissbierbrauerei G Schneider Sohn','Stuttgart','Devassa','american-pale-ale','Huyghe','belgian-strong-golden-ale','nono','Verhaeghe','best-beers-importadora','flanders-red-ale','erdinger-weissbrau','Damm','brazilways','hijos-de-rivera','premium-american-lager','Fantôme','saison','Het Anker','brouwerij-van-steenberge','abbaye-de-leffe','belgian-blond-ale','schwarzbier','Hanssens Artisanaal','lambic-fruit','Primo Schincariol','sem-alcool','nachod','Boston Beer Company','wood-aged','outros','conhaque','hair-of-the-dog','specialty-beer','pint','schornstein','russian-imperial-stout','North-Coast','de-landtsheer','tarantino','Struise','flanders-brown-ale','dama-bier','goose-island','three-floyds','barleywine','brooklyn','dieu-du-ciel','american-stout','shv','bodebrown','strongscotale','deschutes-brewery','dum-cervejaria','weltenburg','helles','el-bolson','cervejaria-colorado','imperial-double-ipa','oud-beersel-','primavera','jw-lees','de-koningshoeven','founders-brewing','brewdog','baltika','carlsberg','lost-abbey','bierland','vienna','ipa','surly','outono','foreign-extra-stout','de-dochter-van-de-korenaar','mikkeller','pivovar-broumo','ballast-point','imperial-strong-porter','fiftyfifty-brewing','rogue','american-amber-ale','cervejaria-wals','Lindemans','left-hand','porter','old-ale','cigar-city','verao','alesmith-brewing','coruja','keller','firestone-walker','cervejaria-nacional','invicta','cerveceria-mexicana','elysian-brewing','the-bruery','barco','belgian-ipa','brasserie-debly','belgian-specialty-ale','anual-safrada','black-ipa','evil-twin-brewing','Brouwerij-de-Molen','brassagem-unica','hors-concours','amager-bryghus','colaborativa','eisbock','schorschbrau','guangdong-blue-ribbon','sapporo','classic-american-pilsner','jacobsen','nail-brewing','crown-beverages','doppelbock','tazawako-beer-brewery-pub','other-smoked','sharps-brewery','maison-de-brasseur','le-trou-du-diable','aji-beer','wells-youngs','cervejaria-jupiter','inbev','picobrouwerij-alvinne-den-bierzolder-','american-ipa','3-cariocas','lohn-bier','cervejaria-tupiniquim','berggren-beer','5-elementos','cervejaria-augustinus','hocus-pocus','cervejaria-motim','botto-bier','prairie-artisan-ales','nomada-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 (3629,2970,3830,3661,3828,4014,6012,2968,3717,3659,3762,3763,5574,6077,7226,6418,11866,6839,7677)) AND Listing.catid IN (3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,56,57,58,59,60,61,65,66,67,68,69,71,75,76,77,78,79,80,81,82,83,84,85,86,87,88,92,93,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,115,116,124,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168) AND Listing.state = 1 AND Listing.access IN ( 1,4) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )
23. SELECT content_id AS listing_id, count(*) AS favored FROM j25_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (43,47,49,53,56,71,84,85,100,117,124,125,141,142,145,159,192,194,211,274,296,322,328,399,401,402,419,468,472,473,477,511,525,530,531,532,607,609,676,714,761,771,829,908,910,1051,1230,1293,1469,1482,1574,1618,1664,1808,1817,1822,1945,1955,2001,2021,2046,2055,2057,2060,2065,2096,2143,2148,2161,2223,2276,2279,2356,2432,2468,2517,2520,2521,2714,2743,2752,2840,2941,2963,3024,3138,3144,3167,3196,3264,3355,3496,3500,3510,3886,3907,4053,4112,4263,4446,4469,4509,4545,4718,4731,4739,4740,4778,4786,4828,4961,5305,5351,5488,5587,5731,5746,5821,5848,5916,5960,6050,6051,6230,6285,6287,6288,6289,6396,6399,6406,6407,6412,6413,6431,6433,6434,6435,6436,6437,6438,6526,6730,6893,7014,7029,7083,7117,7221,7232,7318,7435,7508,8536,8639,9149,9616,11259,11441,11868,11993,12128,12236,12450,12503,13285,13312,14796,14863,15504,15532,16958,17151) 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,47,49,53,56,71,84,85,100,117,124,125,141,142,145,159,192,194,211,274,296,322,328,399,401,402,419,468,472,473,477,511,525,530,531,532,607,609,676,714,761,771,829,908,910,1051,1230,1293,1469,1482,1574,1618,1664,1808,1817,1822,1945,1955,2001,2021,2046,2055,2057,2060,2065,2096,2143,2148,2161,2223,2276,2279,2356,2432,2468,2517,2520,2521,2714,2743,2752,2840,2941,2963,3024,3138,3144,3167,3196,3264,3355,3496,3500,3510,3886,3907,4053,4112,4263,4446,4469,4509,4545,4718,4731,4739,4740,4778,4786,4828,4961,5305,5351,5488,5587,5731,5746,5821,5848,5916,5960,6050,6051,6230,6285,6287,6288,6289,6396,6399,6406,6407,6412,6413,6431,6433,6434,6435,6436,6437,6438,6526,6730,6893,7014,7029,7083,7117,7221,7232,7318,7435,7508,8536,8639,9149,9616,11259,11441,11868,11993,12128,12236,12450,12503,13285,13312,14796,14863,15504,15532,16958,17151) 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,14386,62,875,5410,523,6561,2958,2437,4379,2565,4386,367,41667,12658,9117,16512,326,8769,484,19701,12954,16197,5267,11738,1378,14999,13280,27728,12093,20825,35035,1753) )
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,326,367,484,523,875,1378,1753,2437,2565,2958,4379,4386,5267,5410,6561,8769,9117,11738,12093,12658,12954,13280,14386,14999,16197,16512,19701,20825,27728,35035,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 (6327,7340,6450,6546,7515,7243,6282,6290,6307,7245) 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 (6327,7340,6450,7515,7243,6282,6290,6307,7245) 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 (11738,63,20311,12552,14386,9117) )
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,9117,11738,12552,14386,20311) 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 )