SELECT almm_locations.ID as ID, almm_locations.nom as nom, almm_locations.type_date as type_tarif, almm_locations.type_date_we as we, almm_locations.tarifs_charges, almm_locations.tarifs_taxe, almm_locations.tarifs_caution, almm_locations.tarifs_acompte, almm_locations.tarifs_acompte_montant, almm_loueurs.nom as loueur_nom, almm_loueurs.prenom as loueur_prenom, almm_locations.loueur as loueur_id, almm_loueurs.adresse as loueur_adresse, almm_loueurs.adresse2 as loueur_adresse2, almm_loueurs.ville as loueur_ville, almm_loueurs.telephone as loueur_telephone, almm_loueurs.langues as loueur_langues FROM almm_locations LEFT JOIN almm_loueurs ON almm_locations.loueur=almm_loueurs.ID WHERE almm_locations.ID = 630
SELECT * FROM almm_tarifs WHERE location = 630 and (year = 2024 or year = 2024+1) and tarif >=100
Novembre 2024
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
||||||
2450 € | ||||||
2 |
3 |
4 |
5 |
6 |
7 |
8 |
2450 € | ||||||
9 |
10 |
11 |
12 |
13 |
14 |
15 |
2450 € | ||||||
16 |
17 |
18 |
19 |
20 |
21 |
22 |
2450 € | ||||||
23 |
24 |
25 |
26 |
27 |
28 |
29 |
2450 € | ||||||
30 |
||||||
2450 € |
Décembre 2024
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
5 |
6 |
|
2450 € | ||||||
7 |
8 |
9 |
10 |
11 |
12 |
13 |
5250 € | ||||||
14 |
15 |
16 |
17 |
18 |
19 |
20 |
5250 € | ||||||
21 |
22 |
23 |
24 |
25 |
26 |
27 |
6300 € | ||||||
28 |
29 |
30 |
31 |
|||
6300 € |
Janvier 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
||||
6300 € | ||||||
4 |
5 |
6 |
7 |
8 |
9 |
10 |
5250 € | ||||||
11 |
12 |
13 |
14 |
15 |
16 |
17 |
5250 € | ||||||
18 |
19 |
20 |
21 |
22 |
23 |
24 |
5250 € | ||||||
25 |
26 |
27 |
28 |
29 |
30 |
31 |
5250 € |
Février 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
5250 € | ||||||
8 |
9 |
10 |
11 |
12 |
13 |
14 |
6300 € | ||||||
15 |
16 |
17 |
18 |
19 |
20 |
21 |
6300 € | ||||||
22 |
23 |
24 |
25 |
26 |
27 |
28 |
6300 € |
Mars 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
6300 € | ||||||
8 |
9 |
10 |
11 |
12 |
13 |
14 |
5250 € | ||||||
15 |
16 |
17 |
18 |
19 |
20 |
21 |
5250 € | ||||||
22 |
23 |
24 |
25 |
26 |
27 |
28 |
5250 € | ||||||
29 |
30 |
31 |
||||
5250 € |
Avril 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
|||
5250 € | ||||||
5 |
6 |
7 |
8 |
9 |
10 |
11 |
5250 € | ||||||
12 |
13 |
14 |
15 |
16 |
17 |
18 |
2450 € | ||||||
19 |
20 |
21 |
22 |
23 |
24 |
25 |
2450 € | ||||||
26 |
27 |
28 |
29 |
30 |
||
2450 € |
Mai 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
|||||
2450 € | ||||||
3 |
4 |
5 |
6 |
7 |
8 |
9 |
2450 € | ||||||
10 |
11 |
12 |
13 |
14 |
15 |
16 |
2450 € | ||||||
17 |
18 |
19 |
20 |
21 |
22 |
23 |
2450 € | ||||||
24 |
25 |
26 |
27 |
28 |
29 |
30 |
2450 € | ||||||
31 |
||||||
2450 € |
Juin 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
5 |
6 |
|
2450 € | ||||||
7 |
8 |
9 |
10 |
11 |
12 |
13 |
2450 € | ||||||
14 |
15 |
16 |
17 |
18 |
19 |
20 |
2450 € | ||||||
21 |
22 |
23 |
24 |
25 |
26 |
27 |
2450 € | ||||||
28 |
29 |
30 |
||||
2975 € |
Juillet 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
|||
2975 € | ||||||
5 |
6 |
7 |
8 |
9 |
10 |
11 |
2975 € | ||||||
12 |
13 |
14 |
15 |
16 |
17 |
18 |
2975 € | ||||||
19 |
20 |
21 |
22 |
23 |
24 |
25 |
2975 € | ||||||
26 |
27 |
28 |
29 |
30 |
31 |
|
2975 € |
Août 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
1 |
||||||
2975 € | ||||||
2 |
3 |
4 |
5 |
6 |
7 |
8 |
2975 € | ||||||
9 |
10 |
11 |
12 |
13 |
14 |
15 |
2975 € | ||||||
16 |
17 |
18 |
19 |
20 |
21 |
22 |
2975 € | ||||||
23 |
24 |
25 |
26 |
27 |
28 |
29 |
2975 € | ||||||
30 |
31 |
|||||
2975 € |
Septembre 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
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 |
|||
Octobre 2025
S | D | L | M | M | J | V |
---|---|---|---|---|---|---|
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 |