Rsa97

http-URI    = "http:" "//" authority path-abempty [ "?" query ] 
              [ "#" fragment ]
query       = *( pchar / "/" / "?" )
pchar       = unreserved / pct-encoded / sub-delims / ":" / "@"
unreserved  = ALPHA / DIGIT / "-" / "." / "_" / "~"
pct-encoded = "%" HEXDIG HEXDIG
sub-delims  = "!" / "$" / "&" / "'" / "(" / ")" 
              / "*" / "+" / "," / ";" / "="
ALPHA      := [A-Za-z]
DIGIT      := [0-9]
HEXDIG     := [0-9A-F]

UPDATE `users` 
  LEFT JOIN (
    SELECT `user_id_from`, COUNT(*) AS `count` FROM `messages` GROUP BY `user_id_from`
  ) AS `from` ON `from`.`user_id_from` = `users`.`user_id`
  LEFT JOIN (
    SELECT `user_id_to`, COUNT(*) AS `count` FROM `messages` GROUP BY `user_id_to`
  ) AS `to` ON `to`.`user_id_to` = `users`.`user_id`
  SET `users`.`sended` = IFNULL(`from`.`count`, 0), 
      `users`.`received` = IFNULL(`to`.`count`, 0)

SELECT `u`.`id`, `u`.`name`
  FROM `article_subject` AS `as`
  JOIN `user_subject` AS `us` 
    ON `as`.`article_id` = :article_id AND `us`.`subject_id` = `as`.`subject_id`
  JOIN `users` AS `u` 
    ON `u`.`id` = `us`.`user_id`

SELECT `p`.*
  FROM `product` AS `p`
  JOIN `attributes` AS `a1` ON `a1`.`object_id` = `p`.`id`
    AND `a1`.`field_id` = :field1 AND `a1`.`value` = :value1
  JOIN `attributes` AS `a2` ON `a2`.`object_id` = `p`.`id`
    AND `a2`.`field_id` = :field2 AND `a2`.`value` = :value2

var res = JSON.parse(data);
var name = Object.keys(res)[0];
var select = res[name].reduce(function(prev, cur, index) {
  return (prev+'<option value="'+cur+'">'+(index+1));
} , '<select name="'+name+'">') + '</select>';