SELECT performer."id", performer."user", "portfolio", "rating", "balance", performer."created_at"
FROM performer
INNER JOIN performer_subject ON performer.id = performer_subject.performer_id AND performer_subject.subject_id = :subject_id
where not exists(select 1 from "order" where performer.id = order.performer and order.completed = false)
ORDER BY ratingSELECT performer."id", performer."user", "portfolio", "rating", "balance", performer."created_at"
FROM performer
INNER JOIN performer_subject ON performer.id = performer_subject.performer_id AND performer_subject.subject_id = :subject_id
where not exists(select 1 from "order" where performer.id = order.performer)
ORDER BY ratingselect
"product_id" AS "id",
min("price_fallback") AS "price",
(array_agg("price_base" ORDER BY price_fallback DESC))[1] as "price_old"
from "cache"
WHERE ("showcase_id" IN (66, 1))
group by "product_id"
order by "product_id"
limit 50;DB::table('posts')
->select('*')
->where('id', '>', $getPost->id)
->where('city', '=', $getPost->city)
->where('approve', '=', 1)
->orderByRaw('(id > ?) desc, id asс' , [$getPost->id])
->limit(10)
->get();“35544” = ANY (string_to_array(participantsid,','))Find_in_set(35544, participantsid);
SELECT ClientID, LastName, FirstName, FROM orders
inner join Client using(ClientID)
where OrderDate like “2015%” // это надо заменить на extract(year, OrderDate) = 2015 взависимости то того что за дб
Group by ClientID, LastName, FirstName
having count(*) >= 25;create table public.profiles (
id uuid not null,
username text default concat('Пользователь #', random()*100000),
primary key (id)
);Users::select(
'users.*',
DB::raw("IF(exist (select * from admin where admin.user_id = users.id), 'admin', (select name from rank where score<=users.points order by score desc limit 1)) as rank"))
->get();SELECT b.id, b.title,
CASE WHEN exists (SELECT ib.book_id FROM issued_book ib where ib.book_id = b.id AND ib.date_return IS NULL)
THEN 'Нет в наличии'
ELSE 'В наличии'
END AS Наличие
FROM book b;Post::where('status', 1)
->join('post_tag', 'posts.id', '=', 'post_tag.post_id')
->join('tags', 'tags.id', '=', 'post_tag.tag_id')
->select('posts.*', DB::raw('group_concat(tags.name) as tags_name'))
->groupBy('posts.id', 'posts.name', 'posts.content')->get();Post::where('status', 1)
->select('posts.*', DB::raw('select group_concat(tags.name) as tags_name from post_tag join tags on tags.id=post_tag.tag_id where post_tag.post_id = posts.id'))->get();SELECT name, salary FROM public.player
ORDER BY (salary = 475000) DESC, salary asc
LIMIT 5;$items = Color::query()
->leftJoin('users', 'users.color', '=', 'colors.color')
->leftJoin('size', 'size.user_id', '=', 'users.id')
->selectRaw('color.color, SUM(length)')
->groupBy('color.color');SET @table_name = table_name;
SET @sql_text = concat('SELECT COUNT(*) INTO counter FROM ', @table_name);
PREPARE stmt FROM @sql_text;
EXECUTE stmt;