-- ===========================================

-- CONSULTA NORMALIZADA DE RESPUESTAS AGRO

-- ===========================================

SELECT a.id_agro, 1 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p1 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 1
LEFT JOIN preguntas o ON o.num_preg = 1 AND o.num_opcion = a.p1

UNION ALL
SELECT a.id_agro, 2 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p2 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 2
LEFT JOIN preguntas o ON o.num_preg = 2 AND o.num_opcion = a.p2

UNION ALL
SELECT a.id_agro, 3 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p3 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 3
LEFT JOIN preguntas o ON o.num_preg = 3 AND o.num_opcion = a.p3

UNION ALL
SELECT a.id_agro, 4 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p4 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 4
LEFT JOIN preguntas o ON o.num_preg = 4 AND o.num_opcion = a.p4

UNION ALL
SELECT a.id_agro, 5 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p5 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 5
LEFT JOIN preguntas o ON o.num_preg = 5 AND o.num_opcion = a.p5

UNION ALL
SELECT a.id_agro, 6 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p6 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 6
LEFT JOIN preguntas o ON o.num_preg = 6 AND o.num_opcion = a.p6

UNION ALL
SELECT a.id_agro, 7 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p7 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 7
LEFT JOIN preguntas o ON o.num_preg = 7 AND o.num_opcion = a.p7

UNION ALL
SELECT a.id_agro, 8 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p8 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 8
LEFT JOIN preguntas o ON o.num_preg = 8 AND o.num_opcion = a.p8

UNION ALL
SELECT a.id_agro, 9 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p9 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 9
LEFT JOIN preguntas o ON o.num_preg = 9 AND o.num_opcion = a.p9

UNION ALL
SELECT a.id_agro, 10 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p10 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 10
LEFT JOIN preguntas o ON o.num_preg = 10 AND o.num_opcion = a.p10

UNION ALL
SELECT a.id_agro, 11 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p11 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 11
LEFT JOIN preguntas o ON o.num_preg = 11 AND o.num_opcion = a.p11

UNION ALL
SELECT a.id_agro, 12 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p12 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 12
LEFT JOIN preguntas o ON o.num_preg = 12 AND o.num_opcion = a.p12

UNION ALL
SELECT a.id_agro, 13 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p13 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 13
LEFT JOIN preguntas o ON o.num_preg = 13 AND o.num_opcion = a.p13

UNION ALL
SELECT a.id_agro, 14 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p14 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 14
LEFT JOIN preguntas o ON o.num_preg = 14 AND o.num_opcion = a.p14

UNION ALL
SELECT a.id_agro, 15 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p15 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 15
LEFT JOIN preguntas o ON o.num_preg = 15 AND o.num_opcion = a.p15

UNION ALL
SELECT a.id_agro, 16 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p16 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 16
LEFT JOIN preguntas o ON o.num_preg = 16 AND o.num_opcion = a.p16

UNION ALL
SELECT a.id_agro, 17 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p17 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 17
LEFT JOIN preguntas o ON o.num_preg = 17 AND o.num_opcion = a.p17

UNION ALL
SELECT a.id_agro, 18 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p18 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 18
LEFT JOIN preguntas o ON o.num_preg = 18 AND o.num_opcion = a.p18

UNION ALL
SELECT a.id_agro, 19 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p19 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 19
LEFT JOIN preguntas o ON o.num_preg = 19 AND o.num_opcion = a.p19

UNION ALL
SELECT a.id_agro, 20 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p20 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 20
LEFT JOIN preguntas o ON o.num_preg = 20 AND o.num_opcion = a.p20

UNION ALL
SELECT a.id_agro, 21 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p21 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 21
LEFT JOIN preguntas o ON o.num_preg = 21 AND o.num_opcion = a.p21

UNION ALL
SELECT a.id_agro, 22 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p22 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 22
LEFT JOIN preguntas o ON o.num_preg = 22 AND o.num_opcion = a.p22

