Indiquer un code postal ou une ville
Poster une annonce
Indiquer un code postal ou une ville
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-nettoyage'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=110
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'
SELECT ville_nom FROM villes WHERE ville_cp='92600' AND ville_nom like '%asnieres%sur%seine%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%nettoyeur%vapeur%' OR ssrubr_title like '%nettoyeur%vapeur%' OR ssrubr_slug like '%nettoyeur%vapeur%') AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='92600'
SELECT ville_cp, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.731335678816 AND ville_latitude_deg<49.091064321184 AND ville_longitude_deg>2.0118884034916 AND ville_longitude_deg<2.5592315965084 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyeur vapeur'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='110'AND MATCH (wish_title,wish_desc) AGAINST ('+nettoyeur vapeur*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92600%'
SELECT * FROM texte WHERE cate_id=110
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='nettoyeur vapeur' OR ssrubr_slug='nettoyeur-vapeur' OR (ssrubr_title like '%nettoyeur vapeur%')) AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='nettoyeur-vapeur' AND cate_id='110'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='92600'
SELECT ville_cp, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.731335678816 AND ville_latitude_deg<49.091064321184 AND ville_longitude_deg>2.0118884034916 AND ville_longitude_deg<2.5592315965084 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.461539197041 AND ville_latitude_deg<49.360860802959 AND ville_longitude_deg>1.6013751089489 AND ville_longitude_deg<2.9697448910511 HAVING distance <= 50 ORDER BY distance ASC
SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +vapeur*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92600,92600,92300,92270,92110,92230,92700,92250,92400,92200,93400,92390,93450,93800,95100,95870,93210,93200,95218,95210,92800,92150,78800,92000,95880,93430,95110,92500,75020,75017,75011,75019,75007,75006,75018,75001,75005,75012,75004,75003,75002,75000,75008,75016,75015,75013,75010,75116,75009,75014,93300,93120,78420,95360,95230,95120,93240,93500,93380,78500,92170,95170,95130,93310,92100,92210,95410,95530,95600,93350,78360,95580,95580,95240,78400,95160,93440,92240,95130,92130,92380,92120,93170,78600,95370,94250,93260,93230,95140,95350,95680,92410,95390,92420,92430,92190,92360,93100,78600,95320,78170,94270,93000,78380,78290,95400,95200,92310,93700,93150,92320,92220,78110,95500,92140,95400,95350,94205,94200,78560,94300,94110,94160,95220,93140,95250,78430,93130,78230,94800,95440,92370,95330,92330,92260,94220,92350,95500,78140,95550,95150,95480,94240,94230,94239,94231,94232,94233,94234,94235,94236,94237,94238,95460,78100,78150,78750,78220,78150,93110,92340,95570,95560,78160,94140,95840,78700,95570,95720,93250,94120,95570,92290,95740,78870,78112,94700,94410,94400,95500,95720,78000,94550,78620,94130,94340,93340,93320,94170,78260,95560,78300,78590,93600,95560,95500,95720,94320,93360,95190,95840,78570,95610,92160,91370,94260,93270,78350,93220,95540,78240,94150,91570,94600,78780,78955,94360,93420,95590,95720,95560,78590,93390,93190,95430,93330,94000,95700,95190,78530,78350,78240,95310,91300,94390,94310,95000,94500,94100,94210,94340)
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +vapeur*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92600,92600,92300,92270,92110,92230,92700,92250,92400,92200,93400,92390,93450,93800,95100,95870,93210,93200,95218,95210,92800,92150,78800,92000,95880,93430,95110,92500,75020,75017,75011,75019,75007,75006,75018,75001,75005,75012,75004,75003,75002,75000,75008,75016,75015,75013,75010,75116,75009,75014,93300,93120,78420,95360,95230,95120,93240,93500,93380,78500,92170,95170,95130,93310,92100,92210,95410,95530,95600,93350,78360,95580,95580,95240,78400,95160,93440,92240,95130,92130,92380,92120,93170,78600,95370,94250,93260,93230,95140,95350,95680,92410,95390,92420,92430,92190,92360,93100,78600,95320,78170,94270,93000,78380,78290,95400,95200,92310,93700,93150,92320,92220,78110,95500,92140,95400,95350,94205,94200,78560,94300,94110,94160,95220,93140,95250,78430,93130,78230,94800,95440,92370,95330,92330,92260,94220,92350,95500,78140,95550,95150,95480,94240,94230,94239,94231,94232,94233,94234,94235,94236,94237,94238,95460,78100,78150,78750,78220,78150,93110,92340,95570,95560,78160,94140,95840,78700,95570,95720,93250,94120,95570,92290,95740,78870,78112,94700,94410,94400,95500,95720,78000,94550,78620,94130,94340,93340,93320,94170,78260,95560,78300,78590,93600,95560,95500,95720,94320,93360,95190,95840,78570,95610,92160,91370,94260,93270,78350,93220,95540,78240,94150,91570,94600,78780,78955,94360,93420,95590,95720,95560,78590,93390,93190,95430,93330,94000,95700,95190,78530,78350,78240,95310,91300,94390,94310,95000,94500,94100,94210,94340) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='92600'
SELECT ville_cp, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.731335678816 AND ville_latitude_deg<49.091064321184 AND ville_longitude_deg>2.0118884034916 AND ville_longitude_deg<2.5592315965084 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.9112*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9112*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.461539197041 AND ville_latitude_deg<49.360860802959 AND ville_longitude_deg>1.6013751089489 AND ville_longitude_deg<2.9697448910511 HAVING distance <= 50 ORDER BY distance ASC
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 4155 AND W.type_id = 1) OR (W.util_id != 4155 AND W.type_id = 2)) AND (`post_util_id` = 4155 OR `dest_util_id` = 4155) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=4155 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 4155 AND W.type_id = 1) OR (W.util_id != 4155 AND W.type_id = 2)) AND (`post_util_id` = 4155 OR `dest_util_id` = 4155) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93477 AND W.type_id = 1) OR (W.util_id != 93477 AND W.type_id = 2)) AND (`post_util_id` = 93477 OR `dest_util_id` = 93477) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=93477 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111734 AND W.type_id = 1) OR (W.util_id != 111734 AND W.type_id = 2)) AND (`post_util_id` = 111734 OR `dest_util_id` = 111734) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111734 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121485 AND W.type_id = 1) OR (W.util_id != 121485 AND W.type_id = 2)) AND (`post_util_id` = 121485 OR `dest_util_id` = 121485) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121485 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124632 AND W.type_id = 1) OR (W.util_id != 124632 AND W.type_id = 2)) AND (`post_util_id` = 124632 OR `dest_util_id` = 124632) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=124632 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 129820 AND W.type_id = 1) OR (W.util_id != 129820 AND W.type_id = 2)) AND (`post_util_id` = 129820 OR `dest_util_id` = 129820) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129820 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 136380 AND W.type_id = 1) OR (W.util_id != 136380 AND W.type_id = 2)) AND (`post_util_id` = 136380 OR `dest_util_id` = 136380) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=136380 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 148130 AND W.type_id = 1) OR (W.util_id != 148130 AND W.type_id = 2)) AND (`post_util_id` = 148130 OR `dest_util_id` = 148130) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=148130 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 157864 AND W.type_id = 1) OR (W.util_id != 157864 AND W.type_id = 2)) AND (`post_util_id` = 157864 OR `dest_util_id` = 157864) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=157864 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182041 AND W.type_id = 1) OR (W.util_id != 182041 AND W.type_id = 2)) AND (`post_util_id` = 182041 OR `dest_util_id` = 182041) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=182041 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193120 AND W.type_id = 1) OR (W.util_id != 193120 AND W.type_id = 2)) AND (`post_util_id` = 193120 OR `dest_util_id` = 193120) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193120 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 197030 AND W.type_id = 1) OR (W.util_id != 197030 AND W.type_id = 2)) AND (`post_util_id` = 197030 OR `dest_util_id` = 197030) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197030 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 60903 AND W.type_id = 1) OR (W.util_id != 60903 AND W.type_id = 2)) AND (`post_util_id` = 60903 OR `dest_util_id` = 60903) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=60903 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 204950 AND W.type_id = 1) OR (W.util_id != 204950 AND W.type_id = 2)) AND (`post_util_id` = 204950 OR `dest_util_id` = 204950) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=204950 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207210 AND W.type_id = 1) OR (W.util_id != 207210 AND W.type_id = 2)) AND (`post_util_id` = 207210 OR `dest_util_id` = 207210) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207210 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 225775 AND W.type_id = 1) OR (W.util_id != 225775 AND W.type_id = 2)) AND (`post_util_id` = 225775 OR `dest_util_id` = 225775) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=225775 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 195800 AND W.type_id = 1) OR (W.util_id != 195800 AND W.type_id = 2)) AND (`post_util_id` = 195800 OR `dest_util_id` = 195800) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=195800 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 232745 AND W.type_id = 1) OR (W.util_id != 232745 AND W.type_id = 2)) AND (`post_util_id` = 232745 OR `dest_util_id` = 232745) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232745 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 238457 AND W.type_id = 1) OR (W.util_id != 238457 AND W.type_id = 2)) AND (`post_util_id` = 238457 OR `dest_util_id` = 238457) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=238457 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 271109 AND W.type_id = 1) OR (W.util_id != 271109 AND W.type_id = 2)) AND (`post_util_id` = 271109 OR `dest_util_id` = 271109) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271109 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 274992 AND W.type_id = 1) OR (W.util_id != 274992 AND W.type_id = 2)) AND (`post_util_id` = 274992 OR `dest_util_id` = 274992) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=274992 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 284947 AND W.type_id = 1) OR (W.util_id != 284947 AND W.type_id = 2)) AND (`post_util_id` = 284947 OR `dest_util_id` = 284947) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=284947 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 159396 AND W.type_id = 1) OR (W.util_id != 159396 AND W.type_id = 2)) AND (`post_util_id` = 159396 OR `dest_util_id` = 159396) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=159396 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 271946 AND W.type_id = 1) OR (W.util_id != 271946 AND W.type_id = 2)) AND (`post_util_id` = 271946 OR `dest_util_id` = 271946) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271946 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326774 AND W.type_id = 1) OR (W.util_id != 326774 AND W.type_id = 2)) AND (`post_util_id` = 326774 OR `dest_util_id` = 326774) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326774 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 327803 AND W.type_id = 1) OR (W.util_id != 327803 AND W.type_id = 2)) AND (`post_util_id` = 327803 OR `dest_util_id` = 327803) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=327803 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 348386 AND W.type_id = 1) OR (W.util_id != 348386 AND W.type_id = 2)) AND (`post_util_id` = 348386 OR `dest_util_id` = 348386) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=348386 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357876 AND W.type_id = 1) OR (W.util_id != 357876 AND W.type_id = 2)) AND (`post_util_id` = 357876 OR `dest_util_id` = 357876) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357876 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 373109 AND W.type_id = 1) OR (W.util_id != 373109 AND W.type_id = 2)) AND (`post_util_id` = 373109 OR `dest_util_id` = 373109) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=373109 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377570 AND W.type_id = 1) OR (W.util_id != 377570 AND W.type_id = 2)) AND (`post_util_id` = 377570 OR `dest_util_id` = 377570) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=377570 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377322 AND W.type_id = 1) OR (W.util_id != 377322 AND W.type_id = 2)) AND (`post_util_id` = 377322 OR `dest_util_id` = 377322) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=377322 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 379128 AND W.type_id = 1) OR (W.util_id != 379128 AND W.type_id = 2)) AND (`post_util_id` = 379128 OR `dest_util_id` = 379128) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=379128 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 379441 AND W.type_id = 1) OR (W.util_id != 379441 AND W.type_id = 2)) AND (`post_util_id` = 379441 OR `dest_util_id` = 379441) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=379441 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 384149 AND W.type_id = 1) OR (W.util_id != 384149 AND W.type_id = 2)) AND (`post_util_id` = 384149 OR `dest_util_id` = 384149) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=384149 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 383889 AND W.type_id = 1) OR (W.util_id != 383889 AND W.type_id = 2)) AND (`post_util_id` = 383889 OR `dest_util_id` = 383889) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=383889 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 360113 AND W.type_id = 1) OR (W.util_id != 360113 AND W.type_id = 2)) AND (`post_util_id` = 360113 OR `dest_util_id` = 360113) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=360113 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389049 AND W.type_id = 1) OR (W.util_id != 389049 AND W.type_id = 2)) AND (`post_util_id` = 389049 OR `dest_util_id` = 389049) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389049 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 247267 AND W.type_id = 1) OR (W.util_id != 247267 AND W.type_id = 2)) AND (`post_util_id` = 247267 OR `dest_util_id` = 247267) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=247267 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 390376 AND W.type_id = 1) OR (W.util_id != 390376 AND W.type_id = 2)) AND (`post_util_id` = 390376 OR `dest_util_id` = 390376) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=390376 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 398563 AND W.type_id = 1) OR (W.util_id != 398563 AND W.type_id = 2)) AND (`post_util_id` = 398563 OR `dest_util_id` = 398563) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=398563 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 408336 AND W.type_id = 1) OR (W.util_id != 408336 AND W.type_id = 2)) AND (`post_util_id` = 408336 OR `dest_util_id` = 408336) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=408336 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 412044 AND W.type_id = 1) OR (W.util_id != 412044 AND W.type_id = 2)) AND (`post_util_id` = 412044 OR `dest_util_id` = 412044) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=412044 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 188930 AND W.type_id = 1) OR (W.util_id != 188930 AND W.type_id = 2)) AND (`post_util_id` = 188930 OR `dest_util_id` = 188930) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=188930 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 425593 AND W.type_id = 1) OR (W.util_id != 425593 AND W.type_id = 2)) AND (`post_util_id` = 425593 OR `dest_util_id` = 425593) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=425593 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 434723 AND W.type_id = 1) OR (W.util_id != 434723 AND W.type_id = 2)) AND (`post_util_id` = 434723 OR `dest_util_id` = 434723) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434723 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 438254 AND W.type_id = 1) OR (W.util_id != 438254 AND W.type_id = 2)) AND (`post_util_id` = 438254 OR `dest_util_id` = 438254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=438254 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 227988 AND W.type_id = 1) OR (W.util_id != 227988 AND W.type_id = 2)) AND (`post_util_id` = 227988 OR `dest_util_id` = 227988) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227988 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 428269 AND W.type_id = 1) OR (W.util_id != 428269 AND W.type_id = 2)) AND (`post_util_id` = 428269 OR `dest_util_id` = 428269) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=428269 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 287643 AND W.type_id = 1) OR (W.util_id != 287643 AND W.type_id = 2)) AND (`post_util_id` = 287643 OR `dest_util_id` = 287643) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=287643 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 180672 AND W.type_id = 1) OR (W.util_id != 180672 AND W.type_id = 2)) AND (`post_util_id` = 180672 OR `dest_util_id` = 180672) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=180672 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 180672 AND W.type_id = 1) OR (W.util_id != 180672 AND W.type_id = 2)) AND (`post_util_id` = 180672 OR `dest_util_id` = 180672) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 488591 AND W.type_id = 1) OR (W.util_id != 488591 AND W.type_id = 2)) AND (`post_util_id` = 488591 OR `dest_util_id` = 488591) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=488591 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 141749 AND W.type_id = 1) OR (W.util_id != 141749 AND W.type_id = 2)) AND (`post_util_id` = 141749 OR `dest_util_id` = 141749) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=141749 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193383 AND W.type_id = 1) OR (W.util_id != 193383 AND W.type_id = 2)) AND (`post_util_id` = 193383 OR `dest_util_id` = 193383) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193383 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 451911 AND W.type_id = 1) OR (W.util_id != 451911 AND W.type_id = 2)) AND (`post_util_id` = 451911 OR `dest_util_id` = 451911) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451911 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 508574 AND W.type_id = 1) OR (W.util_id != 508574 AND W.type_id = 2)) AND (`post_util_id` = 508574 OR `dest_util_id` = 508574) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=508574 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 511255 AND W.type_id = 1) OR (W.util_id != 511255 AND W.type_id = 2)) AND (`post_util_id` = 511255 OR `dest_util_id` = 511255) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=511255 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 293236 AND W.type_id = 1) OR (W.util_id != 293236 AND W.type_id = 2)) AND (`post_util_id` = 293236 OR `dest_util_id` = 293236) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293236 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 520871 AND W.type_id = 1) OR (W.util_id != 520871 AND W.type_id = 2)) AND (`post_util_id` = 520871 OR `dest_util_id` = 520871) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=520871 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 117081 AND W.type_id = 1) OR (W.util_id != 117081 AND W.type_id = 2)) AND (`post_util_id` = 117081 OR `dest_util_id` = 117081) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=117081 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529626 AND W.type_id = 1) OR (W.util_id != 529626 AND W.type_id = 2)) AND (`post_util_id` = 529626 OR `dest_util_id` = 529626) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529626 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 509154 AND W.type_id = 1) OR (W.util_id != 509154 AND W.type_id = 2)) AND (`post_util_id` = 509154 OR `dest_util_id` = 509154) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=509154 AND note_visu IN (1,3,4)
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=110 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100
SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='nettoyeur vapeur' OR ssrubr_slug like '%nettoyeur vapeur%' OR MATCH (ssrubr_slug) AGAINST ('(+nettoyeur +vapeur)')) AND sk.ssrubr_id='983' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='983' AND actu_niveau=0 ORDER BY actu_ordre DESC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC
Contactez-nous