';
$resSwitch = $Schema->executeQuery('SELECT R.EQUIPAMIENTO,R.ALIAS,R.CATEGORIA,R.VEHICULO
FROM VEHICULOS_EQUIPAMIENTOS_REL R
WHERE R.CATEGORIA = ? AND R.VEHICULO = ?
UNION
SELECT B.DESCRIPCION AS EQUIPAMIENTO,B.ALIAS,B.CATEGORIA,NULL AS VEHICULO
FROM VEHICULOS_EQUIPAMIENTOS_BASE B
WHERE B.CATEGORIA = ? AND B.ALIAS NOT IN (SELECT ALIAS
FROM VEHICULOS_EQUIPAMIENTOS_REL
WHERE CATEGORIA = ? AND VEHICULO = ?)
ORDER BY EQUIPAMIENTO ASC', 'iiiii', [$row['CODIGO'], $_SESSION['CODIGO_COCHE'], $row['CODIGO'], $row['CODIGO'], $_SESSION['CODIGO_COCHE']]);
if($resSwitch->num_rows) {
$nr = 0;
while($rowSwitch = $resSwitch->fetch_array()) {
$nr++;
$checked = $rowSwitch['VEHICULO'] != NULL ? 'checked' : FALSE;
$html .= '
';
$resREL = $Schema->executeQuery('SELECT B.*, R.*
FROM VEHICULOS_EQUIPAMIENTOS_BASE B
LEFT JOIN VEHICULOS_EQUIPAMIENTOS_REL R ON B.DESCRIPCION = R.EQUIPAMIENTO
WHERE R.VEHICULO = ?
AND B.CATEGORIA = ?
ORDER BY B.DESCRIPCION ASC', 'ii', [$_SESSION['CODIGO_COCHE'], $row['CODIGO']]);
while($rowREL = $resREL->fetch_array()) {
$html .= '