Random Furry Games

Category: RPG
 
5.0 (1)
Category: Shooter
 
3.5 (1)
Category: MMORPG
 
8.0 (1)
Category: Fighting
 
4.0 (1)
Category: Platformer
 
0.0 (0)
Category: Racing
 
0.0 (0)
Category: Platformer
 
0.0 (0)
Video Games Games

Games

196 results - showing 1 - 15
« 1 2 3 4 5 ... 14 » 
Ordering 
 
 
0.0 (0)
Written by JoJoJoshua     August 19, 2014     401   0   8   0   0   0

Game Details

System
Genre
Publisher(s)
Developer(s)
Max Players
ESRB
 
5.0 (1)
Written by JoJoJoshua     May 22, 2014     550   0   8   0   0   0

Furry Features

Species
Save the mysterious kingdom of Lemuria from the Queen of the Night, who has stolen the sun, the moon and the stars. Child of Light is a playable poem...
 
0.0 (0)
Written by weremagnus     December 30, 2013     1039   0   7   0   0   3

Game Details

System
Publisher(s)
Developer(s)
Max Players
ESRB

Furry Features

Species
 
0.0 (0)
Written by JoJoJoshua     October 08, 2013     3442   0   6   0   0   1

Game Details

System
Genre
Publisher(s)
Developer(s)
Max Players
ESRB
 
0.0 (0)
Written by JoJoJoshua     July 17, 2013     1465   0   5   0   0   1

Game Details

System
Developer(s)
Max Players
ESRB

Furry Features

 
0.0 (0)
Written by JoJoJoshua     June 16, 2013     1340   0   5   0   0   0

Game Details

Publisher(s)
Developer(s)
Max Players

Furry Features

Species
 
0.0 (0)
Written by JoJoJoshua     June 16, 2013     3190   0   7   0   0   0

Game Details

System
Publisher(s)
Developer(s)
Max Players
ESRB

Furry Features

Species
 
0.0 (0)
Written by JoJoJoshua     April 13, 2013     3344   0   6   0   0   1

Game Details

System
Genre
Publisher(s)
Max Players
ESRB

Furry Features

Species
 
0.0 (0)
Written by JoJoJoshua     April 13, 2013     1618   0   10   0   0   0

Game Details

Genre
Publisher(s)
Max Players
ESRB

Furry Features

 
4.5 (1)
Written by JoJoJoshua     April 13, 2013     1101   0   6   0   0   2
 
0.0 (0)
Written by JoJoJoshua     April 13, 2013     1673   0   6   0   0   0

Game Details

Genre
Publisher(s)
Developer(s)
Max Players
ESRB

Furry Features

Species
 
3.5 (1)
Written by JoJoJoshua     April 03, 2013     2014   0   7   0   0   0

Game Details

System
Genre
Publisher(s)
Developer(s)
Max Players
ESRB

Furry Features

Species
   
196 results - showing 1 - 15
« 1 2 3 4 5 ... 14 » 
 
Powered by JReviews

JReviews Debug Console

PHP Errors

