Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche appartement contre divers services

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE DE CHAMBRE CONTRE SERVICE (6 M
Profil du voisin
Ablavi rolande G

Rouen 76000

1350€

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT CONTRE DES SERVICES (3 MOIS
Profil du voisin
Princia R

Neuville-sur-Oise 95000

80€

Louer ma chambre
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
Daniel M

Chaumont-en-Vexin 60240

299€

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOGEMENT SUR ROUEN
Profil du voisin
Loulou S

Rouen 76000

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE DANS MAISON (12 MOIS)
Profil du voisin
Voisin #167304

Villennes-sur-Seine 78670

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

SERVICE CONTRE LOGEMENT (3 MOIS)
Profil du voisin
Barbara G

Cergy 95000

690€

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HEBERGEMENT (3 MOIS)
Profil du voisin
Severine V

Rouen 76100

690€

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

AIDE MéNAGèRE ET DAME DE COMPAGNIE
Profil du voisin
Dos santos F

Rouen 76000

225€/m

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

BESOIN D'UN LOGEMENT CONTRE SERVICES
Profil du voisin
Jean-marie J

Élancourt 78990

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

FEMME JOYEUSE ET SERIEUSE CH PETIT LOGE
Profil du voisin
Voisin #54229

Andé 27430

250€/m

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

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

  7. 0.0001

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

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

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

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

  26. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC

  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 = 461313

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

  32. 0.0001

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

  34. 0

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

  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='290450' AND wish_id<>'461313' 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='27200'

  40. 0.0058

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.633639197041 AND ville_latitude_deg<49.532960802959 AND ville_longitude_deg>0.79677713024136 AND ville_longitude_deg<2.1698828697586 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0041

    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 (27200,27950,78270,27620,27950,27950,78270,27620,27950,78270,27510,27950,27120,27920,27920,27620,27950,78270,78270,27950,27510,27120,27630,78270,78270,27940,27510,78270,27620,27120,78270,78270,78840,27950,27120,27510,27600,78270,27120,27120,27120,27120,27940,95780,27600,27950,27120,27700,27120,27120,27120,27630,27120,78980,27510,27120,27630,78270,78270,95510,27120,78270,27120,27630,78980,27940,27600,78520,95710,95780,27640,78840,27120,27120,27630,27940,27600,27630,27640,78710,27600,27120,95510,27120,78200,27640,27700,27490,95710,78980,27630,27600,27120,27510,27420,27510,27930,27490,95780,27700,78200,27700,27700,78520,27730,27120,27510,78980,27220,78200,27600,78200,27630,27730,27490,78200,95710,27930,27220,27120,27730,27940,78200,95420,27930,27420,95510,95510,95770,27930,27420,27700,78520,28260,27940,27420,28260,27220,27780,27420,27700,27220,78200,27600,27700,27600,78980,27420,27930,95770,95770,78200,27930,95510,27220,27490,27930,78980,27430,27220,78200,95420,27490,78440,27930,27120,78200,27420,27930,27870,27930,78200,28260,27420,27720,27930,27700,78980,78440,27150,27750,95420,27930,78520,27400,27930,78711,78200,27700,27720,27220,27930,95420,95420,95420,95510,78930,27220,27220,28260,27540,27150,27700,60240,27420,95420,27150,78930,78111,27220,27150,95420,27150,78200,78930,78930,27400,95420,78440,27930,78790,78790,27930,27400,27930,27220,78790,78790,27400,78440,78440,27700,27930,28260,27930,27930,27430,27430,27720,78440,27430,78790,78440,27150,27220,27530,27430,78930,27700,27700,95420,78790,27220,27430,78440,27930,78790,27400,27400,27000,27150,27220,95420,27430,60240,78440,27150,28260,27440,27220,78910,27220,27440,78440,27150,27400,28560,27440,28260,60240,28260,28260,28560,60240,78910,78970,60240,78930,27430,27930,27930,27430,27100,27220,78910,27930,78440,28260,27100,27400,27400,95420,95450,78250,27440,60240,78790,78790,27220,27400,27400,27400,27220,78930,60240,27150,95450,95450,27930,95450,27150,78790,78910,27150,95420,78820,27440,78680,27180,95450,27380,27220,78580,27830,27590,27660,27660,27400,27400,27180,28520,28520,78550,27100,27930,60240,27740,27180,27240,27220,27690,78910,78410,78410,27240,27440,78410,27380,27220,27440,27150,95750,27180,28410,27930,95450,78770,27220,78250,27110,27930,60240,78250,95450,27400,78410,27180,27860,27380,27380,78550,27140,27400,60240,27810,78250,78910,60240,78126,28410,27850,27930,60240,27380,60240,27590,27790,78910,78250,95450,27150,27360,27610,78910,95640,60240,27380,27110,78250,60240,27340,78580,78770,27140,78580,27710,27400,27180,27180,95450,95450,27110,78130,27180,78770,27380,95450,27400,27150,78550,27150,78410,27320,27460,27140,27110,78910,27340,78770,27240,27400,28410,27340,28570,27770,27180,27400,27650,60590,60590,27460,27320,27240,95750,27110,27150,27190,27150,95450,27180,78550,78770,95640,95640,78550,95450,27110,78124,27240,27150,27380,27320,78770,78740,27370,78920,60590,60590,28410,27110,60240,27480,95450,78130,28410,27110,27480,78890,27460,60240,28410,78580,60240,27480,28410,78124,27190,27190,27150,60590,60240,78740,27380,60590,76520,76520,28500,76410,27110,27190,78940,27180,95450,27110,27650,78550,27240,27240,78580,27370,76520,27190,78630,27340,50680,78770,27150,27370,28500,27480,27110,28410,95640,27190,95180,27910,28500,27480,60240,76320,95640,78490,95650,95650,27650,28500,78950,78940,60240,78650,27480,95830,27190,27140,60590,27910,27110,95800,78480,27480,78650,76520,76520,60590,27110,95000,28410,27240,60590,76520,27150,27320,27480,27370,60240,27190,78540,27340,60240,95640,27240,27110,27370,76410,27190,95830,76520,95650,78490,28380,78490,76520,60240,27190,78490,60240,27190,78510,76410,76350,27190,27910,76520,28500,78113,28500,95640,76320,27910,78121,60240,27370,27110,27320,27190,60590,28100,27110,27370,95650,27320,28350,27110,27910,27190,95490,78670,78670,27240,60240,60240,60240,27240,60590,78810,76116,27190,95280,76520,78640,27320,27240,60119,78630,78850,28500,60240,28500,27110,78113,28500,78640,14380,78490,78490,27190,78490,27910,76220,60119,27370,27370,27110,28500,76500,60240,76410,78570,78640,95810,28500,76520,27370,76410,76220,27370,27110,78113,28500,27190,76220,27370,27190,27190,60590,76780,76160,95650,78640,95520,60850,78113,95810,27110,28500,76780,28500,95640,76220,27240,78810,76240,60240,27370,78955,78490,78490,28350,95000,27170,76220,28210,28500,60850,28210,76780,95810,95000,27110,60119,60390,27110,60173,27370,27240,76800,78113,76116,78780,78490,60240,76500,76160,60240,76160,78113,27170,27170,27240,27370,95810,78240,78570,28500,76160,22870,76920,76240,27110,27370,78260,28210,78300,76500,76780,76220,27670,27170,27160,76220,78450,60240,27160,76780,60790,60850,95300,95300,27570,78240,76116,78490,27110,28500,28210,27170,95300,78760,78370,28270,27190,60390,27110,95810,76116,95610,27370,27190,60850,78610,27570,28500,76160,60390,76530,27370,28500,76220,27370,78125,27170,60850,95810,27170,95310,78700,76780,28210,28210,76300,28270,28210,76780,76116,95810,60850,76240,27570,27670,60390,27370,60175,28210,78860,60790,27570,76750,76220,78340,60149,27370,27190,27170,27160,76650,76116,78690,27370,27160,76116,76220,78310,95300,76160,78990,60790,27110,76530,60650,78450,60110,27670,27110,76160,78125,28270,78112,76220,76113,28270,76116,76780,28500,78100,28210,28210,27370,76380,28210,76160,76160,76220,60110,60650,76000,76100,28210,78125,28500,27170,60650,27170,28270,78310,60390,95690,60650,78620,28500,60390,95690,78610,78750,27190,28210,76160,76750,78230,27160,76116,76120,28270,76160,76230,78600,60390,76530,76113,60390,27890,27520,95430,27160,78590,78590,50410,27160,78160) 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<>'461313' 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=387630 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 = 387630 AND W.type_id = 1) OR (W.util_id != 387630 AND W.type_id = 2)) AND (`post_util_id` = 387630 OR `dest_util_id` = 387630) 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 = 387630

  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=362905 AND note_visu IN (1,3,4)

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

  49. 0.0001

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

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

  53. 0.0001

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

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

  57. 0.0001

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

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

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

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

  69. 0.0002

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

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

  73. 0.0002

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

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

  77. 0.0001

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  83. 0.0009

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

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

Taille variable Globale : 78.91 KB