Queries zusammenfassen - aber wie?

[HighPower]

Moin,

weitere Frage: Wie kann ich folgende Abfrage in in ein Query kombinieren? Momentan sind es 3 die man aber bestimmt in eine zusammenfassen kann - da ich alerdings Anfänger bin habe ich keine ahnung wie das funktionieren soll.

$sql_item_first = mysql_query("SELECT item_title, member_artist FROM " . $config['db_pref'] . "items LEFT JOIN
" . $config['db_pref'] . "members ON item_owner = member_id LEFT JOIN " . $config['db_pref'] . "categories 
ON item_category = category_id WHERE item_category = category_id AND item_active = 1 
" . $sort_order . " LIMIT 1") or ErrorDB(0, mysql_errno(), mysql_error());            
$item_first = mysql_escape_string(mysql_result($sql_item_first, 0, 'item_title'));
                        
$sql_item_last = mysql_query("SELECT item_title, member_artist FROM " . $config['db_pref'] . "items LEFT JOIN 
" . $config['db_pref'] . "members ON item_owner = member_id LEFT JOIN " . $config['db_pref'] . "categories 
ON item_category = category_id WHERE item_category = category_id AND item_active = 1 
AND item_id = " . $item_select . " " . $sort_order . " LIMIT 1") or ErrorDB(0, mysql_errno(), mysql_error());            
$item_last = mysql_escape_string(mysql_result($sql_item_last, 0, 'item_title'));
    
$sql_item_position = mysql_query("SELECT count(item_id) as item_position FROM " . $config['db_pref'] . "items 
LEFT JOIN " . $config['db_pref'] . "categories 
ON item_category = category_id WHERE item_title BETWEEN '" . $item_first . "' AND '" . $item_last . "' 
AND item_category = category_id AND item_active = 1") or ErrorDB(0, mysql_errno(), mysql_error());            
$item_position = mysql_result($sql_item_position, 0, 'item_position'); 

Vielen Dank für Eure Hilfe!

[wahsaga]

Regeln lesen, Code umbrechen.