-3000kg
qu'à l'achat
Description de l'annonce
Bonjour je recherche un véhicule pour aller travailler
#Voiture sans permis
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-3000kg
qu'à l'achat
Bonjour je recherche un véhicule pour aller travailler
#Voiture sans permis
Louer une voiture entre particuliers ou proposer une voiture en location.
Poster une annonce
-3000kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
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='610505'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='voiture-sans-permis' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1094'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'voiture-sans-permis' 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('68' 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='481452' 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` = 481452
SELECT util_cp FROM utilisateur WHERE util_id=481452 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 = 610505
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1094 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 481452 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='610505'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='610505' 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=481452 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=481452 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 = 481452 AND W.type_id = 1) OR (W.util_id <> 481452 AND W.type_id = 2)) AND (M.post_util_id = 481452 OR M.dest_util_id = 481452) 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 = '610505'
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='481452' AND wish_id<>'610505' 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='68170'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.317039197041 AND ville_latitude_deg<48.216360802959 AND ville_longitude_deg>6.7310053833052 AND ville_longitude_deg<8.0689946166948 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 ('68170','68390','68400','68440','68390','68110','68200','68100','68440','68440','68260','68270','68490','68390','68440','68120','68490','68270','68440','68350','68460','68120','68440','68350','68440','68720','68790','68490','68720','68680','68440','68490','68510','68440','68190','68740','68840','68680','68510','68850','68310','68490','68950','68740','68990','68510','68510','68510','68510','68720','68720','68740','68540','68190','68130','68510','68510','68510','68720','68720','68890','68130','68870','68990','68190','68870','68540','68720','68130','68720','68500','68720','68130','68130','68720','68510','68130','68250','68740','68890','68520','68500','68130','68210','68500','68740','68128','68360','68130','68720','68250','68130','68700','68700','68520','68510','68700','68130','68500','68130','68740','68130','68730','68520','68130','68130','68740','68740','68700','68730','68720','68700','68210','68500','68700','68500','68740','68130','68800','68250','68250','68220','68130','68210','68500','68730','68700','68127','68960','68130','68210','68210','68500','68210','68210','68560','68220','68250','68220','68500','68128','68220','68500','68780','68500','68250','68800','68210','68220','68210','68118','68330','68600','68960','68560','68960','68960','68780','68800','68116','68500','68250','68220','68300','68128','68250','68530','68640','68800','68780','68600','68640','68220','68560','68220','68640','68530','68480','68620','68210','68210','68220','68640','68560','68290','68780','68210','68210','68760','68800','68780','68760','68210','68570','04056','68250','68640','04057','68210','04055','68780','68210','68600','68610','68210','68480','04018','04005','04091','04075','04000','04009','04070','04030','04020','04010','04002','04031','04019','68600','68210','04123','04123','68600','68210','04124','68210','68210','68610','68210','04054','04001','68210','04058','68420','68600','04089','04089','04039','04041','04041','04039','04089','04089','68780','04051','68580','68610','68290','68570','68280','68640','68127','68280','68210','68480','04125','04125','68690','68210','68220','68220','68420','04102','04102','68580','68210','68290','68600','68420','68420','90150','68480','68580','04053','68220','04052','04052','90360','68580','68600','68690','68550','90150','90150','68420','68280','68480','68480','68580','90360','68580','68480','68600','04101','04127','04126','68220','68580','68210','68290','04059','04104','68210','04105','04103','68480','68600','68480','68600','68420','68480','68210','68290','68230','90110','68550','68470','68480','04118','68580','04112','68600','04112','68480','68480','68470','90150','90150','04142','04042','04042','04040','90110','68210','68210','68210','68220','68580','04106','04142','90100','68420','04112','68290','04108','90100','90150','68290','90110','68480','04132','04132','90110','04115','04153','68230','04153','90100','90110','68480','68480','68280','90150','90150','68320','68480','68480','68140','68480','68470','90150','68380','68140','90150','68290','68290','68920','68480','04114','04116','68470','90130','90150','04107','90100','68290','68480','68470','90110','68920','04144','68180','68480','68230','68140','68290','04117','04133','90130','04133','68000','68830','68320','04302','90130','68140','68320','90150','04147','68230','68230','68480','68380','90170','68320','68320','68121','68470','90170','04223','90170','04303','68230','04303','90100','90100','04143','90370','02935','90100','68320','90150','90150','04243','68320','04402','04304','04148','02944','68320','68480','68140','90160','68140','68820','68380','04224','90100','90340','68480','68320','04244','04145','68290','90340','04414','68480','68040','90380','02814','04245','90170','68380','04222','68230','68230','90140','68380','02813','68480','04310','90140','90140','04310','90160','04202','90100','68140','90100','90200','02933','68320','68125','04305','68320','90300','04203','90200','04146','90100','90340','04412','68320','02933','04225','90100','90100','04422','04410','02943','68770','68480','04254','02807','02812','68320','68140','04242','90300','02947','90160','68820','90140','04313','90600','04421','02924','02807','90400','04204','04413','90300','02946','90200','04312','68320','90200','02805','04411','04253','90140','68240','02953','68910','04226','68240','02932','02806','04246','04423','04419','90400','04206','90100','68240','90200','90120','90140','02953','90000','90300','04232','68150','04252','02926','90330','04252','04453','02925','04415','02942','68980','88540','02803','90300','04464','68630','68630','90400','04227','04323','02923','04314','90200','04416','90400','04247','02800','02800','04417','88310','04451','02952','90400','04208','02800','02954','90300','04452','68370','90300','90100','02823','02822','90120','04433','04450','04234','90400','90100','68150','68340','67390','68340','02922','90400','04228','04207','04233','04463','25490','90850','02802','02900','02900','02900','02857','04322','90400','04424','25490','67390','90400','02828','04462','68650','88230','90850','04315','90350','04432','02824','90100','90200','02826','68970','68970','88250','02950','02950','04461','90100','04455','02825','25600','25490','04418','88160','88560','90700','25490','68240','67390','04425','90400','04434','02842','02915','02902','90200','04435','04441','90800','04426','90800','25600','88310','04229','02856','67390','67390','04465','90500','04324','02830','04316','04332','02827','02905','68750','70400','04436','04456','70400','04466','68150','70290','90800','04460','04442','25600','90100','02882','02882','02852','67390','25230','88160','70400','90800','68650','90500','04436','02854','02903','02888','04333','02883','02853','67390','02832','02827','02843','25200','25460','70290','04443','70400','04334','04719','02884') AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1094' AND wish_id<>'610505' 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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477334 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 = 477334 AND W.type_id = 1) OR (W.util_id <> 477334 AND W.type_id = 2)) AND (M.post_util_id = 477334 OR M.dest_util_id = 477334) 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 = 477334
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=539765 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 = 539765 AND W.type_id = 1) OR (W.util_id <> 539765 AND W.type_id = 2)) AND (M.post_util_id = 539765 OR M.dest_util_id = 539765) 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 = 539765
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=508880 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 = 508880 AND W.type_id = 1) OR (W.util_id <> 508880 AND W.type_id = 2)) AND (M.post_util_id = 508880 OR M.dest_util_id = 508880) 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 = 508880
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=480743 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 = 480743 AND W.type_id = 1) OR (W.util_id <> 480743 AND W.type_id = 2)) AND (M.post_util_id = 480743 OR M.dest_util_id = 480743) 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 = 480743
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=314509 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 = 314509 AND W.type_id = 1) OR (W.util_id <> 314509 AND W.type_id = 2)) AND (M.post_util_id = 314509 OR M.dest_util_id = 314509) 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 = 314509
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=468583 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 = 468583 AND W.type_id = 1) OR (W.util_id <> 468583 AND W.type_id = 2)) AND (M.post_util_id = 468583 OR M.dest_util_id = 468583) 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 = 468583
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=460719 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 = 460719 AND W.type_id = 1) OR (W.util_id <> 460719 AND W.type_id = 2)) AND (M.post_util_id = 460719 OR M.dest_util_id = 460719) 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 = 460719
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=412734 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 = 412734 AND W.type_id = 1) OR (W.util_id <> 412734 AND W.type_id = 2)) AND (M.post_util_id = 412734 OR M.dest_util_id = 412734) 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 = 412734
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=296776 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 = 296776 AND W.type_id = 1) OR (W.util_id <> 296776 AND W.type_id = 2)) AND (M.post_util_id = 296776 OR M.dest_util_id = 296776) 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 = 296776
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='1094' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=191362 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 = 191362 AND W.type_id = 1) OR (W.util_id <> 191362 AND W.type_id = 2)) AND (M.post_util_id = 191362 OR M.dest_util_id = 191362) 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 = 191362
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