Joshua Sigar

what are you trying to sort? http://pastebin.com

You might want to clear *post2cat table as well

Okay, here it is. Efficiency NOT guaranteed.


<?php $my_posts = $wpdb->get_results( "
SELECT * FROM
$wpdb->posts p1,
$wpdb->posts p2,
$wpdb->post2cat c1,
$wpdb->post2cat c2
WHERE
p1.ID = p2.ID AND
p1.ID = c1.post_ID AND
p2.ID = c2.post_ID AND
c1.category_id = 6 AND
c2.category_id = 5
" );
?>

<?php if( $my_posts ) : foreach( $my_posts as $post ) : setup_postdata( $post ); ?>
<?php the_title(); ?>
<?php endforeach; endif; ?>

Okay, try this one

$cat_counts = $wpdb->get_results("SELECT cat_ID,
COUNT($wpdb->post2cat.post_id) AS cat_count
FROM $wpdb->categories
INNER JOIN $wpdb->post2cat ON (cat_ID = category_id)
INNER JOIN $wpdb->posts ON (ID = post_id)
WHERE post_status = 'publish'
GROUP BY category_id
HAVING cat_count > 50");

Okay, at your own risk, replace the following section of code …
$cat_counts = $wpdb->get_results("SELECT cat_ID,
COUNT($wpdb->post2cat.post_id) AS cat_count
FROM $wpdb->categories
INNER JOIN $wpdb->post2cat ON (cat_ID = category_id)
INNER JOIN $wpdb->posts ON (ID = post_id)
WHERE post_status = 'publish'
GROUP BY category_id");

..with the following…
$cat_counts = $wpdb->get_results("SELECT cat_ID,
COUNT($wpdb->post2cat.post_id) AS cat_count
FROM $wpdb->categories
INNER JOIN $wpdb->post2cat ON (cat_ID = category_id)
INNER JOIN $wpdb->posts ON (ID = post_id)
WHERE post_status = 'publish' AND cat_count > 50
GROUP BY category_id");

Depending on the server setting, a file from external site could be included and …

Will it work properly with permalink disabled?
Will it work with Default Theme?