Mysql select not duplicated values with condition -

I'm looking for a fast way to run this type of statement:

  SELECT * where (aktywne = 1 and user_id = 6)) and aktywne = 0, and user_id = 6)   
 table aukcje_przedmioty   
 
 
 you can try to do something  
  SELECT a. * `From` Aukcje_przedmioty a join (select Ugr_aid for Aukeje_prgdmi group by API, Ugr_aid Having Max (Aketin) = 0) = Akskyujr_aidi A.yujr_aidi and Akskopis = A.opiais WHERE Ugr_aidi = 6   
  
 to see the use on your setup that will do the best for you.