Discuter
Description de l'annonce
Bonjour,
Je cherche un coffre de toit du 9.7 au 21.7.
Merci #coffre de toit
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour,
Je cherche un coffre de toit du 9.7 au 21.7.
Merci #coffre de toit
Annonces similaires
Tout voirLouer un coffre de toit entre particuliers ou proposer un coffre de toit en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
40€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='432833'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='coffre-de-toit' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='723'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'coffre-de-toit' 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='227'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='25'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='231552' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 231552
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 = 432833
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=723 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='432833'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='432833' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 231552 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=231552 LIMIT 1
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 = 231552 AND W.type_id = 1) OR (W.util_id <> 231552 AND W.type_id = 2)) AND (M.post_util_id = 231552 OR M.dest_util_id = 231552) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='231552' AND note_visu IN (1,3,4)
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 = '432833'
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='231552' AND wish_id<>'432833' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='25570'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.0262*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.0262*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.57001- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.576539197041 AND ville_latitude_deg<47.475860802959 AND ville_longitude_deg>5.9103514106836 AND ville_longitude_deg<7.2296685893164 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_cp IN ('25570','25790','25500','25500','25500','02406','02406','25650','25650','02406','02414','25500','25650','02406','25130','25650','25390','02124','02405','25690','25650','25650','02400','25500','25500','25650','02127','02316','02105','25390','25390','02113','25300','02416','02123','25650','25500','25210','02108','25390','02316','25390','25210','02112','02400','02400','25390','25690','25690','02318','02126','25520','02103','02114','25390','25210','25210','25690','02116','02149','25210','02149','02115','25300','25210','25210','25520','25300','02149','02322','25580','25580','25390','01428','02314','01453','02325','25210','25510','02019','25520','25520','02027','25210','25210','25690','02023','02117','01423','25800','25800','02019','25300','01453','25580','01428','25210','02206','02017','25580','25580','25530','01423','01423','02027','02024','01421','25520','02037','01423','25510','25300','02037','02301','02303','02304','01452','25210','25510','02014','25300','25510','01454','25530','25580','01431','25210','01421','25530','25380','25300','25800','25530','25580','01424','02208','02022','25520','02300','01425','01431','01427','02035','01420','02207','25510','25520','25300','25300','01426','25380','25920','25380','01426','02052','01450','02028','02025','02036','01450','25210','01429','02043','25380','01430','25520','02013','25210','02052','25930','25300','02016','02034','25520','01422','01454','01445','25530','25510','25580','25530','01450','25510','25300','02042','25580','02046','01441','02012','25140','02300','25330','25120','02053','25580','25520','02015','01443','25140','25380','25300','25530','02616','25580','25580','25380','25530','01440','01442','02063','25530','25530','25160','02616','25380','25580','25580','01443','01473','02063','01443','02333','25380','01400','01446','25840','02063','02054','25140','25530','01470','01475','01468','01436','25530','25380','01474','25300','02001','02002','02010','25160','02063','25330','01401','02054','25840','25140','01462','01400','01475','02000','01400','01545','25530','01436','25111','01404','25380','25160','25560','02333','25360','25380','25530','01439','01437','01473','02065','25120','25580','25380','01438','25270','02056','01544','25580','01404','02067','25620','25620','25560','01568','02336','01470','01463','01470','25120','25360','25430','25370','25430','25160','25160','01405','01475','25360','02068','01432','01355','01470','01355','01358','25160','01541','25370','25380','02615','25120','01589','01434','25360','25430','01489','25370','01406','01484','01483','01464','25370','25370','25360','25330','01412','25360','25330','25190','01542','02615','02057','01357','25560','25360','01415','01483','25270','25430','01432','02072','25430','01541','01543','01541','02058','25160','25370','25360','01356','25430','01407','25360','25120','02610','01464','25430','01407','25620','01354','25290','25430','01417','01567','01538','01565','01435','25330','25190','01412','25190','01407','01350','25120','25190','01484','25360','01485','01483','02074','02074','25110','01537','01356','02073','01433','01415','25360','02075','02087','25430','25430','25270','25560','25560','25110','01482','25450','25330','25330','01588','25360','01413','25190','01408','01566','02345','01352','01338','02075','25160','25110','01535','01587','25470','01565','25190','25290','02610','25160','25370','01407','02610','01417','01584','02340','01566','01329','01530','01534','25620','02088','25470','25110','01373','01409','25110','01486','01047','01536','25620','01534','01587','01533','25360','25430','01374','01585','25340','25620','25430','01353','25470','01562','25190','25560','01532','01585','01324','25470','25470','25340','01410','25110','25190','01529','02523','03238','25330','25110','25370','25620','25470','01563','01045','01416','25370','25190','03236','01410','25190','25190','25620','25620','01586','25360','02613','01585','25560','25270','01523','02345','01410','01321','02525','01046','25190','25360','25110','01528','25190','01787','25620','25160','25110','25330','25330','01375','01418','01551','25290','01564','01322','01528','25360','25340','01337','03233','01526','01787','01372','01323','01038','01410','25190','25330','25560','01552','01580','25470','01527','25640','01789','01524','25190','25190','25190','01773','01515','01318','01774','01774','25110','02610','25110','25110','25110','25470','25620','02338','02338','25470','01526','02612','01525','01317','01326','02518','01775','25820','25340','25110','01776','25240','25150','02354','25240','01376','01410','25340','01787','25190','25270','01522','01515','25250','01749','01044','25560','01063','25150','01595','25110','25340','01580','25660','01325','03235','01525','25150','01555','01773','01522','01774','02520','25330','01376','01040','25330','25330','01580','03280','25270','03232','02345','01775','25640','25640','25660','25190','01148','01313','01553','25660','01788','25960','25110','25110','01682','01773','25290','01514','39250','25340','25470','01786','03234','39250','01315','01063','03280','01312','01748','01063','01554','25340','25240','25640','25640','25250','25250','01041','25290','25270','01583','02350','25340','01376','25270','02515','01521','02608','01043','01595','25110','01377','25150','01554','01682','01721','25660','25150','01148','01682','02608','25340','02353','01721','02723','25220','25640','01747','01772','25290','25220','01796','02517','25270','01510','25240','01063','01746','01721','25110','01316','25470','01772','25330','01721','01757','03286','01040','01062','25660','01682','25330','01342','01682','25660','01040','25340','01041','01041','39250','25220','01041','02514','01343','01795','01148','01683','01691','01772','25190','02360','39250','03225','25310','25150','01307','01304','25220','01061','25310','25240','01683','02722','01797','03280','03237','25640','25640','25110','25640','01513','01745','01306','01756','25640','01690','25220','03285','01784','25660','01721','02607','25150','25190','25330','01042','01754','25440','39250','25110','02576','01681','01680','25270','01512','01681','01782','25310','25340','01148','01690','01744','03226','25250','25110','02914','25270','01042','25250','01756','01785','25250','01683','01513','01510','25220','25220','01148','01782','01308','25150','01042','01720','01059','01041','01754','25640','25640','25470','02513','25640','02516','39250','01784','01794','01304','01782','01694','01791','01674','01345','01792','01754','25110','01305','25240','25240','25660','01754','25440','25340','25640','02577','01041','01782','25150','25250','01035','25340','01058','02363','01674','03216','39250','25680','02912','25260','25220','01674','01741','25440','01148','01344','01680','02575','25310','01783','25150','01678','39110','02362','25680','03215','01720','02606','25440','01034','03215','25440','01509','25250','25640','25250','25250','01684','02720','25440','01742','25250','25720','25720','01792','02714','01740','01037','01148','01694','01670','02534','25440','01782','39250','25250','25680','02577','25640','25640','25260','02887','01303','01793','02575','25000','01053','25720','01753','03210','39110','01304','02912','25680','25640','25310','39110','39250','25640','39250','01304','01692','01686','01085','02720','01782','25700','02575','39250','25640','01148','01345','25260','01670','01695','03212','25240','25680','01088','25440','25440','25310','01783','39250','01679','01036','01762','25440','01054','01148','01055','03284','25190','25680','25340','01695','03216','25640','03215','02512','25440','25680','01670','01082','01117','25310','03214','25720','39250','39250','39250','01673','01676','01730','03213','39250','39250','25250','01726','39110','02572','03283','02908','25640','01673','25680','01124','02714','01039','25240','25240','01677','01694','01726','39250','25640','03208','25250','01763','01685','39110','01033','03212','01752','01752','01053','25310','25320','03272','03206','01084','02605','01675','03272','25680','25640','01147','25870','25260','01725','02907','01695','03206','02572','39110','25720','02362','01031','25680','39110') AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='723' AND wish_id<>'432833' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=534496 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 = 534496 AND W.type_id = 1) OR (W.util_id <> 534496 AND W.type_id = 2)) AND (M.post_util_id = 534496 OR M.dest_util_id = 534496) 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 = 534496
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317460 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 = 317460 AND W.type_id = 1) OR (W.util_id <> 317460 AND W.type_id = 2)) AND (M.post_util_id = 317460 OR M.dest_util_id = 317460) 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 = 317460
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=261805 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 = 261805 AND W.type_id = 1) OR (W.util_id <> 261805 AND W.type_id = 2)) AND (M.post_util_id = 261805 OR M.dest_util_id = 261805) 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 = 261805
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=179155 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 = 179155 AND W.type_id = 1) OR (W.util_id <> 179155 AND W.type_id = 2)) AND (M.post_util_id = 179155 OR M.dest_util_id = 179155) 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 = 179155
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=163326 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 = 163326 AND W.type_id = 1) OR (W.util_id <> 163326 AND W.type_id = 2)) AND (M.post_util_id = 163326 OR M.dest_util_id = 163326) 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 = 163326
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 723
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 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'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous