Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Louer une salle de réception (mariage)

Annonces similaires

Tout voir
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59250

Recherche location urgente : salle
Profil du voisin
Cynthia D

Haveluy 59250

295€/jr

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59000

Recherche d'une salle
Profil du voisin
Jacques T

Lille 59000

-- €

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59100

Recherche salle
Profil du voisin
Amelia V

Roubaix 59100

500€/we

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59280

Recherche salle 18 ans jumeaux
Profil du voisin
Jeremy G

Armentieres 59280

150€/jr

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59880

Recherche salle de réception
Profil du voisin
Marie N

Saint-Saulve 59880

345€/jr

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59250

Recherche salle à louer
Profil du voisin
Christelle T

Halluin 59250

415€/we

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59000

Salle de reception
Profil du voisin
Voisin #521043

Lille 59000

420€/we

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59553

Recherche petite salle pour mariage
Profil du voisin
Steeve

Cuincy 59553

500€/we

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 62300

Salle de réception
Profil du voisin
Voisin #505900

Lens 62300

425€/we

Louer ma salle
Location salle reception
Location : salle reception

Demande il y a + de 30j

Il y a + de 30j • 59552

Salle mariage 50 personnes (2 jours)
Profil du voisin
Voisin #338372

Lambres-lez-Douai 59552

