ГК РФ Статья 1295.2
Исключительное право на служебное произведение принадлежит работодателю, если трудовым или гражданско-правовым договором между работодателем и автором не предусмотрено иное.
SELECT `u`.`nick`, IFNULL(`tc`.`count`, 0) AS `comments`,
IFNULL(`fp`.`count`, 0) AS `posts`,
IFNULL(`l`.`count`, 0) AS `likes`
FROM `users` AS `u`
LEFT JOIN (
SELECT `sender_id`, COUNT(*) AS `count`
FROM `thread_comments` GROUP BY `sender_id`
) AS `tc` ON `tc`.`sender_id` = `u`.`id`
LEFT JOIN (
SELECT `sender_id`, COUNT(*) AS `count`
FROM `forum_posts` GROUP BY `sender_id`
) AS `fp` ON `fp`.`sender_id` = `u`.`id`
LEFT JOIN (
SELECT `owner_id`, COUNT(*) AS `count`
FROM `likes` GROUP BY `owner_id`
) AS `l` ON `l`.`owner_id` = `u`.`id`
ORDER BY `tc`.`count` DESC, `u`.`nick` ASC
LIMIT 15 SELECT `t1`.`code`, `t1`.`name`, `t1`.`max_int1`, `t2`.`name`, `t2`.`max_int2`
FROM (
SELECT `t`.`name` AS `name`, `t`.`code` AS `code`, `t`.`int1` AS `max_int1`
FROM (
SELECT `code`, MAX(`int1`) AS `int1`
FROM `table` WHERE `city`= :city GROUP BY `code`
) AS `m`
JOIN `table` AS `t` ON `t`.`city` = :city AND `t`.`code` = `m`.`code`
AND `t`.`int1` = `m`.`int1`
) AS `t1`
JOIN (
SELECT `t`.`name` AS `name`, `t`.`code` AS `code`, `t`.`int2` AS `max_int2`
FROM (
SELECT `code`, MAX(`int2`) AS `int2`
FROM `table` WHERE `city`= :city GROUP BY `code`
) AS `m`
JOIN `table` AS `t` ON `t`.`city` = :city AND `t`.`code` = `m`.`code`
AND `t`.`int2` = `m`.`int2`
) AS `t2` ON `t1`.`code` = `t2`.`code` #pragma pack(push,1)
typedef _websocketPacket {
unsigned char one; // здесь ваша 1
unsigned char indexElement;
unsigned char rest[18];
} wsPacket;
#pragma pack(pop)
wsPacket myData;