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='salle'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=176
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'
SELECT ville_nom FROM villes WHERE ville_cp='95200' AND ville_nom like '%sarcelles%' 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 '%chaise%' OR ssrubr_title like '%chaise%' OR ssrubr_slug like '%chaise%') AND cate_id='176' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='95200'
SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.109170802952 AND ville_longitude_deg<2.657489197048 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='chaise'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='176'AND MATCH (wish_title,wish_desc) AGAINST ('+chaise*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '95200%'
SELECT * FROM texte WHERE cate_id=176
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='chaise' OR ssrubr_slug='chaise' OR (ssrubr_title like '%chaise%')) AND cate_id='176' 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 (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='chaise' AND cate_id='176'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='95200'
SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.109170802952 AND ville_longitude_deg<2.657489197048 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- 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.6979260970883 AND ville_longitude_deg<3.0687339029117 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='176' AND MATCH (wish_desc) AGAINST ('(+chaise*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95200,95400,95200,95350,95440,95400,95350,95410,95160,93380,95460,95170,95720,95720,95360,95140,95330,95500,95500,93430,93240,95720,93440,95570,95580,95580,95500,95880,95230,95190,95570,95600,95500,95190,95720,95680,93200,93210,93800,93350,95210,95218,95570,95850,93450,92390,95390,95120,93150,95560,95190,93700,93300,93120,95270,95380,95570,95270,92230,95560,95700,95320,95560,95380,95110,95850,95560,95130,95130,93500,95840,93600,95100,95270,93420,93400,95590,95270,95270,93000,92600,95380,95670,92270,92110,95270,93140,95550,95150,95380,95270,93310,95270,95840,93270,95470,92300,95740,95380,92700,93260,93230,95270,95250,95240,95870,93130,95590,95370,93320,92250,93340,95270,92400,93290,95270,93170,77990,95530,95270,93100,95470,95540,93390,93190,93410,92200,93250,78500,95220,75019,75010,75011,75012,75013,75014,75015,75016,75017,75116,75020,75005,75009,75008,75003,75007,75006,75018,75001,75004,75000,75002,77990,95480,95590,95430,95470,95630,78800,95470,95260,93110,95290,93220,94300,60260,95260,77290,78420,93470,77181,95760,93370,92000,77230,95430,60560,95660,93360,60580,95620,77230,78600,94120,60128,60520,92800,92150,77270,77230,92500,60820,94160,95340,94170,95820,77181,78360,95340,92170,94130,93330,93460)
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((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- 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='176' AND MATCH (wish_desc) AGAINST ('(+chaise*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95200,95400,95200,95350,95440,95400,95350,95410,95160,93380,95460,95170,95720,95720,95360,95140,95330,95500,95500,93430,93240,95720,93440,95570,95580,95580,95500,95880,95230,95190,95570,95600,95500,95190,95720,95680,93200,93210,93800,93350,95210,95218,95570,95850,93450,92390,95390,95120,93150,95560,95190,93700,93300,93120,95270,95380,95570,95270,92230,95560,95700,95320,95560,95380,95110,95850,95560,95130,95130,93500,95840,93600,95100,95270,93420,93400,95590,95270,95270,93000,92600,95380,95670,92270,92110,95270,93140,95550,95150,95380,95270,93310,95270,95840,93270,95470,92300,95740,95380,92700,93260,93230,95270,95250,95240,95870,93130,95590,95370,93320,92250,93340,95270,92400,93290,95270,93170,77990,95530,95270,93100,95470,95540,93390,93190,93410,92200,93250,78500,95220,75019,75010,75011,75012,75013,75014,75015,75016,75017,75116,75020,75005,75009,75008,75003,75007,75006,75018,75001,75004,75000,75002,77990,95480,95590,95430,95470,95630,78800,95470,95260,93110,95290,93220,94300,60260,95260,77290,78420,93470,77181,95760,93370,92000,77230,95430,60560,95660,93360,60580,95620,77230,78600,94120,60128,60520,92800,92150,77270,77230,92500,60820,94160,95340,94170,95820,77181,78360,95340,92170,94130,93330,93460) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='95200'
SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.109170802952 AND ville_longitude_deg<2.657489197048 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- 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.6979260970883 AND ville_longitude_deg<3.0687339029117 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 = 4471 AND W.type_id = 1) OR (W.util_id != 4471 AND W.type_id = 2)) AND (`post_util_id` = 4471 OR `dest_util_id` = 4471) 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=4471 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 = 5925 AND W.type_id = 1) OR (W.util_id != 5925 AND W.type_id = 2)) AND (`post_util_id` = 5925 OR `dest_util_id` = 5925) 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=5925 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 = 6535 AND W.type_id = 1) OR (W.util_id != 6535 AND W.type_id = 2)) AND (`post_util_id` = 6535 OR `dest_util_id` = 6535) 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=6535 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 = 70580 AND W.type_id = 1) OR (W.util_id != 70580 AND W.type_id = 2)) AND (`post_util_id` = 70580 OR `dest_util_id` = 70580) 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=70580 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 = 94128 AND W.type_id = 1) OR (W.util_id != 94128 AND W.type_id = 2)) AND (`post_util_id` = 94128 OR `dest_util_id` = 94128) 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=94128 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 = 139404 AND W.type_id = 1) OR (W.util_id != 139404 AND W.type_id = 2)) AND (`post_util_id` = 139404 OR `dest_util_id` = 139404) 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=139404 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 = 168857 AND W.type_id = 1) OR (W.util_id != 168857 AND W.type_id = 2)) AND (`post_util_id` = 168857 OR `dest_util_id` = 168857) 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=168857 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 = 168857 AND W.type_id = 1) OR (W.util_id != 168857 AND W.type_id = 2)) AND (`post_util_id` = 168857 OR `dest_util_id` = 168857) 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 = 197551 AND W.type_id = 1) OR (W.util_id != 197551 AND W.type_id = 2)) AND (`post_util_id` = 197551 OR `dest_util_id` = 197551) 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=197551 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 = 201537 AND W.type_id = 1) OR (W.util_id != 201537 AND W.type_id = 2)) AND (`post_util_id` = 201537 OR `dest_util_id` = 201537) 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=201537 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 = 201537 AND W.type_id = 1) OR (W.util_id != 201537 AND W.type_id = 2)) AND (`post_util_id` = 201537 OR `dest_util_id` = 201537) 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 = 201537 AND W.type_id = 1) OR (W.util_id != 201537 AND W.type_id = 2)) AND (`post_util_id` = 201537 OR `dest_util_id` = 201537) 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 = 219974 AND W.type_id = 1) OR (W.util_id != 219974 AND W.type_id = 2)) AND (`post_util_id` = 219974 OR `dest_util_id` = 219974) 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=219974 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 = 242769 AND W.type_id = 1) OR (W.util_id != 242769 AND W.type_id = 2)) AND (`post_util_id` = 242769 OR `dest_util_id` = 242769) 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=242769 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 = 36912 AND W.type_id = 1) OR (W.util_id != 36912 AND W.type_id = 2)) AND (`post_util_id` = 36912 OR `dest_util_id` = 36912) 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=36912 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 = 257977 AND W.type_id = 1) OR (W.util_id != 257977 AND W.type_id = 2)) AND (`post_util_id` = 257977 OR `dest_util_id` = 257977) 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=257977 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 = 261011 AND W.type_id = 1) OR (W.util_id != 261011 AND W.type_id = 2)) AND (`post_util_id` = 261011 OR `dest_util_id` = 261011) 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=261011 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 = 269129 AND W.type_id = 1) OR (W.util_id != 269129 AND W.type_id = 2)) AND (`post_util_id` = 269129 OR `dest_util_id` = 269129) 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=269129 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 = 276078 AND W.type_id = 1) OR (W.util_id != 276078 AND W.type_id = 2)) AND (`post_util_id` = 276078 OR `dest_util_id` = 276078) 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=276078 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 = 290056 AND W.type_id = 1) OR (W.util_id != 290056 AND W.type_id = 2)) AND (`post_util_id` = 290056 OR `dest_util_id` = 290056) 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=290056 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 = 293715 AND W.type_id = 1) OR (W.util_id != 293715 AND W.type_id = 2)) AND (`post_util_id` = 293715 OR `dest_util_id` = 293715) 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=293715 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 = 315652 AND W.type_id = 1) OR (W.util_id != 315652 AND W.type_id = 2)) AND (`post_util_id` = 315652 OR `dest_util_id` = 315652) 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=315652 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 = 252240 AND W.type_id = 1) OR (W.util_id != 252240 AND W.type_id = 2)) AND (`post_util_id` = 252240 OR `dest_util_id` = 252240) 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=252240 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 = 327549 AND W.type_id = 1) OR (W.util_id != 327549 AND W.type_id = 2)) AND (`post_util_id` = 327549 OR `dest_util_id` = 327549) 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=327549 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 = 329608 AND W.type_id = 1) OR (W.util_id != 329608 AND W.type_id = 2)) AND (`post_util_id` = 329608 OR `dest_util_id` = 329608) 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=329608 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 = 331094 AND W.type_id = 1) OR (W.util_id != 331094 AND W.type_id = 2)) AND (`post_util_id` = 331094 OR `dest_util_id` = 331094) 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=331094 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 = 186004 AND W.type_id = 1) OR (W.util_id != 186004 AND W.type_id = 2)) AND (`post_util_id` = 186004 OR `dest_util_id` = 186004) 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=186004 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 = 351629 AND W.type_id = 1) OR (W.util_id != 351629 AND W.type_id = 2)) AND (`post_util_id` = 351629 OR `dest_util_id` = 351629) 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=351629 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 = 353559 AND W.type_id = 1) OR (W.util_id != 353559 AND W.type_id = 2)) AND (`post_util_id` = 353559 OR `dest_util_id` = 353559) 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=353559 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 = 353913 AND W.type_id = 1) OR (W.util_id != 353913 AND W.type_id = 2)) AND (`post_util_id` = 353913 OR `dest_util_id` = 353913) 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=353913 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 = 357073 AND W.type_id = 1) OR (W.util_id != 357073 AND W.type_id = 2)) AND (`post_util_id` = 357073 OR `dest_util_id` = 357073) 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=357073 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 = 372192 AND W.type_id = 1) OR (W.util_id != 372192 AND W.type_id = 2)) AND (`post_util_id` = 372192 OR `dest_util_id` = 372192) 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=372192 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 = 373615 AND W.type_id = 1) OR (W.util_id != 373615 AND W.type_id = 2)) AND (`post_util_id` = 373615 OR `dest_util_id` = 373615) 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=373615 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 = 252240 AND W.type_id = 1) OR (W.util_id != 252240 AND W.type_id = 2)) AND (`post_util_id` = 252240 OR `dest_util_id` = 252240) 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 = 208498 AND W.type_id = 1) OR (W.util_id != 208498 AND W.type_id = 2)) AND (`post_util_id` = 208498 OR `dest_util_id` = 208498) 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=208498 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 = 435537 AND W.type_id = 1) OR (W.util_id != 435537 AND W.type_id = 2)) AND (`post_util_id` = 435537 OR `dest_util_id` = 435537) 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=435537 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 = 450456 AND W.type_id = 1) OR (W.util_id != 450456 AND W.type_id = 2)) AND (`post_util_id` = 450456 OR `dest_util_id` = 450456) 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=450456 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 = 475869 AND W.type_id = 1) OR (W.util_id != 475869 AND W.type_id = 2)) AND (`post_util_id` = 475869 OR `dest_util_id` = 475869) 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=475869 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 = 249215 AND W.type_id = 1) OR (W.util_id != 249215 AND W.type_id = 2)) AND (`post_util_id` = 249215 OR `dest_util_id` = 249215) 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=249215 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 = 419827 AND W.type_id = 1) OR (W.util_id != 419827 AND W.type_id = 2)) AND (`post_util_id` = 419827 OR `dest_util_id` = 419827) 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=419827 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 = 487476 AND W.type_id = 1) OR (W.util_id != 487476 AND W.type_id = 2)) AND (`post_util_id` = 487476 OR `dest_util_id` = 487476) 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=487476 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 = 487476 AND W.type_id = 1) OR (W.util_id != 487476 AND W.type_id = 2)) AND (`post_util_id` = 487476 OR `dest_util_id` = 487476) 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 = 370964 AND W.type_id = 1) OR (W.util_id != 370964 AND W.type_id = 2)) AND (`post_util_id` = 370964 OR `dest_util_id` = 370964) 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=370964 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 = 509940 AND W.type_id = 1) OR (W.util_id != 509940 AND W.type_id = 2)) AND (`post_util_id` = 509940 OR `dest_util_id` = 509940) 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=509940 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 = 373668 AND W.type_id = 1) OR (W.util_id != 373668 AND W.type_id = 2)) AND (`post_util_id` = 373668 OR `dest_util_id` = 373668) 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=373668 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 = 533961 AND W.type_id = 1) OR (W.util_id != 533961 AND W.type_id = 2)) AND (`post_util_id` = 533961 OR `dest_util_id` = 533961) 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=533961 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 = 545427 AND W.type_id = 1) OR (W.util_id != 545427 AND W.type_id = 2)) AND (`post_util_id` = 545427 OR `dest_util_id` = 545427) 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=545427 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 = 545574 AND W.type_id = 1) OR (W.util_id != 545574 AND W.type_id = 2)) AND (`post_util_id` = 545574 OR `dest_util_id` = 545574) 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=545574 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=176 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='chaise' OR ssrubr_slug like '%chaise%' OR MATCH (ssrubr_slug) AGAINST ('(+chaise)')) AND sk.ssrubr_id='859' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='859' 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