Database Queries (21)

  1. *********CategoryModel | Non-Model Query:
    (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, IF(JreviewsCategory.page_title <> '',JreviewsCategory.page_title,ParentCategory.title) AS `Category.title_seo`, JreviewsCategory.title_override AS `Category.title_override`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, IF(ParentCategory.metadesc <> '' AND JreviewsCategory.desc_override =1,ParentCategory.metadesc,ParentCategory.description) AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config` FROM fur_categories AS ParentCategory INNER JOIN fur_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS ListingType ON ListingType.id = JreviewsCategory.criteriaid WHERE ParentCategory.id = 95 ) UNION (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, IF(JreviewsCategory.page_title <> '',JreviewsCategory.page_title,ParentCategory.title) AS `Category.title_seo`, JreviewsCategory.title_override AS `Category.title_override`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, IF(ParentCategory.metadesc <> '' AND JreviewsCategory.desc_override =1,ParentCategory.metadesc,ParentCategory.description) AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config` FROM fur_categories AS Category, fur_categories AS ParentCategory INNER JOIN fur_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS ListingType ON ListingType.id = JreviewsCategory.criteriaid WHERE Category.published = 1 AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND Category.id = 95 AND ParentCategory.parent_id > 0 ) ORDER BY `Category.lft`
  2. *********CategoryModel | Find
    SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count` FROM fur_categories AS Category LEFT JOIN fur_categories AS ParentCategory ON Category.lft <= ParentCategory.lft AND Category.rgt >= ParentCategory.rgt LEFT JOIN fur_content AS Listing ON ParentCategory.id = Listing.catid AND (Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-12-22 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-12-22" )) INNER JOIN fur_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id WHERE 1 = 1 AND ( Category.published = 1 AND ParentCategory.access IN ( 1 ) AND Category.extension = "com_content" AND (Category.id = 95 OR Category.parent_id = 95) ) GROUP BY Category.id ORDER BY Directory.desc,Category.lft
  3. *********EverywhereComContentModel | Find
    SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, 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`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, 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.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 fur_content AS Listing USE KEY (jr_created) INNER JOIN fur_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN fur_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN fur_categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt LEFT JOIN fur_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN fur_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN fur_users AS User ON User.id = Listing.created_by LEFT JOIN fur_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 ( ParentCategory.id IN (95) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-12-22 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-12-22" ) AND Category.access IN ( 1) AND Listing.access IN ( 1) ) ORDER BY Listing.created DESC LIMIT 15
  4. *********CriteriaModel | Find
    SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.search AS `Criteria.search`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM fur_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (1) )
  5. *********FieldModel | Non-Model Query:
    SELECT groupid FROM fur_jreviews_groups WHERE groupid IN (4,1,5,6) AND type = 'content'
  6. *********FieldModel | Non-Model Query:
    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`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM fur_jreviews_fields AS Field INNER JOIN fur_jreviews_groups AS `Group` ON (`Group`.groupid = Field.groupid AND `Group`.groupid IN (1,4,5) AND `Group`.type = 'content' ) WHERE Field.location = 'content' AND Field.published = 1 ORDER BY Group.ordering, Field.ordering
  7. *********FieldModel | Non-Model Query:
    SELECT Listing.contentid AS element_id,jr_system,jr_genre,jr_publisher,jr_developer,jr_players,jr_esrb,jr_releasedate,jr_furryrelevance,jr_species,jr_characters,jr_amazon FROM fur_jreviews_content AS Listing WHERE Listing.contentid IN (1294,1293,1077,910,909,841,800,799,736,735,734,733,726,725,705)
  8. *********FieldModel | Non-Model Query:
    SELECT * FROM fur_jreviews_fieldoptions WHERE fieldid IN ( '1','2','6','11') AND value IN ( 'psn','action','teen','alligator','bear','boar','cat','chicken','cow','dog','elephant','giraffe','goat','hippopotamus','horse','kangaroo','lion','ostrich','pig','sheep','tiger','wolf','zebra','cheetah','crocodile','polar-bear','hyena','deer','ram','panda','xbox360','ps3','wii','xbla','wiiware','ds','pcmac','snes','sega-genesis','commodore-64','pc','gamecube','arcade','playstation-2','nintendo-64','sega-game-gear','game-boy','playstation','mac','mobile','sega-dreamcast','nintendo-3ds','game-boy-color','game-boy-advance','nintendo-ds','ipad','flash','na','frog','Shooter','mature','steam','chrome','psp','racing','everyone','fox','rpg','dragon','bird','mmorpg','platformer','adventure','everyone10','strategy','owl','cub','falcon','gorilla','monkey','rabbit','rhinocerus','armadillo','bat','bug','chimera','demon','fish','mermaid','monster','naga','snake','centaur','mouse','toad','tortoise','turtle','badger','ps-vita','xbox-one','playstation-4','wii-u','rat','kitsune','panther','elk','donkey') ORDER BY ordering ASC ,optionid ASC
  9. *********CommunityModel | Find
    SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM fur_community_users AS Community WHERE 1 = 1 AND ( userid IN (64,3163) )
  10. *********MediaModel | Non-Model Query:
    SELECT media.media_id, media.media_type, 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 fur_jreviews_media AS media WHERE listing_id IN (1294,1293,1077,910,909,841,800,799,736,735,734,733,726,725,705) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1
  11. *********EverywhereComContentModel | findCount | Count: 196
    SELECT COUNT(*) FROM fur_content AS Listing INNER JOIN fur_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN fur_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN fur_categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt LEFT JOIN fur_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN fur_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE 1 = 1 AND ( ParentCategory.id IN (95) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-12-22 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-12-22" ) AND Category.access IN ( 1) AND Listing.access IN ( 1) )
  12. *********DirectoryModel | Find
    SELECT Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.name`, Directory.tmpl_suffix AS `Directory.tmpl_suffix`, Directory.title AS `Directory.slug` FROM fur_jreviews_directories AS Directory WHERE 1 = 1 AND ( Directory.id = 1 )
  13. *********FieldModel | Non-Model Query:
    SELECT count(DISTINCT groupid) FROM fur_jreviews_criteria WHERE groupid != ''
  14. *********FieldModel | Non-Model Query:
    SELECT criteriaid FROM fur_jreviews_categories WHERE `option` = 'com_content' AND id IN (95)
  15. *********CriteriaModel | Find
    SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.search AS `Criteria.search`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM fur_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (0) )
  16. *********CategoryModel | Find
    SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count` FROM fur_categories AS Category LEFT JOIN fur_categories AS ParentCategory ON Category.lft <= ParentCategory.lft AND Category.rgt >= ParentCategory.rgt LEFT JOIN fur_content AS Listing ON ParentCategory.id = Listing.catid AND (Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-12-22 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-12-22" )) INNER JOIN fur_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id WHERE 1 = 1 AND ( Category.published = 1 AND ParentCategory.access IN ( 1 ) AND Category.extension = "com_content" AND Category.level <= 2 ) GROUP BY Category.id ORDER BY Directory.desc,Category.lft
  17. *********EverywhereComContentModel | Find
    SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, 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`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, 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.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 fur_content AS Listing INNER JOIN fur_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN fur_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN fur_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN fur_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN fur_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN fur_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN fur_users AS User ON User.id = Listing.created_by LEFT JOIN fur_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.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-12-22 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-12-22" ) AND Category.access IN (1) AND Listing.access IN (1) ) ORDER BY RAND(1503052008) LIMIT 12
  18. *********FieldModel | Non-Model Query:
    SELECT Listing.contentid AS element_id,jr_system,jr_genre,jr_publisher,jr_developer,jr_players,jr_esrb,jr_releasedate,jr_furryrelevance,jr_species,jr_characters,jr_amazon FROM fur_jreviews_content AS Listing WHERE Listing.contentid IN (167,726,189,196,120,125,686,198,683,241,132,549)
  19. *********FieldModel | Non-Model Query:
    SELECT * FROM fur_jreviews_fieldoptions WHERE fieldid IN ( '1','2','6','11') AND value IN ( 'xbox','fighting','teen','wolf','tiger','elephant','lion','penguin','rabbit','chameleon','mole','bug','leopard','chimera','bat','snes','sega-genesis','game-boy','platformer','na','cat','pig','armadillo','psn','playstation','everyone','dragon','kangaroo','bandicoot','xbox360','ps3','wii','psp','ds','gamecube','playstation-2','mobile','game-boy-color','game-boy-advance','rpg','fox','pc','mmorpg','pcmac','dos','amiga','adventure','boar','cub','dog','hare','ferret','moose','rat','weasel','Actionadventure','falcon','cheetah','tanooki','racing','monkey','lizard','Shooter','mature') ORDER BY ordering ASC ,optionid ASC
  20. *********CommunityModel | Find
    SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM fur_community_users AS Community WHERE 1 = 1 AND ( userid IN (64) )
  21. *********MediaModel | Non-Model Query:
    SELECT media.media_id, media.media_type, 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 fur_jreviews_media AS media WHERE listing_id IN (167,726,196,120,125,686,683,241,132,549) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1