Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Lieu de réception (2 jours)

Annonces similaires

Tout voir
Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE POUR SHOWROON
Profil du voisin
Audrey B

Lille 59000

500€/j

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE SALLE POUR ANNIVERSAIRE
Profil du voisin
Voisin #46257

Armentières 59280

250€

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE POUR ANNIVERSAIRE
Profil du voisin
Sabrina L

Lillers 62190

200€/j

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE PETITE SALLE POUR MARIAGE
Profil du voisin
Séverine S

Lens 62300

300€/w-e

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE DE RéCEPTION
Profil du voisin
Voisin #505900

Lens 62300

425€/w-e

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

CHERCHE SALLE DE RéCEPTION (2 JOURS)
Profil du voisin
Fabienne D

Noeux-les-Mines 62290

500€/w-e

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOCATION DE SALLE
Profil du voisin
Virginie B

Somain 59490

80€/j

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE D’ANNIVERSAIRE
Profil du voisin
Chloe T

Villeneuve-d'Ascq 59491

900€/nuit

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

SALLE POUR MARIAGE (2 JOURS)
Profil du voisin
Carole L

Orchies 59310

690€

Location salle reception
Location salle reception

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SALLE
Profil du voisin
Hanen G

Roubaix 59100

800€/j

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

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

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

  7. 0.0001

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

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

  30. 0

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

  32. 0.0001

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

  34. 0

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

  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='304182' AND wish_id<>'471766' 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='62172'

  40. 0.0078

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.66667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.967039197041 AND ville_latitude_deg<50.866360802959 AND ville_longitude_deg>1.9609797054346 AND ville_longitude_deg<3.3723602945654 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0095

    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 (62172,62530,62530,62160,62530,62114,62160,62690,62144,62150,62620,62690,62153,62144,62150,62143,62160,62690,62670,62620,62153,62690,62800,62150,62290,62144,62144,62690,62580,62620,62940,62150,62980,62620,62690,62150,62980,62690,62131,62690,62750,62690,62690,62113,62131,62113,62113,62131,62144,62149,62150,62580,62149,62196,62300,62127,62690,62700,62690,62660,62150,62161,62161,62223,62232,62210,62150,62300,62127,62580,62580,62690,62232,62690,62223,62690,62149,62199,62410,62161,62150,62161,62460,62122,62400,62123,62232,62232,62123,62123,62460,62123,62138,62223,62410,62580,62149,62540,62127,62430,62680,62221,62218,62138,62122,62690,62920,62223,62400,62123,62410,62470,62580,62127,62223,62880,62580,62000,62138,62810,62460,62920,62149,62320,62810,62580,62127,62470,59480,62223,62540,62138,62127,62880,62880,62127,62580,62130,62420,62127,62123,62400,62123,62810,62260,62440,62320,62000,62123,62232,62580,62127,59496,62157,62810,62223,62810,62740,62410,62260,62580,62138,62127,62550,62127,62320,62320,62920,62810,62217,62217,62127,62550,62880,62840,62217,62136,62136,62136,62110,62550,59221,62810,62127,62640,62130,62550,59496,62151,62580,62710,62350,62123,62223,62217,62810,62217,62118,62130,62550,62840,62810,59480,62123,62123,62173,59274,62123,62810,62490,62130,59185,62260,62173,62127,62490,62118,62810,62127,59134,62190,62550,62350,62810,62217,62550,62130,62350,62158,59134,62550,62270,62118,62130,59184,62810,62173,62136,62123,62950,62217,62220,62130,62119,62123,62173,62130,62350,62810,62190,62810,62130,59112,62260,62550,62130,59272,62190,62190,62590,62550,62118,62490,62130,62190,62350,62128,62190,62118,59249,62810,62128,62550,62350,62158,59251,62550,62270,62118,62130,59112,62550,62810,59134,62128,62128,62270,59249,62175,59660,59253,62123,62490,59136,62190,62120,62130,59940,62175,62128,62158,62130,62970,62175,62158,62128,62810,62550,62118,59133,62130,62130,62840,62175,59553,62130,62175,62810,62330,62820,62350,59147,62550,59147,62190,62270,59940,62111,62141,62130,62116,62156,59162,62134,62810,62128,62111,62120,62134,62156,62117,62134,62158,62158,59147,62960,62960,62840,62121,59134,62120,59261,59134,62330,62128,62130,62270,59133,59950,62130,59128,62156,62158,59553,59553,62130,62130,62130,62760,62120,62810,62111,62490,62960,80600,62156,62270,62270,62270,62116,62111,62121,59239,59552,62116,62156,62490,62790,62134,62130,59320,62128,62270,62840,59211,62120,62128,59239,62760,62112,62134,59263,59500,62130,62156,62121,62128,59320,59320,62120,59552,59551,62270,62112,62120,62120,59286,62134,59189,59283,59283,62134,62134,59169,59940,59113,80600,62490,62182,80600,62134,62116,59320,59280,62270,62490,62760,62121,62760,59320,62145,62130,62130,62111,62120,59189,62130,62120,62810,59259,59551,62960,62134,59139,62145,62156,62760,59320,62134,59151,62760,62130,59320,62182,62128,62128,62111,59320,62270,59232,62116,62111,62130,59246,59189,59175,62270,62760,62134,62130,62860,62134,59320,59119,59710,62960,59193,62760,59450,62130,62159,62120,62182,80600,62182,59181,62121,59169,62270,59187,59840,80600,59175,59139,62145,62760,62121,62860,62760,62128,59194,59151,62270,59710,62134,59190,62134,59120,62130,62960,59280,59270,62116,62111,59270,59160,59310,62120,59850,62121,62121,62120,59710,59155,62310,62121,62111,80560,62860,62860,62270,59930,62270,59151,62270,59194,62770,62860,62121,80560,59169,62270,62760,80600,59190,62310,62960,62270,62960,59840,62860,59235,62310,62450,80560,59173,59287,62760,62770,62145,62860,59270,80560,62770,62860,59710,59169,59190,59270,80300,80560,62270,59167,62770,62120,59190,80560,80300,62450,62159,62270,80560,62310,62270,59116,62159,59273,59182,59287,59840,62860,62310,59148,62770,59151,62390,59130,62120,59173,62450,62760,62760,62450,59790,62770,59810,62860,62860,62860,62310,80300,59151,59270,80300,59242,59000,59800,59160,59350,59777,62450,80560,59169,62770,80300,80600,80560,80300,62450,62760,62860,80600,62310,59182,62310,59190,62770,62124,62129,59190,62450,59242,59173,62760,59237,62120,62390,62860,59310,62390,62120,80560,80560,59350,80600,62560,62129,80600,80600,62310,62770,59236,62310,62124,59110,62450,59310,59176,62450,80600,62310,62129,59260,59234,62860,62450,80560,62770,62770,62770,62770,59270,59273,62310,59146,80560,59265,62390,62310,80300,62124,80600,62310,59176,80600,59114,62450,62560,62129,62390,59262,59173,59370,62310,59265,80560,59190,62450,62147,59118,62120,62560,59870,62770,62124,80600,62390,62770,59190,59520,80560,59700,62129,59890,59310,59830,62310,62310,62770,80600,59234,62390,80300,62310,59890,62120,59270,80300,62860,62147,80370,59830,59242,59114,80560,62129,80300,62147,59173,62450,59234,62124,59165,59870,80560,80560,62450,62860,62575,62124,80600,62310,59490,62380,62560,80560,59265,59560,80370,62770,62390,59670,62310,80360,59247,62390,80600,59310,62147,59830,59580,80630,80600,59247,80360,62770,80300,59270,59299,59870,62140,59830,80600,59670,80300,59580,62450,59152,59152,62380,80300,59554,59114,62140,62570,59670,62450,80300,80300,80370,62124,62124,62570,59554,59400,62147,59870,59114,62390,62575,59510,62560,62140,59265,59152,59910,80560,59252,80370,62310,59170,59290,59265,62390,80600,59490,62140,62140,59310,80360,59247,59310,62310,62510,80300,62450,80560,62390,59830,59670,80360,62147,80300,62124,62140,80300,59491,59493,59650,59655,59152,62560,62140,62450,80360,59268,59830,62560,62380,62140,59310,59252,59400,80370,59554,59780,59179,62140,62570,59670,80560,62390,62390,80750,59310,62124,59420,59830,59670,59252,80300,59510,62380,59215,59223,59250,59126,80370,80370,59554,80750,59780,62560,62124,80360,62570,59870,62140,59870,59560,80360,59267,62124,59267,62140,62560,59670,80300,59554,59171,62140,80150,62380,80300,62124,59670,62310,62219,62140,80360,80300,80300,59780,62500,59172,59111,80300,62219,59390,59267,59670,80300,80360,59870,62140,59178,62140,62500,59100,59230,62140,59117,62140,62147,80670,80370,59670,59295,59295,62990,80300,59159,59171,59200,80260,59310,59690,59390,62560,59554,80260,59161,80370,59159,62390,62380,62380,59390,62140,59400,62500,80670,80560,80560,62140,62140,80810,80300,62124,80360,59141,59670,59111,62390,59178,62140,59230,80300,80300,59285,80300,62990,80370,59390,80260,59166,59670,80260,80370,59400,80370,59143,59226,62560,59161,59172,59111,80150,80150,62380,62990,59124,80360,80360,62380,62500,62650,59285,62500,59159,80370,80360,80360,62990,62380,59156,59231,62500,80370,80370,59171,80150) 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<>'471766' 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=249571 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 = 249571 AND W.type_id = 1) OR (W.util_id != 249571 AND W.type_id = 2)) AND (`post_util_id` = 249571 OR `dest_util_id` = 249571) 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 = 249571

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

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

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

  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=505900 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 = 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

  61. 0.0001

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

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1000

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

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

Taille variable Globale : 78.9 KB