MechanicalAngel 10.02.2012 03:25 work

— Привет.
— Как там ваши дела с Наташей? Еще не поженились?
— Нет, мы расстались.
— А что случилось?
— Мне надоело, у нее были слишком большие запросы.
— Например какие?
— Ну например update instance inner join (select group.id as group_id, (select message.id from message inner join thread on thread.id = message.thread_id where location_id = @location_id and language_id = @language_id and concat(group_key, ‘.’) like concat(group.’key’, ‘.%’) order by message.created desc limit 1) as last_message_id, (select count(*) from thread where location_id = @location_id and language_id = @language_id and concat(group_key, ‘.’) like concat(group.’key’, ‘.%’)) as thread_count, (select if(sum(thread.message_count) is null, 0, sum(thread.message_count)) from thread where location_id = @location_id and language_id = @language_id and concat(group_key, ‘.’) like concat(group.’key’, ‘.%’)) as message_count from group where @group_key like concat(‘key’, ‘.%’)) as statistics on statistics.group_id = instance.group_id set instance.message_id = statistics.last_message_id, instance.thread_count = statistics.thread_count, instance.message_count = statistics.message_count where instance.location_id = @location_id and instance.language_id = @language_id

lol
Recommended by: @dorfe, @xujnya
1. dorfe 10.02.2012 04:00

Я сразу подумал что @location_id и @language_id несколько раз порекомендовали это псто -_-

2. xujnya 10.02.2012 07:40

Хороший рассказ.

Do you really want to delete ?