Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Cherche Barnum ou chapiteau type cirque (8 jours)

Annonces similaires

Tout voir
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 95210

Cherche location : tente de réception
Profil du voisin
Bernard D

Saint-Gratien 95210

300€/we

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 91470

Location tonnelle (2 jours)
Profil du voisin
Trécy B

Angervilliers 91470

200€

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 78170

Louer chauffage électrique pour tente
Profil du voisin
Christian D

La Celle-Saint-Cloud 78170

20€/jr

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 78490

Recherche barnum (2 jours)
Profil du voisin
Stéphanie B

Le Tremblay-sur-Mauldre 78490

50€

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 78130

Location tente ou barnum
Profil du voisin
Etienne N

Mureaux 78130

40€

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 77123

Tente de réception 20 pers. (2 weekends
Profil du voisin
Pascale S

Noisy-sur-Ecole 77123

200€

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 91700

Location tente de réception (barnum)
Profil du voisin
Christine C

Sainte-Geneviève-des-Bois 91700

80€/nuit

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 95000

Recherche barnum pour le 14 septembre
Profil du voisin
Céline M

Boisemont 95000

100€/we

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 91410

Barnum 3x9 m
Profil du voisin
Nathalie C

Dourdan 91410

100€/jr

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 77330

Recherche tonnelle
Profil du voisin
Akia A

Ozoir-la-Ferriere 77330

50€/jr

Louer mon barnum

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

  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, 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

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

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

  30. 0.0001

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

  31. 0.0001

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

  33. 0

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

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

  38. 0.0001

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

  39. 0.0071

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*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.267039197041 AND ville_latitude_deg<49.166360802959 AND ville_longitude_deg>1.4351343365919 AND ville_longitude_deg<2.7982056634081 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0067

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

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

  42. 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)

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

  44. 0.0002

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

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

  47. 0.0001

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

  48. 0.0002

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

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

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

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

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

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

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

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

  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='889' 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=98095 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 = 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

  80. 0.0002

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

  81. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889

  82. 0.0016

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

  83. 0

    SELECT count(*) as nbwish FROM wish

  84. 0.0734

    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

84 requetes sql en 0.0997

Taille variable Globale : 78.9 KB