const pg = require('pg');
require('dotenv').config();
const c = new pg.Client(process.env.DATABASE_URL);
c.connect().then(() => c.query(`
  SELECT o.id, o.merchant_name, o.size, o.price, o.original_price, o.product_id
  FROM offers o JOIN products p ON o.product_id = p.id
  WHERE p.name ILIKE '%Cruyff%Danny%'
  ORDER BY o.size LIMIT 20
`)).then(r => {
  console.log(JSON.stringify(r.rows, null, 2));
  c.end();
}).catch(e => { console.error(e.message); process.exit(1); });