select c.client_code, c.client_name
from media_order_detail mod
innerjoin media_order mo on
mod.id =mo.media_order
innerjoin document d on
mo.document = d.id
innerjoin client c
d.client = c.id
Roses are #FF0000 Violets are #0000FF all my base are belong to you