Indiquer un code postal ou une ville
Poster une annonce
Indiquer un code postal ou une ville
Proposer mon aide
Louer du matériel ou proposer un service
Faire appel à mes voisins
Besoin d'un objet ou d'un service ?
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-audiovisuel'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=232
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 '%accessoires%appareil%photo%' OR ssrubr_title like '%accessoires%appareil%photo%' OR ssrubr_slug like '%accessoires%appareil%photo%') AND cate_id='232' 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='accessoires appareil photo'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='232'AND MATCH (wish_title,wish_desc) AGAINST ('+accessoires appareil photo*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92120%'
SELECT * FROM texte WHERE cate_id=232
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='accessoires appareil photo' OR ssrubr_slug='accessoires-appareil-photo' OR (ssrubr_title like '%accessoires appareil photo%')) AND cate_id='232' 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 (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='accessoires-appareil-photo' AND cate_id='232'
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='232' AND MATCH (wish_desc) AGAINST ('(+accessoires +appareil +photo*)' 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='232' AND MATCH (wish_desc) AGAINST ('(+accessoires +appareil +photo*)' 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 = 18746 AND W.type_id = 1) OR (W.util_id != 18746 AND W.type_id = 2)) AND (`post_util_id` = 18746 OR `dest_util_id` = 18746) 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=18746 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 = 148223 AND W.type_id = 1) OR (W.util_id != 148223 AND W.type_id = 2)) AND (`post_util_id` = 148223 OR `dest_util_id` = 148223) 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=148223 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 = 206104 AND W.type_id = 1) OR (W.util_id != 206104 AND W.type_id = 2)) AND (`post_util_id` = 206104 OR `dest_util_id` = 206104) 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=206104 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 = 208576 AND W.type_id = 1) OR (W.util_id != 208576 AND W.type_id = 2)) AND (`post_util_id` = 208576 OR `dest_util_id` = 208576) 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=208576 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 = 292241 AND W.type_id = 1) OR (W.util_id != 292241 AND W.type_id = 2)) AND (`post_util_id` = 292241 OR `dest_util_id` = 292241) 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=292241 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 = 292241 AND W.type_id = 1) OR (W.util_id != 292241 AND W.type_id = 2)) AND (`post_util_id` = 292241 OR `dest_util_id` = 292241) 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 = 302064 AND W.type_id = 1) OR (W.util_id != 302064 AND W.type_id = 2)) AND (`post_util_id` = 302064 OR `dest_util_id` = 302064) 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=302064 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 = 307576 AND W.type_id = 1) OR (W.util_id != 307576 AND W.type_id = 2)) AND (`post_util_id` = 307576 OR `dest_util_id` = 307576) 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=307576 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 = 296468 AND W.type_id = 1) OR (W.util_id != 296468 AND W.type_id = 2)) AND (`post_util_id` = 296468 OR `dest_util_id` = 296468) 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=296468 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 = 330921 AND W.type_id = 1) OR (W.util_id != 330921 AND W.type_id = 2)) AND (`post_util_id` = 330921 OR `dest_util_id` = 330921) 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=330921 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 = 339026 AND W.type_id = 1) OR (W.util_id != 339026 AND W.type_id = 2)) AND (`post_util_id` = 339026 OR `dest_util_id` = 339026) 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=339026 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 = 307576 AND W.type_id = 1) OR (W.util_id != 307576 AND W.type_id = 2)) AND (`post_util_id` = 307576 OR `dest_util_id` = 307576) 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 = 351098 AND W.type_id = 1) OR (W.util_id != 351098 AND W.type_id = 2)) AND (`post_util_id` = 351098 OR `dest_util_id` = 351098) 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=351098 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 = 387475 AND W.type_id = 1) OR (W.util_id != 387475 AND W.type_id = 2)) AND (`post_util_id` = 387475 OR `dest_util_id` = 387475) 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=387475 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 = 389254 AND W.type_id = 1) OR (W.util_id != 389254 AND W.type_id = 2)) AND (`post_util_id` = 389254 OR `dest_util_id` = 389254) 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=389254 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 = 393676 AND W.type_id = 1) OR (W.util_id != 393676 AND W.type_id = 2)) AND (`post_util_id` = 393676 OR `dest_util_id` = 393676) 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=393676 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 = 395499 AND W.type_id = 1) OR (W.util_id != 395499 AND W.type_id = 2)) AND (`post_util_id` = 395499 OR `dest_util_id` = 395499) 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=395499 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 = 328459 AND W.type_id = 1) OR (W.util_id != 328459 AND W.type_id = 2)) AND (`post_util_id` = 328459 OR `dest_util_id` = 328459) 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=328459 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 = 398888 AND W.type_id = 1) OR (W.util_id != 398888 AND W.type_id = 2)) AND (`post_util_id` = 398888 OR `dest_util_id` = 398888) 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=398888 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 = 413694 AND W.type_id = 1) OR (W.util_id != 413694 AND W.type_id = 2)) AND (`post_util_id` = 413694 OR `dest_util_id` = 413694) 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=413694 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 = 430558 AND W.type_id = 1) OR (W.util_id != 430558 AND W.type_id = 2)) AND (`post_util_id` = 430558 OR `dest_util_id` = 430558) 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=430558 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 = 320205 AND W.type_id = 1) OR (W.util_id != 320205 AND W.type_id = 2)) AND (`post_util_id` = 320205 OR `dest_util_id` = 320205) 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=320205 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 = 518290 AND W.type_id = 1) OR (W.util_id != 518290 AND W.type_id = 2)) AND (`post_util_id` = 518290 OR `dest_util_id` = 518290) 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=518290 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 = 519991 AND W.type_id = 1) OR (W.util_id != 519991 AND W.type_id = 2)) AND (`post_util_id` = 519991 OR `dest_util_id` = 519991) 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=519991 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 = 522278 AND W.type_id = 1) OR (W.util_id != 522278 AND W.type_id = 2)) AND (`post_util_id` = 522278 OR `dest_util_id` = 522278) 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=522278 AND note_visu IN (1,3,4)
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='647' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 296468
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='647' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 328459
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 351098 AND W.type_id = 1) OR (W.util_id != 351098 AND W.type_id = 2)) AND (`post_util_id` = 351098 OR `dest_util_id` = 351098) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 351098
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389254 AND W.type_id = 1) OR (W.util_id != 389254 AND W.type_id = 2)) AND (`post_util_id` = 389254 OR `dest_util_id` = 389254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 389254
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 307576 AND W.type_id = 1) OR (W.util_id != 307576 AND W.type_id = 2)) AND (`post_util_id` = 307576 OR `dest_util_id` = 307576) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 307576
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 307576 AND W.type_id = 1) OR (W.util_id != 307576 AND W.type_id = 2)) AND (`post_util_id` = 307576 OR `dest_util_id` = 307576) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 307576
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 18746 AND W.type_id = 1) OR (W.util_id != 18746 AND W.type_id = 2)) AND (`post_util_id` = 18746 OR `dest_util_id` = 18746) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 18746
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 320205 AND W.type_id = 1) OR (W.util_id != 320205 AND W.type_id = 2)) AND (`post_util_id` = 320205 OR `dest_util_id` = 320205) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 320205
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 519991 AND W.type_id = 1) OR (W.util_id != 519991 AND W.type_id = 2)) AND (`post_util_id` = 519991 OR `dest_util_id` = 519991) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 519991
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 339026 AND W.type_id = 1) OR (W.util_id != 339026 AND W.type_id = 2)) AND (`post_util_id` = 339026 OR `dest_util_id` = 339026) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 339026
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='643' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 208576
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 393676 AND W.type_id = 1) OR (W.util_id != 393676 AND W.type_id = 2)) AND (`post_util_id` = 393676 OR `dest_util_id` = 393676) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 393676
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 292241 AND W.type_id = 1) OR (W.util_id != 292241 AND W.type_id = 2)) AND (`post_util_id` = 292241 OR `dest_util_id` = 292241) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 292241
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 292241 AND W.type_id = 1) OR (W.util_id != 292241 AND W.type_id = 2)) AND (`post_util_id` = 292241 OR `dest_util_id` = 292241) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 292241
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 413694 AND W.type_id = 1) OR (W.util_id != 413694 AND W.type_id = 2)) AND (`post_util_id` = 413694 OR `dest_util_id` = 413694) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 413694
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 518290 AND W.type_id = 1) OR (W.util_id != 518290 AND W.type_id = 2)) AND (`post_util_id` = 518290 OR `dest_util_id` = 518290) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 518290
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='643' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 395499 AND W.type_id = 1) OR (W.util_id != 395499 AND W.type_id = 2)) AND (`post_util_id` = 395499 OR `dest_util_id` = 395499) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 395499
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 522278 AND W.type_id = 1) OR (W.util_id != 522278 AND W.type_id = 2)) AND (`post_util_id` = 522278 OR `dest_util_id` = 522278) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 522278
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='643' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206104 AND W.type_id = 1) OR (W.util_id != 206104 AND W.type_id = 2)) AND (`post_util_id` = 206104 OR `dest_util_id` = 206104) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 206104
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 387475 AND W.type_id = 1) OR (W.util_id != 387475 AND W.type_id = 2)) AND (`post_util_id` = 387475 OR `dest_util_id` = 387475) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 387475
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 430558 AND W.type_id = 1) OR (W.util_id != 430558 AND W.type_id = 2)) AND (`post_util_id` = 430558 OR `dest_util_id` = 430558) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 430558
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 302064 AND W.type_id = 1) OR (W.util_id != 302064 AND W.type_id = 2)) AND (`post_util_id` = 302064 OR `dest_util_id` = 302064) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 302064
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='647' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 398888 AND W.type_id = 1) OR (W.util_id != 398888 AND W.type_id = 2)) AND (`post_util_id` = 398888 OR `dest_util_id` = 398888) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 398888
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='647' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 330921
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='643' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 148223 AND W.type_id = 1) OR (W.util_id != 148223 AND W.type_id = 2)) AND (`post_util_id` = 148223 OR `dest_util_id` = 148223) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 148223
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=232 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='accessoires appareil photo' OR ssrubr_slug like '%accessoires appareil photo%' OR MATCH (ssrubr_slug) AGAINST ('(+accessoires +appareil +photo)')) AND sk.ssrubr_id='647' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='647' 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