Voir les annonces autour de moi Géolocaliser
Poster une annonce
Voir les annonces autour de moi Géolocaliser
Proposer mon aide
Louer du matériel ou proposer un service
Faire appel à mes voisins
Besoin d'un objet ou d'un service ?
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='vetement'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=91
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('78' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT ville_nom FROM villes WHERE ville_cp='78280' AND ville_nom like '%guyancourt%' ORDER BY ville_population_2012 DESC LIMIT 0,1
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<>''
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE ssrubr_slug='robe-de-mariee' AND cate_id='91' LIMIT 0,1
SELECT COUNT(wish_id) AS nb FROM wish WHERE ssrubr_id=830 AND type_id=1 AND wish_visu IN (1,6,10)
SELECT ssrubr_meta_title, sssrubr_h1 FROM ssrubr WHERE ssrubr_id=830 LIMIT 1
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78280'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>1.7937867581343 AND ville_longitude_deg<2.3395532418657 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='Robe de mariée'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='91' AND ssrubr_id='830' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp like '78280%'
SELECT * FROM texte WHERE cate_id=91
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='robe mariée; robe de mariee' OR ssrubr_slug='robe-de-mariee' OR (ssrubr_title like '%robe mariée; robe de mariee%')) AND cate_id='91' ORDER BY ssrubr_id LIMIT 0,1
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='robe-de-mariee' AND cate_id='91'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='78280'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.3844560125509 AND ville_longitude_deg<2.7488839874491 HAVING distance <= 50 ORDER BY distance ASC
SELECT COUNT(*) AS cnt FROM (SELECT wish.wish_id FROM wish LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='91' AND ssrubr_id='830' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('78280','78280','78960','78180','78210','78114','78470','78117','78117','78530','78350','78390','78190','78470','78330','78000','91190','78350','91190','78590','78470','78460','78150','78220','78320','91400','78450','78340','78150','78990','78320','78720','78720','78590','78140','78870','91470','78860','78460','78320','78370','91440','92370','91430','91940','91190','92420','92430','78310','78450','78170','78720','78620','91470','78310','91570','78160','92410','92310','91400','91430','91400','78430','92380','91940','78380','78290','78760','78112','78750','91470','91470','78810','91940','78720','78640','78690','78560','78690','92190','92360','92210','78640','78400','91640','78850','78640','91120','92290','78490','92350','91370','78810','78100','78230','78240','92140','78240','78110','92100','91140','91140','78610','78640','92130','78490','78490','92260','92330','92500','78121','92320','91300','91160','92150','92800','91470','78830','91640','78720','78490','92160','78650','91160','78830','92220','78610','78125','92000','78630','78360','91640','91620','78490','92240','92340','78490','78490','94260','78300','92170','78650','91160','91380','78420','91640','92120','91460','78800','91160','78600','91680','92200','78124','91620','94239','94230','94232','94240','94233','94234','94235','94236','94237','94238','94231','78770','78610','78490','92400','94110','91320','78580','78580','92250') AND type_id=1 GROUP BY wish_id) t
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.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- 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='5' AND cate_id='91' AND ssrubr_id='830' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('78280','78280','78960','78180','78210','78114','78470','78117','78117','78530','78350','78390','78190','78470','78330','78000','91190','78350','91190','78590','78470','78460','78150','78220','78320','91400','78450','78340','78150','78990','78320','78720','78720','78590','78140','78870','91470','78860','78460','78320','78370','91440','92370','91430','91940','91190','92420','92430','78310','78450','78170','78720','78620','91470','78310','91570','78160','92410','92310','91400','91430','91400','78430','92380','91940','78380','78290','78760','78112','78750','91470','91470','78810','91940','78720','78640','78690','78560','78690','92190','92360','92210','78640','78400','91640','78850','78640','91120','92290','78490','92350','91370','78810','78100','78230','78240','92140','78240','78110','92100','91140','91140','78610','78640','92130','78490','78490','92260','92330','92500','78121','92320','91300','91160','92150','92800','91470','78830','91640','78720','78490','92160','78650','91160','78830','92220','78610','78125','92000','78630','78360','91640','91620','78490','92240','92340','78490','78490','94260','78300','92170','78650','91160','91380','78420','91640','92120','91460','78800','91160','78600','91680','92200','78124','91620','94239','94230','94232','94240','94233','94234','94235','94236','94237','94238','94231','78770','78610','78490','92400','94110','91320','78580','78580','92250') AND type_id=1 GROUP BY wish_id ORDER BY distance ASC, wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 600
SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (212598,194739,190205,310502,232433,196940,286595,237906,318373,295263,55086,222619,35248,297597,59300,15430,297636,229263,385371,252283,197808,122566,546399,241613,82352,78734,541744,293925)
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 = 212598 AND W.type_id = 1) OR (W.util_id <> 212598 AND W.type_id = 2)) AND (M.post_util_id = 212598 OR M.dest_util_id = 212598) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212598 AND note_visu IN (1,3,4)
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 = 194739 AND W.type_id = 1) OR (W.util_id <> 194739 AND W.type_id = 2)) AND (M.post_util_id = 194739 OR M.dest_util_id = 194739) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=194739 AND note_visu IN (1,3,4)
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 = 190205 AND W.type_id = 1) OR (W.util_id <> 190205 AND W.type_id = 2)) AND (M.post_util_id = 190205 OR M.dest_util_id = 190205) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=190205 AND note_visu IN (1,3,4)
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 = 310502 AND W.type_id = 1) OR (W.util_id <> 310502 AND W.type_id = 2)) AND (M.post_util_id = 310502 OR M.dest_util_id = 310502) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=310502 AND note_visu IN (1,3,4)
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 = 232433 AND W.type_id = 1) OR (W.util_id <> 232433 AND W.type_id = 2)) AND (M.post_util_id = 232433 OR M.dest_util_id = 232433) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232433 AND note_visu IN (1,3,4)
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 = 196940 AND W.type_id = 1) OR (W.util_id <> 196940 AND W.type_id = 2)) AND (M.post_util_id = 196940 OR M.dest_util_id = 196940) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196940 AND note_visu IN (1,3,4)
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 = 286595 AND W.type_id = 1) OR (W.util_id <> 286595 AND W.type_id = 2)) AND (M.post_util_id = 286595 OR M.dest_util_id = 286595) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=286595 AND note_visu IN (1,3,4)
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 = 237906 AND W.type_id = 1) OR (W.util_id <> 237906 AND W.type_id = 2)) AND (M.post_util_id = 237906 OR M.dest_util_id = 237906) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237906 AND note_visu IN (1,3,4)
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 = 318373 AND W.type_id = 1) OR (W.util_id <> 318373 AND W.type_id = 2)) AND (M.post_util_id = 318373 OR M.dest_util_id = 318373) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=318373 AND note_visu IN (1,3,4)
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 = 295263 AND W.type_id = 1) OR (W.util_id <> 295263 AND W.type_id = 2)) AND (M.post_util_id = 295263 OR M.dest_util_id = 295263) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=295263 AND note_visu IN (1,3,4)
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 = 55086 AND W.type_id = 1) OR (W.util_id <> 55086 AND W.type_id = 2)) AND (M.post_util_id = 55086 OR M.dest_util_id = 55086) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=55086 AND note_visu IN (1,3,4)
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 = 222619 AND W.type_id = 1) OR (W.util_id <> 222619 AND W.type_id = 2)) AND (M.post_util_id = 222619 OR M.dest_util_id = 222619) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222619 AND note_visu IN (1,3,4)
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 = 35248 AND W.type_id = 1) OR (W.util_id <> 35248 AND W.type_id = 2)) AND (M.post_util_id = 35248 OR M.dest_util_id = 35248) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=35248 AND note_visu IN (1,3,4)
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 = 297597 AND W.type_id = 1) OR (W.util_id <> 297597 AND W.type_id = 2)) AND (M.post_util_id = 297597 OR M.dest_util_id = 297597) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=297597 AND note_visu IN (1,3,4)
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 = 59300 AND W.type_id = 1) OR (W.util_id <> 59300 AND W.type_id = 2)) AND (M.post_util_id = 59300 OR M.dest_util_id = 59300) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=59300 AND note_visu IN (1,3,4)
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 = 15430 AND W.type_id = 1) OR (W.util_id <> 15430 AND W.type_id = 2)) AND (M.post_util_id = 15430 OR M.dest_util_id = 15430) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=15430 AND note_visu IN (1,3,4)
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 = 297636 AND W.type_id = 1) OR (W.util_id <> 297636 AND W.type_id = 2)) AND (M.post_util_id = 297636 OR M.dest_util_id = 297636) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=297636 AND note_visu IN (1,3,4)
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 = 229263 AND W.type_id = 1) OR (W.util_id <> 229263 AND W.type_id = 2)) AND (M.post_util_id = 229263 OR M.dest_util_id = 229263) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229263 AND note_visu IN (1,3,4)
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 = 385371 AND W.type_id = 1) OR (W.util_id <> 385371 AND W.type_id = 2)) AND (M.post_util_id = 385371 OR M.dest_util_id = 385371) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=385371 AND note_visu IN (1,3,4)
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 = 252283 AND W.type_id = 1) OR (W.util_id <> 252283 AND W.type_id = 2)) AND (M.post_util_id = 252283 OR M.dest_util_id = 252283) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=252283 AND note_visu IN (1,3,4)
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 = 197808 AND W.type_id = 1) OR (W.util_id <> 197808 AND W.type_id = 2)) AND (M.post_util_id = 197808 OR M.dest_util_id = 197808) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197808 AND note_visu IN (1,3,4)
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 = 122566 AND W.type_id = 1) OR (W.util_id <> 122566 AND W.type_id = 2)) AND (M.post_util_id = 122566 OR M.dest_util_id = 122566) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=122566 AND note_visu IN (1,3,4)
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 = 546399 AND W.type_id = 1) OR (W.util_id <> 546399 AND W.type_id = 2)) AND (M.post_util_id = 546399 OR M.dest_util_id = 546399) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546399 AND note_visu IN (1,3,4)
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 = 241613 AND W.type_id = 1) OR (W.util_id <> 241613 AND W.type_id = 2)) AND (M.post_util_id = 241613 OR M.dest_util_id = 241613) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=241613 AND note_visu IN (1,3,4)
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 = 82352 AND W.type_id = 1) OR (W.util_id <> 82352 AND W.type_id = 2)) AND (M.post_util_id = 82352 OR M.dest_util_id = 82352) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82352 AND note_visu IN (1,3,4)
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 = 78734 AND W.type_id = 1) OR (W.util_id <> 78734 AND W.type_id = 2)) AND (M.post_util_id = 78734 OR M.dest_util_id = 78734) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78734 AND note_visu IN (1,3,4)
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 = 541744 AND W.type_id = 1) OR (W.util_id <> 541744 AND W.type_id = 2)) AND (M.post_util_id = 541744 OR M.dest_util_id = 541744) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541744 AND note_visu IN (1,3,4)
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 = 293925 AND W.type_id = 1) OR (W.util_id <> 293925 AND W.type_id = 2)) AND (M.post_util_id = 293925 OR M.dest_util_id = 293925) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293925 AND note_visu IN (1,3,4)
SELECT util_id, util_connect FROM util_suivi WHERE util_id IN (212598,194739,190205,310502,232433,196940,286595,237906,318373,295263,55086,222619,35248,297597,59300,15430,297636,229263,385371,252283,197808,122566,546399,241613,82352,78734,541744,293925)
SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_title, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url 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 IN (830)
SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (194739,212598,190205,310502,232433,196940,286595,237906,318373,295263,59300,55086,222619,35248,297597,385371,197808,15430,297636,229263,252283,122566,546399,241613,82352,78734,541744,293925)
SELECT util_id, util_photo FROM util_info WHERE util_id IN (194739,212598,190205,310502,232433,196940,286595,237906,318373,295263,59300,55086,222619,35248,297597,385371,197808,15430,297636,229263,252283,122566,546399,241613,82352,78734,541744,293925)
SELECT cate_title_slug, cate_title FROM category WHERE cate_id=91 LIMIT 1
SELECT ss.ssrubr_id, ss.ssrubr_slug, ss.ssrubr_title, ss.ssrubr_mail, c.cate_title_slug FROM ssrubr ss INNER JOIN category c ON ss.cate_id = c.cate_id WHERE ss.ssrubr_id = 830 LIMIT 1
SELECT ssrubr_filtre_1, ssrubr_filtre_2, ssrubr_filtre_3, ssrubr_filtre_4, ssrubr_filtre_5, ssrubr_filtre_6, ssrubr_filtre_7, ssrubr_filtre_8, ssrubr_filtre_9 FROM ssrubr WHERE ssrubr_id=830 LIMIT 1
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous