-- Select rows where disabled = 1 and custom_name is duplicated. -- Results are ordered by custom_name. SELECT s.* FROM shop_nomenclatures s JOIN ( SELECT custom_name FROM shop_nomenclatures WHERE disabled = 1 AND custom_name IS NOT NULL AND custom_name <> '' GROUP BY custom_name HAVING COUNT(*) > 1 ) dup ON s.custom_name = dup.custom_name WHERE s.disabled = 1 ORDER BY s.custom_name; const mysql = require('mysql2/promise'); async function createConnection() { return mysql.createConnection({ host: process.env.DB_HOST || 'localhost', user: process.env.DB_USER || 'root', password: process.env.DB_PASS || '', database: process.env.DB_NAME || 'test', port: process.env.DB_PORT ? Number(process.env.DB_PORT) : 3306, charset: 'utf8_general_ci' }); } module.exports = { createConnection }; const { createConnection } = require('./src/db'); const fs = require('fs'); const QUERY = fs.readFileSync('./query.sql', 'utf8'); async function main() { const conn = await createConnection(); try { const [rows] = await conn.query(QUERY); if (!rows.length) { console.log('No duplicate custom_name rows found (disabled = 1).'); return; } // Print grouped by custom_name let current = null; for (const r of rows) { if (r.custom_name !== current) { current = r.custom_name; console.log('\n===', current, '==='); } console.log(JSON.stringify(r)); } } finally { await conn.end(); } } main().catch(err => { console.error(err); process.exit(1); }); { "name": "duplicate-custom-name", "version": "1.0.0", "description": "Find disabled rows with duplicate custom_name in shop_nomenclatures", "main": "index.js", "scripts": { "start": "node index.js" }, "dependencies": { "mysql2": "^3.6.0" } } Usage: 1. Set database connection environment variables: - DB_HOST, DB_USER, DB_PASS, DB_NAME, DB_PORT (optional) 2. Install dependencies: npm install 3. Run: npm start The query used is in query.sql. It selects rows with disabled = 1 and duplicate custom_name, ordered by custom_name.