Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche tente réception ou lieu à louer

Annonces similaires

Tout voir
Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION : CHAPITEAU
Profil du voisin
Rene C

Tignieu-Jameyzieu 38230

190€/w-e

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOUE BARNUM
Profil du voisin
Léna O

Pont-de-Cheruy 38230

60€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOUER UNE TONNELLE OU PETIT CHAPITEAU
Profil du voisin
Marie agnes C

Saint-Ondras 38490

95€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE à LOUER DES BARNUMS
Profil du voisin
Voisin #194639

Caluire-et-Cuire 69300

150€

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION DE TENTE DE RéCEPTION
Profil du voisin
Delphine L

La Boisse 01120

113€

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE TENTE DE RéCEPTION à  LOUER
Profil du voisin
Estelle F

Saint-Laurent-de-Mure 69720

200€/w-e

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

BARNUM+TABLE ET BANCS
Profil du voisin
Bruno P

Bourg-en-Bresse 01000

175€/w-e

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

TENTE DE RECEPTION
Profil du voisin
Emre S

Charvieu-Chavagneux 38230

200€/j

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOUER UN CHAPITEAU BARNUM (2 JOURS)
Profil du voisin
Christelle P

Chassieu 69680

100€

Location tente reception
Location tente reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION D'UN BARNUM POUR LE 11/09
Profil du voisin
Laetitia M

Genas 69740

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

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

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

  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='281143' AND wish_id<>'449221' 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='01640'

  40. 0.0044

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.0284*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.0284*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((5.38917- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.578739197041 AND ville_latitude_deg<46.478060802959 AND ville_longitude_deg>4.7415186962095 AND ville_longitude_deg<6.0368213037905 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0056

    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 (01640,01640,01640,01500,01160,01500,01450,01160,01640,01230,01450,01160,01160,01450,01110,01160,01160,01110,01500,01450,01230,01500,01500,01320,01230,01500,01450,01430,01430,01500,01230,01250,01500,01230,01430,01320,01150,01230,01250,01430,01450,01430,01160,01230,01250,01150,01450,01150,01250,01320,01230,01320,01110,01240,01230,01240,01250,01230,01150,01110,01250,01450,01430,01110,01430,01430,01430,01230,01250,01250,01320,01240,01800,01110,01150,01430,38390,01150,01150,01110,01110,01320,01800,01250,01250,01250,01250,01150,01150,01260,38390,01460,01450,01800,01460,01460,01240,01250,01250,01240,01260,01800,01250,01800,01260,01260,38390,38390,01260,01130,01130,01800,01460,01150,01960,01110,01470,01330,01260,01110,01150,01000,01460,38390,01800,38390,01330,01250,01800,01000,01510,01310,01580,01510,01370,01510,01260,01470,01240,01580,38390,01800,01800,01240,01470,01470,01810,01810,01250,38118,01260,01260,01260,01260,01240,01370,01800,01510,01310,01680,01260,01310,01130,38118,01360,01800,01240,01470,01510,01440,01400,01510,01240,01310,01130,01400,01120,01130,01360,39240,01580,01100,01330,01510,01330,01260,38460,01400,01370,01100,01580,01680,01510,01120,01420,01330,01510,01660,01810,01200,01680,01420,38280,01200,01510,01200,01510,39240,01360,38460,01660,01310,01400,01130,01130,01300,01420,01120,38460,01300,38230,39320,01390,01400,01250,01300,01200,01360,01100,38460,38510,01120,01680,38280,74910,01330,01120,38460,01340,01200,74910,38460,01400,01130,01370,01120,01200,01370,01300,01400,01250,01300,01420,38510,69330,74910,01350,39240,39240,01990,74910,01350,01350,01340,38460,38230,38510,01370,39240,01300,01420,01200,01330,01310,39240,01350,38460,39240,74910,01310,01350,01851,01200,01660,74270,39320,01300,01270,38230,01400,39320,39240,01390,01200,01270,01390,38460,01310,01350,38230,01540,01300,01300,01130,01340,01700,38460,01120,01300,01300,01680,01390,73310,01200,01340,39240,69330,38510,01270,01350,01100,39320,39240,01330,73310,01990,01390,01410,01300,01130,39240,38510,38280,74270,74270,73310,38510,01590,01300,01540,01350,38460,74270,01400,01540,38460,01200,01990,01340,74270,01340,01700,39240,38460,39160,74270,01300,01400,39320,01270,73310,73310,39320,69330,39240,39240,01390,01270,74270,38510,01380,38890,39320,01590,74150,38460,01700,38510,01590,01340,01290,01390,39240,01380,39320,01390,38460,39360,38460,38460,01550,01300,69125,69124,01350,39160,74150,39320,01140,39160,38290,69330,01300,38510,01480,39240,39240,01300,74520,01290,01340,74270,01340,38460,39320,74150,01990,01270,38510,01140,01300,01700,74270,01140,39260,01480,73310,74520,74520,39240,73310,73310,01300,74150,01340,39160,39160,39370,74270,01300,01200,73170,01600,01550,39320,74270,01270,38080,39360,39160,01300,74270,01290,38890,73170,38890,38890,39320,74150,01290,74520,69140,74150,38300,01600,01480,38510,69740,74150,69120,39240,39370,69250,01600,69580,01550,39260,38290,69270,69270,69150,01300,39160,69680,39160,39160,01560,01140,69730,39360,73310,69250,69250,01480,01600,39360,01300,74520,01090,01140,73170,38890,01340,39320,74150,74270,73410,74270,39240,01600,39360,38630,74520,01630,39360,01290,01300,01090,38630,01380,01560,01380,01290,38110,01380,39370,38540,39240,01140,69580,73170,39360,01140,39160,74150,74150,39160,69270,01480,01290,01750,74270,69720,69720,74270,01380,69250,01600,38080,74150,01090,39320,39240,74330,69270,01600,38290,39260,01630,01090,69250,39240,39320,73170,01140,73410,01630,01480,74150,74520,69270,69270,39240,01560,74150,01090,01480,01290,39360,74150,01560,01090,69650,38090,74270,01290,38070,39160,69100,71480,69300,01300,73170,69650,39170,69660,69220,39320,69500,38300,01560,38630,01600,38300,01750,01480,38090,71480,39200,01190,38110,39240,73170,01480,39170,38300,73170,38110,69220,74150,38490,39270) 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<>'449221' 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='889' 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=186000 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 = 186000 AND W.type_id = 1) OR (W.util_id != 186000 AND W.type_id = 2)) AND (`post_util_id` = 186000 OR `dest_util_id` = 186000) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0002

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

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

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

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

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

  61. 0.0002

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

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

  65. 0.0002

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

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

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

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

  77. 0.0002

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889

  83. 0.0008

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

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

Taille variable Globale : 78.9 KB