The SQL optimizer incorrectly alters the logic of a query that uses CTEs and nested JOIN operations. WITH `res` AS ( SELECT `t2`.`id`, CAST(IF(NOT `t3`.`id` IS NULL, 1, 0) AS BIGINT) AS `id_active`, ...
This is a fork of verajosemanuel/ESmisc, which is for Spanish numbers. I've changed the Spanish to English and made a few other minor modifications.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback