SELECT *
FROM zakazdetal A
LEFT JOIN manufacture_consist B ON A.id = B.orderdetal_id
LEFT JOIN zakaz C ON A.zakid = C.id
LEFT JOIN production_motion_consist D ON A.id=D.orderdetal_id
WHERE (B.orderdetal_id IS NULL or (B.kol<>A.kol))
OR (D.orderdetal_id IS NULL or (D.kol<>A.kol))

select  zakazdetal.id, 
(select sum(kol) from manufacture_consist where manufacture_consist.orderdetal_id=zakazdetal.id) as manufactured, 
(select sum(kol) from production_motion_consist where production_motion_consist.orderdetal_id=zakazdetal.id) as released 
from zakazdetal

select distinct(orderdetal_id), ordered, manufactured, released from
(select id as orderdetal_id, kol as ordered, 0 as manufactured, 0 as released from zakazdetal
union all select orderdetal_id, 0 as ordered, kol as manufactured, 0 as released from manufacture_consist
union all select orderdetal_id,  0 as ordered, 0 as manufactured, kol as released from production_motion_consist
) as ZD order by orderdetal_id

select id as orderdetal_id, kol as ordered, 0 as manufactured, 0 as released from zakazdetal

union all select orderdetal_id, 0 as ordered, kol as manufactured, 0 as released from manufacture_consist [color=red]where manufacture_consist .orderdetal_id=zakazdetal.id[/color]