delimiter $$
drop function if exists `last_images_names`$$
create function `last_images_names` (aid int, ilimit int)
returns varchar(255)
reads sql data
begin
return (select group_concat(`name`) from (
select `name` from `images` where `album_id` = aid
order by `image_id` desc limit ilimit
) as _i);
end$$
delimiter ;
select `name`, last_images_names(`id`, 5) from `albums` order by `album_id` desc limit 10;
select u0.*, u1.*
from `user` as u0
inner join `user` as u1
on u1.id > u0.id and u1.show = 1
where
<some condition for u0>
limit 1;select STAMP_HASH, group_concat(RATE_CODE) from m_rates group by RATE_CODE;log_not_found off; отключит запись в error_log ошибок о том, что файл не найден. А error_log настраивается так nginx.org/ru/docs/ngx_core_module.html#error_log
$serial = new DOTNET('system', 'System.IO.Ports.SerialPort');
$serial->PortName = 'COM3';
$serial->Open();
$serial->Write('string');
$serial->Close();