Short Stories

Pornography I’ve Seen

catsort = catName
MySQL server version: 5.0.51a-24-log
CATEGORY QUERY: 
 SELECT wp_tobysterm_taxonomy.count as 'count',
    wp_tobysterms.term_id, wp_tobysterms.name, wp_tobysterms.slug,
    wp_tobysterm_taxonomy.parent, wp_tobysterm_taxonomy.description FROM
    wp_tobysterms, wp_tobysterm_taxonomy WHERE wp_tobysterms.term_id =
    wp_tobysterm_taxonomy.term_id  AND
    wp_tobysterm_taxonomy.taxonomy = 'link_category' AND wp_tobysterms.slug IN ('pornography')
    ORDER BY wp_tobysterms.name ASC

CATEGORY QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [count] => 5
            [term_id] => 18
            [name] => Pornography I've Seen
            [slug] => pornography
            [parent] => 0
            [description] => 
        )

)
LINK QUERY:
 SELECT * FROM wp_tobyslinks l
      inner join wp_tobysterm_relationships tr on l.link_id = tr.object_id
      inner join wp_tobysterm_taxonomy tt on 
      tt.term_taxonomy_id = tr.term_taxonomy_id 
      inner join wp_tobysterms t on t.term_id = tt.term_id 
      WHERE tt.taxonomy='link_category' AND l.link_visible='Y' 
      ORDER BY l.link_rating ASC