UNION ALL
SELECT a.id_agro, 23 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p23 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 23
LEFT JOIN preguntas o ON o.num_preg = 23 AND o.num_opcion = a.p23

UNION ALL
SELECT a.id_agro, 24 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p24 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 24
LEFT JOIN preguntas o ON o.num_preg = 24 AND o.num_opcion = a.p24

UNION ALL
SELECT a.id_agro, 25 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p25 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 25
LEFT JOIN preguntas o ON o.num_preg = 25 AND o.num_opcion = a.p25

UNION ALL
SELECT a.id_agro, 26 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p26 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 26
LEFT JOIN preguntas o ON o.num_preg = 26 AND o.num_opcion = a.p26

UNION ALL
SELECT a.id_agro, 27 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p27 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 27
LEFT JOIN preguntas o ON o.num_preg = 27 AND o.num_opcion = a.p27

UNION ALL
SELECT a.id_agro, 28 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p28 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 28
LEFT JOIN preguntas o ON o.num_preg = 28 AND o.num_opcion = a.p28

UNION ALL
SELECT a.id_agro, 29 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p29 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 29
LEFT JOIN preguntas o ON o.num_preg = 29 AND o.num_opcion = a.p29

UNION ALL
SELECT a.id_agro, 30 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p30 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 30
LEFT JOIN preguntas o ON o.num_preg = 30 AND o.num_opcion = a.p30

UNION ALL
SELECT a.id_agro, 31 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p31 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 31
LEFT JOIN preguntas o ON o.num_preg = 31 AND o.num_opcion = a.p31

UNION ALL
SELECT a.id_agro, 32 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p32 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 32
LEFT JOIN preguntas o ON o.num_preg = 32 AND o.num_opcion = a.p32

UNION ALL
SELECT a.id_agro, 33 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p33 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 33
LEFT JOIN preguntas o ON o.num_preg = 33 AND o.num_opcion = a.p33

UNION ALL
SELECT a.id_agro, 34 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p34 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 34
LEFT JOIN preguntas o ON o.num_preg = 34 AND o.num_opcion = a.p34

UNION ALL
SELECT a.id_agro, 35 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p35 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 35
LEFT JOIN preguntas o ON o.num_preg = 35 AND o.num_opcion = a.p35

UNION ALL
SELECT a.id_agro, 36 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p36 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 36
LEFT JOIN preguntas o ON o.num_preg = 36 AND o.num_opcion = a.p36

UNION ALL
SELECT a.id_agro, 37 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p37 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 37
LEFT JOIN preguntas o ON o.num_preg = 37 AND o.num_opcion = a.p37

UNION ALL
SELECT a.id_agro, 38 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p38 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 38
LEFT JOIN preguntas o ON o.num_preg = 38 AND o.num_opcion = a.p38

UNION ALL
SELECT a.id_agro, 39 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p39 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 39
LEFT JOIN preguntas o ON o.num_preg = 39 AND o.num_opcion = a.p39

UNION ALL
SELECT a.id_agro, 40 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p40 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 40
LEFT JOIN preguntas o ON o.num_preg = 40 AND o.num_opcion = a.p40

UNION ALL
SELECT a.id_agro, 41 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p41 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 41
LEFT JOIN preguntas o ON o.num_preg = 41 AND o.num_opcion = a.p41

UNION ALL
SELECT a.id_agro, 42 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p42 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 42
LEFT JOIN preguntas o ON o.num_preg = 42 AND o.num_opcion = a.p42

UNION ALL
SELECT a.id_agro, 43 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p43 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 43
LEFT JOIN preguntas o ON o.num_preg = 43 AND o.num_opcion = a.p43

UNION ALL
SELECT a.id_agro, 44 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p44 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 44
LEFT JOIN preguntas o ON o.num_preg = 44 AND o.num_opcion = a.p44

UNION ALL
SELECT a.id_agro, 45 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p45 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 45
LEFT JOIN preguntas o ON o.num_preg = 45 AND o.num_opcion = a.p45

UNION ALL
SELECT a.id_agro, 46 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p46 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 46
LEFT JOIN preguntas o ON o.num_preg = 46 AND o.num_opcion = a.p46

UNION ALL
SELECT a.id_agro, 47 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p47 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 47
LEFT JOIN preguntas o ON o.num_preg = 47 AND o.num_opcion = a.p47

UNION ALL
SELECT a.id_agro, 48 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p48 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 48
LEFT JOIN preguntas o ON o.num_preg = 48 AND o.num_opcion = a.p48

UNION ALL
SELECT a.id_agro, 49 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p49 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 49
LEFT JOIN preguntas o ON o.num_preg = 49 AND o.num_opcion = a.p49

UNION ALL
SELECT a.id_agro, 50 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p50 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 50
LEFT JOIN preguntas o ON o.num_preg = 50 AND o.num_opcion = a.p50

UNION ALL
SELECT a.id_agro, 51 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p51 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 51
LEFT JOIN preguntas o ON o.num_preg = 51 AND o.num_opcion = a.p51

UNION ALL
SELECT a.id_agro, 52 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p52 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 52
LEFT JOIN preguntas o ON o.num_preg = 52 AND o.num_opcion = a.p52

UNION ALL
SELECT a.id_agro, 53 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p53 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 53
LEFT JOIN preguntas o ON o.num_preg = 53 AND o.num_opcion = a.p53

UNION ALL
SELECT a.id_agro, 54 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p54 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 54
LEFT JOIN preguntas o ON o.num_preg = 54 AND o.num_opcion = a.p54

UNION ALL
SELECT a.id_agro, 55 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p55 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 55
LEFT JOIN preguntas o ON o.num_preg = 55 AND o.num_opcion = a.p55

UNION ALL
SELECT a.id_agro, 56 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p56 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 56
LEFT JOIN preguntas o ON o.num_preg = 56 AND o.num_opcion = a.p56

UNION ALL
SELECT a.id_agro, 57 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p57 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 57
LEFT JOIN preguntas o ON o.num_preg = 57 AND o.num_opcion = a.p57

UNION ALL
SELECT a.id_agro, 58 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p58 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 58
LEFT JOIN preguntas o ON o.num_preg = 58 AND o.num_opcion = a.p58

UNION ALL
SELECT a.id_agro, 59 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p59 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 59
LEFT JOIN preguntas o ON o.num_preg = 59 AND o.num_opcion = a.p59

UNION ALL
SELECT a.id_agro, 60 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p60 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 60
LEFT JOIN preguntas o ON o.num_preg = 60 AND o.num_opcion = a.p60

UNION ALL
SELECT a.id_agro, 61 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p61 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 61
LEFT JOIN preguntas o ON o.num_preg = 61 AND o.num_opcion = a.p61

UNION ALL
SELECT a.id_agro, 62 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p62 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 62
LEFT JOIN preguntas o ON o.num_preg = 62 AND o.num_opcion = a.p62

UNION ALL
SELECT a.id_agro, 63 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p63 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 63
LEFT JOIN preguntas o ON o.num_preg = 63 AND o.num_opcion = a.p63

UNION ALL
SELECT a.id_agro, 64 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p64 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 64
LEFT JOIN preguntas o ON o.num_preg = 64 AND o.num_opcion = a.p64

UNION ALL
SELECT a.id_agro, 65 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p65 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 65
LEFT JOIN preguntas o ON o.num_preg = 65 AND o.num_opcion = a.p65

UNION ALL
SELECT a.id_agro, 66 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p66 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 66
LEFT JOIN preguntas o ON o.num_preg = 66 AND o.num_opcion = a.p66

UNION ALL
SELECT a.id_agro, 67 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p67 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 67
LEFT JOIN preguntas o ON o.num_preg = 67 AND o.num_opcion = a.p67

UNION ALL
SELECT a.id_agro, 68 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p68 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 68
LEFT JOIN preguntas o ON o.num_preg = 68 AND o.num_opcion = a.p68

UNION ALL
SELECT a.id_agro, 69 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p69 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 69
LEFT JOIN preguntas o ON o.num_preg = 69 AND o.num_opcion = a.p69

UNION ALL
SELECT a.id_agro, 70 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p70 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 70
LEFT JOIN preguntas o ON o.num_preg = 70 AND o.num_opcion = a.p70

UNION ALL
SELECT a.id_agro, 71 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p71 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 71
LEFT JOIN preguntas o ON o.num_preg = 71 AND o.num_opcion = a.p71

UNION ALL
SELECT a.id_agro, 72 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p72 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 72
LEFT JOIN preguntas o ON o.num_preg = 72 AND o.num_opcion = a.p72

UNION ALL
SELECT a.id_agro, 73 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p73 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 73
LEFT JOIN preguntas o ON o.num_preg = 73 AND o.num_opcion = a.p73

UNION ALL
SELECT a.id_agro, 74 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p74 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 74
LEFT JOIN preguntas o ON o.num_preg = 74 AND o.num_opcion = a.p74

UNION ALL
SELECT a.id_agro, 75 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p75 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 75
LEFT JOIN preguntas o ON o.num_preg = 75 AND o.num_opcion = a.p75

UNION ALL
SELECT a.id_agro, 76 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p76 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 76
LEFT JOIN preguntas o ON o.num_preg = 76 AND o.num_opcion = a.p76

UNION ALL
SELECT a.id_agro, 77 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p77 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 77
LEFT JOIN preguntas o ON o.num_preg = 77 AND o.num_opcion = a.p77

UNION ALL
SELECT a.id_agro, 78 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p78 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 78
LEFT JOIN preguntas o ON o.num_preg = 78 AND o.num_opcion = a.p78

UNION ALL
SELECT a.id_agro, 79 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p79 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 79
LEFT JOIN preguntas o ON o.num_preg = 79 AND o.num_opcion = a.p79

UNION ALL
SELECT a.id_agro, 80 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p80 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 80
LEFT JOIN preguntas o ON o.num_preg = 80 AND o.num_opcion = a.p80

UNION ALL
SELECT a.id_agro, 81 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p81 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 81
LEFT JOIN preguntas o ON o.num_preg = 81 AND o.num_opcion = a.p81

UNION ALL
SELECT a.id_agro, 82 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p82 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 82
LEFT JOIN preguntas o ON o.num_preg = 82 AND o.num_opcion = a.p82

UNION ALL
SELECT a.id_agro, 83 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p83 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 83
LEFT JOIN preguntas o ON o.num_preg = 83 AND o.num_opcion = a.p83

UNION ALL
SELECT a.id_agro, 84 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p84 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 84
LEFT JOIN preguntas o ON o.num_preg = 84 AND o.num_opcion = a.p84

UNION ALL
SELECT a.id_agro, 85 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p85 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 85
LEFT JOIN preguntas o ON o.num_preg = 85 AND o.num_opcion = a.p85

UNION ALL
SELECT a.id_agro, 86 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p86 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 86
LEFT JOIN preguntas o ON o.num_preg = 86 AND o.num_opcion = a.p86

UNION ALL
SELECT a.id_agro, 87 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p87 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 87
LEFT JOIN preguntas o ON o.num_preg = 87 AND o.num_opcion = a.p87

UNION ALL
SELECT a.id_agro, 88 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p88 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 88
LEFT JOIN preguntas o ON o.num_preg = 88 AND o.num_opcion = a.p88

UNION ALL
SELECT a.id_agro, 89 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p89 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 89
LEFT JOIN preguntas o ON o.num_preg = 89 AND o.num_opcion = a.p89

