Location ›

Autres

›

Lancez votre recherche pour voir les annonces.

Indiquer un code postal ou une ville

Poster une annonce

Se connecter S'inscrire

i18n

Chambre étudiante chez l habitant (2 semaines)

Location Chambre en colocation Location chambre en colocation entre particuliers (59)

Discuter

Ce voisin demande à louer à Bailleul (59270)

200€/Faire offre

1 annonce

Prix

200€/Faire offre

Description de l'annonce

Bonjour., étudiante en alternance 15 jours par mois sur Bailleul, je suis à la recherche d une chambre chez l habitant pendant 2 semaines par mois du dimanche soir au vendredi matin.
#chambre en colocation

Annonces similaires

Tout voir

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UNE CHAMBRE à LOUER (11 MOI

Lucie D

Lille 59000

330€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

LOUER UNE CHAMBRE CHEZ UN PARTICULIER

Voisin #52014

Dunkerque 59140

20€/^nuit

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE à LOUER

Elisabeth D

Bailleul 59270

370€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE

Anthony

Bruay-la-Buissière 62700

400€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

éTUDIANTE CHERCHE LOCATION CHAMBRE

Lilou G

Lille 59000

150€

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE à LOUER

Voisin #77833

Armentières 59280

163€/^sem

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT GRATUIT !

Félice W

Lille 59800

-- €

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE à L'ANNéE REXPOIDE

Patrice B

Rexpoëde 59122

-- €

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

POUR VISITER (2 NUITS)

Nicolas S

Ronchin 59790

60€

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CHEZ L'HABITANT (3 MOIS)

Jean L

Bailleul 59270

700€

Louer une chambre entre particuliers ou proposer une chambre en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0002
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='629787'
0.0001
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1
0.0001
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='193'
0.0001
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='516033' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 516033
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
0.0002
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
0.0004
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
0.0003
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
0.0003
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 629787
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='629787'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='629787' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 516033 AND util_tel != ''
0
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 516033 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
0.0001
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 516033 AND W.type_id = 1) OR (W.util_id != 516033 AND W.type_id = 2)) AND (`post_util_id` = 516033 OR `dest_util_id` = 516033) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='516033' AND note_visu IN (1,3,4)
0.0001
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '629787'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='516033' AND wish_id<>'629787' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59270'
0.0042
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.7333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.7333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.73333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.283639197041 AND ville_latitude_deg<51.182960802959 AND ville_longitude_deg>2.0228806632822 AND ville_longitude_deg<3.4437793367178 HAVING distance <= 50 ORDER BY distance ASC
0.0029
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (59270,59270,59270,59270,59181,59940,59270,59270,59270,59299,59850,59232,59190,59270,59190,62840,59193,59940,59190,59114,59940,62840,59253,62840,59280,59114,59930,59660,59114,62136,59116,59280,59190,59236,59890,62350,59560,59190,59190,59114,59670,59249,62136,59134,62136,59249,59670,62840,62136,62350,59190,59840,62350,59840,62350,59320,59670,59890,59670,62840,59160,59320,62350,59670,59189,62400,59470,59320,59320,62350,59670,59237,59134,59134,59480,59320,59670,59190,59840,62232,59134,59560,59173,62149,59134,59320,62400,59189,59670,59211,59189,59470,59320,62330,62920,59670,59173,59122,62920,59274,62138,59470,59117,59136,62350,59480,59670,62149,59118,59320,59130,59350,62400,59496,59173,59184,62232,62232,59173,62330,59120,59320,62149,59272,59496,59520,62660,62138,62138,59670,62120,59126,59250,59223,59470,59285,59166,59470,62138,62190,62920,59670,59110,62232,62190,59700,59173,62232,62138,62149,62149,59000,59800,59160,62120,59777,59350,59139,62113,62113,62120,59910,59380,59147,59122,59221,62199,59112,62113,59263,62122,62120,62131,59470,62131,59147,59251,62120,62190,59185,62196,62131,59380,62157,62120,62980,62980,59139,62122,62120,62410,62190,62290,62120,59370,59147,59420,62410,59122,62410,62120,62120,62120,59155,62120,62620,62410,62190,62120,59175,59380,59285,62151,59285,62540,59112,59493,59650,59491,59655,59113,59960,59200,59122,62670,62120,59790,62120,59470,59133,59175,59260,62540,59380,62190,62190,59170,59290,62120,62500,59100,62145,62700,62120,62880,59133,59470,59380,62620,62880,62880,62940,62160,62510,62750,62114,59810,59470,62120,62120,62575,62530,62260,59143,59380,62220,62880,62260,59470,62129,62620,59470,62260,59551,62260,62575,62470,62190,59143,62129,59380,59710,62620,62160,59380,62550,62470,59510,62440,62550,62145,62960,62960,62460,59122,62500,62300,62550,59510,59380,59492,62570,59150,59239,62820,59380,62550,62590,62710,62150,59390,59630,62218,62221,59143,59262,59273,62129,59390,59470,59261,62550,62150,62219,62143,62500,62570,62150,62160,62800,62550,62500,62145,62172,62550,59239,62300,62530,59273,59143,62740,59551,62129,59284,62145,59830,59390,59710,59390,59229,59152,59152,62460,59710,62640,59143,62550,62570,62430,59152,62150,62150,59115,62570,62960,59780,59380,62550,62420,59152,62550,62530,62150,59710,62150,62129,62500,62219,62500,62960,62210,62119,59242,59229,59254,62960,62110,59162,62690,59143,62910,62680,59495,59246,59630,62550,59380,59830,62550,59830,62150,62460,62380,59242,62153,62153,62144,62580,62910,59380,62134,59780,62950,62150,62141,59143,59630,62129,62690,62960,62380,62500,59283,59180,59780,62127,62550,62380,62320,62690,59235,62970,59630,59123,62910,62127,62380,62320,59242,62960,59830,59210,62790,59830,59310,62690,62320,62320,62144,62130,62500,62380,62580,62690,62560,59283,62910,62960,59950,59123,62580,62134,59830,62580,62550,62500,62550,62910,62380,62690,62560,62134,62380,62380,62580,62144,62127,59830,62134,59630,62580,62130,62560,59286,62144,59310,62690,62690,62580,62380,59128,62580,62690,62490,62370,59430,59140,59640,59279,59240,59279,62690,62690,62130,62134,62580,62910,62310,62130,62134,62127,62490,59630,62580,62690,62223,62130,62500,59760,62310,59310,62134,62310,59553,59553,62127,62690,62144,62560,62560,59194,62890,62134,62580,62890,62890,62560,62380,62127,59553,59310,59310,62310,59279,62580,62130,62380,62370,59310,62134,62127,62690,62223,62370,62161,62161,62134,62223,59148,62890,62490,62310,62310,62134,62310,62310,62560,62890,59500,62127,62380,59194,59119,62130,59820,62690,62127,62130,62130,62310,59310,62127,62490,62380,62130,62130,62380,59552,62560,62134,62223,62223,62161,62161,62223,62690,59552,62370,62370,62123,62223,62310,59310,62117,62130,62310,62890,62123,62123,62890,59450,62134,62134,62123,62127,62380,62130,62118,62380,59870,62134,62370,59167,59310,62130,62310,62162,62112,62118,62380,62560,62130,62560,62118,62810,62310) AND fami_id='5' AND cate_id='193' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='505' AND wish_id<>'629787' AND wish_url='' ORDER BY rand() LIMIT 0,10
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83882 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 83882 AND W.type_id = 1) OR (W.util_id != 83882 AND W.type_id = 2)) AND (`post_util_id` = 83882 OR `dest_util_id` = 83882) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 83882
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=52014 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 52014 AND W.type_id = 1) OR (W.util_id != 52014 AND W.type_id = 2)) AND (`post_util_id` = 52014 OR `dest_util_id` = 52014) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 52014
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=373325 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 373325 AND W.type_id = 1) OR (W.util_id != 373325 AND W.type_id = 2)) AND (`post_util_id` = 373325 OR `dest_util_id` = 373325) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 373325
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=514057 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 514057 AND W.type_id = 1) OR (W.util_id != 514057 AND W.type_id = 2)) AND (`post_util_id` = 514057 OR `dest_util_id` = 514057) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 514057
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=387633 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 387633 AND W.type_id = 1) OR (W.util_id != 387633 AND W.type_id = 2)) AND (`post_util_id` = 387633 OR `dest_util_id` = 387633) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 387633
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77833 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 77833 AND W.type_id = 1) OR (W.util_id != 77833 AND W.type_id = 2)) AND (`post_util_id` = 77833 OR `dest_util_id` = 77833) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 77833
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477222 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 477222 AND W.type_id = 1) OR (W.util_id != 477222 AND W.type_id = 2)) AND (`post_util_id` = 477222 OR `dest_util_id` = 477222) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 477222
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=213106 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 213106 AND W.type_id = 1) OR (W.util_id != 213106 AND W.type_id = 2)) AND (`post_util_id` = 213106 OR `dest_util_id` = 213106) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 213106
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=458896 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 458896 AND W.type_id = 1) OR (W.util_id != 458896 AND W.type_id = 2)) AND (`post_util_id` = 458896 OR `dest_util_id` = 458896) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 458896
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=286065 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 286065 AND W.type_id = 1) OR (W.util_id != 286065 AND W.type_id = 2)) AND (`post_util_id` = 286065 OR `dest_util_id` = 286065) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 286065
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505
0.001
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0
SELECT count(*) as nbwish FROM wish
0.0494
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

85 requetes sql en 0.0676

Taille variable Globale : 78.88 KB