SELECT ..., `c`.`font_category`, `v`.`font_variants`
FROM `font`
LEFT JOIN `asset` AS `as` ON `as`.`asset_id` = `font`.`font_asset_id`
LEFT JOIN `resource` ON `resource`.`rc_id` = `as`.`asset_rc_id`
LEFT JOIN (
SELECT `fav`.`fav_font_id` AS `font_id`,
GROUP_CONCAT(`fao`.`fao_value`) AS `font_category`
FROM `font_attribute_value` AS `fav`
JOIN `font_attribute` AS `fa`
ON `fa`.`name` = 'category'
AND `fa`.`fa_id` = `fav`.`fav_attribute_id`
AND `fav`.`fav_font_id` = :font_id
JOIN `font_attribute_option` AS `fao`
ON `fao`.`fao_id` = `fav`.`fav_attribute_option_id`
GROUP BY `fav`.`fav_font_id`
) AS `c` ON `c`.`font_id` = `font`.`font_id`
LEFT JOIN (
SELECT `fav`.`fav_font_id` AS `font_id`,
GROUP_CONCAT(`fao`.`fao_value`) AS `font_variants`
FROM `font_attribute_value` AS `fav`
JOIN `font_attribute` AS `fa`
ON `fa`.`name` = 'variants'
AND `fa`.`fa_id` = `fav`.`fav_attribute_id`
AND `fav`.`fav_font_id` = :font_id
JOIN `font_attribute_option` AS `fao`
ON `fao`.`fao_id` = `fav`.`fav_attribute_option_id`
GROUP BY `fav`.`fav_font_id`
) AS `v` ON `c`.`font_id` = `font`.`font_id`
WHERE `font`.`font_id` = :font_idfunction alphabetPosition(text) {
return text.replace(/([A-Z])/gi, function(char) {
return (char > 'Z' ? char.charCodeAt(0) - 96 : char.charCodeAt(0) - 64);
});
}parseFloat(str.charCodeAt(i)) < 91 получили parseFloat(str.charCodeAt(i) < 91).
console.log(responseText);
exten => _99XXX,1,JabberSend(asteriskjabber, ${JID_${EXTEN:2}},${CALLERID(all)} звонил(а) в ${STRFTIME(${EPOCH},,%c)}!) / "городской номер моей атс")
same => n,HangupSELECT COUNT(*)
FROM (
SELECT `question_id`, COUNT(*) AS `count`
FROM `answers`
GROUP BY `question_id`
HAVING `count` > 100
)