alanedwardes

SELECT posts.post_title, posts.ID post_id, media.ID media_id
FROM $wpdb->posts media
JOIN $wpdb->posts posts
ON posts.post_content LIKE CONCAT('%', media.guid, '%')
WHERE media.post_type = 'attachment'
AND posts.post_type = 'post'
AND posts.post_status = 'publish'
GROUP BY posts.ID
ORDER BY media.post_date DESC
LIMIT 0, 9

alanedwardes

<?php
/*
Plugin Name: WordPress Mint Intergration
Description: Adds mint to the site's header (if the user isn't logged in), adds a "Statistics" menu option with Mint in an iframe.
Author: Alan Edwardes
Author URI: http://alan.edward.es/
Version: 1.0
*/

function add_mint_javascript(){

alanedwardes

// By Alan Edwardes - http://alanedwardes.com/contact
// Licensed under The GNU General Public License (GPL)
// -------------------------------------------------------------
// A simple events wrapper function for adding events that works
// cross browser, and allows you to use the first parameter of
// the callback function as a reference to the object that the 
// event was fired from, which replaces IE's lack of support
// for the "this" variable.
//
// Ex. Usage: