1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
| SELECT
DISTINCT id0
FROM
(
SELECT
a0_.id AS id0,
a0_.nom AS nom1,
a0_.prenom AS prenom2,
a0_.dateNaissance AS dateNaissance3,
a0_.description AS description4,
a0_.photo AS photo5,
a0_.video AS video6,
a0_.genre AS genre7,
a0_.genreAidant AS genreAidant8,
a0_.mobile AS mobile9,
a0_.medical AS medical10,
a0_.gele AS gele11,
a0_.animal AS animal12,
a0_.slug AS slug13,
a0_.creeLe AS creeLe14,
a0_.modifieLe AS modifieLe15,
a0_.geleLe AS geleLe16,
a0_.visiteRecue AS visiteRecue17,
a0_.visiteARecevoir AS visiteARecevoir18,
12756 * ASIN(
SQRT(
POWER(
SIN(
(
(
SELECT
`lat`
FROM
`craue_geo_postalcode`
WHERE
`country` = ?
AND `postal_code` = ?
) - (
SELECT
`lat`
FROM
`craue_geo_postalcode`
WHERE
`country` = 'FR'
AND `postal_code` = a1_.codePostal
)
) * PI()/ 360
),
2
) + COS(
(
SELECT
`lat`
FROM
`craue_geo_postalcode`
WHERE
`country` = ?
AND `postal_code` = ?
) * PI()/ 180
) * COS(
(
SELECT
`lat`
FROM
`craue_geo_postalcode`
WHERE
`country` = 'FR'
AND `postal_code` = a1_.codePostal
) * PI()/ 180
) * POWER(
SIN(
(
(
SELECT
`lng`
FROM
`craue_geo_postalcode`
WHERE
`country` = ?
AND `postal_code` = ?
) - (
SELECT
`lng`
FROM
`craue_geo_postalcode`
WHERE
`country` = 'FR'
AND `postal_code` = a1_.codePostal
)
) * PI()/ 360
),
2
)
)
) AS sclr19,
(
DATEDIFF(CURRENT_DATE, a0_.dateNaissance) / 365
) AS sclr20
FROM
Aide a0_
INNER JOIN AdresseAide a1_ ON a0_.id = a1_.aide_id
INNER JOIN aide_jours a3_ ON a0_.id = a3_.aide_id
INNER JOIN Jour j2_ ON j2_.id = a3_.jour_id
INNER JOIN aide_medicals a5_ ON a0_.id = a5_.aide_id
INNER JOIN Medical m4_ ON m4_.id = a5_.medical_id
INNER JOIN aide_interets a7_ ON a0_.id = a7_.aide_id
INNER JOIN Interet i6_ ON i6_.id = a7_.interet_id
INNER JOIN Frequence f8_ ON a0_.frequence_id = f8_.id
INNER JOIN Tuteur t9_ ON a0_.tuteur_id = t9_.id
WHERE
a0_.gele = 0
HAVING
1 = 1
AND sclr19 <= ?
ORDER BY
sclr19 ASC
) dctrn_result
LIMIT
15 OFFSET 0 |
Partager