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='box-stockage'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=79
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'
SELECT ville_nom FROM villes WHERE ville_cp='92120' AND ville_nom like '%montrouge%' 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 '%stockage%box%securise%' OR ssrubr_title like '%stockage%box%securise%' OR ssrubr_slug like '%stockage%box%securise%') AND cate_id='79' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='92120'
SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.0435146819952 AND ville_longitude_deg<2.5898253180048 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='sécurisé; stockage box securise'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='79'AND MATCH (wish_title,wish_desc) AGAINST ('+sécurisé; stockage box securise*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92120%'
SELECT * FROM texte WHERE cate_id=79
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='sécurisé; stockage box securise' OR ssrubr_slug='sécurisé;-stockage-box-securise' OR (ssrubr_title like '%sécurisé; stockage box securise%')) AND cate_id='79' 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 (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='stockage-box-securise' AND cate_id='79'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='92120'
SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.0435146819952 AND ville_longitude_deg<2.5898253180048 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.6337758163378 AND ville_longitude_deg<2.9995641836622 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='79' AND MATCH (wish_desc) AGAINST ('(+sécurisé; +stockage +box +securise*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92120,92120,94250,92240,92170,94110,92220,92320,92130,94270,94240,94239,94238,94237,94236,94235,94234,94233,94231,94232,94230,92140,94800,92330,92260,92340,94205,94200,92100,92350,75001,75004,75011,75010,75009,75000,75007,75005,75006,75003,75002,75008,75020,75019,75018,75017,75116,75016,75015,75012,75013,75014,92190,92360,94550,92290,94400,94220,94320,94260,92160,94140,94160,94150,92210,92800,92150,92200,91370,92310,92370,94700,93170,92410,94600,94300,92110,93400,91320,92300,93310,91300,94390,94310,78140,92400,92380,93100,94410,91570,92250,92420,92430,92600,94340,93500,78220,93260,93230,92500,94000,92270,91550,91430,94290,93300,92700,93120,91120,78350,94130,92000,91430,91200,94120,78170,93450,92230,92390,91380,91420,91160,93130,94460,93210,93200,94480,93110,94380,93000,94190,91160,94210,94340,94100,78000,91140,94170,78800,78150,78400,93140,91400,78290,78380,78530,78350,94500,94430,94360,78150,78420,91560,93800,95870,93350,91270,91160,93250,94450,95100,93240,91260,78430,93360,93430,91140,93150,93700,91400,91230,93330,78560,94470,78117,78360,93440,91210,95880,91360,91360,94370,94380,91600,95218,95360,91160,95210,91390,91440,93380,94350,78110,93340,93320,95110,91170,91330,91190,78870,94490,94880,94880,93220,78500,78160,95140,94420,78230,78117,91190,78210,91940,95230,95170,91700,78750,93160,78590,91800,95410,95500,95120,91620,78620,93460,78280,91350,78600,78600,95530,94440,78100,94440,95130,78330,91620,78590,78112,94510,95400,91130,91000,91940)
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.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- 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='79' AND MATCH (wish_desc) AGAINST ('(+sécurisé; +stockage +box +securise*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92120,92120,94250,92240,92170,94110,92220,92320,92130,94270,94240,94239,94238,94237,94236,94235,94234,94233,94231,94232,94230,92140,94800,92330,92260,92340,94205,94200,92100,92350,75001,75004,75011,75010,75009,75000,75007,75005,75006,75003,75002,75008,75020,75019,75018,75017,75116,75016,75015,75012,75013,75014,92190,92360,94550,92290,94400,94220,94320,94260,92160,94140,94160,94150,92210,92800,92150,92200,91370,92310,92370,94700,93170,92410,94600,94300,92110,93400,91320,92300,93310,91300,94390,94310,78140,92400,92380,93100,94410,91570,92250,92420,92430,92600,94340,93500,78220,93260,93230,92500,94000,92270,91550,91430,94290,93300,92700,93120,91120,78350,94130,92000,91430,91200,94120,78170,93450,92230,92390,91380,91420,91160,93130,94460,93210,93200,94480,93110,94380,93000,94190,91160,94210,94340,94100,78000,91140,94170,78800,78150,78400,93140,91400,78290,78380,78530,78350,94500,94430,94360,78150,78420,91560,93800,95870,93350,91270,91160,93250,94450,95100,93240,91260,78430,93360,93430,91140,93150,93700,91400,91230,93330,78560,94470,78117,78360,93440,91210,95880,91360,91360,94370,94380,91600,95218,95360,91160,95210,91390,91440,93380,94350,78110,93340,93320,95110,91170,91330,91190,78870,94490,94880,94880,93220,78500,78160,95140,94420,78230,78117,91190,78210,91940,95230,95170,91700,78750,93160,78590,91800,95410,95500,95120,91620,78620,93460,78280,91350,78600,78600,95530,94440,78100,94440,95130,78330,91620,78590,78112,94510,95400,91130,91000,91940) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='92120'
SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.0435146819952 AND ville_longitude_deg<2.5898253180048 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.6337758163378 AND ville_longitude_deg<2.9995641836622 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 = 13119 AND W.type_id = 1) OR (W.util_id != 13119 AND W.type_id = 2)) AND (`post_util_id` = 13119 OR `dest_util_id` = 13119) 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=13119 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 = 53102 AND W.type_id = 1) OR (W.util_id != 53102 AND W.type_id = 2)) AND (`post_util_id` = 53102 OR `dest_util_id` = 53102) 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=53102 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 = 63657 AND W.type_id = 1) OR (W.util_id != 63657 AND W.type_id = 2)) AND (`post_util_id` = 63657 OR `dest_util_id` = 63657) 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=63657 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 = 8045 AND W.type_id = 1) OR (W.util_id != 8045 AND W.type_id = 2)) AND (`post_util_id` = 8045 OR `dest_util_id` = 8045) 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=8045 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 = 137802 AND W.type_id = 1) OR (W.util_id != 137802 AND W.type_id = 2)) AND (`post_util_id` = 137802 OR `dest_util_id` = 137802) 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=137802 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 = 91663 AND W.type_id = 1) OR (W.util_id != 91663 AND W.type_id = 2)) AND (`post_util_id` = 91663 OR `dest_util_id` = 91663) 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=91663 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 = 91663 AND W.type_id = 1) OR (W.util_id != 91663 AND W.type_id = 2)) AND (`post_util_id` = 91663 OR `dest_util_id` = 91663) 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 = 177633 AND W.type_id = 1) OR (W.util_id != 177633 AND W.type_id = 2)) AND (`post_util_id` = 177633 OR `dest_util_id` = 177633) 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=177633 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 = 198894 AND W.type_id = 1) OR (W.util_id != 198894 AND W.type_id = 2)) AND (`post_util_id` = 198894 OR `dest_util_id` = 198894) 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=198894 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 = 198894 AND W.type_id = 1) OR (W.util_id != 198894 AND W.type_id = 2)) AND (`post_util_id` = 198894 OR `dest_util_id` = 198894) 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 = 203818 AND W.type_id = 1) OR (W.util_id != 203818 AND W.type_id = 2)) AND (`post_util_id` = 203818 OR `dest_util_id` = 203818) 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=203818 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 = 205162 AND W.type_id = 1) OR (W.util_id != 205162 AND W.type_id = 2)) AND (`post_util_id` = 205162 OR `dest_util_id` = 205162) 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=205162 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 = 205467 AND W.type_id = 1) OR (W.util_id != 205467 AND W.type_id = 2)) AND (`post_util_id` = 205467 OR `dest_util_id` = 205467) 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=205467 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 = 211670 AND W.type_id = 1) OR (W.util_id != 211670 AND W.type_id = 2)) AND (`post_util_id` = 211670 OR `dest_util_id` = 211670) 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=211670 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 = 227780 AND W.type_id = 1) OR (W.util_id != 227780 AND W.type_id = 2)) AND (`post_util_id` = 227780 OR `dest_util_id` = 227780) 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=227780 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 = 248396 AND W.type_id = 1) OR (W.util_id != 248396 AND W.type_id = 2)) AND (`post_util_id` = 248396 OR `dest_util_id` = 248396) 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=248396 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 = 248396 AND W.type_id = 1) OR (W.util_id != 248396 AND W.type_id = 2)) AND (`post_util_id` = 248396 OR `dest_util_id` = 248396) 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 = 104570 AND W.type_id = 1) OR (W.util_id != 104570 AND W.type_id = 2)) AND (`post_util_id` = 104570 OR `dest_util_id` = 104570) 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=104570 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 = 297213 AND W.type_id = 1) OR (W.util_id != 297213 AND W.type_id = 2)) AND (`post_util_id` = 297213 OR `dest_util_id` = 297213) 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=297213 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 = 301708 AND W.type_id = 1) OR (W.util_id != 301708 AND W.type_id = 2)) AND (`post_util_id` = 301708 OR `dest_util_id` = 301708) 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=301708 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 = 98381 AND W.type_id = 1) OR (W.util_id != 98381 AND W.type_id = 2)) AND (`post_util_id` = 98381 OR `dest_util_id` = 98381) 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=98381 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 = 343091 AND W.type_id = 1) OR (W.util_id != 343091 AND W.type_id = 2)) AND (`post_util_id` = 343091 OR `dest_util_id` = 343091) 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=343091 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 = 206436 AND W.type_id = 1) OR (W.util_id != 206436 AND W.type_id = 2)) AND (`post_util_id` = 206436 OR `dest_util_id` = 206436) 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=206436 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 = 351545 AND W.type_id = 1) OR (W.util_id != 351545 AND W.type_id = 2)) AND (`post_util_id` = 351545 OR `dest_util_id` = 351545) 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=351545 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 = 292525 AND W.type_id = 1) OR (W.util_id != 292525 AND W.type_id = 2)) AND (`post_util_id` = 292525 OR `dest_util_id` = 292525) 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=292525 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 = 372193 AND W.type_id = 1) OR (W.util_id != 372193 AND W.type_id = 2)) AND (`post_util_id` = 372193 OR `dest_util_id` = 372193) 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=372193 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 = 89631 AND W.type_id = 1) OR (W.util_id != 89631 AND W.type_id = 2)) AND (`post_util_id` = 89631 OR `dest_util_id` = 89631) 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=89631 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 = 393016 AND W.type_id = 1) OR (W.util_id != 393016 AND W.type_id = 2)) AND (`post_util_id` = 393016 OR `dest_util_id` = 393016) 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=393016 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 = 408639 AND W.type_id = 1) OR (W.util_id != 408639 AND W.type_id = 2)) AND (`post_util_id` = 408639 OR `dest_util_id` = 408639) 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=408639 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 = 424797 AND W.type_id = 1) OR (W.util_id != 424797 AND W.type_id = 2)) AND (`post_util_id` = 424797 OR `dest_util_id` = 424797) 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=424797 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 = 425208 AND W.type_id = 1) OR (W.util_id != 425208 AND W.type_id = 2)) AND (`post_util_id` = 425208 OR `dest_util_id` = 425208) 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=425208 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 = 425800 AND W.type_id = 1) OR (W.util_id != 425800 AND W.type_id = 2)) AND (`post_util_id` = 425800 OR `dest_util_id` = 425800) 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=425800 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 = 424797 AND W.type_id = 1) OR (W.util_id != 424797 AND W.type_id = 2)) AND (`post_util_id` = 424797 OR `dest_util_id` = 424797) 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 = 78686 AND W.type_id = 1) OR (W.util_id != 78686 AND W.type_id = 2)) AND (`post_util_id` = 78686 OR `dest_util_id` = 78686) 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=78686 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 = 408639 AND W.type_id = 1) OR (W.util_id != 408639 AND W.type_id = 2)) AND (`post_util_id` = 408639 OR `dest_util_id` = 408639) 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 = 472039 AND W.type_id = 1) OR (W.util_id != 472039 AND W.type_id = 2)) AND (`post_util_id` = 472039 OR `dest_util_id` = 472039) 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=472039 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 = 408639 AND W.type_id = 1) OR (W.util_id != 408639 AND W.type_id = 2)) AND (`post_util_id` = 408639 OR `dest_util_id` = 408639) 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 = 477180 AND W.type_id = 1) OR (W.util_id != 477180 AND W.type_id = 2)) AND (`post_util_id` = 477180 OR `dest_util_id` = 477180) 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=477180 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 = 471981 AND W.type_id = 1) OR (W.util_id != 471981 AND W.type_id = 2)) AND (`post_util_id` = 471981 OR `dest_util_id` = 471981) 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=471981 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 = 493489 AND W.type_id = 1) OR (W.util_id != 493489 AND W.type_id = 2)) AND (`post_util_id` = 493489 OR `dest_util_id` = 493489) 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=493489 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 = 513495 AND W.type_id = 1) OR (W.util_id != 513495 AND W.type_id = 2)) AND (`post_util_id` = 513495 OR `dest_util_id` = 513495) 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=513495 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 = 548058 AND W.type_id = 1) OR (W.util_id != 548058 AND W.type_id = 2)) AND (`post_util_id` = 548058 OR `dest_util_id` = 548058) 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=548058 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 = 548058 AND W.type_id = 1) OR (W.util_id != 548058 AND W.type_id = 2)) AND (`post_util_id` = 548058 OR `dest_util_id` = 548058) 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 = 548058 AND W.type_id = 1) OR (W.util_id != 548058 AND W.type_id = 2)) AND (`post_util_id` = 548058 OR `dest_util_id` = 548058) 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 = 548058 AND W.type_id = 1) OR (W.util_id != 548058 AND W.type_id = 2)) AND (`post_util_id` = 548058 OR `dest_util_id` = 548058) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
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=79 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='sécurisé; stockage box securise' OR ssrubr_slug like '%sécurisé; stockage box securise%' OR MATCH (ssrubr_slug) AGAINST ('(+sécurisé; +stockage +box +securise)')) AND sk.ssrubr_id='514' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='514' 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