Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Location projecteur d’ambiance

Autres annonces du voisin

Tout voir
Location refrigerateur
Location refrigerateur
FRIGO /CONGéLATEUR A LOUER
Profil du voisin
Vincent V

Maroeuil 62161

20€/j

Louer le frigo
Service multi services
Service multi services
SERVICE : PETITS TRAVAUX
Profil du voisin
Vincent V

Maroeuil 62161

10€/h

Demander ce bricoleur

Annonces similaires

Tout voir
Location jeux de lumieres
Location jeux de lumieres
MINI LYRE à  LED à  LOUER
Profil du voisin
Damien L

Orchies 59310

20€/j

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
JEUX DE LUMIèRE
Profil du voisin
Jonathan B

Montigny-en-Ostrevent 59182

50€/j

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
BANDEROLE JEUX
Profil du voisin
Anne laurence D Voisin vérifié
100% fiable

Aniche 59580

2€/j

Louer ces spots
100%
Location jeux de lumieres
Location jeux de lumieres
ILLUMINER VOS éVéNEMENTS !
Profil du voisin
Marie D

Lens 62300

30€/j

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
JEU DE LUMIèRES
Profil du voisin
Lucas L Voisin vérifié
5.0 91% fiable

Ronchin 59790

14€/j

Louer ces spots
5.0 91%
Location jeux de lumieres
Location jeux de lumieres
LOCATION JETS DE SCèNE
Profil du voisin
Clement B

Merville 59660

40€/j

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
LOCATION JEU DE LUMIèRE
Profil du voisin
Lorelei L

Mericourt 62680

25€/w-e

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
JEUX DE LUMIèRE ET MACHINE à FUMéE
Profil du voisin
Lorelei L

Mericourt 62680

25€/w-e

Louer ces spots
Location jeux de lumieres
Location jeux de lumieres
CHIFFRE LUMINEUX ANNIVERSAIRE 127CM EN B
Profil du voisin
Remi M

Lens 62300

20€

Louer ces spots

