Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Salle avec couchages (2 jours)

Annonces similaires

Tout voir
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SALLE POUR ANNIVERSAIRE WE 13
Profil du voisin
Frantz K

Caudebec-les-Elbeuf 76320

300€/w-e

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SALLE DE RéCEPTION / JARDIN P
Profil du voisin
Louise L

Bihorel 76420

800€/j

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SALLE à  LOUER (100 PERSONNE
Profil du voisin
Voisin #52215

Bourg-Achard 27310

600€/w-e

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE MARIAGE
Profil du voisin
Btissam M

Étrépagny 27150

400€/j

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE DE RECEPTION BAPTEME (2 JOURS)
Profil du voisin
Maheva G

Brecey 50370

400€

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

24AOUT 2024
Profil du voisin
Nolwenn B

Maromme 76150

250€/w-e

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

1 AN DE NOTRE FILLE
Profil du voisin
Clara D

Notre-Dame-de-Bondeville 76960

250€/j

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

LOCATION DE SALLE POUR BAPTêME
Profil du voisin
Nicolas H

Oissel 76350

300€/w-e

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOCATION SALLE POUR ANNIVERSAIRE
Profil du voisin
Daniel D

La Vaupalière 76150

800€/w-e

Louer ma salle
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SALLE DE RéCEPTION ATYPIQUE
Profil du voisin
Laetitia B

Serquigny 27470

500€

Louer ma salle

Louer un lieu de reception entre particuliers ou proposer un lieu de reception 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='620810'

  3. 0.0001

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

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'salle-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='27'

  7. 0.0001

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

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

  30. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1000 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0001

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

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

  39. 0.0002

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

  40. 0.0058

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.600339197041 AND ville_latitude_deg<49.499660802959 AND ville_longitude_deg>0.39723707697713 AND ville_longitude_deg<1.7694229230229 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0082

    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 (27930,27930,27930,27180,27930,27180,27930,27930,27180,27180,27180,27110,27930,27930,27930,27180,27930,27930,27000,27190,27110,27180,27930,27180,27190,27930,27190,27930,27190,27190,27930,27110,27930,27930,27180,27400,27400,27110,27930,27190,27930,27930,27110,27400,27110,27930,27190,27930,27180,27400,27190,27110,27190,27190,27400,27490,27190,27110,27930,27190,27930,27930,27240,27110,27110,27400,27190,27190,27490,27220,27190,27170,27110,27240,27180,27930,27930,27110,27490,27930,27120,27190,27190,27490,50680,27930,27240,27170,27220,27400,27400,27240,27400,27490,27110,27110,14380,27170,27170,27170,27120,27120,27120,27190,27240,27190,27110,27110,27400,27240,27400,27110,27120,27600,27220,27190,27110,27400,27220,27120,27110,27110,27220,27170,27170,27190,27120,27400,27110,27600,27120,27110,27120,27220,27400,27170,27400,27370,27110,27240,27950,27600,27240,27370,27190,27400,27110,27120,27170,27600,27400,27170,27120,27220,27600,27220,27240,27220,27400,27220,27240,27120,27190,27110,27400,27370,27120,27120,27110,27120,50410,27370,27370,27160,27120,27370,27600,27110,27940,27370,27600,27240,27370,27400,27110,27950,27410,27760,27160,27220,27170,27950,27120,27600,27240,27220,27190,27220,27950,27430,27370,27120,27370,27940,27160,27370,27240,27320,27170,27410,27430,27370,27950,27170,22870,27220,27370,27220,27410,27370,27940,27220,27340,27920,27920,76320,27120,27100,27430,27370,27430,27950,27370,27800,27890,27240,27800,27410,27170,27640,27330,27120,27370,27370,27370,27160,27430,27940,27120,27370,27120,27170,27600,27220,27160,27220,27430,27430,27370,27320,27240,27470,76320,27800,27730,27950,27550,27220,27330,27160,27220,27100,76500,27160,27160,27370,27410,27120,27640,27950,27470,27940,27370,27730,27690,27670,27950,27800,27940,27340,27340,27510,27300,27410,27220,27700,27160,27470,27220,76410,27320,27800,27340,27160,27330,27750,27120,27700,27700,27700,76500,27340,27430,27550,27800,27220,76500,27670,78270,27100,27670,27770,27370,50570,27200,27410,78270,27160,27330,27700,27780,27700,76410,78270,27730,27430,27160,27320,76410,76410,27570,27460,27330,27520,27740,27300,27410,27460,27800,27800,27590,27460,27520,27520,27160,27800,27520,27570,27570,27570,76350,76410,27590,27700,27330,27800,27800,27700,27300,27530,28520,28520,78980,27410,28350,27320,27290,78270,27510,27130,27330,27640,27300,27810,76520,27520,27720,27330,27650,27320,27250,78270,27620,27700,28350,28260,27510,27800,78270,27380,27330,27520,27520,27410,27800,28270,27700,27540,27800,27620,27700,76520,27800,28380,28260,28260,27440,76530,78270,78270,76520,27380,27360,27610,27160,27410,27320,50800,76530,76520,27300,50210,27290,28260,27510,27800,28260,27710,78980,27520,27520,27520,78980,28260,27800,27130,76113,76530,27250,27330,27520,27300,27380,27300,28500,27650,78270,78980,27520,28270,27130,27250,27300,27290,76520,28260,27290,27800,76113,27300,27700,27440,27310,27630,27310,27250,27270,78270,27800,27620,27700,27290,28260,27130,27130,27580,27650,28270,27510,76800,28270,27330,76520,27290,28270,27310,28260,76650,27310,76380,27310,27290,28270,27800,78200,78840,27310,50370,28500,27250,27270,28500,27290,78270,27620,27270,27250,78980,27380,76520,28270,27700,28500,27130,27250,28270,50370,27510,27450,27310,14450,27630,27300,27510,27330,27300,27250,27800,27300,76920,27310,27440,78270,27440,27580,28570,27250,27380,76240,27800,78200,78980,27510,27450,27270,28270,76520,28560,27800,76530,27150,78270,27380,27310,95780,27130,27270,78520,28500,78790,27630,76113,27630,28270,27300,78710,27290,27270,27420,27450,27420,28560,28260,27440,27310,27380,28270,76300,78200,27290,27420,28100,27230,78790,76120,78980,76240,27290,27420,76520,27560,28410,76160,27390,78270,61300,27300,27310,27380,76530,27230,28500,61300,95510,28270,27420,61550,27150,27380,76840,27630,78200,28500,27630,27850,28500,27300,95710,27440,78111,78200,27270,27910,28500,27130,27560,76520,78840,28270,27150,27450,76000,76100,27300,95780,27270,27390,27150,78910,76240,76140,27230,27390,78200,76160,28340,28410,27560,28500,27350,27230,78200,61300,27630,27290,27150,78200,27560,27790,76160,27440,78790,27420,27820,27420,27450,27150,76520,76480,28500,28410,61550,61550,95510,27230,61300,27390,78910,78200,76480,27350,27230,27420,27230,27350,28410,27580,76160,95710,28500,28500,27270,27150,76380,28410,28500,28500,78200,28270,76160,78550,27350,27350,95780,27630,78520,61300,78910,28500,27290,28500,28270,78200,50250,27270,27350,27560,76840,78790,27390,28500,27230,28170,27270,27230,27420,27230,27450,27450,27560,27390,27390,27150,27910,78790,61550,28340,76116,27500,27350,28340,27870,28410,61300,95770,28170,27230,78790,95710,27500,27910,78520,76130,27350,76420,76160,28410,76250,76150,76230,27350,28250,28170,27820,27820,27150,27230,76160,76380,95770,95770,61300,78200,27150,76480,78930,78930,61300,78790,76160,78930,28500,27230,95420,78200,78711,28340,27350,28500,61550,28410,28500,95510,27720,22680,78930,27390,27230,95510,27150,27560,27150,61190,78550,27480,78550,27910,27260,27230,28500,78520,14290,27150,78550,76480,50300,27560,28250,76480,76960,78910,27910,76150,50300,76940,27390,76480,76116,27230,95510,78440,27560,27390,76160,14290,27500,27150,27350,76840,61550,27230,76160,78930,95420,61550,14290,61300,27910,95420,61270,28170,28340,28340,78440,28170,78790,76116,27230) 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='1000' AND wish_id<>'620810' 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='1000' 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=549583 AND note_visu IN (1,3,4)

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

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

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

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

  57. 0.0002

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

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

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1000

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

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

Taille variable Globale : 78.88 KB