List specific custom fields in a post that match post title

I really need a soulution. Can someone show me by example how to list all posts that have the custom field key “schematics” value =1 in single.php? I have tried many things including:

<?php get_header(); ?>
<?php $query= "
$toc = $wpdb->get_results( $query );
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE $wpdb->term_taxonomy.term_id = 24
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_key = 'meat'
ORDER BY $wpdb->postmeta.meta_value ASC
";

$toc = $wpdb->get_results( $query );
?>

at the very top of the template file then attempting to display ANYTHING AT ALL under the_content
<?php echo "$toc"; ?>

I did get the word Array to appear!

I am at my wits end. There must be a simple solution. I have tried all examples and many plugins and none return desired results. My theme is 2.5 compatible. The closest I got was using the in-series plug in which is awesome but, only works on the last two levels of my needed example output above (by design).

I just need a way to display my data kind of like like a recipe book. I am sure that has been done a million times already. I cannot use categories, that will not work with the same “schematic (or recipe)” in different categories.

Using a custom field, I can assign each related post to a single common name or number. Allowing me to list their permalinks in a table of contents format. Right?????????

Kind of like:

foreach post in current posts lowest category
if posts custom key = "this" then print its permalink
end foreach loop

No parents, children or grandchildren come into play there right? Except getting only posts from its lowest category instead of all of its categories to speed things up?

Just the lowest category of the post so all posts in higher cats do not need to be queried?

Sounds easy but, after over 100 hours (easy) of tying I am going nuts!!

This is not a money making thing. It is for me and my kids. For game cheats, schematics, model airplane plans, guitar tab and such things.

If I did not mention, I got this to work to a point:

<ul>
<?php global $post;
$myposts = get_posts('numberposts=100&offset=0&category=24');
foreach($myposts as $post) : ?>
<?php echo c2c_get_custom('schematics'); ?>
<li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li>
<?php endforeach; ?>
</ul>

but, it lists children. If I could mod that code to only list the posts that have the custom field key “schematics” value=”1″ I would be done!

current mood == Frustrated….

Sorry so long winded. I desire to make my request a clear as possible.

My family and I appreciate all input and assistance to a great degree.