UNION ALL
SELECT a.id_agro, 90 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p90 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 90
LEFT JOIN preguntas o ON o.num_preg = 90 AND o.num_opcion = a.p90

UNION ALL
SELECT a.id_agro, 91 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p91 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 91
LEFT JOIN preguntas o ON o.num_preg = 91 AND o.num_opcion = a.p91

UNION ALL
SELECT a.id_agro, 92 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p92 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 92
LEFT JOIN preguntas o ON o.num_preg = 92 AND o.num_opcion = a.p92

UNION ALL
SELECT a.id_agro, 93 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p93 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 93
LEFT JOIN preguntas o ON o.num_preg = 93 AND o.num_opcion = a.p93

UNION ALL
SELECT a.id_agro, 94 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p94 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 94
LEFT JOIN preguntas o ON o.num_preg = 94 AND o.num_opcion = a.p94

UNION ALL
SELECT a.id_agro, 95 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p95 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 95
LEFT JOIN preguntas o ON o.num_preg = 95 AND o.num_opcion = a.p95

UNION ALL
SELECT a.id_agro, 96 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p96 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 96
LEFT JOIN preguntas o ON o.num_preg = 96 AND o.num_opcion = a.p96

UNION ALL
SELECT a.id_agro, 97 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p97 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 97
LEFT JOIN preguntas o ON o.num_preg = 97 AND o.num_opcion = a.p97

UNION ALL
SELECT a.id_agro, 98 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p98 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 98
LEFT JOIN preguntas o ON o.num_preg = 98 AND o.num_opcion = a.p98

UNION ALL
SELECT a.id_agro, 99 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p99 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 99
LEFT JOIN preguntas o ON o.num_preg = 99 AND o.num_opcion = a.p99

UNION ALL
SELECT a.id_agro, 100 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p100 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 100
LEFT JOIN preguntas o ON o.num_preg = 100 AND o.num_opcion = a.p100

UNION ALL
SELECT a.id_agro, 101 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p101 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 101
LEFT JOIN preguntas o ON o.num_preg = 101 AND o.num_opcion = a.p101

UNION ALL
SELECT a.id_agro, 102 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p102 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 102
LEFT JOIN preguntas o ON o.num_preg = 102 AND o.num_opcion = a.p102

UNION ALL
SELECT a.id_agro, 103 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p103 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 103
LEFT JOIN preguntas o ON o.num_preg = 103 AND o.num_opcion = a.p103

UNION ALL
SELECT a.id_agro, 104 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p104 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 104
LEFT JOIN preguntas o ON o.num_preg = 104 AND o.num_opcion = a.p104

UNION ALL
SELECT a.id_agro, 105 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p105 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 105
LEFT JOIN preguntas o ON o.num_preg = 105 AND o.num_opcion = a.p105

UNION ALL
SELECT a.id_agro, 106 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p106 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 106
LEFT JOIN preguntas o ON o.num_preg = 106 AND o.num_opcion = a.p106

UNION ALL
SELECT a.id_agro, 107 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p107 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 107
LEFT JOIN preguntas o ON o.num_preg = 107 AND o.num_opcion = a.p107

UNION ALL
SELECT a.id_agro, 108 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p108 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 108
LEFT JOIN preguntas o ON o.num_preg = 108 AND o.num_opcion = a.p108

UNION ALL
SELECT a.id_agro, 109 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p109 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 109
LEFT JOIN preguntas o ON o.num_preg = 109 AND o.num_opcion = a.p109

UNION ALL
SELECT a.id_agro, 110 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p110 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 110
LEFT JOIN preguntas o ON o.num_preg = 110 AND o.num_opcion = a.p110

UNION ALL
SELECT a.id_agro, 111 AS num_pregunta, q.question, o.pregunta AS respuesta, a.p111 AS valor
FROM evaluacion_agro a
JOIN questions q ON q.num_pregunta = 111
LEFT JOIN preguntas o ON o.num_preg = 111 AND o.num_opcion = a.p111;