(Solucionado)Problemas en consulta multiples tablas

[lone]

Problema solucionado. Aquien le pueda interesar el codigo queda como sigue:

$query = "SELECT DISTINCT m.manufacturer_id, m.mf_name, m.mf_category_id
FROM #__{vm}_manufacturer m
LEFT JOIN #__{vm}_product_mf_xref mx ON mx.manufacturer_id = m.manufacturer_id
LEFT JOIN #__{vm}_manufacturer_category_id f ON f.mf_category_id = m.mf_category_id
LEFT JOIN #__{vm}_product p ON p.product_id = mx.product_id
LEFT JOIN #__{vm}_product_category_xref cx ON cx.product_id = p.product_id
WHERE cx.category_id =".(int)$category_id;
$query .= " ORDER BY f.mf_category_name ASC";

$query_all = "SELECT f.mf_category_id,f.mf_category_name FROM #__{vm}_manufacturer_category f ";
$query_all .= "ORDER BY f.mf_category_name ASC";

$db = new ps_DB;
if ($auto == 1 && !empty( $mf_category_id ) ) {
$db->query( $query );
} else {
$db->query( $query_all );
}
$res = $db->record;
if( empty( $res )) {
if( $auto == 1 ) {
$db->query( $query_all );
$res = $db->record;
} else {
echo 'No manufacturers defined!';
return;
}