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='voiture'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=81
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'
SELECT ville_nom FROM villes WHERE ville_cp='93140' AND ville_nom like '%bondy%' 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 '%voitures%' OR ssrubr_title like '%voitures%' OR ssrubr_slug like '%voitures%') AND cate_id='81' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='93140'
SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.1930597328734 AND ville_longitude_deg<2.7402802671266 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='voiture; voitures'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='81'AND MATCH (wish_title,wish_desc) AGAINST ('+voiture; voitures*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '93140%'
SELECT * FROM texte WHERE cate_id=81
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='voiture; voitures' OR ssrubr_slug='voiture;-voitures' OR (ssrubr_title like '%voiture; voitures%')) AND cate_id='81' 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 (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='voitures' AND cate_id='81'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='93140'
SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.1930597328734 AND ville_longitude_deg<2.7402802671266 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.7826384337256 AND ville_longitude_deg<3.1507015662744 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='81' AND MATCH (wish_desc) AGAINST ('(+voiture; +voitures*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93140,93140,93000,93130,93260,93230,93250,93340,93320,93150,93110,93700,93100,93500,93170,93350,93360,93220,93310,94120,94170,94300,93270,93390,93190,93120,93300,93440,93600,93370,93330,94130,95500,93410,93460,93240,94360,94160,95140,77181,93470,93210,93200,93420,93160,94340,94410,95500,94350,93400,77500,94220,95400,94500,75008,75007,75010,75006,75011,75005,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,75004,75003,75009,75001,75000,75002,93290,93380,93450,92390,94200,94205,77181,95500,95500,93430,77420,95360,94700,94210,94340,94100,77270,95700,94140,94430,94270,94420,92110,77177,95410,95200,95400,92230,93800,95190,94000,95720,95880,77185,92600,95350,94800,92300,77186,95170,94250,77410,94400,77360,92170,95440,94880,94880,94490,77290,77184,92120,77200,92270,92200,95160,94110,94380,95380,77340,95720,94600,95230,92240,95218,95210,95350,94510,94370,94380,92400,92250,92700,77400,95380,94320,77990,94240,94234,94238,94230,94231,94239,94233,94232,94235,94237,94236,77400,77410,77090,77183,95580,95580,92220,95460,94460,95190,95100,77600,94470,77990,94550,95120,92130,95380,95720,94310,94390,95600,92320,77680,92150,92800,77400,95110,92100,92340,95330,95380,77410,77600,77600,77400,77290,77410,77400,92140,94450,95190,94190,95380,77410,95870,95680,77400,92260,92330,95850,95570,94150,94290,77600,95720,77230,95570,92360,92190,77410,92210,95130,77164,92000,94440,77230,95390,92350,77400,92500,78800,77410,95470,77230,94260)
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.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- 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='81' AND MATCH (wish_desc) AGAINST ('(+voiture; +voitures*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93140,93140,93000,93130,93260,93230,93250,93340,93320,93150,93110,93700,93100,93500,93170,93350,93360,93220,93310,94120,94170,94300,93270,93390,93190,93120,93300,93440,93600,93370,93330,94130,95500,93410,93460,93240,94360,94160,95140,77181,93470,93210,93200,93420,93160,94340,94410,95500,94350,93400,77500,94220,95400,94500,75008,75007,75010,75006,75011,75005,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,75004,75003,75009,75001,75000,75002,93290,93380,93450,92390,94200,94205,77181,95500,95500,93430,77420,95360,94700,94210,94340,94100,77270,95700,94140,94430,94270,94420,92110,77177,95410,95200,95400,92230,93800,95190,94000,95720,95880,77185,92600,95350,94800,92300,77186,95170,94250,77410,94400,77360,92170,95440,94880,94880,94490,77290,77184,92120,77200,92270,92200,95160,94110,94380,95380,77340,95720,94600,95230,92240,95218,95210,95350,94510,94370,94380,92400,92250,92700,77400,95380,94320,77990,94240,94234,94238,94230,94231,94239,94233,94232,94235,94237,94236,77400,77410,77090,77183,95580,95580,92220,95460,94460,95190,95100,77600,94470,77990,94550,95120,92130,95380,95720,94310,94390,95600,92320,77680,92150,92800,77400,95110,92100,92340,95330,95380,77410,77600,77600,77400,77290,77410,77400,92140,94450,95190,94190,95380,77410,95870,95680,77400,92260,92330,95850,95570,94150,94290,77600,95720,77230,95570,92360,92190,77410,92210,95130,77164,92000,94440,77230,95390,92350,77400,92500,78800,77410,95470,77230,94260) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='93140'
SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.1930597328734 AND ville_longitude_deg<2.7402802671266 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.7826384337256 AND ville_longitude_deg<3.1507015662744 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 = 6313 AND W.type_id = 1) OR (W.util_id != 6313 AND W.type_id = 2)) AND (`post_util_id` = 6313 OR `dest_util_id` = 6313) 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=6313 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 = 7937 AND W.type_id = 1) OR (W.util_id != 7937 AND W.type_id = 2)) AND (`post_util_id` = 7937 OR `dest_util_id` = 7937) 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=7937 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 = 9211 AND W.type_id = 1) OR (W.util_id != 9211 AND W.type_id = 2)) AND (`post_util_id` = 9211 OR `dest_util_id` = 9211) 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=9211 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 = 11574 AND W.type_id = 1) OR (W.util_id != 11574 AND W.type_id = 2)) AND (`post_util_id` = 11574 OR `dest_util_id` = 11574) 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=11574 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 = 44486 AND W.type_id = 1) OR (W.util_id != 44486 AND W.type_id = 2)) AND (`post_util_id` = 44486 OR `dest_util_id` = 44486) 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=44486 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 = 60182 AND W.type_id = 1) OR (W.util_id != 60182 AND W.type_id = 2)) AND (`post_util_id` = 60182 OR `dest_util_id` = 60182) 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=60182 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 = 101689 AND W.type_id = 1) OR (W.util_id != 101689 AND W.type_id = 2)) AND (`post_util_id` = 101689 OR `dest_util_id` = 101689) 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=101689 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 = 116726 AND W.type_id = 1) OR (W.util_id != 116726 AND W.type_id = 2)) AND (`post_util_id` = 116726 OR `dest_util_id` = 116726) 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=116726 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 = 121201 AND W.type_id = 1) OR (W.util_id != 121201 AND W.type_id = 2)) AND (`post_util_id` = 121201 OR `dest_util_id` = 121201) 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=121201 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 = 130963 AND W.type_id = 1) OR (W.util_id != 130963 AND W.type_id = 2)) AND (`post_util_id` = 130963 OR `dest_util_id` = 130963) 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=130963 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 = 112528 AND W.type_id = 1) OR (W.util_id != 112528 AND W.type_id = 2)) AND (`post_util_id` = 112528 OR `dest_util_id` = 112528) 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=112528 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 = 150227 AND W.type_id = 1) OR (W.util_id != 150227 AND W.type_id = 2)) AND (`post_util_id` = 150227 OR `dest_util_id` = 150227) 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=150227 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 = 185733 AND W.type_id = 1) OR (W.util_id != 185733 AND W.type_id = 2)) AND (`post_util_id` = 185733 OR `dest_util_id` = 185733) 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=185733 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 = 203275 AND W.type_id = 1) OR (W.util_id != 203275 AND W.type_id = 2)) AND (`post_util_id` = 203275 OR `dest_util_id` = 203275) 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=203275 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 = 153882 AND W.type_id = 1) OR (W.util_id != 153882 AND W.type_id = 2)) AND (`post_util_id` = 153882 OR `dest_util_id` = 153882) 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=153882 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 = 215758 AND W.type_id = 1) OR (W.util_id != 215758 AND W.type_id = 2)) AND (`post_util_id` = 215758 OR `dest_util_id` = 215758) 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=215758 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 = 221709 AND W.type_id = 1) OR (W.util_id != 221709 AND W.type_id = 2)) AND (`post_util_id` = 221709 OR `dest_util_id` = 221709) 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=221709 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 = 226243 AND W.type_id = 1) OR (W.util_id != 226243 AND W.type_id = 2)) AND (`post_util_id` = 226243 OR `dest_util_id` = 226243) 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=226243 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 = 234782 AND W.type_id = 1) OR (W.util_id != 234782 AND W.type_id = 2)) AND (`post_util_id` = 234782 OR `dest_util_id` = 234782) 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=234782 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 = 312783 AND W.type_id = 1) OR (W.util_id != 312783 AND W.type_id = 2)) AND (`post_util_id` = 312783 OR `dest_util_id` = 312783) 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=312783 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 = 411963 AND W.type_id = 1) OR (W.util_id != 411963 AND W.type_id = 2)) AND (`post_util_id` = 411963 OR `dest_util_id` = 411963) 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=411963 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 = 396074 AND W.type_id = 1) OR (W.util_id != 396074 AND W.type_id = 2)) AND (`post_util_id` = 396074 OR `dest_util_id` = 396074) 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=396074 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 = 465345 AND W.type_id = 1) OR (W.util_id != 465345 AND W.type_id = 2)) AND (`post_util_id` = 465345 OR `dest_util_id` = 465345) 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=465345 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 = 421715 AND W.type_id = 1) OR (W.util_id != 421715 AND W.type_id = 2)) AND (`post_util_id` = 421715 OR `dest_util_id` = 421715) 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=421715 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 = 497956 AND W.type_id = 1) OR (W.util_id != 497956 AND W.type_id = 2)) AND (`post_util_id` = 497956 OR `dest_util_id` = 497956) 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=497956 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 = 503606 AND W.type_id = 1) OR (W.util_id != 503606 AND W.type_id = 2)) AND (`post_util_id` = 503606 OR `dest_util_id` = 503606) 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=503606 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 = 541762 AND W.type_id = 1) OR (W.util_id != 541762 AND W.type_id = 2)) AND (`post_util_id` = 541762 OR `dest_util_id` = 541762) 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=541762 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=81 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='voiture; voitures' OR ssrubr_slug like '%voiture; voitures%' OR MATCH (ssrubr_slug) AGAINST ('(+voiture; +voitures)')) AND sk.ssrubr_id='985' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='985' 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