Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Service pose cuisine à 91330 Yerres


Service pose cuisine : 1 annonces de pose cuisine entre particuliers à 91330 Yerres Vous voulez faire une installation de cuisine toute équipée ou vous cherchez une personne pour le montage de cuisine d'été ? Faire appel à un artisan cuisiniste pour faire votre plan de travail de cuisine et pour la pose de votre cuisine est essentiel pour l'agencement de votre cuisine. Faire poser sa cuisine doit être étudiée avec soins, même pour le montage de cuisine en kit et surtout pour la pose de cuisine sur mesure. Pour un prix de pose de cuisine pas cher, trouvez un voisin cuisiniste en extra autour de chez vous pour un service de pose de cuisine entre particuliers.
 ... voir la suite
Demander un service / jobbing de pose de cuisine ou proposer un service de pose de cuisine entre particuliers.
Poster une annonce

Retour
Fermer

Service › Bricoleur

Lancez votre recherche pour voir les annonces.

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0002

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  2. 0.0001

    SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='bricolage'

  3. 0

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=50

  4. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('91' USING utf8mb4) COLLATE utf8mb4_general_ci

  5. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='91330' AND ville_nom like '%yerres%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  6. 0.0005

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0002

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%pose%de%cuisine%' OR ssrubr_title like '%pose%de%cuisine%' OR ssrubr_slug like '%pose%de%cuisine%') AND cate_id='50' ORDER BY ssrubr_id LIMIT 0,1

  8. 0.0001

    SHOW TABLES LIKE 'pays'

  9. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  10. 0.0002

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  11. 0.0001

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

  12. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.536835678816 AND ville_latitude_deg<48.896564321184 AND ville_longitude_deg>2.227388085411 AND ville_longitude_deg<2.772611914589 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='pose cuisine; pose de cuisine'

  14. 0.0003

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='50' AND ssrubr_id='604' AND wish_visu IN (1,6,10) AND wish_cp like '91330%'

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=50

  16. 0.0003

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='pose cuisine; pose de cuisine' OR ssrubr_slug='pose-cuisine;-pose-de-cuisine' OR (ssrubr_title like '%pose cuisine; pose de cuisine%')) AND cate_id='50' ORDER BY ssrubr_id LIMIT 0,1

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='pose-de-cuisine' AND cate_id='50'

  18. 0.0001

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

  19. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.536835678816 AND ville_latitude_deg<48.896564321184 AND ville_longitude_deg>2.227388085411 AND ville_longitude_deg<2.772611914589 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.267039197041 AND ville_latitude_deg<49.166360802959 AND ville_longitude_deg>1.8184643365919 AND ville_longitude_deg<3.1815356634081 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.0043

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND ssrubr_id='604' AND wish_visu IN (1,6,10) AND wish_cp IN (91330,91330,91800,94450,94440,91560,94470,91860,94520,94520,94440,91230,94190,94460,91800,94440,94380,94370,91480,94380,94480,77170,91480,94290,91270,91210,91200,77380,94000,94310,94390,94880,94880,94600,94490,91450,77150,94210,94100,94340,91250,91260,77170,94430,91450,94510,91000,91130,91550,77150,91090,77127,91000,94320,91170,94400,94700,94140,91280,94500,91250,91350,94340,94410,94150,77340,77166,94420,77173,94550,91600,91390,91320,91420,94220,77166,91250,94130,94360,91100,91080,77550,77330,91360,94800,94350,91700,94260,77184,94205,94200,91070,94235,94236,94238,94231,94234,94237,94233,94232,94239,94240,94230,94160,91090,77680,91360,91160,91380,94270,94170,94120,92340,93330,92160,91100,94110,91700,77111,77185,77550,93160,94300,77176,77170,91300,91700,94250,77420,77550,91830,91250,93110,93360,91160,77220,91160,77135,92220,91240,91540,91540,93100,93460,92120,91220,77550,91220,91370,91160,92260,92330,77111,77186,93170,77176,77183,77090,92290,91540,77240,91120,77220,92320,92240,91310,91140,77200,93250,92350,91620,93220,93130,77390,77240,77240,77164,93230,93260,77950,91810,92140,91310,91310,92170,75016,75015,75017,75018,75019,75020,75116,75014,75013,75001,75000,75002,75004,75005,75006,75007,75008,75012,75011,75003,75009,75010,77220,77220,91140,93310,77500,91540,77360,77600) AND type_id=1 GROUP BY wish_id

  22. 0.0001

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (58408,71582,80255,109226,118517,124666,128033,128459,112783,132414,137349,145057,111209,157302,197347,206377,221800,264409,274733,283130,35191,254891,146058,262874,233510,313463,13600,377795,289357,403584,147429,223503,493329)

  23. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 58408 AND W.type_id = 1) OR (W.util_id <> 58408 AND W.type_id = 2)) AND (M.post_util_id = 58408 OR M.dest_util_id = 58408) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  24. 0.0001

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

  25. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 71582 AND W.type_id = 1) OR (W.util_id <> 71582 AND W.type_id = 2)) AND (M.post_util_id = 71582 OR M.dest_util_id = 71582) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  26. 0.0001

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

  27. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 80255 AND W.type_id = 1) OR (W.util_id <> 80255 AND W.type_id = 2)) AND (M.post_util_id = 80255 OR M.dest_util_id = 80255) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  28. 0.0001

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

  29. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 109226 AND W.type_id = 1) OR (W.util_id <> 109226 AND W.type_id = 2)) AND (M.post_util_id = 109226 OR M.dest_util_id = 109226) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  30. 0.0001

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

  31. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 118517 AND W.type_id = 1) OR (W.util_id <> 118517 AND W.type_id = 2)) AND (M.post_util_id = 118517 OR M.dest_util_id = 118517) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  32. 0.0001

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

  33. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124666 AND W.type_id = 1) OR (W.util_id <> 124666 AND W.type_id = 2)) AND (M.post_util_id = 124666 OR M.dest_util_id = 124666) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  34. 0.0001

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

  35. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128033 AND W.type_id = 1) OR (W.util_id <> 128033 AND W.type_id = 2)) AND (M.post_util_id = 128033 OR M.dest_util_id = 128033) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  36. 0.0001

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

  37. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128459 AND W.type_id = 1) OR (W.util_id <> 128459 AND W.type_id = 2)) AND (M.post_util_id = 128459 OR M.dest_util_id = 128459) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  38. 0.0001

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

  39. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 112783 AND W.type_id = 1) OR (W.util_id <> 112783 AND W.type_id = 2)) AND (M.post_util_id = 112783 OR M.dest_util_id = 112783) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  40. 0.0001

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

  41. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132414 AND W.type_id = 1) OR (W.util_id <> 132414 AND W.type_id = 2)) AND (M.post_util_id = 132414 OR M.dest_util_id = 132414) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  42. 0.0001

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

  43. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137349 AND W.type_id = 1) OR (W.util_id <> 137349 AND W.type_id = 2)) AND (M.post_util_id = 137349 OR M.dest_util_id = 137349) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  44. 0.0001

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

  45. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145057 AND W.type_id = 1) OR (W.util_id <> 145057 AND W.type_id = 2)) AND (M.post_util_id = 145057 OR M.dest_util_id = 145057) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  46. 0.0001

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

  47. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111209 AND W.type_id = 1) OR (W.util_id <> 111209 AND W.type_id = 2)) AND (M.post_util_id = 111209 OR M.dest_util_id = 111209) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  48. 0.0001

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

  49. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 157302 AND W.type_id = 1) OR (W.util_id <> 157302 AND W.type_id = 2)) AND (M.post_util_id = 157302 OR M.dest_util_id = 157302) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  50. 0.0001

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

  51. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 197347 AND W.type_id = 1) OR (W.util_id <> 197347 AND W.type_id = 2)) AND (M.post_util_id = 197347 OR M.dest_util_id = 197347) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  52. 0.0001

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

  53. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206377 AND W.type_id = 1) OR (W.util_id <> 206377 AND W.type_id = 2)) AND (M.post_util_id = 206377 OR M.dest_util_id = 206377) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  54. 0.0001

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

  55. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 221800 AND W.type_id = 1) OR (W.util_id <> 221800 AND W.type_id = 2)) AND (M.post_util_id = 221800 OR M.dest_util_id = 221800) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  56. 0.0001

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

  57. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 264409 AND W.type_id = 1) OR (W.util_id <> 264409 AND W.type_id = 2)) AND (M.post_util_id = 264409 OR M.dest_util_id = 264409) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  58. 0.0001

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

  59. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 274733 AND W.type_id = 1) OR (W.util_id <> 274733 AND W.type_id = 2)) AND (M.post_util_id = 274733 OR M.dest_util_id = 274733) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  60. 0.0001

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

  61. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 283130 AND W.type_id = 1) OR (W.util_id <> 283130 AND W.type_id = 2)) AND (M.post_util_id = 283130 OR M.dest_util_id = 283130) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  62. 0.0001

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

  63. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 35191 AND W.type_id = 1) OR (W.util_id <> 35191 AND W.type_id = 2)) AND (M.post_util_id = 35191 OR M.dest_util_id = 35191) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  64. 0.0001

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

  65. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254891 AND W.type_id = 1) OR (W.util_id <> 254891 AND W.type_id = 2)) AND (M.post_util_id = 254891 OR M.dest_util_id = 254891) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  66. 0.0001

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

  67. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 146058 AND W.type_id = 1) OR (W.util_id <> 146058 AND W.type_id = 2)) AND (M.post_util_id = 146058 OR M.dest_util_id = 146058) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  68. 0.0001

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

  69. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 262874 AND W.type_id = 1) OR (W.util_id <> 262874 AND W.type_id = 2)) AND (M.post_util_id = 262874 OR M.dest_util_id = 262874) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  70. 0.0001

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

  71. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 233510 AND W.type_id = 1) OR (W.util_id <> 233510 AND W.type_id = 2)) AND (M.post_util_id = 233510 OR M.dest_util_id = 233510) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  72. 0.0001

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

  73. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 313463 AND W.type_id = 1) OR (W.util_id <> 313463 AND W.type_id = 2)) AND (M.post_util_id = 313463 OR M.dest_util_id = 313463) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  74. 0.0001

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

  75. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 13600 AND W.type_id = 1) OR (W.util_id <> 13600 AND W.type_id = 2)) AND (M.post_util_id = 13600 OR M.dest_util_id = 13600) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  76. 0.0001

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

  77. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377795 AND W.type_id = 1) OR (W.util_id <> 377795 AND W.type_id = 2)) AND (M.post_util_id = 377795 OR M.dest_util_id = 377795) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  78. 0.0001

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

  79. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 289357 AND W.type_id = 1) OR (W.util_id <> 289357 AND W.type_id = 2)) AND (M.post_util_id = 289357 OR M.dest_util_id = 289357) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  80. 0.0001

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

  81. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 403584 AND W.type_id = 1) OR (W.util_id <> 403584 AND W.type_id = 2)) AND (M.post_util_id = 403584 OR M.dest_util_id = 403584) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  82. 0.0001

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

  83. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147429 AND W.type_id = 1) OR (W.util_id <> 147429 AND W.type_id = 2)) AND (M.post_util_id = 147429 OR M.dest_util_id = 147429) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  84. 0.0001

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

  85. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 223503 AND W.type_id = 1) OR (W.util_id <> 223503 AND W.type_id = 2)) AND (M.post_util_id = 223503 OR M.dest_util_id = 223503) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  86. 0.0001

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

  87. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 493329 AND W.type_id = 1) OR (W.util_id <> 493329 AND W.type_id = 2)) AND (M.post_util_id = 493329 OR M.dest_util_id = 493329) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  88. 0.0001

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

  89. 0.0001

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

  90. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.536835678816 AND ville_latitude_deg<48.896564321184 AND ville_longitude_deg>2.227388085411 AND ville_longitude_deg<2.772611914589 HAVING distance <= 20 ORDER BY distance ASC

  91. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.267039197041 AND ville_latitude_deg<49.166360802959 AND ville_longitude_deg>1.8184643365919 AND ville_longitude_deg<3.1815356634081 HAVING distance <= 50 ORDER BY distance ASC

  92. 0.0002

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='pose cuisine; pose de cuisine' OR ssrubr_slug like '%pose cuisine; pose de cuisine%' OR MATCH (ssrubr_slug) AGAINST ('(+pose +cuisine; +pose +de +cuisine)')) AND sk.ssrubr_id='604' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  93. 0.0001

    SELECT * FROM actu WHERE ssrubr_id='604' AND actu_niveau=0 ORDER BY actu_ordre DESC

  94. 0.0001

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

  95. 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='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  96. 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 (50) ORDER BY ssrubr_order ASC

  97. 0.0011

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

  98. 0.0238

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  99. 0.021

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

99 requetes sql en 0.0781

Taille variable Globale : 83.95 KB