Rsa97

trait Harvestable {
  function harvest() { }
}
trait Waterable {
  function water() { }
}
trait Repottable {
  function repot() { }
};
class Plant { }
class Vegetable extends Plant {
  use Waterable;
  use Harvestable;
}
class Fruit extends Plant {
  use Waterable;
  use Harvestable;
  use Repottable;
}
class Succulent extends Plant {
  use Repottable;
}

background: url(data:image/svg+xml,Здесь URL-кодированный SVG)

const [n, a] = [
  users.map((el) => el.name),
  users.map((el) => el.age),
];

const [n, a] = users.reduce(
  (acc, el) => {
    acc[0].push(el.name);
    acc[1].push(el.age);
    return acc;
  },
  [[][]],
);

SELECT `t1`.*
  FROM `table` AS `t1`
  JOIN `table` AS `t2` ON `t2`.`user_id` = `t1`.`friend_user_id`
    AND `t2`.`friend_user_id` = `t1`.`user_id`

SELECT `t1`.*
  FROM `table` AS `t1`
  JEFT JOIN `table` AS `t2` ON `t2`.`user_id` = `t1`.`friend_user_id`
    AND `t2`.`friend_user_id` = `t1`.`user_id`
  WHERE `t2`.`user_id` IS NULL

SELECT `g`.*
  FROM (
    SELECT `goods_id`
      FROM `goods_property`
      WHERE (`type` = 'caffeine_capacity' AND `value` = 'small')
        OR (`type` = 'color_type' AND `value` = 'green')
      GROUP BY `goods_id`
      HAVING COUNT(*) = 2
  ) AS `p`
  JOIN `goods` AS `g` ON `g`.`id` = `p`.`goods_id`

SELECT `g`.*
  FROM `goods` AS `g`
  JOIN `goods_property` AS `p1` ON `p1`.`goods_id` = `g`.`id`
    AND `p1`.`type` = 'caffeine_capacity' AND `p1`.`value` = 'small'
  JOIN `goods_property` AS `p2` ON `p2`.`goods_id` = `g`.`id`
    AND `p2`.`type` = 'color_type'  AND `p2`.`value` = 'green'

SELECT `g`.*
  FROM `goods`
  WHERE `id` IN (
    SELECT `goods_id`
      FROM `goods_property`
      WHERE `type` = 'caffeine_capacity' AND `value` = 'small'
  ) AND `id` IN (
    SELECT `goods_id`
      FROM `goods_property`
      WHERE `type` = 'color_type' AND `value` = 'green'
  )