nklatt

$table = 'some_table';
$columns = implode(',', array(
	'title',
	'description',
	'etc...',
));
$sql = '
	INSERT INTO '.$some_table.' (product_id, '.$columns.')
	SELECT "'.$destId.'", '.$columns.'
	FROM '.$some_table.' WHERE product_id = "'.$origId->id.'"

nklatt

Site allows members (people) to register for programs. People belong to one or
more Accounts. Programs are divided up into Seasons.

When viewing the entity list page for Accounts, we want to be able to filter the
list based on the seasons the people within each account are registered for.
E.g., we often want to show only Accounts which have People registered for
Programs within the current Season.

Pertinent database tables and columns:
accounts: id

nklatt

<input pattern="/^(?:(\d+\/[1-9]\d*)|(\d*(?:(\s\d+\/[1-9]\d*)|\.\d+)?))$/">
<!--
(?: => non-capturing group, EITHER
  (\d+\/[1-9]\d*) => any number of digits followed by a slash then any number of digits not beginning with 0 (fraction)
  | => OR
  (\d*(?: => zero or more digits followed by non-capturing group, EITHER
    (
      \s => a space
      \d+ => any number of digits
      \/ => a slash

nklatt

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
# ...
SET sql_mode=(SELECT CONCAT(@@sql_mode,',ONLY_FULL_GROUP_BY'));

nklatt

If using Vue with TypeScript and ESLint and get the error message:

You have used a rule which requires type information, but don't have parserOptions set to generate type information for this file

it could be because you just created a new Vue single file component
with a <template> section but no <script setup lang="ts"> section.