Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche une étudiante

Autres annonces du voisin

Tout voir
Service aide menagere
Service aide menagere
AIDE MéNAGèRE
Profil du voisin
Fatoumata C

Saint-Germain-en-Laye 78100

14€/h

Demander un ménage
Service aide personne
Service aide personne
AIDES AUX PERSONNES AGéES
Profil du voisin
Fatoumata C

Saint-Germain-en-Laye 78100

10€/h

Demander une aide
Service babysitter
Service babysitter

Demande il y a + de 30j

Il y a + de 30j

CHERCHE BABY-SITTER (MERCREDIS)
Profil du voisin
Fatoumata C

Saint-Germain-en-Laye 78100

-- €

Proposer mes services

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service
CHAMBRE MEUBLéE INDEPENDANTE (15 MOIS)
Profil du voisin
Michael J

Paris 75011

-- €

Louer la chambre
Location logement contre service
Location logement contre service
CHAMBRE DISPO
Profil du voisin
Rachid D

Créteil 94000

-- €

Louer la chambre
Location logement contre service
Location logement contre service
BELLE APPARTEMENT AU PIED DU MéTRO FORT
Profil du voisin
Voisin #57503

Aubervilliers 93300

354€/m

Louer la chambre
Location logement contre service
Location logement contre service
OFFRE DE COLOCATION CONTRE SERVICE
Profil du voisin
Respectueux I

Noisy-le-Sec 93130

-- €

Louer la chambre
Location logement contre service
Location logement contre service
LOGEMENT CONTRE SERVICES TYPE MéNAGE ET
Profil du voisin
Yug B

Vincennes 94300

-- €

Louer la chambre
Location logement contre service
Location logement contre service
HéBERGEMENT CONTRE SORTIE D'éCOLE OU L
Profil du voisin
Malika R

Bezons 95870

-- €

Louer la chambre
Location logement contre service
Location logement contre service
SERVICES CONTRE HéBERGEMENT A 75 PARIS
Profil du voisin
Voisin #222004

Paris 75000

1750€

Louer la chambre
Location logement contre service
Location logement contre service
AIDE AUX PERSONNES âGéES
Profil du voisin
Izadora O

Paris 75014

-- €

Louer la chambre
Location logement contre service
Location logement contre service
PROPOSE LOGEMENT CONTRE SERVICES (3 SEMA
Profil du voisin
Bruno M

Ezanville 95460

-- €

Louer la chambre
Location logement contre service
Location logement contre service
CHAMBRE CONTRE GARDE D'ENFANT (10H)
Profil du voisin
Guy B

Mantes-la-Jolie 78200

110€

Louer la 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='338906'

  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

    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='139073' 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` = 139073

  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.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.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 = 338906

  30. 0

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

  32. 0.0001

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

  33. 0

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

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 139073 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 = 139073 AND W.type_id = 1) OR (W.util_id != 139073 AND W.type_id = 2)) AND (`post_util_id` = 139073 OR `dest_util_id` = 139073) 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='139073' 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 = '338906'

  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='139073' AND wish_id<>'338906' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 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='1080' LIMIT 0,1

  40. 0.0001

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

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

  42. 0.0001

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

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

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

  45. 0.0001

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

  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='1031' LIMIT 0,1

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

  49. 0.0001

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

  50. 0.0058

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.3992984337256 AND ville_longitude_deg<2.7673615662744 HAVING distance <= 50 ORDER BY distance ASC

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

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

  53. 0.0001

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

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

  55. 0.0001

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

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

  57. 0.0001

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

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

  59. 0.0001

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

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

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

  67. 0.0001

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

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

  69. 0.0001

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

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

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0001

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

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

  79. 0.0001

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

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

  81. 0.0001

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

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

  83. 0.0001

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

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

  85. 0.0001

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

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

  87. 0.0001

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

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

  89. 0.0001

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

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

  91. 0.0001

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

  92. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  93. 0.0008

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

  94. 0

    SELECT count(*) as nbwish FROM wish

  95. 0.0477

    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

95 requetes sql en 0.0687

Taille variable Globale : 79.38 KB