Discuter
Description de l'annonce
Bonjour je recherche une location d'une machine à glace pillée pour vendredi 26 mai s'il vous plaît #machine a glace
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour je recherche une location d'une machine à glace pillée pour vendredi 26 mai s'il vous plaît #machine a glace
Annonces similaires
Tout voirLouer une machine (glace) entre particuliers ou proposer une machine (glace) 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='501082'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='machine-a-glace' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='846'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'machine-a-glace' 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='207'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='338037' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 338037
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 = 501082
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=846 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='501082'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='501082' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 338037 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=338037 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 = 338037 AND W.type_id = 1) OR (W.util_id <> 338037 AND W.type_id = 2)) AND (M.post_util_id = 338037 OR M.dest_util_id = 338037) 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='338037' 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 = '501082'
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='338037' AND wish_id<>'501082' 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='95580'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.6145960970883 AND ville_longitude_deg<2.9854039029117 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 ('95580','95580','95600','95230','95680','95160','95120','95390','95170','95210','95218','95880','95320','95410','95350','95330','95130','95350','95110','95360','95130','93430','95570','93800','95560','95570','95400','95200','93380','95460','95440','95840','95100','95570','95150','95550','92230','95560','95560','95240','95250','92390','93450','95740','93240','93200','93210','95370','95400','95840','95720','95530','95140','95720','95590','95560','92270','95870','95220','95480','95720','92600','92700','78500','93440','95540','95720','95500','95570','93120','93300','95270','95500','92110','92300','93350','93400','92250','95270','78800','95430','95630','92400','95500','95430','95850','95190','78600','95190','95270','78420','95590','92200','95190','93700','93150','95760','92000','93500','95500','95290','95620','95850','78360','95310','78600','95610','78700','95590','95260','95270','92500','93310','95260','95270','95380','95660','95270','95380','95270','95270','95270','92800','92150','95270','95300','93000','95700','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','95270','93260','93230','95300','95300','95270','93140','93600','95340','78400','78780','95690','93170','78570','95000','95670','95470','78110','95000','78260','93420','93100','93130','95380','95300','78230','95690','92170','95340','95520','95820','93270','95380','92210','78560','60230','92100','60820','95380','78290','78380','95690','60260','94300','78100','93320','93340','95650','95340','78570','95280','93250','92380','78300','95490','95690','95810','78170','78430','93110','78955','92240','94160','60530','92120','78750','93190','93390','92130','94250','60580','92430','92420','93290','95650','95470','93410','94270','77990','92410','94200','94205','95470','95650','95810','94120','78112','93220','95470','92310','60560','78160','93360','92190','92360','95000','77990','78510','60270','94220','95810','94170','95800','60530','92220','92320','60530','92140','94110','78240','93370','60520','78670','78670','78620','77181','93470','60460','94800','78150','94130','78870','60540','60540','77230','95180','78480','77290','78150','78540','92370','94410','60128','95810','78240','94340','95650','95650','77230','95810','78140','94140','78590','93330','60530','92260','92330','60530','92350','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','78220','94700','77270','78740','95830','94360','93460','60540','77230','60520','95450','78630','77181','95810','92340','60460','60540','60340','94400','60500','78000','95830','60128','77500','60340','78740','93160','95450','94500','60110','60530','60500','60110','78590','94350','92290','95450','60530','94550','60740','95640','95810','60520','78860','94100','94210','94340','60540','94320','95450','77290','77230','94000','78130','77410','77410','94430','94600','77230','95640','78330','77420','77177','78350','95450','78630','78450','92160','94260','91370','78130','60300','60300','78250','78210','94150','94420','95450','95640','91570','78810','77230','78920','78450','60110','95640','78350','78530','60660','60119','94310','94390','78250','77230','94380','78250','77410','77230','78410','77410','77280','60570','60160','78580','95640','95640','77186','77360','95640','77185','91300','95450','77410','91320','78121','78250','60240','60730','60660','60660','60950','94490','94880','94880','91430','60660','60660','60119','60300','94460','60175','60300','78390','77230','77200','91430','78250','95450','60330','78810','95450','60730','78340','77184','60570','78117','94290','77400','78280','94370','94380','60160','91400','77230','60110','60300','60730','60250','95640','94190','77340','77230','77400','91120','60119','94510','77410','95450','78410','91550','95450','94470','60180','60730','91200','78580','77400','60173','95450','78180','78580','77410','95750','60100','94450','78190','77090','77183','78850','77600','94480','60950','78370','77400','78820','95450','60300','77230','78250','78410','78117','77400','78960','78440','60240','60300','91380','91160','91560','60250','91160','91420','95450','60300','60300','78124','60730','91140','60300','77600','77600','78126','91190','77400','77680','77165','60330','77165','78580','60660','60149','78124','77400','78114','60870','91190','77410','91400','91270','78440','77230','77600','78410','78410','78640','60700','95750','60110','91330','60240','91440','78470','94440','60950','60570','60290','91230','78990','78440','60550','60250','78440','77165','77165','91160','77450','77410','60250','60790','60430','60290','60240','91140','77164','78640','78680','77410','91260','95420','78650','60330','94440','77600','60790','60240','60810','95420','95450','78440','77410','77144','78470','91210','60810','60790','91800','60240','77144','77700','60240','60300','91940','78640','78440','77165','78970','77135','60240','60290','60240','60870','77450','78470','60790','77450','94440','91160','91360','91360','77178','60250','91390','91600','60140','91940','91190','77330','91170','78770','77150','95420','78640','78440','60240','77170','78440','77600','60430','60290','78320','60810','78760','60790','60870','78460','94520','94520','60240','60790','60940','60330','77700','60440','78310','95420','60240','78770','60290','60810','60240','91940','95510','78320','77150','77178','77450','60940','91860','60430','78650','78580','60250','91700','77122','60250','91620','60250','60140','77700','78440','91800','60700','91620','60250','95420','95420','78440','60440','77450','91350','91400','78770','77124','78310','60430','60290','60240','78930','60940','91470','60240','78490','60240','78490','60140','91000','91130','60440','60700','78770','78720','78930','77450','78770','78720','78440','60430','60140','91640','91450','95420','77165','77165','60240','77450','60240','91480','78770','77700','78320','60440','60240','60810','95510','91240','78490','78490','60370','91310','91470','91480','60810','91310','91310','60250','91700','78460','60370','78770','77450','60370','91460','91700','95420','78690','77173','78520','77124','60700','60140','60800','77100','77124','78490','77174','77380','60600','60700','95510','60390','78930','91470','77100','77700','60410','60440','78720','77170','60430','77860','91090','91000','95420','60440','60240','60810','60390','91450','78520','77910','78200','77124','91220','91220','60240','77139','60240','60240','95420','78200','78711','95510','78490','78490','78490','91310','77580','78790','78790','60430','78930','60240','60700','78690','60390','91470','95420','60134','60600','91070','77139','60134','60600','91080','78930','91250','77860','77220','60410','60390','60800','60140','77910','77220','60240','78520','77174','60600','60840','91640','78490','77860','60390','60440','60240','60410','77166','60240','95780','78720','78930','78930','77100','78790','60700','78910','91180','60600','60240','91640','91250','77127','60930','60800','60240','78940','95420','60600','78890','60240','91470','91680','91280','78910','78200','78610','60700','77220','60440','91090','78910','60000','77166','60600','77220','77139','60800','91680','78490','95510','60410','78790','60240','95420','60430','77910','78200','60390','77580','77580','60590','60510','77139','77470','78790','91290','60510','60000','91640','91100','60510','91290','60710','78200','60240','60590','91520','91340','78840','95710','95710','91250','77610','60240','78610','77580','78830','78940','77580','95780','60510','78200','77470','60320','77170','60410','60190','60190','78910','77910','60190','78200','78790','77580','78200','60590','60410','78910','60510','60600','91100','60240','78270','77220','78200','77470','60800','60390','60710','60800','60620','60620','78830','77550','77111','78200','77470','60190','60680','78125','78720','91630','91630','60600','77390','91530','91630','60510','91630','60600','91810','60190','60590','78610','78710','78520','95510','60620','60590','60390','78910','60510','60800','77163','91540','77580','78270','60600','77440','91650','60600','77610','60155','27140','27630','91650','91540','91540','78790','77440','95770','60126','91470','60590','77111','95780','77139','78200','77470','95710','60600','60320','77580','60800','60129','60620','60240','78270','78490','77610','78790','60600') AND fami_id='5' AND cate_id='207' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='846' AND wish_id<>'501082' 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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549775 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 = 549775 AND W.type_id = 1) OR (W.util_id <> 549775 AND W.type_id = 2)) AND (M.post_util_id = 549775 OR M.dest_util_id = 549775) 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 = 549775
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=524136 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 = 524136 AND W.type_id = 1) OR (W.util_id <> 524136 AND W.type_id = 2)) AND (M.post_util_id = 524136 OR M.dest_util_id = 524136) 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 = 524136
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=438593 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 = 438593 AND W.type_id = 1) OR (W.util_id <> 438593 AND W.type_id = 2)) AND (M.post_util_id = 438593 OR M.dest_util_id = 438593) 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 = 438593
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=343533 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 = 343533 AND W.type_id = 1) OR (W.util_id <> 343533 AND W.type_id = 2)) AND (M.post_util_id = 343533 OR M.dest_util_id = 343533) 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 = 343533
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339299 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 = 339299 AND W.type_id = 1) OR (W.util_id <> 339299 AND W.type_id = 2)) AND (M.post_util_id = 339299 OR M.dest_util_id = 339299) 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 = 339299
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=334005 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 = 334005 AND W.type_id = 1) OR (W.util_id <> 334005 AND W.type_id = 2)) AND (M.post_util_id = 334005 OR M.dest_util_id = 334005) 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 = 334005
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='846' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=325620 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 = 325620 AND W.type_id = 1) OR (W.util_id <> 325620 AND W.type_id = 2)) AND (M.post_util_id = 325620 OR M.dest_util_id = 325620) 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 = 325620
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 846
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