--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-13' OR (disponibilite.date_debut='2010-08-13' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64) AND camping_car.famille = 'fourgon1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82) AND camping_car.famille = 'fourgon1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-17' OR (
disponibilite.date_fin = '2010-01-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-31' OR (
disponibilite.date_fin = '2010-08-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-10' OR (
disponibilite.date_fin = '2010-01-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 1 ccar --------------
Alerte => 1 correspondants
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-15' OR (
disponibilite.date_fin = '2010-05-15' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-03' OR (
disponibilite.date_fin = '2010-07-03' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 1 ccar --------------
Alerte => 1 correspondants
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-10' OR (
disponibilite.date_fin = '2010-07-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-22' OR (
disponibilite.date_fin = '2010-05-22' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-10' OR (
disponibilite.date_fin = '2010-07-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-10' OR (
disponibilite.date_fin = '2010-07-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (25,39,70,90) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-28' OR (
disponibilite.date_fin = '2010-01-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-02-01' OR (
disponibilite.date_fin = '2010-02-01' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-31' OR (
disponibilite.date_fin = '2010-01-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-21' OR (disponibilite.date_debut='2010-08-21' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-17' OR (
disponibilite.date_fin = '2010-09-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-02-18' OR (
disponibilite.date_fin = '2010-02-18' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-02-18' OR (
disponibilite.date_fin = '2010-02-18' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-10' OR (
disponibilite.date_fin = '2010-07-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-11' OR (
disponibilite.date_fin = '2010-06-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-18' OR (
disponibilite.date_fin = '2010-07-18' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (08,10,51,52)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-29' OR (
disponibilite.date_fin = '2010-01-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-10-23' OR (disponibilite.date_debut='2010-10-23' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-11-06' OR (
disponibilite.date_fin = '2010-11-06' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (03,15,43,63)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-29' OR (
disponibilite.date_fin = '2010-01-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-01' OR (
disponibilite.date_fin = '2010-05-01' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-31' OR (
disponibilite.date_fin = '2010-01-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-01-31' OR (
disponibilite.date_fin = '2010-01-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-30' OR (
disponibilite.date_fin = '2010-09-30' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-19' OR (
disponibilite.date_fin = '2010-06-19' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (44,49,53,72,85) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-16' OR (disponibilite.date_debut='2010-08-16' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-27' OR (
disponibilite.date_fin = '2010-08-27' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-10-02' OR (disponibilite.date_debut='2010-10-02' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-16' OR (
disponibilite.date_fin = '2010-10-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (44,49,53,72,85) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 1 ccar --------------
Alerte => 1 correspondants
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-23' OR (
disponibilite.date_fin = '2010-06-23' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-28' OR (
disponibilite.date_fin = '2010-06-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-14' OR (
disponibilite.date_fin = '2010-07-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-11' OR (
disponibilite.date_fin = '2010-07-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-11' OR (
disponibilite.date_fin = '2010-07-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-18' OR (disponibilite.date_debut='2010-09-18' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-25' OR (
disponibilite.date_fin = '2010-09-25' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 1 ccar --------------
Alerte => 1 correspondants
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-29' OR (disponibilite.date_debut='2010-09-29' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-04' OR (
disponibilite.date_fin = '2010-10-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (25,39,70,90)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-22' OR (
disponibilite.date_fin = '2010-08-22' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-12' OR (
disponibilite.date_fin = '2010-08-12' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-07' OR (
disponibilite.date_fin = '2010-08-07' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (59,62)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-20' OR (disponibilite.date_debut='2010-08-20' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-29' OR (
disponibilite.date_fin = '2010-08-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-20' OR (
disponibilite.date_fin = '2010-08-20' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-04-04' OR (
disponibilite.date_fin = '2010-04-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-16' OR (disponibilite.date_debut='2010-08-16' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-26' OR (
disponibilite.date_fin = '2010-08-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (25,39,70,90)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-04-26' OR (
disponibilite.date_fin = '2010-04-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-20' OR (disponibilite.date_debut='2010-08-20' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-29' OR (
disponibilite.date_fin = '2010-08-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-07' OR (
disponibilite.date_fin = '2010-07-07' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-16' OR (
disponibilite.date_fin = '2010-05-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-06' OR (
disponibilite.date_fin = '2010-08-06' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-06' OR (
disponibilite.date_fin = '2010-08-06' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-01' OR (disponibilite.date_debut='2010-09-01' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2011-06-30' OR (
disponibilite.date_fin = '2011-06-30' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-13' OR (
disponibilite.date_fin = '2010-08-13' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-28' OR (
disponibilite.date_fin = '2010-05-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-04' OR (
disponibilite.date_fin = '2010-06-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-21' OR (disponibilite.date_debut='2010-08-21' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-05' OR (
disponibilite.date_fin = '2010-09-05' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-16' OR (
disponibilite.date_fin = '2010-05-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-13' OR (
disponibilite.date_fin = '2010-06-13' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-13' OR (
disponibilite.date_fin = '2010-06-13' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-23' OR (disponibilite.date_debut='2010-09-23' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-10' OR (
disponibilite.date_fin = '2010-10-10' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-16' OR (
disponibilite.date_fin = '2010-05-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-17' OR (
disponibilite.date_fin = '2010-07-17' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-03' OR (
disponibilite.date_fin = '2010-08-03' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-12' OR (
disponibilite.date_fin = '2010-06-12' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2011-04-16' OR (disponibilite.date_debut='2011-04-16' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2011-04-30' OR (
disponibilite.date_fin = '2011-04-30' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-16' OR (
disponibilite.date_fin = '2010-05-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (25,39,70,90) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-29' OR (
disponibilite.date_fin = '2010-05-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-23' OR (
disponibilite.date_fin = '2010-08-23' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-01' OR (disponibilite.date_debut='2010-09-01' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-15' OR (
disponibilite.date_fin = '2010-09-15' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (67,68)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-29' OR (
disponibilite.date_fin = '2010-05-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (18,28,36,37,41,45) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-04' OR (disponibilite.date_debut='2010-09-04' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-11' OR (
disponibilite.date_fin = '2010-09-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (44,49,53,72,85) AND camping_car.famille = 'fourgon1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-09' OR (
disponibilite.date_fin = '2010-08-09' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-12' OR (
disponibilite.date_fin = '2010-06-12' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-24' OR (
disponibilite.date_fin = '2010-05-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (18,28,36,37,41,45)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-05-24' OR (
disponibilite.date_fin = '2010-05-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (18,28,36,37,41,45)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-02' OR (
disponibilite.date_fin = '2010-08-02' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-11' OR (
disponibilite.date_fin = '2010-07-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-11' OR (
disponibilite.date_fin = '2010-07-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (16,17,79,86) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-22' OR (disponibilite.date_debut='2010-08-22' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-07' OR (
disponibilite.date_fin = '2010-09-07' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-25' OR (
disponibilite.date_fin = '2010-07-25' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-27' OR (
disponibilite.date_fin = '2010-06-27' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-14' OR (disponibilite.date_debut='2010-09-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-26' OR (
disponibilite.date_fin = '2010-09-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-07' OR (
disponibilite.date_fin = '2010-08-07' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (59,62)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-19' OR (disponibilite.date_debut='2010-08-19' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-29' OR (
disponibilite.date_fin = '2010-08-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-19' OR (disponibilite.date_debut='2010-08-19' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-29' OR (
disponibilite.date_fin = '2010-08-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-14' OR (disponibilite.date_debut='2010-09-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-26' OR (
disponibilite.date_fin = '2010-09-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (14,50,61)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-06-21' OR (
disponibilite.date_fin = '2010-06-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-10-01' OR (disponibilite.date_debut='2010-10-01' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-31' OR (
disponibilite.date_fin = '2010-10-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-15' OR (disponibilite.date_debut='2010-08-15' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-22' OR (
disponibilite.date_fin = '2010-08-22' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-15' OR (disponibilite.date_debut='2010-08-15' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-22' OR (
disponibilite.date_fin = '2010-08-22' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-19' OR (disponibilite.date_debut='2010-09-19' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-26' OR (
disponibilite.date_fin = '2010-09-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-06' OR (disponibilite.date_debut='2010-08-06' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-14' OR (disponibilite.date_debut='2010-09-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-26' OR (
disponibilite.date_fin = '2010-09-26' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-10' OR (disponibilite.date_debut='2010-09-10' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-24' OR (
disponibilite.date_fin = '2010-09-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (44,49,53,72,85)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-11' OR (
disponibilite.date_fin = '2010-07-11' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (21,58,71,89)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-31' OR (
disponibilite.date_fin = '2010-07-31' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-27' OR (disponibilite.date_debut='2010-08-27' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-30' OR (
disponibilite.date_fin = '2010-08-30' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (09,12,31,32,46,65,81,82) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-20' OR (
disponibilite.date_fin = '2010-07-20' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-27' OR (
disponibilite.date_fin = '2010-07-27' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-16' OR (
disponibilite.date_fin = '2010-07-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (19,23,87)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-05' OR (disponibilite.date_debut='2010-09-05' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-03' OR (
disponibilite.date_fin = '2010-10-03' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-06' OR (disponibilite.date_debut='2010-09-06' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-20' OR (
disponibilite.date_fin = '2010-09-20' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (44,49,53,72,85)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'fourgon1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'fourgon1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-16' OR (
disponibilite.date_fin = '2010-07-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (54,55,57,88) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-08' OR (
disponibilite.date_fin = '2010-08-08' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 1 ccar --------------
Alerte => 1 correspondants
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-21' OR (
disponibilite.date_fin = '2010-08-21' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-14' OR (disponibilite.date_debut='2010-08-14' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-28' OR (
disponibilite.date_fin = '2010-08-28' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-04' OR (
disponibilite.date_fin = '2010-09-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-04' OR (
disponibilite.date_fin = '2010-09-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (59,62) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-04' OR (
disponibilite.date_fin = '2010-09-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-04' OR (
disponibilite.date_fin = '2010-09-04' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-08' OR (disponibilite.date_debut='2010-08-08' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-18' OR (
disponibilite.date_fin = '2010-07-18' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (18,28,36,37,41,45) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-13' OR (disponibilite.date_debut='2010-08-13' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-19' OR (
disponibilite.date_fin = '2010-08-19' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'autre1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-03' OR (disponibilite.date_debut='2010-08-03' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-24' OR (
disponibilite.date_fin = '2010-07-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (04,05,06,13,83,84)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-16' OR (disponibilite.date_debut='2010-08-16' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-22' OR (
disponibilite.date_fin = '2010-08-22' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (02,60,80)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-13' OR (disponibilite.date_debut='2010-08-13' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-07-23' OR (
disponibilite.date_fin = '2010-07-23' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (75,77,78,91,92,93,94,95)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-26' OR (disponibilite.date_debut='2010-08-26' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-09-01' OR (
disponibilite.date_fin = '2010-09-01' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-09' OR (disponibilite.date_debut='2010-08-09' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-15' OR (
disponibilite.date_fin = '2010-08-15' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (11,30,34,48,66) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-09' OR (disponibilite.date_debut='2010-08-09' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (14,50,61)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-09' OR (disponibilite.date_debut='2010-08-09' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (14,50,61) AND camping_car.famille = 'capucine1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-07' OR (disponibilite.date_debut='2010-08-07' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-14' OR (
disponibilite.date_fin = '2010-08-14' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (59,62)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-09-26' OR (disponibilite.date_debut='2010-09-26' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-10-24' OR (
disponibilite.date_fin = '2010-10-24' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (01,07,26,38,42,69,73,74) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-08' OR (disponibilite.date_debut='2010-08-08' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-08' OR (disponibilite.date_debut='2010-08-08' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-16' OR (
disponibilite.date_fin = '2010-08-16' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (27,76)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-21' OR (disponibilite.date_debut='2010-08-21' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-29' OR (
disponibilite.date_fin = '2010-08-29' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64) AND camping_car.famille = 'profile1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-08' OR (disponibilite.date_debut='2010-08-08' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-15' OR (
disponibilite.date_fin = '2010-08-15' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-08' OR (disponibilite.date_debut='2010-08-08' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-15' OR (
disponibilite.date_fin = '2010-08-15' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (24,33,40,47,64)
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------
--------------------------------------------------
SELECT * FROM disponibilite
INNER JOIN camping_car ON camping_car.id_camping_car = disponibilite.id_camping_car
WHERE disponibilite.deleted != 1 AND ISNULL(id_reservation) AND ((disponibilite.date_creation >= "2010-07-31 00:00:00" AND disponibilite.date_creation <= "2010-07-31 23:59:59") OR (disponibilite.date_modif >= "2010-07-31 00:00:00" AND disponibilite.date_modif <= "2010-07-31 23:59:59")) AND (disponibilite.date_debut < '2010-08-15' OR (disponibilite.date_debut='2010-08-15' AND disponibilite.debut_am = 1 )) AND (disponibilite.date_fin > '2010-08-20' OR (
disponibilite.date_fin = '2010-08-20' AND disponibilite.fin_pm = 1 ))AND camping_car.visible = 1 AND camping_car.departement IN (22,29,35,56) AND camping_car.famille = 'integral1'
--------------------------------------------------
----------- Resulat trouvés : 0 ccar --------------