#include <string.h>
#include <stdio.h>
int main(int argc, char *argv[])
{
unsigned char *text, *key;
unsigned char shift, rightNumber;
for (text = argv[1], key = argv[2]; *text; text++, key++) {
if (0 == *key)
key = argv[2];
if (*text >= 'A' && *text <= 'Z') {
shift = *key - 'A';
rightNumber = *text + shift;
if (rightNumber > 'Z')
rightNumber -= ('Z' - 'A');
printf(""%c + %c '%.3d' == "%c\n", *text, *key, shift, rightNumber);
}
}SELECT `g`.`id`, `g`.`name`, `g`.`description`, `g`.`price`, `i`.`images`
FROM `goods` AS `g`
LEFT JOIN (
SELECT `good_id`, GROUP_CONCAT(`link` SEPARATOR ',') AS `images`
FROM `images`
GROUP BY `good_id`
) AS `i` ON `i`.`good_id` = `g`.`id`
WHERE `g`.`id_category` = :category
ORDER BY `g`.`id` DESC;SELECT `a`.`name`, IFNULL(`c`.`count`, 0)
FROM `author_user` AS `au`
JOIN `authors` AS `a` ON `au`.`user` = :user AND `a`.`id` = `au`.`author_id`
LEFT JOIN (
SELECT `p`.`author_id`, COUNT(*) AS `count`
FROM `posts` AS `p`
LEFT JOIN `post_user` AS `pu` ON `pu`.`user_id` = :user AND `pu`.`post_id` = `p`.`id`
WHERE `pu`.`post_id` IS NULL
GROUP BY `p`.`author_id`
) AS `c` ON `c`.`author_id` = `au`.`author_id`SELECT `id`
FROM `table`
WHERE `f_id` IN (27, 47)
GROUP BY `id`
HAVING COUNT(`id`) = 2print md5('a'.''.md5('b'));
57e9f61da712c151b9d535392036223fSELECT MD5(CONCAT('a', MD5('b')))
57e9f61da712c151b9d535392036223f