global $wpdb;

$querystr = "
SELECT $wpdb->posts.*,
$wpdb->term_relationships.term_taxonomy_id,
$wpdb->terms.slug
FROM $wpdb->posts
JOIN $wpdb->term_relationships ON $wpdb->posts.id = $wpdb->term_relationships.object_id
JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
JOIN $wpdb->terms ON $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id
WHERE
$wpdb->posts.post_type = ‘wpsc-product’
AND
$wpdb->posts.post_title LIKE ‘%ECOBOOMER%’
AND
$wpdb->posts.post_content IS NOT NULL
AND
$wpdb->term_taxonomy.taxonomy <> ‘wpsc-variation’
ORDER BY
$wpdb->posts.post_title DESC
“;

$pageposts = $wpdb->get_results($querystr, OBJECT);

if(!$pageposts)
echo $wpdb->last_error;

?>




global $wpsc_custom_meta, $wpsc_variations;

$wpsc_custom_meta = new wpsc_custom_meta( get_the_ID() );
$wpsc_variations = new wpsc_variations( get_the_ID() );

?>

” rel=”bookmark” title=”Permanent Link to “>


Not Found

Sorry, but you are looking for something that isn’t here.