1000€

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

  3. 0

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

  4. 0

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

  7. 0.0001

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

  9. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0001

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

  11. 0.0003

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

  12. 0.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 (88) ORDER BY ssrubr_order ASC

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

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

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

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

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

  24. 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 (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.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 (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 = 268774

  30. 0.0001

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

  31. 0.0001

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

  33. 0

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

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

  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='52526' AND wish_id<>'268774' 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='59235'

  39. 0.0044

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.033639197041 AND ville_latitude_deg<50.932960802959 AND ville_longitude_deg>2.4433156856277 AND ville_longitude_deg<3.8566843143723 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0088

    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 (59235,59310,59710,59246,59310,59242,59710,59551,59310,59710,59242,59283,59310,59148,59239,59242,59283,59710,59239,59310,59194,59273,59551,62790,59830,59261,59286,59870,59162,59194,59273,62820,59310,59830,62141,59310,59133,59310,59950,59830,59310,59870,59175,59113,59830,59262,59167,59810,59830,59119,59830,59128,59175,62590,62970,59146,59133,59830,59870,59155,62220,59690,59310,59147,59870,62119,59450,59553,59780,59553,59139,59182,59790,59152,59152,59230,59112,59152,59870,59147,62950,59263,59178,59226,59500,59139,59230,59780,59490,59287,59182,59287,59147,59870,59870,59187,59260,59251,59178,59176,59152,59176,59552,62710,59553,59490,59112,62640,59552,62880,59169,59320,59179,59510,59185,62110,62740,59320,59171,62490,59120,59350,59160,59800,59000,59780,59169,59777,59165,59226,59370,62440,59272,59178,62112,59580,59171,59178,59169,59169,59510,59136,59390,59320,62410,62880,62880,59184,62117,59211,62420,62490,59221,59110,59320,59215,62112,59580,62320,62320,59171,59158,62880,59130,62490,62138,59151,59170,59290,62490,59234,59169,59496,59230,62221,62218,62320,59234,59700,59390,59134,59350,59320,59151,59390,62410,59158,59158,59320,59320,59274,62430,59390,62490,59320,59134,59124,62320,59135,59134,62680,59320,62580,59520,59655,59491,59650,59493,59230,62410,59230,59151,59234,59158,59160,62138,59151,62490,62580,59840,59172,59496,62300,59255,59134,59840,59115,59118,59156,59252,59220,62410,59252,62490,62580,59135,59134,62580,59265,59151,59100,59420,59840,59172,62118,59480,62210,62860,59910,59247,59150,59237,62490,62300,62118,59199,59249,59195,59293,62138,59111,62580,59220,59480,59494,59252,59259,59111,59249,59195,62580,59200,59265,59199,62860,59590,59220,59247,62138,62750,59282,62118,62156,59280,62138,62860,59247,62860,62156,59111,62860,62580,59494,62580,62580,59192,62860,59121,62118,62840,59295,59295,62156,62118,59282,62118,59174,62860,59111,62156,59410,62860,59890,62800,62860,59223,59126,62149,59250,62840,59121,59265,59930,59554,62149,59970,62580,62156,62840,59280,59116,62143,62580,59860,59141,59224,62980,62149,62156,59960,59265,62160,59265,62118,59268,62860,59125,59236,62156,59141,59554,62223,62149,59278,62153,62860,62182,62980,62149,59193,59296,62223,59400,59163,62136,62580,59300,59880,62160,59890,59970,59233,62182,59141,59554,59224,59300,62840,59166,62223,62113,62113,62670,59300,62223,59770,62860,62128,59198,62223,59117,59161,62128,59554,59554,59560,59161,62860,62136,62153,59970,62160,62840,62128,62182,59850,59560,62660,62114,59161,62223,62136,62217,59227,59264,62144,62223,59554,62128,62223,62290,62000,59269,62113,62128,59188,62182,59277,59213,59163,59940,59990,59243,59269,59990,62400,62172,59227,59161,59227,62217,59990,62144,59188,59400,59181,62860,59267,62860,62400,59213,62217,62128,62530,59163,59129,59400,62128,59253,62860,59990,62136,59154,62530,62217,62217,62530,62131,62131,62144,62128,59400,62860,59990,62131,62161,62161,62400,59269,59267,59400,62128,62128,62217,62147,59213,59213,59990,62620,59400,59188,62147,59940,62232,59144,62128,59294,62620,62000,59217,62232,62232,59292,59400,59920,62144,59990,59159,62175,62232,62690,59940,62161,62690,62128,62196,59530,62232,59281,62690,62128,62690,62128,62920,62150,62159,59213,59213,59530,62161,59214,59144,62147,59660,59217,62620,62940,59730,62144,62199,62620,59400,62217,59270,62350,62173,59217,62690,62150,59159,59267,62123,62175,62121,59730,59400,62147,59144,59217,59241,59400,62350,62122,62124,59530,59730,62147,62175,59730,62920,62690,62690,62121,59157,62123,59530,62123,59144,59144,62147,59270,62920,62690,59157,62159,62150,62175,62150,59730,62124,62700,59159,62173,62159,62124,62123,59270,62123,62123,59530,62121,62150,62175,59258,62350,59530,62173,59540,62690,59271,59258,62124,59232,62122,62121,62350,62150,59540,59144,59270,62690,62123,59218,59218,59530,59127,59570,62690,62173,62450,59231,62124,62147,59270,62123,59530,62540,59218,59258,59530,62350,59191,62121,62450,62121,62150,62690,62123,62123,59730,59218,62124,62690,59191,59570,62690,59530,62127,62810,62116,62123,62450,59540,62460,62124,59270,59270,62540,62350,62690,62116,62121,59530,62157,62150,59570,59266,59540,59225,62350,62450,62124,62116,59570,59360,62121,59570,59144,62127,59530,59144,62124,59191,62124,62123,62450,62810,62470,62460,59299,62116,62450,62690,62124,62450,59190,62150,62123,62111,59530,62810,59225,59127,62190,62123,59222,59231,59980,62450,59231,59266,62450,62123,62470,62260,62121,59222,59570,62151,59190,59530,62450,62124,62810,59190,62127,59570,62810,62810,59570,59980,62330,62127,62260,62190,62124,59127,62127,59360,62121,59222,59266,59270,62450,62810,62158,62460,62124,59288) 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<>'268774' 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='1000' 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=56491 AND note_visu IN (1,3,4)

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

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

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

  52. 0.0001

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

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

  56. 0.0001

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

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

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

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

  68. 0.0001

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

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

  72. 0.0001

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

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

  76. 0.0001

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

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

  80. 0.0001

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

  81. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1000

  82. 0.0009

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

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

Taille variable Globale : 78.9 KB