'([\-]*[\d]+)''$1'::character varyingwith main_tb (id, detal, mono, row_num) as (select id,
detal,
mono
row_number() over (partition by detal order by id) as row_num
from tb)
select t.id,
t.detal,
t.name,
(select t1.mono from main_tb as t1 where t1.detal = t.detal and t1.row_num = 1) mono,
(select t1.mono from main_tb as t1 where t1.detal = t.detal and t1.row_num = 2) mono2,
(select t1.mono from main_tb as t1 where t1.detal = t.detal and t1.row_num = 3) mono3
from tb as tselect u.*
from users u
where not exists(
select 999
from user_statuses us
where us.user_id = u.id
and us.status_id = 1
)$cycle = function($first, $second)
{
foreach(xopa($first, $second) as $items)
{
echo $items;
}
};
$cycle($first, $second);FOR /R %f IN (*.bin) DO REN "%f" *.exe$product = R::dispense('products');
$product->image = $_FILES[$input_name]['name'][0]; // СЮДА НАДО ЗАПИСАТЬ МАССИВ ИМЕН ИЗОБРАЖЕНИЙ (сейчас записано только имя первого изображения)<br>
R::store($product);$product = R::dispense('products');
$product_id = $product->id;
foreach($files as $file)
{
// Вставка сведений из $file в таблицу product_images с входным параметром $product_id
}$this->db->select('инструктор, дата, SUM(длительность)');
$this->db->from('( SELECT DISTINCT инструктор, дата, начало, длительность
FROM таблица ) AS алиас');
$this->db->group_by(['инструктор', 'дата']);
$query = $this->db->get();20 таблицами в которых рассортированы сериалы по разным жанрам.
<a href="#" class="menu__item menu__item--sport"><span>Зимний спорт</span></a>.menu__item
{
text-decoration: none;
}
.menu__item > span
{
text-decoration: underline;
}
.menu__item:after
{
position: unset;
content: '▪';
margin-left: 5px;
}group by year ...group by EXTRACT(year from CAST(invoice_date as date)) ...