Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche urgente barnum à  louer

Autres annonces du voisin

Tout voir
Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE BARNUM A  LOUER (20/30 PERS.
Profil du voisin
Francis R

Évry 91000

-- €

Annonces similaires

Tout voir
Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION DE BARNUM
Profil du voisin
Catherine A

Villiers-Saint-Frédéric 78640

110€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOCATION : TENTE DE RéCEPTION
Profil du voisin
Bernard D

Saint-Gratien 95210

300€/w-e

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOUER UN BARNUM DE 20M²
Profil du voisin
Voisin #184935

Chatou 78400

80€

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE à LOUER BARNAUM
Profil du voisin
Nadine S

Montmorency 95160

50€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION : BARNUM D'UN JOUR
Profil du voisin
Anja A

Eaubonne 95600

110€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE TONNELLE
Profil du voisin
Akia A

Ozoir-la-Ferriere 77330

50€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE BARNUM OU TENTE !!
Profil du voisin
Amine B

Melun 77000

40€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

URGENT CHERCHE BARNUM PLIANT ENVIRON 3X6
Profil du voisin
Sonia Y

Champigny-sur-Marne 94500

80€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE BARNUM
Profil du voisin
Voisin #513432

Sainte-Genevieve-des-Bois 91700

95€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

JE CHERCHE à LOUER UN BARNUM DE 2X5M
Profil du voisin
Lana L

Puteaux 92800

100€/j

Louer un barnum entre particuliers ou proposer un barnum 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='315077'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tente-reception' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='889'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tente-reception' 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='176'

  6. 0.0001

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

  7. 0.0001

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

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

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

  12. 0.0003

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

  13. 0.0002

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

  14. 0.0002

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

  15. 0.0002

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

  16. 0.0002

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

  17. 0.0002

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

  18. 0.0002

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

  19. 0.0002

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

  20. 0.0003

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

  21. 0.0002

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

  22. 0.0001

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

  23. 0.0002

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

  24. 0.0002

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

  25. 0.0001

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

  26. 0.0001

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

  27. 0.0001

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

  28. 0.0002

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

  29. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 315077

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=889 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

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

  42. 0.0002

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

  43. 0.0001

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

  44. 0.0059

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.183639197041 AND ville_latitude_deg<49.082960802959 AND ville_longitude_deg>1.7695916332696 AND ville_longitude_deg<3.1304083667304 HAVING distance <= 50 ORDER BY distance ASC

  45. 0.0065

    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 (91000,91090,91450,91450,91130,91250,91000,91250,91280,91080,91090,91100,91250,91070,91350,91100,91210,91700,91170,91480,77127,91260,91860,91230,91540,91540,91270,91600,91390,91830,91800,91250,91540,91800,91700,91560,77380,91360,91480,94480,91810,91220,91200,91330,91220,91540,77176,94520,94520,91360,91240,91710,91550,94440,94190,91700,77550,91750,91420,94290,94450,91830,77240,91310,77176,91630,94440,91160,77550,91610,91750,94460,77310,91160,91630,77240,91380,94440,77170,91310,91310,94390,94310,77170,91620,77166,94470,91320,77310,91770,77240,91160,91290,91310,94150,94600,94380,91180,91750,91160,91630,91760,77310,94320,91290,91460,91620,77550,94380,94370,94260,77350,91630,91140,91630,91300,77150,91590,94550,94000,91590,91140,77166,77950,92160,91850,94400,77111,77550,91120,77150,77350,77950,77350,91520,91340,94880,94880,94490,77930,91590,77173,92340,91890,94700,91840,91370,77950,94140,91510,91510,77170,94231,91680,94230,94233,94239,94238,94234,94240,94232,94235,94236,94237,77190,94340,94210,94100,77930,77930,94430,77950,94510,91730,77000,77000,91790,94800,77111,91590,77190,92290,77930,94410,94110,91490,91430,94340,94220,77950,92260,92330,77390,91400,91650,77930,91590,94200,94500,94205,91940,94270,92350,91940,91430,91570,91730,77000,92220,77340,77930,77330,77000,91440,91650,94420,94250,91590,91640,91640,92320,91590,91490,91490,77390,91680,94160,94130,91730,91910,91820,92120,77390,94360,77950,92140,91580,92240,77630,91650,77390,91820,77390,94350,77220,91400,91580,77680,91580,77184,91590,77630,77220,91190,91940,94300,94120,94170,77220,92130,91720,91640,91580,77115,92360,92190,91400,91640,92170,91880,77590,93330,91190,91530,77390,77185,78350,93160,91580,77115,77390,77220,91470,77630,91490,93100,93170,93110,77135,92370,77590,91190,91530,77720,75001,75000,75002,75004,75005,75007,75008,75010,75006,75009,75020,75003,75011,75017,75019,75016,75015,75014,75018,75116,75012,75013,91720,93360,77420,92100,78140,91470,77390,93460,77183,77090,92310,91150,78350,78530,77186,78117,91580,93230,93130,93260,78220,91490,78470,77610,77720,78117,77164,93250,93310,77820,77390,77200,91470,93220,92410,77220,77590,91470,92210,91530,91530,91150,91720,91470,91720,77600,77390,93000,93140,77820,78000,77360,77123,93500,77500,91470,92430,92420,77920,93320,93340,78114,77610,77600,77600,78460,92380,77720,92150,92800,77390,77390,78830,93370,93400,92200,77177,91150,77850,77400,91720,77600,91150,78470,77610,77123,91410,77600,92110,77400,77610,78280,77300,91720,77123,93120,93300,78150,91150,77720,92300,78960,77720,77870,78460,93190,93390,77720,77400,77600,77210,91410,78170,77400,77760,77210,91870,92400,77174,77133,77820,77181,93470,91150,78150,92250,77390,78830,77610,92600,77610,92500,93150,93700,93350,91150,78210,78470,91410,77181,78720,93270,91720,77400,78180,77144,93200,93210,91150,92270,91150,77760,77700,77720,93410,92390,93450,77400,78720,77174,77410,92700,78730,78730,77133,78290,78380,92000,77700,91150,91410,78720,92230,77760,91410,77760,93440,91150,77760,78400,77610,77400,77270,93600,93240,77720,78430,78720,77810,78330,91150,91780,91780,78870,77540,77144,77700,78800,77760,77430,93800,78720,77540,78390,78590,77830,91690,78190,93430,78560,78590,77410,93290,78420,95500,45330,95140,78320,77700,78160,95870,93420,93380,91150,95360,91150,78320,77370,91150,91410,77163,77780,78730,95100,77720,77760,78620,77720,45330,95880,77540,78360,78110,77450,91690,91690,77540,78750,78730,77670,78450,77830,95500,78320,77760,95400,95210,95218,45330,77450,77580,45300,91690,77700,78230,77540,77250,91690,77410,77690,91690,77760,78112,77450,95410,91410,77410,77880,78340,95170,95110,45330,78860,78120,91410,77670,78100,77450,77250,77370,78500,78990,77410,77860,95230,77760,77131,77515,77540,77290,95500,77163,78660,77450,95500,77163,77760,91780,95700,95200,95400,95120,77830,78600,45330,95350,78310,77860,77410,77410,45300,77140,77250,78690,77250,78730,77370,78600,77690,77370,95160,77370,78310,78450,77580,95530,77370,78370,91410,77580,77580,78120,95130,91410,77450,95580,95580,78610,91410,91740,78125,95600,78240,45330,77760,95190,95720,77760,77450,77410,95440,77410,95240,77515,77580,77131,91930,77250,77760,95350,77130,45300,78240,77860,95370,77450,78690,78760,77410,95130,77290,45300,91660,77540,78810,91740,77130,77990,77580,45300,77140,95680,77760,91660,78300,77515,45390,45390,77250,77154,45390,95720,45390,95380,78610,95390,77230,77140,77890,45330,45300,95460,78660,28700,95380,95320,77890,28700,78640,77100,95330,45300,77120,78120,77130,77230,77990,77370,78660,91740,95220,77140,77120,78810,78850,77515,77410,78490,45300,77140,78640,77148,77130,77580,78660,77370,77515,78640,95190,95250,77230,95720,77167,78630,78260,77970,78660,78955,77100,77124,78700,77250,77710,95380,77580,77141,77167,45300,77230,78125,77165,77100,95380,95570,78121,77130,78490,78490,78490,78610,77890,95570,77580,77154,77167,78640,77120,95480,77470,77230,45300,77165,77165,77124,95570,95550,95150,77230,77370,45300,77570,45300,77580,78570,77230,77130,77370,28700,77167,77148,28700,95190,45390,95850,78670,78670,95560,95380,45480,77120,45390,95720,77130,91670,45390,78660,28310,77165,95840,77520,77370,77890,77940,95470,77230,77580,77230,78650,77120,95560,28700,77940,77470,78125,78490,78490,77230,95740,77940,95560,77230,78570,77124,78780,77470,77520,78660,78490,77130,95610) AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='889' AND wish_id<>'315077' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  48. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 251071 AND W.type_id = 1) OR (W.util_id != 251071 AND W.type_id = 2)) AND (`post_util_id` = 251071 OR `dest_util_id` = 251071) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0002

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

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

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

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

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

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

  69. 0.0001

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

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

  73. 0.0001

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

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

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

  82. 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='889' LIMIT 0,1

  83. 0.0001

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

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

  85. 0.0001

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

  86. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889

  87. 0.0009

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

  88. 0

    SELECT count(*) as nbwish FROM wish

  89. 0.0488

    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

89 requetes sql en 0.0723

Taille variable Globale : 79.32 KB