-150kg
qu'à l'achat
Description de l'annonce
Durant le mois d'octobres
#Scooter
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-150kg
qu'à l'achat
Durant le mois d'octobres
#Scooter
Louer un scooter entre particuliers ou proposer un scooter en location.
Poster une annonce
-150kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
-150kg
qu'à l'achat
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
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 cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
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 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='596273'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='scooter' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='861'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'scooter' LIMIT 1
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='81'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('62' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='463911' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 463911
SELECT util_cp FROM utilisateur WHERE util_id=463911 LIMIT 1
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 596273
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=861 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 463911 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='596273'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='596273' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=463911 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=463911 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 = 463911 AND W.type_id = 1) OR (W.util_id <> 463911 AND W.type_id = 2)) AND (M.post_util_id = 463911 OR M.dest_util_id = 463911) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '596273'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='463911' AND wish_id<>'596273' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='62175'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.750339197041 AND ville_latitude_deg<50.649660802959 AND ville_longitude_deg>2.0808481920031 AND ville_longitude_deg<3.4858118079969 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('62175','62175','62121','62175','62175','62128','62121','62128','62175','62121','62217','62173','62128','62173','62128','62116','62121','62128','62116','62217','62116','62217','62116','62128','62128','62159','62173','62121','62217','62217','62217','62121','62217','62173','62128','62121','62121','62111','62128','62000','62121','62116','62121','62450','62128','62128','62128','62123','62123','62128','62128','62000','62223','62450','62123','62123','62116','62123','62223','62118','62223','62223','62111','62123','80300','62450','62223','80300','62450','62450','62182','62123','62182','62156','62123','62111','62159','62450','62111','62123','62450','80300','62223','62111','62156','62159','62111','62223','62450','62161','62118','62450','62118','62450','62118','80300','62161','62123','62156','62124','62111','62124','62156','62158','62161','62161','62158','62860','62118','62450','62450','62223','80300','62123','62123','80300','62182','62580','62158','62760','62860','62450','62124','62156','80300','62450','62123','62123','62118','62182','62810','62111','62580','62158','62580','62580','62124','80360','62810','62111','80560','62124','62580','80360','62810','62156','62123','62118','80560','62124','62580','62450','62810','62156','80560','62144','80300','62860','62760','62490','62147','62158','80560','62580','62490','62147','62144','62124','62450','80300','62860','62760','62580','80360','80560','62860','80300','62144','62580','80300','62450','62690','62124','59259','62760','62860','80360','62580','62450','80360','80300','80560','62860','62690','62580','62810','62810','62490','62147','62158','62860','62144','80560','80300','62580','62690','62810','62760','62760','62153','62490','80300','80360','80360','62860','62860','62153','62760','62147','80560','62124','80560','62690','80300','62124','62144','80360','62158','62690','62124','62860','62320','62690','62124','62810','62490','62690','62320','62490','62490','80300','80360','62810','62810','80560','62690','80300','62117','80300','62124','62320','62320','62210','80600','80560','80560','80300','62810','62860','62760','62860','62112','62810','62680','59151','80560','80560','59151','62147','62490','80360','62690','62690','80300','62860','62760','62127','62860','62147','62112','62690','80560','62800','80300','80300','80360','62143','80300','62300','80360','62810','59151','80360','62860','62690','59400','80560','62530','80560','62160','62430','62810','62690','62760','59553','80360','59169','62147','62124','80300','62810','62760','62690','59552','62810','62172','62420','62760','80810','59267','62690','62530','80200','80360','62127','59151','62127','59169','80560','80360','80600','62300','80360','59169','59159','62690','62110','62760','62160','80300','59552','80560','80360','62810','62760','62221','62218','62810','62127','62150','62127','80300','62860','62810','59554','80560','80240','59265','59500','62150','80760','59554','62810','59400','62740','62760','80240','62750','80340','59553','59553','59265','59267','80300','62150','62950','80300','62160','62640','80300','59231','80200','62127','59265','62760','62270','59151','80600','80600','80300','62114','80200','62810','62127','59187','62440','80600','59231','62127','59159','62127','59128','62150','62970','80300','80240','62530','80122','62119','80300','80340','62810','59265','80340','62710','80300','59267','62127','59159','59169','62127','80340','80340','62127','59450','80560','59247','59169','62620','80300','80200','80600','62670','62880','62880','62880','80340','62270','59234','62270','80600','59950','80240','80560','80560','80240','80800','59268','62150','59287','80560','59231','62127','62270','59234','59265','80600','62880','59554','62620','59119','80300','80200','62130','80600','62141','80200','80340','62410','62270','62980','62410','59247','59281','80113','80240','62980','62410','80200','59182','59287','59297','80200','80600','59554','59554','62150','59286','80240','80240','59241','59554','59400','62270','80200','59247','80980','62290','59234','62150','62790','62620','62940','62590','80800','80800','80200','62130','62150','59162','80113','80112','62127','62130','80260','59266','80600','59161','62127','80340','62130','80740','80340','62270','62130','62149','80340','80200','59283','62150','62620','80600','62149','59400','80260','80260','62113','62113','62270','80630','62130','59176','80200','59167','59266','62220','62410','80800','80200','59182','80800','59194','62113','80340','59161','59252','59400','62131','59266','80800','59258','80600','62130','59194','62270','62270','62131','62131','62460','59283','59176','80260','59258','80800','62460','62130','59252','80260','62138','62138','80200','80260','80800','80240','59165','62149','80200','62138','62700','80200','62820','59252','59580','80800','80800','80200','80121','62138','62130','59141','62196','80240','62460','80240','62660','59221','80200','59295','59295','80260','59400','62130','62130','59261','80340','80260','59258','62270','59580','59111','59400','02420','80740','59185','80340','80200','62149','59239','80600','59161','59141','59161','80240','59146','80600','59400','02420','80260','62138','80200','59480','62232','80260','59496','62270','80260','80200','80260','62130','62130','80800','80200','59496','80600','62232','59112','59400','80200','62270','80800','62130','80600','62199','59133','59148','62130','62130','80200','59490','80115','62470','80240','80131','62550','59141','80600','80260','62130','62270','62540','59239','59172','62122','59246','80800','62400','59112','80170','59111','59310','62470','02420','80240','62232','62232','59251','62130','59133','80800','80320','59870','80340','80800','80240','62270','59111','62149','02420','80200','02420','80600','62550','59274','80131','80320','62122','62550','62270','80115','02490','80600','59551','80750','59127','59215','80800','80240','59147','62400','59184','80131','02420','80600','59400','59217','59870','59551','80200','02420','59272','62270','59490','62920','80260','80320','80670','80200','80260','80240','62270','80800','02490','02420','62260','62130','80750','59277','02490','80260','80170','62390','59217','62540','59310','59172','80170','62840','62550','59235','62260','59710','62130','59480','62270','80800','59111','62920','59147','59134','62130','62130','59179','62270','59134','80200','59142','80320','80670','62130','62130','59147','80200','80370','59127','80260','62550','62400','62130','62550','80260','80380','80370','62270','59136','80240','62390','80200','80200','80720','59191','59217','59127','59293','59870','62157','59127','59171','59157','80200','62136','80670','59870','59156','62550','62550','59710','62232','80260','02420','80200','62130','80800','62840','80320','80320','80370','59129','62550','59710','59113','80320','62390','80260','62136','80170','62130','62130','59124','62270','62136','80320','02110','59296','59217','59134','59310','62130','59171','62151','80200','80670','59157','02420','02490','02490','59191','62920','59263','59310','80720','59282','80170','80670','62260','80440','59191','59188','59870','80370','62550','80110','80370','80260','62390','59282','80260','02420','62134','62390','62130','80380','62390','62550','59242','80370','80260','80720','59710','80170','59249','80320','80320','62270','59249','62350','80670','59127','59292','80370','62134','62134','59175','80320','59188','59220','80170','62550','59214','80620','62134','80450','02490','59171','59198','59175','59134','80190','02490','80380','59188','62390','59540','62770','59139','80110','59225','80136','02420','62130','59870','59870','80670','59310','62260','59242','62550','62130','62190','59211','80190','80260','80370','02590','80440','02490','59273','02420','62130','80370','02490','80650','02110','80170','80320','80190','80320','02420','59225','62350','59139','80110','59320','80400','80190','62190','62190','62136','59134','80450','80170','59178','59255','59540','62134','62134','59310','80850','62350','59320','80190','80400','59155','62190','62390','62134','80400','80370','80700','62770','59320','59220','62550','80370','59310','59320','59320','59135','62390','59227','59227','02490','02420','80620','59320','80110','62190','62350','80190','80190','62134','59178','80400','59230','80000','80080','80090','59121','62770','02110','80370','80370','62770','62134','02110','59238','62550','59242','62190','80700','62840','80700','02110','80170','80110','02590','02590','02420','80330','80330','80440','02760','62770','59310','62190','62120','59540','59940','80170','80190','59320','80440','02100','80110','80310','62770','62770','59220','59253','80190','59224','80170','59810','80370','62350','62190','59830','80170','62134','80190','59230','59178','59271','59273','62134','80190','80190','59195','59121','62350','59120','80110','80780','59980','59660','62390','62770','80110','59224','80620','59540','62134','62960','62960','59320','80118','80190','80110','62960','62770','59135','80620','59980','59980','80370','59790','62390','02100','59294','80370','59730','62134','80110','59320','80190','59980','80370','62770','59310','59730') AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='861' AND wish_id<>'596273' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=527276 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 = 527276 AND W.type_id = 1) OR (W.util_id <> 527276 AND W.type_id = 2)) AND (M.post_util_id = 527276 OR M.dest_util_id = 527276) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 527276
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=510644 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 = 510644 AND W.type_id = 1) OR (W.util_id <> 510644 AND W.type_id = 2)) AND (M.post_util_id = 510644 OR M.dest_util_id = 510644) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 510644
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=504205 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 = 504205 AND W.type_id = 1) OR (W.util_id <> 504205 AND W.type_id = 2)) AND (M.post_util_id = 504205 OR M.dest_util_id = 504205) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 504205
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=359532 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 = 359532 AND W.type_id = 1) OR (W.util_id <> 359532 AND W.type_id = 2)) AND (M.post_util_id = 359532 OR M.dest_util_id = 359532) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 359532
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293895 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 = 293895 AND W.type_id = 1) OR (W.util_id <> 293895 AND W.type_id = 2)) AND (M.post_util_id = 293895 OR M.dest_util_id = 293895) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 293895
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=446013 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 = 446013 AND W.type_id = 1) OR (W.util_id <> 446013 AND W.type_id = 2)) AND (M.post_util_id = 446013 OR M.dest_util_id = 446013) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 446013
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278180 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 = 278180 AND W.type_id = 1) OR (W.util_id <> 278180 AND W.type_id = 2)) AND (M.post_util_id = 278180 OR M.dest_util_id = 278180) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 278180
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 278180
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=224755 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 = 224755 AND W.type_id = 1) OR (W.util_id <> 224755 AND W.type_id = 2)) AND (M.post_util_id = 224755 OR M.dest_util_id = 224755) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 224755
SELECT ssrubr_slug, ssrubr_title, 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='861' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=217741 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 = 217741 AND W.type_id = 1) OR (W.util_id <> 217741 AND W.type_id = 2)) AND (M.post_util_id = 217741 OR M.dest_util_id = 217741) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 217741
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 861
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 861
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 (87) ORDER BY ssrubr_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 (88) ORDER BY ssrubr_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 (81) ORDER BY ssrubr_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 (110) ORDER BY ssrubr_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 (227) ORDER BY ssrubr_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 (176) ORDER BY ssrubr_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 (79) ORDER BY ssrubr_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 (208) ORDER BY ssrubr_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 (228) ORDER BY ssrubr_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 (207) ORDER BY ssrubr_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 (95) ORDER BY ssrubr_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 (173) ORDER BY ssrubr_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 (83) ORDER BY ssrubr_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 (93) ORDER BY ssrubr_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 (193) ORDER BY ssrubr_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 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
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
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