paginandoconsql.md

URL localhost:3001/api/v1/musicians?size=1&page=2

const query = {
  text: 'SELECT m.id, m.first_name, m.last_name, m.second_last_name, m.second_name, m.birth_date, m.death_date, m.city_fk, m.alias, c.name as city_name, co.nicename as country_name, m.image FROM musician AS m INNER JOIN city AS c ON c.id = m.city_fk INNER JOIN country AS co ON co.iso = c.country_iso_fk ORDER BY m.id desc LIMIT $2  OFFSET (($1 - 1) * $2)',
  values: [ '2', '1' ]
}