Rsa97

INSERT 
  INTO `table`
  (список_колонок, `building_id`)
  SELECT список_колонок, 655
    FROM `table`
    WHERE `building_id` = 138 AND ...

Возможно ли его сделать не перечисляя каждую колонку?

(
  SELECT ...
    FROM `table`
    WHERE `feature_id` = 90
    LIMIT 6
) UNION (
  SELECT ...
    FROM `table`
    WHERE `feature_id` = 91
    LIMIT 6
) UNION ...

SELECT `t`.`id`, ROUND(`t`.`views`/(2020 - `t`.`releaseDate` + 1)*100/`m`.`max`) AS `pop`
  FROM `manga` AS `t` 
  JOIN (
    SELECT MAX(ROUND(`views`/(2020 - `releaseDate` + 1))) AS `max`
      FROM `manga`
  ) AS `m`
  WHERE `t`.`active` = 1
  ORDER BY `pop` DESC
  LIMIT 10

SELECT *
  FROM `wp_posts`
  WHERE `ID` IN (
    SELECT `object_id`
      FROM `wp_term_relationships`
      WHERE `term_taxonomy_id` IN (43, 89)
      GROUP BY `object_id`
      HAVING COUNT(*) = 2
    )

SELECT *
  FROM `table` AS `t1`
  JOIN `table` AS `t2`
    ON `t2`.`key` = `t1`.`key`
      AND `t1`.`domain` = 'первый'
      AND `t2`.`domain` = 'второй'
      AND `t2`.`value` != `t1`.`value`

DELETE FROM `user`
  WHERE `id` NOT IN (
    SELECT `student_id`
      FROM `students`
  )

DELIMITER $$
CREATE PROCEDURE ...
BEGIN
...
END$$
DELIMITER ;

SELECT DISTINCT `user_id`
  FROM `ticket`
  WHERE `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 2)
    AND `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 3)
    AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 1)
    AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 4)