SELECT `p`.`name` AS `pub_name`, `c`.`media_url` AS `cover_url`
FROM (
SELECT DISTINCT `publication_id`
FROM `tbl_publication_media`
WHERE `media_type` = 2
) AS `v`
JOIN `tbl_publication` AS `p`
ON `p`.`id` = `v`.`publication_id`
LEFT JOIN `tbl_publication_media` AS `c`
ON `c`.`publication_id` = `p`.`id` AND `c`.`media_type` = 4
PCs with multi-core processors:
Windows 7 was designed to work with today's multi-core processors. All 32-bit versions of Windows 7 can support up to 32 processor cores, while 64‑bit versions can support up to 256 processor cores.
PCs with multiple processors (CPUs):
Commercial servers, workstations, and other high-end PCs may have more than one physical processor. Windows 7 Professional, Enterprise, and Ultimate allow for two physical processors, providing the best performance on these computers. Windows 7 Starter, Home Basic, and Home Premium will recognize only one physical processor.
http://bigtime.group
пытается открыть http://bigtime.group/functions/mail.php
. https://bigtime.group/...
.http://bigtime.group
и https://bigtime.group
- это разные сайты, поэтому запрос блокируется CORS.$x = [0 => ['#ff069f'], 1 => ['#FF5500'], 2 => ['#009900']];
echo $x[1][0][4];
// 5
$x = "Привет!";
echo $x[0];
// �
SELECT `FIO` AS `fio`, 1 AS `position`
FROM `test`
WHERE `FIO` REGEXP CONCAT('^ *', :needle)
UNION SELECT `FIO`, 2
FROM `test`
WHERE `FIO` REGEXP CONCAT('^ *[^ ]+ +', :needle)
AND NOT `FIO` REGEXP CONCAT('^ *', :needle)
UNION SELECT `FIO`, 3
FROM `test`
WHERE `FIO` REGEXP CONCAT('^ *[^ ]+ +[^ +] +', :needle)
AND NOT `FIO` REGEXP CONCAT('^ *[^ ]+ +', :needle)
AND NOT `FIO` REGEXP CONCAT('^ *', :needle)
ORDER BY `position`, TRIM(`fio`);
sign = Math.sign(number)
abs = Math.abs(number)
for (let i = 0; i <= abs; i += 3) {
three.push(i * sign)
}
for (let i = 0; i <= abs; i += 5) {
five.push(i * sign)
}
const step3 = number < 0 ? -3 : 3
const three = Array.from(Array(Math.floor(number / step3) + 1), (_, x) => x * step3)
const step5 = number < 0 ? -5 : 5
const five = Array.from(Array(Math.floor(number / step5) + 1), (_, x) => x * step5)