@ 2014-03-27T20:05:45Z <?php
$cod_videoconferencia[1] = array(1 => 1, 5 => 5, 6 => 6, 7 => 7, 11 => 11, 12 => 12, 13 => 13, 15 => 15);
$cod_videoconferencia[2] = array(2 => 2, 5 => 5, 8 => 8, 9 => 9, 11 => 11, 12 => 12, 14 => 14, 15 => 15);
$cod_videoconferencia[3] = array(3 => 3, 6 => 6, 8 => 8, 10 => 10, 11 => 11, 13 => 13, 14 => 14, 15 => 15);
$cod_videoconferencia[4] = array(4 => 4, 7 => 7, 9 => 9, 10 => 10, 12 => 12, 13 => 13, 14 => 14, 15 => 15);
$cod_videoconferencia[5] = $cod_videoconferencia[1] + $cod_videoconferencia[2];
$cod_videoconferencia[6] = $cod_videoconferencia[1] + $cod_videoconferencia[3];
$cod_videoconferencia[7] = $cod_videoconferencia[1] + $cod_videoconferencia[4];
$cod_videoconferencia[8] = $cod_videoconferencia[2] + $cod_videoconferencia[3];
$cod_videoconferencia[9] = $cod_videoconferencia[2] + $cod_videoconferencia[4];
$cod_videoconferencia[10] = $cod_videoconferencia[3] + $cod_videoconferencia[4];
$cod_videoconferencia[11] = $cod_videoconferencia[1] + $cod_videoconferencia[2] + $cod_videoconferencia[3];
$cod_videoconferencia[12] = $cod_videoconferencia[1] + $cod_videoconferencia[2] + $cod_videoconferencia[4];
$cod_videoconferencia[13] = $cod_videoconferencia[1] + $cod_videoconferencia[3] + $cod_videoconferencia[4];
$cod_videoconferencia[14] = $cod_videoconferencia[2] + $cod_videoconferencia[3] + $cod_videoconferencia[4];
$cod_videoconferencia[15] = $cod_videoconferencia[1] + $cod_videoconferencia[2] + $cod_videoconferencia[3] + $cod_videoconferencia[4];
$sql_videoconferencia = "AND (";
foreach ($cod_videoconferencia as $key => $value) {
$sql_videoconferencia .= " AND ".$key." NOT IN (".implode(",", $cod_videoconferencia[$key]).")";
}
echo $sql_videoconferencia;
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 4.3.0 - 4.3.11 , 4.4.0 - 4.4.9 , 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.7 - 5.6.28 , 7.0.0 - 7.0.20 , 7.1.0 - 7.1.7 , 7.2.29 - 7.2.33 , 7.3.12 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 AND ( AND 1 NOT IN (1,5,6,7,11,12,13,15) AND 2 NOT IN (2,5,8,9,11,12,14,15) AND 3 NOT IN (3,6,8,10,11,13,14,15) AND 4 NOT IN (4,7,9,10,12,13,14,15) AND 5 NOT IN (1,5,6,7,11,12,13,15,2,8,9,14) AND 6 NOT IN (1,5,6,7,11,12,13,15,3,8,10,14) AND 7 NOT IN (1,5,6,7,11,12,13,15,4,9,10,14) AND 8 NOT IN (2,5,8,9,11,12,14,15,3,6,10,13) AND 9 NOT IN (2,5,8,9,11,12,14,15,4,7,10,13) AND 10 NOT IN (3,6,8,10,11,13,14,15,4,7,9,12) AND 11 NOT IN (1,5,6,7,11,12,13,15,2,8,9,14,3,10) AND 12 NOT IN (1,5,6,7,11,12,13,15,2,8,9,14,4,10) AND 13 NOT IN (1,5,6,7,11,12,13,15,3,8,10,14,4,9) AND 14 NOT IN (2,5,8,9,11,12,14,15,3,6,10,13,4,7) AND 15 NOT IN (1,5,6,7,11,12,13,15,2,8,9,14,3,10,4) preferences:dark mode live preview
216.87 ms | 407 KiB | 311 Q