____________________________________________________
sql-jobassistant - attention, requête SQL impossible à réaliser...
Code : 1064
Message d'erreur : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by id_z_option_carriere desc LIMIT 0,15' at line 1
select * from hs3d_view_user uu LEFT OUTER JOIN hs3d_param_villes pv on (uu.uu_codepostal=pv.PV_CP and uu.uu_ville = pv.PV_INTITULE ) left outer join hs3d_param_cantons pc on (pv.fk_id_param_cantons=pc.id_param_cantons) left outer join hs3d_param_pays pp on (pp.ID_PARAM_PAYS=uu.fk_id_param_pays) where id_users_user='1675'
select * from hs3d_news_news nn where FK_ID_NEWS_CAT=2 order by NN_DATEHEURE desc,ID_NEWS_NEWS DESC limit 0,2
SELECT distinct tag, 1 as number, zoc_mc, zoc_loc FROM hs3d_z_option_carriere zoc order by id_z_option_carriere desc LIMIT 0,10
select * from hs3d_cv cv where fk_id_users_user='1675' and cv_publication=1
SELECT ff.*,ffu_principal, fc1.id_forum_cat as fc1_id,fc1.fc_intitule as fc1_intitule,fc2.id_forum_cat as fc2_id,fc2.fc_intitule as fc2_intitule FROM hs3d_forum_forum ff, hs3d_forum_forum_user ffu, hs3d_forum_cat fc2, hs3d_forum_cat fc1 where ff.fk_id_forum_cat=fc2.id_forum_cat and ffu.fk_id_forum_forum = ff.id_forum_forum and ffu.fk_id_users_user='1675' and fc2.fk_id_forum_cat=fc1.id_forum_cat and ffu_val=1 and fc1.cat_actif=1 and fc2.cat_actif = 1 order by ffu_principal desc, ff_intitule asc
select pus_intitule from hs3d_param_users_statut where id_param_users_statut='2'
SELECT *
FROM hs3d_users_user_activite uua, hs3d_param_users_activite pua
WHERE fk_id_param_users_activite = id_param_users_activite
AND fk_id_users_user = '1675'
select * from hs3d_users_user_ami uua,hs3d_users_user uu where ((uua.fk_id_users_user2=uu.id_users_user and uua.fk_id_users_user='1675' and uu.uu_level = 0) or (uua.fk_id_users_user=uu.id_users_user and uua.fk_id_users_user2='1675' and uu.uu_level = 0)) and uua_status='1'
select *,fc1.id_forum_cat as fc1_id,fc1.fc_intitule as fc1_intitule,fc2.id_forum_cat as fc2_id,fc2.fc_intitule as fc2_intitule from hs3d_forum_forum_topic_message fftm,hs3d_forum_forum_topic fft,hs3d_forum_forum ff,hs3d_forum_cat fc2,hs3d_forum_cat fc1 where fftm.fk_id_forum_forum_topic = fft.id_forum_forum_topic and fft.fk_id_forum_forum=ff.id_forum_forum and ff.fk_id_forum_cat = fc2.id_forum_cat and fc2.fk_id_forum_cat = fc1.id_forum_cat and fftm.fk_id_users_user='1675' and ff_actif=1 and fc1.cat_actif = 1 and fc2.cat_actif=1 order by fftm_dateheure desc limit 0,5
insert into hs3d_z_option_carriere (fk_id_users_user,zoc_mc,zoc_loc,tag,count) values('0','Ălectricien','France','Ălectricien@@@France',0)
select count(*) from hs3d_z_option_carriere where zoc_datetime > '2012-04-18' and tag='Ălectricien@@@France'
update hs3d_z_option_carriere set count = 0 where tag= 'Ălectricien@@@France'
delete from hs3d_z_option_carriere where zoc_datetime < '2012-04-18' and 'Ălectricien@@@France' and fk_id_users_user=0
SELECT distinct tag, count as number, zoc_mc, zoc_loc FROM hs3d_z_option_carriere zoc where () order by id_z_option_carriere desc LIMIT 0,15
____________________________________________________
Recherches approchant la recherche d'emploi "Ălectricien" :