Мой самый сложный:
SELECT
op.order_id,
o.id,
o.cntpt,
o.gen_expens,
o.order_cost,
o.cur_payment,
o.payment_type,
o.date_form,
o.death_line,
o.status,
designer.date_start,
designer.date_utv,
designer.date_end,
designer.contractor,
users.user_name,
ctp.date_start AS ctp_date_start,
ctp.date_end AS ctp_date_end,
user_ctp.user_name AS ctp_user_name
FROM `order_productions` op, `order` o
LEFT JOIN `designer`
ON designer.order_id = o.id
LEFT JOIN `users`
ON designer.contractor = users.id
LEFT JOIN `ctp`
ON ctp.order_id = o.id
LEFT JOIN `users` AS user_ctp
ON ctp.contractor = user_ctp.id
WHERE op.prod_name LIKE '%". mysql_real_escape_string($str) ."%'
AND o.id = op.order_id
AND order.". mysql_real_escape_string($cell) ." LIKE '%". mysql_real_escape_string($str) ."%'
AND o.user_id = '". (int)$mngr ."'
GROUP by o.id DESC
LIMIT " . $limit . ", 20
а еще самый страшный
DELETE `order_productions`, `prepress`, `press`, `postpress`
FROM `order_productions`
LEFT JOIN `prepress`
ON prepress.order_id = order_productions.order_id
AND prepress.prod_id = order_productions.prod_id
LEFT JOIN `press`
ON press.order_id = order_productions.order_id
AND press.prod_id = order_productions.prod_id
LEFT JOIN `postpress`
ON postpress.order_id = order_productions.order_id
AND postpress.prod_id = order_productions.prod_id
WHERE order_productions.prod_id > '". ( count($xml->prod_list[0]->prod) - 1 ) ."'
AND order_productions.order_id = '". $order_id ."'
_____________