Louer un jeu de lumieres entre particuliers ou proposer un jeu de lumieres 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='441984'

  3. 0.0001

    INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (441984, 0, '/img/wiiz/271400-220804-1552-location-jeux-de-lumieres.jpeg', 0)

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jeux-de-lumieres' 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='271400' 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` = 271400

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=667 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

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

  39. 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='702' LIMIT 0,1

  40. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271400 AND note_visu IN (1,3,4)

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

  42. 0.0002

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

  43. 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='595' LIMIT 0,1

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

  46. 0.0001

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

  47. 0.0071

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.7- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>1.9957952035945 AND ville_longitude_deg<3.4042047964055 HAVING distance <= 50 ORDER BY distance ASC

  48. 0.0018

    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 (62161,62161,62161,62161,62223,62144,62000,62123,62144,62223,62123,62223,62144,62223,62223,62580,62690,62123,62144,62123,62123,62123,62690,62000,62217,62217,62690,62223,62123,62144,62153,62580,62690,62217,62123,62153,62690,62217,62690,62580,62810,62173,62690,62173,62223,62123,62123,62580,62217,62580,62530,62123,62810,62690,62580,62690,62810,62690,62690,62123,62217,62160,62173,62173,62580,62690,62223,62172,62530,62143,62217,62690,62810,62800,62123,62690,62810,62123,62690,62810,62160,62580,62690,62580,62118,62810,62175,62150,62175,62210,62150,62128,62158,62175,62580,62175,62123,62128,62150,62300,62128,62128,62118,62580,62127,62175,62810,62810,62116,62114,62320,62128,62160,62111,62680,62128,62530,62118,62150,62128,62158,62158,62127,62118,62121,62127,62580,62118,62750,62620,62127,62320,62300,62430,62127,62111,62490,62127,62670,62158,62116,62116,62150,62127,62810,62620,62810,62121,62158,62320,62320,62810,62111,62221,62218,62111,62121,62127,62118,62128,62420,62127,62810,62156,62128,62128,62980,62490,62127,62156,62810,62620,62940,62980,62290,62116,62150,62150,62760,62128,62810,62810,62118,62121,62760,62150,62158,62156,62127,62810,62620,62150,62110,62740,62127,62158,62490,62270,62410,62131,62156,62113,62113,62116,62149,62880,62440,62149,62113,62111,62410,62111,62490,62156,62131,62131,62111,62182,62640,80600,62127,62810,62880,62880,62121,62700,62460,62410,62127,62159,62128,62128,62127,62810,62196,62121,62810,62490,62460,62760,62760,62130,62460,62760,62182,62156,62710,62116,62660,62130,62121,62121,62121,62149,62270,62117,62880,62128,62111,62130,62950,62121,62138,62232,59553,62130,62130,62810,62138,62232,62760,62760,62760,62490,62156,62270,62199,62130,62450,62111,80560,62130,62119,62149,80600,62490,62270,62182,62470,62122,62138,62410,62540,80300,62130,59259,62270,80300,62182,62400,62450,80560,62232,62232,62138,62860,62470,62130,62112,62130,62112,62490,62550,62860,62970,80600,59480,80560,59552,62138,62122,62760,62270,62450,80560,62159,62159,59221,62450,80560,80300,59496,62920,62450,59553,59553,62860,80300,62400,62149,80300,59169,59151,62590,62550,62760,62810,80300,62260,80560,62760,62130,62450,62540,62450,80560,59552,62220,59128,62130,59500,80560,59496,62920,80600,62550,62141,62260,62860,59185,62130,62760,62124,62860,62860,62860,59950,62270,62450,62860,62270,62270,62550,62450,59151,62450,62124,62130,62550,59162,62400,62157,80560,62130,80300,80560,62130,62550,80600,59169,62450,62232,62840,62130,62130,62760,59274,62130,59151,80560,62860,62270,62450,62790,62550,62820,62860,80560,59112,59112,62151,62124,62760,62136,59480,62920,59286,62860,62760,59184,62130,62136,80300,59169,62270,62136,59134,59187,62130,80300,59251,62860,62550,62550,62860,59133,62260,62124,62760,59261,62270,59450,62270,59283,59272,80600,62450,59134,62450,80560,62840,62147,59119,80300,62860,62130,62350,62124,80560,80560,62550,80360,62124,62147,59283,59239,62550,62860,80600,80560,80560,80360,62130,80600,59151,59147,80300,62130,59133,62550,80300,80300,62450,59136,62190,80560,62450,80300,80560,62270,62147,59169,62134,59151,59147,62130,59239,62260,59287,62130,62130,62270,59134,62350,62124,62550,62147,80600,59194,59147,62190,62190,62270,62124,59249,62350,62134,80300,80360,62190,80600,62860,80600,59169,62270,80360,59194,59249,59551,59182,59287,62130,62270,62134,62136,62450,80600,80300,80300,62130,62190,80600,59265,80600,62450,80360,62550,59246,62134,62350,80300,59167,62190,59551,62134,59265,62270,80560,62860,62190,62120,62124,59234,62270,80600,62550,62350,80360,62130,62270,62147,62130,59400,59310,62134,59265,59263,59182,62350,80600,59134,62124,59113,62190,80360,62134,62147,59253,62124,59940,80300,80300,80300,80360,80630,62130,59660,62840,62270,62390,59554,59176,62270,80300,59234,59134,80300,62124,62124,80560,59710,62960,62960,62134,59554,80600,59211,80300,80560,80360,62130,59247,62390,59710,62960,80600,59148,80300,62120,62120,62134,59320,62330,59234,62390,62134,59176,59235,80600,59710,62134,59267,80300,59247,62350,59940,59400,80810,59139,59320,59320,80300,59265,59175,62134,59320,62840,59146,80360,80300,62147,62770,59320,62330,62770,80370,62134,59265,62390,62770,59165,80360,80300,59320,62120,59267,80600,59175,62124,59159,62840,80360,80300,62390,59268,59310,62134,80360,80560,80560,62770,59247,59139,62120,80360,59320,80370,59870,80600,80260,59554,59710,59580,59580,80300,62770,59252,59280,59267,80370,62960,62120,62120,80360,59554,59155,59320,59490,62770,62390,59554,62120,59159,62770,62390,80360,80300,59242,62134,59320,62960,80750,59310,62310,80360,80750,62145,80200,80360,59273,62145,59120,62310,80260,62770,62770,80260,59231,59252,62390,62770,59189,62770,59252,59554,80370,59940,80800,62120,59870,59242,62960,80260,59159,62310,80300,80340,80240,59840,59870,62120,80260,80260,80260,59161,80300,80670,59310,59400,80370,80800,59160,80300,80760,59490,59400,59111,80260,80240,59810,62145,59189,80113,59231,62310,59281,59295,59295,59193,80670,80200,62120,59161,59790,62310,80113,59141,62390,59870,59215,80340,80340,80340,59172,62390,59189,59280,80260,80200,62310,62770,59232,80370,59179,62770,59241,59181,80340,80370,80122,80240,59930,62310,62390,59273,62960,62770,59840,80260,59400,80260,62770,80260,80340,80370,62310,62960,62770,80800,59850,59231,59000,62120,59800,59160,59350,59777,59242,62310,59830,62770,59130,59111,80370,59310,59141,59171,59111,62140,59840,62120,59262,62145,62390,62390,80200,59260,59310,59270,59190,80240,59161,80800,80800,80340,59870,59270,59141,59297,80670,80620,80260,80240,80370,59172,62390,80800,59266,59161,59110,80800,59830,59171,59350,59116,59310,62310,80260,80670,59400,80260,80200,62140,80150,59870,80370,80800,80200,80800,80200,80670,62310,59400,80370,59830,62310,80800,62310,59830,62560,59237,59258,59258,59190,80200,80240,80260,80370,62310,80980,62120,59173,59156,59124,62140,80115,80260,80240,80240,80370,80370,59870,62770,59370,80370,59270,59266,80670,59310,62310,59270,80340,80340,62140,62140,80340,59293,59111,59400,62120,80200,80340,80800,59178,80112,62310,80740,59190,62310,80370,59310,59258,80620,59190,59266,80200,80370,80115,80670,59230,80200,59400,62140,62129,59152,59152,59700,59236,62129,62140,80150,59520,59173,80260,59171,62140,62390,59118,59830,62310,62310,80260,80800,59830,62560,62140,59178,59277,80150,80620,80850,80121,62140,80200,59152,62560,62120,59270,80340,80800,80200,80620,59230,62140,80260,80800,62140,59220,59282,59310,59690,62129,62140,59282,62390,59190,62120,80200,59173,80650,59190,62140,59830,62129,80800,62310,80150,80200,59780,80260,62310,59510,59296,80800,59217,59890,80200,80240,80260,80340,59400,59217,59152,59890,80800,59226,62310,02420,62140,62140,59178,80240,62560,02420,80740,80370,59255,80200,80200,80620,59135) AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='667' AND wish_id<>'441984' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

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

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

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

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

  67. 0.0005

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

  68. 0.0002

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

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

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

  72. 0.0002

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

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

  76. 0.0002

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

  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='667' LIMIT 0,1

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

  79. 0.0001

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

  80. 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='667' LIMIT 0,1

  81. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=359185 AND note_visu IN (1,3,4)

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

  83. 0.0001

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

  84. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 667

  85. 0.0009

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

  86. 0

    SELECT count(*) as nbwish FROM wish

  87. 0.0488

    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

87 requetes sql en 0.0683

Taille variable Globale : 78.5 KB