Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Logement contre service

Autres annonces du voisin

Tout voir
Déménageur avec fourgon
Service : avec fourgon

Demande il y a + de 30j

Il y a + de 30j • 93380

Petit déménagement
Profil du voisin
Imane E

Pierrefitte-sur-Seine 93380

-- €

Proposer mes services

Annonces similaires

Tout voir
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 75001

Jeune etudiant recherche colocation
Profil du voisin
Voisin #79483

Paris 75001

-- €

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 92700

Cherche un studio contre services
Profil du voisin
Voisin #534942

Colombes 92700

400€/m

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 95210

Demande service contre le logement
Profil du voisin
Caroline G

Saint-Gratien 95210

220€/m

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 75000

Bienveillante, aime aider les autres. (1
Profil du voisin
Serena P

Paris 75000

175€

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 95100

Maman isolée étudiante
Profil du voisin
Khaina A

Argenteuil 95100

230€/m

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 77100

Je cherche en urgence un logement (2 moi
Profil du voisin
Kilian P

Nanteuil-lès-Meaux 77100

150€

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 93800

Recherche hébergement contre services
Profil du voisin
Eva N

Epinay-sur-Seine 93800

400€

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 75000

Recherche logement contre services
Profil du voisin
Julia A

Paris 75000

150€/m

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 75000

Recherche logement contre service (3 moi
Profil du voisin
Justin M

Paris 75000

-- €

Louer ma chambre
Location logement contre service
Location : logement contre service

Demande il y a + de 30j

Il y a + de 30j • 77420

Cherche logement contre service
Profil du voisin
Voisin #54593

Champs-sur-Marne 77420

-- €

Louer ma chambre

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='304408'

  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, 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='13'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='98583' 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` = 98583

  9. 0

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

  12. 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 (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.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 (83) ORDER BY ssrubr_order ASC

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

  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.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 (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 = 304408

  30. 0.0001

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

  31. 0.0001

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

  32. 0

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

  33. 0

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

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

  35. 0.0001

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

  36. 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 = '304408'

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

  38. 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='948' LIMIT 0,1

  39. 0.0001

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

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

  41. 0.0001

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

  42. 0.0001

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

  43. 0.0057

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.6817239280719 AND ville_longitude_deg<3.0516160719281 HAVING distance <= 50 ORDER BY distance ASC

  44. 0.0062

    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 (93380,95360,93430,95410,93240,95170,95140,95880,95350,93200,93210,95400,95200,95400,93440,95160,92390,93450,93800,95500,95230,93350,93120,93300,95350,95440,95210,95218,95580,95580,92230,95500,95600,93700,93150,95720,95460,95120,95330,93500,93400,95500,95680,95720,95110,92600,95100,92110,95190,95390,92270,95500,95570,95720,95570,93310,92300,93000,95130,92700,95320,93140,95130,95570,93260,93230,95190,93600,92250,92400,95720,95700,95870,93170,95560,95560,92200,93130,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,93100,95560,95850,93420,95380,95240,95840,95190,93270,95570,95270,95150,95550,93320,93340,95250,78800,95530,93250,95560,95270,78500,95370,94300,95380,93110,92000,95590,95850,95740,78420,93190,93390,95840,92800,92150,95270,95220,93410,94160,95380,95380,93220,92500,93290,94120,92170,93360,95480,78600,95270,95270,95670,94170,95380,93370,95540,95270,94270,94200,94205,77181,78360,93470,95270,94250,92120,94220,95270,95470,92100,94130,95590,95270,92240,77990,92210,95430,95630,93330,78600,77990,94410,92130,94340,77290,95470,95430,78400,93460,94360,95270,94800,95270,77270,95270,94110,94140,77181,95590,95760,92220,94700,95290,92380,77500,95260,92320,95470,93160,78700,78110,92190,92360,95260,92140,95620,94500,95470,94350,95610,92410,77230,78290,78380,95660,92430,92420,77230,95310,78170,78560,94240,94230,94400,94231,94232,94233,94234,94235,94236,94237,94238,94239,92310,77230,78230,94100,94210,94340,60260,92260,92330,78430,77420,77410,60560,94430,95300,77177,92340,60580,95340,92350,94000,60128,77410,78260,78570,78100,60520,92370,94420,77290,78780,94320,94550,60820,95300,95820,94600,95300,77230,95000,78750,95340,95690,78140,95000,92290,77186,78300,77360,78160,77185,78150,78220,78150,77230,78112,60230,94380,60128,94150,94310,94390,77410,95690,60270,94260,60520,94490,94880,94880,77410,78570,77410,78955,77200,78870,95300,95520,92160,78620,77230,77184,95340,60530,77230,77400,95280,95690,91370,94460,78000,94370,94380,77230,95490,95650,78240,78590,77340,77400,60520,95690,94510,60460,95810,91320,77230,77410,94290,60530,77090,77183,91570,94470,77280,77600,78350,77400,78240,91300,94190,95650,77400,78510,78670,78670,60530,60500,77410,95650,77400,60500,94450,77230,95000,60950,78590,95810,60330,77600,77600,95800,91550,77680,77230,77400,91200,60340,78540,78350,78530,60340,60530,94480,78480,60540,60540,95810,91430,77400,60530,60740,91560,60460,77600,95180,78330,78630,60300,60300,91430,78860,78210,77230,91120,77410,94440,77165,60540,91330,77164,78450,95810,77165,78740,95650,95650,77450,91420,91400,91270,95810,77600,60530,91380,91160,77144,78117,91230,60540,94440,60300,77410,77410,95830,91160,60950,77230,77135,77165,77165,77410,77144,77700,60330,95450,60530,91140,78450,78740,95810,91800,77330,78280,78810,95450,77450,60110,94440,95830,91260,60300,60540,60660,78390,78130,77450,60110,77600,91210,77150,95450,78630,60160,77170,60300,60300,60300,91160,60300,77150,78117,77165,77700,60300,95810,91400,94520,94520,78340,91190,60950,95640,60330,95450,78920,91140,78121,78180,78130,91440,77450,77700,60300,91190,78250,78580,95640,60660,60660,91860,91170,91390,91600,60660,60660,78960,91360,77178,95450,91360,78810,78190,77450,60160,91800,91160,78114,78410,60180,95450,60110,78250,60100,77124,77122,78250,77450,95640,77178,60570,77700,60119,78370,60730,60300,95640,78470,91940,77450,60330,91480,78250,91350,60700,77450,78850,60810,60250,91000,91130,77173,91480,91700,95640,95640,60730,78250,95640,95450,60730,91450,77174,91940,91190,60570,60240,91620,60440,77700,78580,60175,60810,78470,60870,60119,95450,77380,91940,77170,77165,77165,78470,78410,77860,91620,77124,77100,77124,60440,60440,78990,77100,78580,95450,60550,60810,60110,77580,91700,60660,60250,91700,78640,95450,60730,78124,77220,91240,60290,91090,91310,91000,78460,95640,77860,78124,78410,60119,77220,77124,60290,91310,91450,91310,78820,95450,78126,77174,78640,60730,91400,77910,95450,78580,60173,91250,91460,77166,77139,78250,77860,60810,95750,91640,60870,60440,95450,60440,78650,78440,78320,91070,60250,78410,78410,60440,91080,78640,91220,91220,77910,60250,91470,77220,78320,77100,77139,95450,60240,60870,60290,77127,77220,60140,78310,78760,77166,91310,91250,60149,60810,91470,78720,78440,60940,91280,78640,78680,60110,60800,60570,60700,78440,60940,78720,77580,77580,78440,60810,78460,95750,77610,60700,60430,78310,60290,60240,91470,91090,60290,60940,77580,78770,60790,78320,60790,77580,77170,77470,78970,60140,77910,95420,77139,78440,60440,60250,91100,91180,60240,77220,78770,78650,77470,78490,60140,91250,95420,95450,60810,77139,78440,91640,77580,60800,60240,60790,60410,77111,91470,77390,78720,78490,60700,60240,60700,60790,77550,60430,91680,60250,77470,60240,60440,60290,60250,60240,77910,78440,60800,77470,78690,77163,78770,78770,77610,60240,60250,78440,78490,78490,78580,91640,60140,91100,60250,77580,91290,78770,91290,60790,91470,77111,60410,60790,60430,60140,95420,60240,91680,77610,78440,78930,95510,91520,91340,78690,78770,95420,77470,78930,60240,60240,77580,60410,60430,77610,60240,78720,91810,91540,60620,60250,60800,91630,77440,60700,77163,78490,77550,77550,91640,77440,78440,91540,91540,91630,60600,78770,60370,60620,60620,95420,95420,77470,91630,77176,77163,78490,78490,60370,91630,77550,77470,78490,60430,60370,91250,91830,78440,77139,60410,60240,60240,60140,77390,60800,60240,77610,78490,60700,78830,78610,60620,78520,95510,91710,60700,60600,95420,60240,60600,91540,91530,78930,91650,60320,60240,60600,60840,60800,60240,91650,78790,78790,91630,77610,77580,77515,60800,60600,77610,60410,60620,95420,60410,60430,77580,77176,77390,77390,78830,60600,60390,60710,78200,78711,77440,78200,77660,78930,77440,95510,77440,77580,60134,91790,78940,77240,60800,78520,91650,60390,60134,78930,60620,77950,91470,60620,78720,60430,78610,78890,78910,77240,95420,77240,91770,78490,78790,60600,91750,60710,60800,60240,60129,95510,77390,60190,78910,95420,77390,60240,60240,77660,60390,60240,78910,78125,78930,78930,60800,60190,60190,91830,77440,77440,60680,60390,95420,60240,91610,77950,60930,91730,78520,77515,77580,60320,60620,60320,60320,77390,77950,91530,60126,60390,60190,91530,77145,95780,77540,77515,78940,78200,60620,77310,60240,60190,78610,77440,77440) 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<>'304408' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  46. 0.0001

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

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

  48. 0.0001

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

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

  50. 0.0001

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

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

  52. 0.0001

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

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

  54. 0.0001

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

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

  56. 0.0001

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

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

  58. 0.0001

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

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

  60. 0.0001

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

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

  62. 0.0001

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

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

  64. 0.0001

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

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

  66. 0.0001

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

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

  68. 0.0001

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

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

  70. 0.0001

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

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

  72. 0.0001

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

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

  74. 0.0001

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

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

  76. 0.0001

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

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

  78. 0.0001

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

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

  80. 0.0001

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

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

  82. 0.0001

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

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

  84. 0.0001

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

  85. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  86. 0.0009

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

  87. 0

    SELECT count(*) as nbwish FROM wish

  88. 0.0496

    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

88 requetes sql en 0.0716

Taille variable Globale : 79.34 KB