LINK QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [link_id] => 37
            [link_url] => http://tobyscales.com/content/1526
            [link_name] => Downtown Theatre
            [link_image] => 
            [link_target] => 
            [link_description] => Downtown Theatre
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 37
            [term_taxonomy_id] => 58
            [term_order] => 0
            [term_id] => 53
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => ProductionLinks
            [slug] => productionlinks
            [term_group] => 0
        )

    [1] => stdClass Object
        (
            [link_id] => 22
            [link_url] => http://tobyscales.com/images/ArtistStatement.jpg
            [link_name] => Artist's Statement
            [link_image] => 
            [link_target] => _blank
            [link_description] => My Official "Statement"
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 22
            [term_taxonomy_id] => 47
            [term_order] => 0
            [term_id] => 42
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => AboutMeLinks
            [slug] => aboutmelinks
            [term_group] => 0
        )

    [2] => stdClass Object
        (
            [link_id] => 24
            [link_url] => http://www.bluecatscreenplay.com/winner/2010_finals.php
            [link_name] => "Joe" - Quarter-Finalist (BlueCat)
            [link_image] => 
            [link_target] => _blank
            [link_description] => BlueCat Screenwriting Competition 2010
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 24
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Screenplays
            [slug] => screenplays
            [term_group] => 0
        )

    [3] => stdClass Object
        (
            [link_id] => 24
            [link_url] => http://www.bluecatscreenplay.com/winner/2010_finals.php
            [link_name] => "Joe" - Quarter-Finalist (BlueCat)
            [link_image] => 
            [link_target] => _blank
            [link_description] => BlueCat Screenwriting Competition 2010
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 24
            [term_taxonomy_id] => 57
            [term_order] => 0
            [term_id] => 52
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 6
            [name] => AwardsLinks
            [slug] => awardslinks
            [term_group] => 0
        )

    [4] => stdClass Object
        (
            [link_id] => 25
            [link_url] => http://tobyscales.com/content/1383
            [link_name] => The Television Play
            [link_image] => 
            [link_target] => _blank
            [link_description] => Produced at 13th Repertory Theatre, 2010
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 25
            [term_taxonomy_id] => 58
            [term_order] => 0
            [term_id] => 53
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => ProductionLinks
            [slug] => productionlinks
            [term_group] => 0
        )

    [5] => stdClass Object
        (
            [link_id] => 26
            [link_url] => http://www.smashwords.com/books/view/12030
            [link_name] => Pornography I've Seen
            [link_image] => 
            [link_target] => _blank
            [link_description] => Kindle and eBook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 26
            [term_taxonomy_id] => 4
            [term_order] => 0
            [term_id] => 4
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Short Stories
            [slug] => shortstories
            [term_group] => 0
        )

    [6] => stdClass Object
        (
            [link_id] => 26
            [link_url] => http://www.smashwords.com/books/view/12030
            [link_name] => Pornography I've Seen
            [link_image] => 
            [link_target] => _blank
            [link_description] => Kindle and eBook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 26
            [term_taxonomy_id] => 22
            [term_order] => 0
            [term_id] => 17
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Short Story Collections
            [slug] => shortstorycollections
            [term_group] => 0
        )

    [7] => stdClass Object
        (
            [link_id] => 26
            [link_url] => http://www.smashwords.com/books/view/12030
            [link_name] => Pornography I've Seen
            [link_image] => 
            [link_target] => _blank
            [link_description] => Kindle and eBook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 26
            [term_taxonomy_id] => 59
            [term_order] => 0
            [term_id] => 54
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => PublicationLinks
            [slug] => publicationlinks
            [term_group] => 0
        )

    [8] => stdClass Object
        (
            [link_id] => 27
            [link_url] => http://search.barnesandnoble.com/Pornography-Ive-Seen/Toby-Scales/e/2940000840436/?itm=1
            [link_name] => Pornography I've Seen - Nook
            [link_image] => 
            [link_target] => _blank
            [link_description] => Barnes & Noble's Nook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 27
            [term_taxonomy_id] => 4
            [term_order] => 0
            [term_id] => 4
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Short Stories
            [slug] => shortstories
            [term_group] => 0
        )

    [9] => stdClass Object
        (
            [link_id] => 27
            [link_url] => http://search.barnesandnoble.com/Pornography-Ive-Seen/Toby-Scales/e/2940000840436/?itm=1
            [link_name] => Pornography I've Seen - Nook
            [link_image] => 
            [link_target] => _blank
            [link_description] => Barnes & Noble's Nook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 27
            [term_taxonomy_id] => 22
            [term_order] => 0
            [term_id] => 17
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Short Story Collections
            [slug] => shortstorycollections
            [term_group] => 0
        )

    [10] => stdClass Object
        (
            [link_id] => 27
            [link_url] => http://search.barnesandnoble.com/Pornography-Ive-Seen/Toby-Scales/e/2940000840436/?itm=1
            [link_name] => Pornography I've Seen - Nook
            [link_image] => 
            [link_target] => _blank
            [link_description] => Barnes & Noble's Nook Download
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 27
            [term_taxonomy_id] => 59
            [term_order] => 0
            [term_id] => 54
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => PublicationLinks
            [slug] => publicationlinks
            [term_group] => 0
        )

    [11] => stdClass Object
        (
            [link_id] => 29
            [link_url] => http://scriptapalooza.com/Winners.html
            [link_name] => "Joe" - Quarter-Finalist (Scriptapalooza)
            [link_image] => 
            [link_target] => _blank
            [link_description] => Quarter-Finalist in 2010 Scriptapalooza Competition
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 29
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Screenplays
            [slug] => screenplays
            [term_group] => 0
        )

    [12] => stdClass Object
        (
            [link_id] => 29
            [link_url] => http://scriptapalooza.com/Winners.html
            [link_name] => "Joe" - Quarter-Finalist (Scriptapalooza)
            [link_image] => 
            [link_target] => _blank
            [link_description] => Quarter-Finalist in 2010 Scriptapalooza Competition
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 29
            [term_taxonomy_id] => 57
            [term_order] => 0
            [term_id] => 52
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 6
            [name] => AwardsLinks
            [slug] => awardslinks
            [term_group] => 0
        )

    [13] => stdClass Object
        (
            [link_id] => 30
            [link_url] => http://www.linkedin.com/pub/toby-scales/22/122/305
            [link_name] => LinkedIn Profile
            [link_image] => 
            [link_target] => _blank
            [link_description] => My Public Profile on LinkedIn
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 30
            [term_taxonomy_id] => 47
            [term_order] => 0
            [term_id] => 42
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => AboutMeLinks
            [slug] => aboutmelinks
            [term_group] => 0
        )

    [14] => stdClass Object
        (
            [link_id] => 32
            [link_url] => http://tobyscales.com/content/1460
            [link_name] => The Penis Play
            [link_image] => 
            [link_target] => 
            [link_description] => The Penis Play - Produced 7/2010 in NYC
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 32
            [term_taxonomy_id] => 6
            [term_order] => 0
            [term_id] => 6
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Stage Plays
            [slug] => stageplays
            [term_group] => 0
        )

    [15] => stdClass Object
        (
            [link_id] => 32
            [link_url] => http://tobyscales.com/content/1460
            [link_name] => The Penis Play
            [link_image] => 
            [link_target] => 
            [link_description] => The Penis Play - Produced 7/2010 in NYC
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 32
            [term_taxonomy_id] => 58
            [term_order] => 0
            [term_id] => 53
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => ProductionLinks
            [slug] => productionlinks
            [term_group] => 0
        )

    [16] => stdClass Object
        (
            [link_id] => 38
            [link_url] => http://storypros.com/4thISCContestResults.html
            [link_name] => "Joe" - Semi-Finalist (StoryPros)
            [link_image] => 
            [link_target] => _blank
            [link_description] => StoryPros Screenwriting Competition 2010
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 38
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Screenplays
            [slug] => screenplays
            [term_group] => 0
        )

    [17] => stdClass Object
        (
            [link_id] => 38
            [link_url] => http://storypros.com/4thISCContestResults.html
            [link_name] => "Joe" - Semi-Finalist (StoryPros)
            [link_image] => 
            [link_target] => _blank
            [link_description] => StoryPros Screenwriting Competition 2010
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 38
            [term_taxonomy_id] => 57
            [term_order] => 0
            [term_id] => 52
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 6
            [name] => AwardsLinks
            [slug] => awardslinks
            [term_group] => 0
        )

    [18] => stdClass Object
        (
            [link_id] => 39
            [link_url] => http://www.sanguinenyc.com
            [link_name] => "fugue" - Finalist, Project Playwright
            [link_image] => 
            [link_target] => _blank
            [link_description] => Sanguine Productions: Project Playwright
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 39
            [term_taxonomy_id] => 6
            [term_order] => 0
            [term_id] => 6
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Stage Plays
            [slug] => stageplays
            [term_group] => 0
        )

    [19] => stdClass Object
        (
            [link_id] => 39
            [link_url] => http://www.sanguinenyc.com
            [link_name] => "fugue" - Finalist, Project Playwright
            [link_image] => 
            [link_target] => _blank
            [link_description] => Sanguine Productions: Project Playwright
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 39
            [term_taxonomy_id] => 57
            [term_order] => 0
            [term_id] => 52
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 6
            [name] => AwardsLinks
            [slug] => awardslinks
            [term_group] => 0
        )

    [20] => stdClass Object
        (
            [link_id] => 21
            [link_url] => http://tobyscales.com/content/321
            [link_name] => She was a redhead, all right
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 1
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 21
            [term_taxonomy_id] => 23
            [term_order] => 0
            [term_id] => 18
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Pornography I've Seen
            [slug] => pornography
            [term_group] => 0
        )

    [21] => stdClass Object
        (
            [link_id] => 20
            [link_url] => http://tobyscales.com/content/310
            [link_name] => You.doc
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 2
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 20
            [term_taxonomy_id] => 23
            [term_order] => 0
            [term_id] => 18
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Pornography I've Seen
            [slug] => pornography
            [term_group] => 0
        )

    [22] => stdClass Object
        (
            [link_id] => 19
            [link_url] => http://tobyscales.com/content/312
            [link_name] => Fucking Mrs. Linneman
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 3
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 19
            [term_taxonomy_id] => 23
            [term_order] => 0
            [term_id] => 18
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Pornography I've Seen
            [slug] => pornography
            [term_group] => 0
        )

    [23] => stdClass Object
        (
            [link_id] => 36
            [link_url] => http://tobyscales.com/content/1513
            [link_name] => Dream of a Dental Sales Representative for the North American Territory
            [link_image] => 
            [link_target] => 
            [link_description] => Dream of a Dental Sales Representative for the North American Territory
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 4
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 36
            [term_taxonomy_id] => 23
            [term_order] => 0
            [term_id] => 18
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Pornography I've Seen
            [slug] => pornography
            [term_group] => 0
        )

    [24] => stdClass Object
        (
            [link_id] => 28
            [link_url] => http://tobyscales.com/content/1423
            [link_name] => Short Carl and the Golden Box
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 5
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 28
            [term_taxonomy_id] => 23
            [term_order] => 0
            [term_id] => 18
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 5
            [name] => Pornography I've Seen
            [slug] => pornography
            [term_group] => 0
        )

)

collapsLink options:

• [—]Pornography I've Seen
  • She was a redhead, all right
  • You.doc
  • Fucking Mrs. Linneman
  • Dream of a Dental Sales Representative for the North American Territory
  • Short Carl and the Golden Box