update materiel_modele set nb_user_materiel_datemodif=now() where id=428320 SELECT equipement,user.numero,user_matos.numero as nummatos FROM `user` Left Join `user_matos` ON `user_matos`.`numero` = `user`.`numero` where equipement like '%Cort%' and equipement like '%action bass 4%' and supprime=0 order by rand() limit 20 nummatos :387026 nummatos :752087 nummatos :1006310 nummatos :1134822 nummatos :798667 nummatos :516056 nummatos :1088980 nummatos :1229807 nummatos :1132356 nummatos :639485 nummatos :1004323 nummatos :541779 nummatos :1041551 nummatos :1074880 nummatos :1260291 nummatos :582718 |