<label class="card2 effect__check">
<input type="checkbox">
</label>SELECT `p`.`product_id`, `p`.`supplier_id`, `p`.`price`, `i`.`title`
FROM (
SELECT `product_id`, MIN(`price`) AS `price`
FROM `supplier_price`
GROUP BY `product_id`
) AS `mp`
JOIN `supplier_price` AS `p` ON `p`.`product_id` = `mp`.`product_id`
AND `p`.`price` = `mp`.`price`
JOIN `product` AS `i` ON `i`.`id` = `mp`.`product_id`SELECT `p`.`product_id`, `p`.`supplier_id`, `p`.`price`, `i`.`title`
FROM (
SELECT `product_id`, `supplier_id`, `price`
FROM `supplier_price`
GROUP BY `product_id`, `supplier_id`, `price` WITH ROLLUP
HAVING `price` = MIN(`price`)
) AS `p`
JOIN `product` AS `i` ON `i`.`id` = `mp`.`product_id`$profiles = array_combine(
array_map(function($profile) { return $profile->id; }, $data['profiles']),
$data['profiles']);
foreach ($data['items'] as $item) {
echo $profile[$item->from_id]->first_name, ' ',
$profile[$item->from_id]->last_name, ' - ',
$items->text, "\n";
}filter определяет, какие типы записей на стене необходимо получить.
Возможные значения:
suggests — предложенные записи на стене сообщества (доступно только при вызове с передачей access_token);
...
function get_drives() {
$letters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
$drives = [];
foreach (str_split($letters) as $drive) {
if (is_dir($drive . ':\\')) {
$drives[] = $drive;
}
}
return $drives;
}SELECT `t1`.*
FROM `dk_products` AS `t1`
LEFT JOIN `dk_products` AS `t2` ON `t1`.`article` = :article
AND `t2`.`article` = :article
AND `t2`.`brand` = `t1`.`brand`
AND `t2`.`date` > `t1`.`date`
WHERE `t2`.`article` IS NULLSELECT `t2`.*
FROM (
SELECT `brand`, MAX(`date`) AS `date`
FROM `dk_products`
WHERE `article` = :article
GROUP BY `brand`
) AS `t1`
JOIN `dk_products` AS `t2` ON `t2`.`article` = :article
AND `t2`.`brand` = `t1`.`brand`
AND `t2`.`date` = `t1`.`date`CREATE SCHEMA is a synonym for CREATE DATABASE.
SELECT `m`.`name`, `m`.`phone`, IFNULL(`t`.`cities`, '')
FROM (
SELECT `mc`.`manager_id` AS `manager_id`,
GROUP_CONCAT(`c`.`name`) AS `cities`
FROM `manager_cities` AS `mc`
JOIN `cities` AS `c` ON `c`.`kladr_id` = `mc`.`kladr_id`
GROUP BY `mc`.`manager_id`
) AS `t`
RIGHT JOIN `managers` AS `m` ON `m`.`manager_id` = `t`.`manager_id`