Symfony Profiler

[
  "route" => "app_semana"
  "route_parameters" => [
    "_route" => "app_semana"
    "_controller" => "App\Controller\SemanasController::semana"
    "id" => "108"
  ]
  "request_uri" => "http://music.bichomen.com/semana/108"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerFnU6ZZx\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "mariadb"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "music"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3 FROM semanas t0 WHERE t0.id = ?"
  "params" => [
    1 => "108"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.discogs AS discogs_4 FROM cantantes t0 WHERE t0.id = ?"
  "params" => [
    1 => 233
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM canciones t0 WHERE t0.id = ?"
  "params" => [
    1 => 356
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < ? ORDER BY s0_.numero DESC LIMIT 1"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ? AND t0.cantante_id = ? AND t0.cancion_id_id = ? LIMIT 1"
  "params" => [
    1 => 107
    2 => 233
    3 => 356
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 363
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 361
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 17
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 352
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 339
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 342
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 16
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 362
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 359
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 358
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 366
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 367
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 348
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 365
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 18
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 334
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 360
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 349
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 15
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 345
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 363
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 361
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 17
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 352
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 339
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 342
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 16
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 362
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 359
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 358
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 366
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 367
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 348
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 365
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 18
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 334
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 360
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 349
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 15
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 345
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.discogs AS discogs_4 FROM cantantes t0 WHERE t0.id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM canciones t0 WHERE t0.id = ?"
  "params" => [
    1 => 357
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < ? ORDER BY s0_.numero DESC LIMIT 1"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ? AND t0.cantante_id = ? AND t0.cancion_id_id = ? LIMIT 1"
  "params" => [
    1 => 107
    2 => 60
    3 => 357
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 363
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 361
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 17
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 352
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 339
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 342
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 16
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 362
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 359
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 358
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 366
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 367
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 348
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 365
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 18
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 334
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 360
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 349
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 15
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 345
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 363
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 361
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 17
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 352
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 339
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 342
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 16
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 362
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 359
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 358
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 366
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 367
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 348
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 365
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 18
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 334
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 360
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 349
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => null
    2 => 15
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 345
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.discogs AS discogs_4 FROM cantantes t0 WHERE t0.id = ?"
  "params" => [
    1 => 213
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM canciones t0 WHERE t0.id = ?"
  "params" => [
    1 => 364
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < ? ORDER BY s0_.numero DESC LIMIT 1"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ? AND t0.cantante_id = ? AND t0.cancion_id_id = ? LIMIT 1"
  "params" => [
    1 => 107
    2 => 213
    3 => 364
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 357
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 364
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 363
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 361
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 17
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 352
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 339
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 342
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 16
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 362
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 359
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 358
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 366
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 367
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 348
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 365
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 18
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 334
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 360
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 349
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => null
    2 => 15
    3 => 108
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 355
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?"
  "params" => [
    1 => 345
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)"
  "params" => [
    1 => 356
    2 => null
    3 => 108
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]