Hi, I want to generate a classification of some equipment but I do not know how to do it so that they come out in a specified order, I do not know how to enter the ORDER BY.
SELECT
divisiones.id_eq1 AS Equipo_1,
eq1.name_eq AS Nombre_E1,
divisiones.id_eq2 AS Equipo_2,
eq2.name_eq AS Nombre_E2,
divisiones.id_eq3 AS Equipo_3,
eq3.name_eq AS Nombre_E3,
divisiones.id_eq4 AS Equipo_4,
eq4.name_eq AS Nombre_E4,
divisiones.id_eq5 AS Equipo_5,
eq5.name_eq AS Nombre_E5,
divisiones.id_eq6 AS Equipo_6,
eq6.name_eq AS Nombre_E6,
divisiones.id_eq7 AS Equipo_7,
eq7.name_eq AS Nombre_E7,
divisiones.id_eq8 AS Equipo_8,
eq8.name_eq AS Nombre_E8,
divisiones.id_eq9 AS Equipo_9,
eq9.name_eq AS Nombre_E9,
divisiones.id_eq10 AS Equipo_10,
eq10.name_eq AS Nombre_E10,
divisiones.id_eq11 AS Equipo_11,
eq11.name_eq AS Nombre_E11,
divisiones.id_eq12 AS Equipo_12,
eq12.name_eq AS Nombre_E12
FROM divisiones
INNER JOIN equipos AS eq1
ON divisiones.id_eq1 = eq1.id_eq
INNER JOIN equipos AS eq2
ON divisiones.id_eq2 = eq2.id_eq
INNER JOIN equipos AS eq3
ON divisiones.id_eq3 = eq3.id_eq
INNER JOIN equipos AS eq4
ON divisiones.id_eq4 = eq4.id_eq
INNER JOIN equipos AS eq5
ON divisiones.id_eq5 = eq5.id_eq
INNER JOIN equipos AS eq6
ON divisiones.id_eq6 = eq6.id_eq
INNER JOIN equipos AS eq7
ON divisiones.id_eq7 = eq7.id_eq
INNER JOIN equipos AS eq8
ON divisiones.id_eq8 = eq8.id_eq
INNER JOIN equipos AS eq9
ON divisiones.id_eq9 = eq9.id_eq
INNER JOIN equipos AS eq10
ON divisiones.id_eq10 = eq10.id_eq
INNER JOIN equipos AS eq11
ON divisiones.id_eq11 = eq11.id_eq
INNER JOIN equipos AS eq12
ON divisiones.id_eq12 = eq12.id_eq
WHERE division_name = '$_POST[createDiv]';