Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche logement contre services, 2 mois

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICES (5 MOIS)
Profil du voisin
Voisin #420897

Lille 59000

1150€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CONTRE SERVICES (10 MOIS)
Profil du voisin
Sarah L

Roubaix 59100

120€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CONTR SERVICE
Profil du voisin
Voisin #470488

Lille 59000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE HéBERGEMENT CONTRE SERVICE
Profil du voisin
Fabien C

Lille 59000

100€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE D'UN LOGEMENT à PARTIR DE MAI
Profil du voisin
Voisin #422203

Lille 59000

460€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICE
Profil du voisin
Voisin #71513

Lille 59000

308€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICES
Profil du voisin
Abdourahim M

Lille 59000

210€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE PARTOUT EN FRANCE CONTRE SERVICE
Profil du voisin
Camelia C

Lille 59000

99€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE URGENT LOCATION CONTRE SERVICES
Profil du voisin
Yarou

Lille 59000

100€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

BESOIN D’UNE CHAMBRE
Profil du voisin
Blandine B

Lille 59000

150€/m

Louer contre service entre particuliers ou proposer contre service en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 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='384603'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='logement-contre-service' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='506'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'logement-contre-service' LIMIT 1

  5. 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'

  6. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='202768' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 202768

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0001

    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

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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 (93) ORDER BY ssrubr_order ASC

  25. 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

  26. 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 (91) ORDER BY ssrubr_order ASC

  27. 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

  28. 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

  29. 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 = 384603

  30. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=506 LIMIT 1

  31. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='384603'

  32. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='384603' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  33. 0.0001

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 202768 AND util_tel != ''

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 202768 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  35. 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 = 202768 AND W.type_id = 1) OR (W.util_id != 202768 AND W.type_id = 2)) AND (`post_util_id` = 202768 OR `dest_util_id` = 202768) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='202768' AND note_visu IN (1,3,4)

  37. 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 = '384603'

  38. 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='202768' AND wish_id<>'384603' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59500'

  40. 0.0056

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.361723505516 AND ville_longitude_deg<3.771616494484 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0042

    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 (59500,59552,59553,59553,59552,59553,59450,59169,59128,62112,59187,59119,62117,59950,59286,62112,62490,62490,59169,59287,62970,59194,59169,62490,59194,59167,59182,59287,62790,59151,59283,62490,62141,62950,59169,62490,59182,59169,59283,59151,62119,59151,59162,59151,62490,59176,62118,62490,62490,59148,62320,59146,62320,62580,59176,62110,59234,62118,62860,59259,62320,62640,59310,59151,62156,59870,59165,62590,62156,59246,62740,62118,59234,62860,62860,59490,62580,59239,62860,62420,62320,62580,59261,62860,59265,59310,62710,59234,62820,62860,62156,62580,59580,62156,62118,59580,62580,59235,59870,62118,62680,62220,59265,62156,59239,59551,59870,62118,62440,62860,62430,59710,62860,59490,62880,62156,59247,62580,62580,59870,59252,62218,62221,59310,62156,59247,59310,62118,62182,59179,62860,62580,59551,62860,62860,62210,59252,59215,59133,59710,62880,62880,62182,59247,59133,62580,59171,62223,62880,59252,59870,62300,59242,59112,59265,59172,62223,62128,59265,62128,62860,59710,62300,62182,62860,59310,59171,59111,59554,62580,59710,59265,59870,62128,59147,59870,59310,62410,59185,62128,59268,59242,59554,59111,62410,59310,59295,59295,59251,59178,62182,62223,59172,59124,59554,59113,62128,59554,59112,59156,62223,59273,59111,62217,59310,62410,59230,59221,59147,62860,59171,62580,59242,62580,59141,59178,59147,62223,59293,62138,62128,59400,59554,62410,62800,62223,62217,62750,59230,62000,62128,59175,62860,59175,62860,59830,62153,62223,59161,62128,59310,59263,62860,59220,59690,59310,59272,59111,62217,62128,62128,62143,59178,59141,62223,59496,59273,59400,59161,62138,59141,59184,59830,59554,59135,59282,59255,59226,62217,62217,62217,59155,62147,59139,59267,59282,59139,59810,59400,62128,59136,59830,62128,59178,59496,59274,59830,62147,59161,62153,59262,59220,59267,62138,59400,62175,62160,59830,62159,62128,62128,59830,62160,59296,59135,59790,62144,59195,62144,62138,59226,62147,59220,59161,59134,59830,59320,59480,62000,62160,59320,62161,59121,62161,59159,62980,59134,59230,62121,59211,62124,59195,62138,59780,62175,59134,59277,59400,59152,59152,59480,59400,62121,59121,62147,62149,62147,62173,62149,59494,62217,62980,59260,59120,59267,59152,59134,59198,62159,59281,59224,62161,62147,62175,62670,62149,62144,62124,59320,59320,62159,59400,62124,62114,62149,62172,59188,59780,59159,59129,62175,62161,59158,59320,59320,62124,62121,59494,59590,59174,62144,59000,59800,59777,59350,59160,59320,59152,59241,62530,59159,59224,62123,59158,62113,62113,62173,59188,62840,59217,62121,62530,62175,59125,59249,62450,59320,59233,62124,62123,59134,62450,59230,59410,62690,59370,59249,59510,59320,59192,62121,59400,62121,62690,59158,62530,62144,59227,59227,62173,59400,62290,59230,62149,62840,59110,62147,59130,62123,59227,62123,62124,62450,62660,59231,59780,62173,59292,59188,62690,62113,62690,62124,62690,59400,62121,59217,59217,59160,59158,59258,62450,59300,62116,59840,59199,59350,59213,62123,62123,62121,59510,59258,62124,59217,62450,59390,62136,62116,62123,62123,59300,59860,59300,62690,62620,59269,62450,62124,62124,59214,62116,59700,62450,62150,59157,59258,62124,59840,59199,62116,62690,59213,62123,59290,59170,62123,59294,62450,62131,59280,62131,62131,62450,59840,62123,59880,62690,62121,59770,59157,59520,62620,62136,62450,59127,62124,59266,62150,62690,62400,62111,59390,62123,59269,59118,59390,59231,62136,59390,62690,62620,59970,59237,62810,62840,59213,59213,59655,59491,59493,59650,62450,62150,59231,62124,62121,62400,59191,59278,59990,62124,62123,59540,59730,62232,62400,62620,62940,62123,62450,62196,62450,62450,62840,59266,59269,62690,62123,62690,62116,59540,62450,59990,62690,62232,62232,59730,62232,59730,62150,62150,59191,80360,59730,59930,59910,62810,80300,80360,59271,59420,59970,59213,59213,59990,62810,59280,59115,80360,59297,59100,59163,62810,62690,59266,59264,59990,62690,80300,59730,62840,62111,80360,59990,59191,62199,62116,80300,80240,59970,59127,62690,59530,59193,62158,59116,59150,80360,59940,59225,62920,62136,62232,62700,62150,62810,80360,59540,80122,62111,62111,62450,62810,62158,59243,62122,62127,59890,59200,62111,59253,59144,59225,80360,59127,59530,80360,62450,02420,62810,59540,62158,62920,59127,59236,62150,59530,80300,80300,62111,62158,02420,62127,59850,62127,80360,59142,59126,59250,59223,80240,80240,62150,62810,59730,80240,80740,59980,59218,59218,59127,59360,59163,62810,62122,59990,62127,62127,59990,80360,62350,62111,62127,59890,62460,59980,62540,59154,62150,59530,62158,59144,59530,62920,62760,59218,59181,80360,59218,62350,59530,80360,80360,59940,59163,62460,80300,59920,59660,80112,02420,80300,62450,02420,59530,62810,62127,62111,59144,59960,59940,62760,59560,59980,59980,59238,80740,80760,02420,59144,80300,59980,62470,62810,62540,62810,62127,62127,59222,80300,62350,59222,02420,80200,02110,62127,59144,62157,59360,62111,80560,62158,62460,02110,62470,80240,59166,59117,80240,80560,59360,59530,80240,59560,80300,59530,59144,62810,80240,59530,62760,80560,62127,62350,62260,62127,62810,59530,62810,59530,62130,80560,62158,80300,62810,80300,80300,02420,80360,62350,62810,62350,59222,62760,62760,62760,80300,80560,62260,62127,59530,80360,59530,59360,62151,80240,59570,62127,80600,80240,02110,80300,80200,62270,80300,59137,62190,62760,59550,62550,59288,80560,02420,80200,59270,02420,59360,62550,62810,62550,62130,62127,80560,59144,80360,80300,62550,02420,80360,62810,59550,62350,80560,59232,62760,59270,80200,02420,59360,80240,80240,59144,62810,80300,80300,02110,59270,80240,80200,02110,59360,80300,80560,80240,62130,62130,02490,62130,59570,02490,80200,59570,62190,62130,80200,80360,02110,59570,80560,62260,62550,62190,62270,80200,02420,59270,62810,62130,62330,80600,59530,62130,59570,02110,62760) 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='506' AND wish_id<>'384603' AND wish_url='' ORDER BY rand() LIMIT 0,10

  42. 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='506' LIMIT 0,1

  43. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420897 AND note_visu IN (1,3,4)

  44. 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 = 420897 AND W.type_id = 1) OR (W.util_id != 420897 AND W.type_id = 2)) AND (`post_util_id` = 420897 OR `dest_util_id` = 420897) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 420897

  46. 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='506' LIMIT 0,1

  47. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=543097 AND note_visu IN (1,3,4)

  48. 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 = 543097 AND W.type_id = 1) OR (W.util_id != 543097 AND W.type_id = 2)) AND (`post_util_id` = 543097 OR `dest_util_id` = 543097) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 543097

  50. 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='506' LIMIT 0,1

  51. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=470488 AND note_visu IN (1,3,4)

  52. 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 = 470488 AND W.type_id = 1) OR (W.util_id != 470488 AND W.type_id = 2)) AND (`post_util_id` = 470488 OR `dest_util_id` = 470488) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 470488

  54. 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='506' LIMIT 0,1

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=209167 AND note_visu IN (1,3,4)

  56. 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 = 209167 AND W.type_id = 1) OR (W.util_id != 209167 AND W.type_id = 2)) AND (`post_util_id` = 209167 OR `dest_util_id` = 209167) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 209167

  58. 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='506' LIMIT 0,1

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=422203 AND note_visu IN (1,3,4)

  60. 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 = 422203 AND W.type_id = 1) OR (W.util_id != 422203 AND W.type_id = 2)) AND (`post_util_id` = 422203 OR `dest_util_id` = 422203) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 422203

  62. 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='506' LIMIT 0,1

  63. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=71513 AND note_visu IN (1,3,4)

  64. 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 = 71513 AND W.type_id = 1) OR (W.util_id != 71513 AND W.type_id = 2)) AND (`post_util_id` = 71513 OR `dest_util_id` = 71513) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  65. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 71513

  66. 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='506' LIMIT 0,1

  67. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490890 AND note_visu IN (1,3,4)

  68. 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 = 490890 AND W.type_id = 1) OR (W.util_id != 490890 AND W.type_id = 2)) AND (`post_util_id` = 490890 OR `dest_util_id` = 490890) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  69. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 490890

  70. 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='506' LIMIT 0,1

  71. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=139682 AND note_visu IN (1,3,4)

  72. 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 = 139682 AND W.type_id = 1) OR (W.util_id != 139682 AND W.type_id = 2)) AND (`post_util_id` = 139682 OR `dest_util_id` = 139682) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  73. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 139682

  74. 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='506' LIMIT 0,1

  75. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=401155 AND note_visu IN (1,3,4)

  76. 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 = 401155 AND W.type_id = 1) OR (W.util_id != 401155 AND W.type_id = 2)) AND (`post_util_id` = 401155 OR `dest_util_id` = 401155) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  77. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 401155

  78. 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='506' LIMIT 0,1

  79. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317838 AND note_visu IN (1,3,4)

  80. 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 = 317838 AND W.type_id = 1) OR (W.util_id != 317838 AND W.type_id = 2)) AND (`post_util_id` = 317838 OR `dest_util_id` = 317838) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  81. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 317838

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  83. 0.0008

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  84. 0

    SELECT count(*) as nbwish FROM wish

  85. 0.0466

    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.0674

Taille variable Globale : 78.91 KB