Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Au secours

Autres annonces du voisin

Tout voir
Service aide personne
Service : aide personne

Demande il y a + de 30j

Il y a + de 30j • 78560

Service : au secours
Profil du voisin
Christian A

Le Port-Marly 78560

20€/h

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 • 75004

Cherche logement contre services
Profil du voisin
Fanny B

Paris 75004

-- €

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

Demande il y a + de 30j

Il y a + de 30j • 91550

Garde enfants, aide au domicile & senior
Profil du voisin
Eunice S

Paray-Vieille-Poste 91550

11€/m

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

Demande il y a + de 30j

Il y a + de 30j • 94200

Logement pour un long sejour
Profil du voisin
Simplice K

Ivry-sur-Seine 94200

350€/m

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

Demande il y a + de 30j

Il y a + de 30j • 78120

Aide au logement pour une formation (6 m
Profil du voisin
Voisin #254795

Sonchamp 78120

200€

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

Demande il y a + de 30j

Il y a + de 30j • 75011

Cherche solution d'hébergement chez une
Profil du voisin
Julie C

Paris 75011

-- €

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

Demande il y a + de 30j

Il y a + de 30j • 75018

Mezzanine en colocation a montare
Profil du voisin
Voisin #385973

Paris 75018

250€/m

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

Demande il y a + de 30j

Il y a + de 30j • 75000

Hébergement contre service., (15 mois)
Profil du voisin
Voisin #549552

Paris 75000

-- €

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

Demande il y a + de 30j

Il y a + de 30j • 94800

Cherche chambre à  louer contre servic
Profil du voisin
Nathalie T

Villejuif 94800

215€/m

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

Demande il y a + de 30j

Il y a + de 30j • 91000

Besoin urgent logement (2 mois)
Profil du voisin
Héléna

Evry 91000

460€

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

Demande il y a + de 30j

Il y a + de 30j • 78160

Offre de services contre hébergement
Profil du voisin
Noe F

Marly-le-Roi 78160

100€

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

  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

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

  7. 0.0001

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

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

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

  20. 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 (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.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.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 = 541955

  30. 0.0001

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

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='541955' 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` = 384581 AND util_tel != ''

  33. 0

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

  34. 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 = 384581 AND W.type_id = 1) OR (W.util_id != 384581 AND W.type_id = 2)) AND (`post_util_id` = 384581 OR `dest_util_id` = 384581) 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='384581' 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 = '541955'

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

  41. 0.0003

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

  42. 0.0001

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

  43. 0.0087

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.11667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.4328668758251 AND ville_longitude_deg<2.8004731241749 HAVING distance <= 50 ORDER BY distance ASC

  44. 0.0077

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

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

  48. 0.0003

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

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

  52. 0.0002

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

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

  56. 0.0002

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

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

  60. 0.0002

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

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

  64. 0.0002

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

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

  68. 0.0002

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

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

  72. 0.0002

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

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

  76. 0.0002

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

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

  80. 0.0002

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

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

  84. 0.0002

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

  85. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  86. 0.0017

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

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

Taille variable Globale : 79.35 KB