conda create -n rapids-24.06 -c rapidsai -c conda-forge -c nvidia rapids=24.06 python=3.11 cuda-version=12.2
COPY

wget https://repo.anaconda.com/miniconda/Miniconda3-latest-Linux-x86_64.sh
bash Miniconda3-latest-Linux-x86_64.sh
COPY

let allTextInputs = postForm[0].querySelectorAll('input:not([type="radio"]):not([type="checkbox"])');

let allRadioInputs = postForm[0].querySelectorAll('input:not([type="text"]):not([type="checkbox"])');

let allCheckBoxInputs = postForm[0].querySelectorAll('input:not([type="text"]):not([type="radio"])');

let allSelectTags = postForm[0].querySelectorAll('select[required]');

console.log(allTextInputs, allCheckBoxInputs, allRadioInputs, allSelectTags);

[
    {
        "$match": {
            "participantId": ObjectId("65c4d2bbd566b4251df9209f")
        }
    },
    {
        "$match": {
            "date": {
                "$gte": ISODate("2024-01-31T18:30:00Z"),
                "$lte": ISODate("2024-02-29T18:29:00Z")
            },
            "src": {
                "$ne": "manual"
            }
        }
    },
    {
        "$group": {
            "_id": "$participantId",
            "totalSteps": {
                "$sum": {
                    "$convert": {
                        "input": "$stepsTaken",
                        "to": "double",
                        "onError": 0,
                        "onNull": 0
                    }
                }
            }
        }
    },
    {
        "$project": {
            "_id": 0,
            "participantId": "$_id",
            "totalSteps": 1
        }
    }
]

// https://resource.dopus.com/t/set-metadata-track-title-and-artist-from-filename/48101

function OnClick(clickData) {
    var cmd = clickData.func.command;
    var tab = clickData.func.sourcetab;
    cmd.deselect = false;

    if (!tab.selected_files) return;

    for (var e = new Enumerator(tab.selected_files); !e.atEnd(); e.moveNext()) {
        var item = e.item();

        var name = item.name_stem;
        var name_track = name.replace(/(^[0-9]*)(.*)/, "$1");
        var name_title = name.replace(/(^[0-9\.\s]*)(.*)(\s-\s)(.*)/, "$2");
        var name_artist = name.replace(/(^[0-9\.\s]*)(.*)(\s-\s)(.*)/, "$4");

        cmd.RunCommand('SetAttr' +
            ' FILE="' + item + '"' +
            ' META "track:{dlgstring|Pista:|' + name_track + '}"');

        cmd.RunCommand('SetAttr' +
            ' FILE="' + item + '"' +
            ' META "title:{dlgstring|Título:|' + name_title + '}"');

        cmd.RunCommand('SetAttr' +
            ' FILE="' + item + '"' +
            ' META "artist:{dlgstring|Artista:|' + name_artist + '}"');

    }
}

           public:
    int findPlatform(int arr[], int dep[], int n)
    {
         sort ( arr,arr+n);sort ( dep , dep+n);
         int i=0;int j=0;int count=0,maxCount=0;
         while ( i<n&&j<n){
             if ( arr[i]<=dep[j]) 
             {count++;i++;}
             else 
             {count--;j++;}
             maxCount=max(count,maxCount);
         }
         return maxCount;
    }
};

  const books = [
    {
      title: 'Algorithms',
      author: ['Robert Sedgewick', 'Kevin Wayne'],
      publisher: 'Addison-Wesley Professional',
      publicationDate: '2011-03-24',
      edition: 4,
      keywords: [
        'computer science',
        'programming',
        'algorithms',
        'data structures',
        'java',
        'math',
        'software',
        'engineering',
      ],
      pages: 976,
      format: 'hardcover',
      ISBN: '9780321573513',
      language: 'English',
      programmingLanguage: 'Java',
      onlineContent: true,
      thirdParty: {
        goodreads: {
          rating: 4.41,
          ratingsCount: 1733,
          reviewsCount: 63,
          fiveStarRatingCount: 976,
          oneStarRatingCount: 13,
        },
      },
      highlighted: true,
    },
    {
      title: 'Structure and Interpretation of Computer Programs',
      author: [
        'Harold Abelson',
        'Gerald Jay Sussman',
        'Julie Sussman (Contributor)',
      ],
      publisher: 'The MIT Press',
      publicationDate: '2022-04-12',
      edition: 2,
      keywords: [
        'computer science',
        'programming',
        'javascript',
        'software',
        'engineering',
      ],
      pages: 640,
      format: 'paperback',
      ISBN: '9780262543231',
      language: 'English',
      programmingLanguage: 'JavaScript',
      onlineContent: false,
      thirdParty: {
        goodreads: {
          rating: 4.36,
          ratingsCount: 14,
          reviewsCount: 3,
          fiveStarRatingCount: 8,
          oneStarRatingCount: 0,
        },
      },
      highlighted: true,
    },
    {
      title: "Computer Systems: A Programmer's Perspective",
      author: ['Randal E. Bryant', "David Richard O'Hallaron"],
      publisher: 'Prentice Hall',
      publicationDate: '2002-01-01',
      edition: 1,
      keywords: [
        'computer science',
        'computer systems',
        'programming',
        'software',
        'C',
        'engineering',
      ],
      pages: 978,
      format: 'hardcover',
      ISBN: '9780130340740',
      language: 'English',
      programmingLanguage: 'C',
      onlineContent: false,
      thirdParty: {
        goodreads: {
          rating: 4.44,
          ratingsCount: 1010,
          reviewsCount: 57,
          fiveStarRatingCount: 638,
          oneStarRatingCount: 16,
        },
      },
      highlighted: true,
    },
    {
      title: 'Operating System Concepts',
      author: ['Abraham Silberschatz', 'Peter B. Galvin', 'Greg Gagne'],
      publisher: 'John Wiley & Sons',
      publicationDate: '2004-12-14',
      edition: 10,
      keywords: [
        'computer science',
        'operating systems',
        'programming',
        'software',
        'C',
        'Java',
        'engineering',
      ],
      pages: 921,
      format: 'hardcover',
      ISBN: '9780471694663',
      language: 'English',
      programmingLanguage: 'C, Java',
      onlineContent: false,
      thirdParty: {
        goodreads: {
          rating: 3.9,
          ratingsCount: 2131,
          reviewsCount: 114,
          fiveStarRatingCount: 728,
          oneStarRatingCount: 65,
        },
      },
    },
    {
      title: 'Engineering Mathematics',
      author: ['K.A. Stroud', 'Dexter J. Booth'],
      publisher: 'Palgrave',
      publicationDate: '2007-01-01',
      edition: 14,
      keywords: ['mathematics', 'engineering'],
      pages: 1288,
      format: 'paperback',
      ISBN: '9781403942463',
      language: 'English',
      programmingLanguage: null,
      onlineContent: true,
      thirdParty: {
        goodreads: {
          rating: 4.35,
          ratingsCount: 370,
          reviewsCount: 18,
          fiveStarRatingCount: 211,
          oneStarRatingCount: 6,
        },
      },
      highlighted: true,
    },
    {
      title: 'The Personal MBA: Master the Art of Business',
      author: 'Josh Kaufman',
      publisher: 'Portfolio',
      publicationDate: '2010-12-30',
      keywords: ['business'],
      pages: 416,
      format: 'hardcover',
      ISBN: '9781591843528',
      language: 'English',
      thirdParty: {
        goodreads: {
          rating: 4.11,
          ratingsCount: 40119,
          reviewsCount: 1351,
          fiveStarRatingCount: 18033,
          oneStarRatingCount: 1090,
        },
      },
    },
    {
      title: 'Crafting Interpreters',
      author: 'Robert Nystrom',
      publisher: 'Genever Benning',
      publicationDate: '2021-07-28',
      keywords: [
        'computer science',
        'compilers',
        'engineering',
        'interpreters',
        'software',
        'engineering',
      ],
      pages: 865,
      format: 'paperback',
      ISBN: '9780990582939',
      language: 'English',
      thirdParty: {
        goodreads: {
          rating: 4.7,
          ratingsCount: 253,
          reviewsCount: 23,
          fiveStarRatingCount: 193,
          oneStarRatingCount: 0,
        },
      },
    },
    {
      title: 'Deep Work: Rules for Focused Success in a Distracted World',
      author: 'Cal Newport',
      publisher: 'Grand Central Publishing',
      publicationDate: '2016-01-05',
      edition: 1,
      keywords: ['work', 'focus', 'personal development', 'business'],
      pages: 296,
      format: 'hardcover',
      ISBN: '9781455586691',
      language: 'English',
      thirdParty: {
        goodreads: {
          rating: 4.19,
          ratingsCount: 144584,
          reviewsCount: 11598,
          fiveStarRatingCount: 63405,
          oneStarRatingCount: 1808,
        },
      },
      highlighted: true,
    },
  ];




 function printBookAuthorsCount(title, ...authors) { // authors can be more than 1 param
    return `The book ${title} has ${authors.length} authors`;
  }

  const { title: book3Title, author: authors } = books[2];

  const bookAuthor = printBookAuthorsCount(
    book3Title,
    'Robert Sedgewick', //rest param 1
    'Kevin Wayne' //rest param 2
  );
  console.log(bookAuthor);

   int f(int ind,int target,vector<int>& a,vector<vector<int>>& dp)
   {
    int pick,nonPick;
      
      if(ind==0)
      {
        if(target%a[0]==0)
        return 1;
        else return 0;
      }
      if(dp[ind][target]!=-1)return dp[ind][target];
       nonPick = f(ind-1,target,a,dp);
       pick=0;
      if(a[ind]<=target)
        pick = f(ind,target-a[ind],a,dp);
      return dp[ind][target]=(pick+nonPick);
   }
    int change(int amount,vector<int>& coins) {
        int n = coins.size();
        vector<vector<int>> dp(n,vector<int>(amount+1,-1));
        return f(n-1,amount,coins,dp);
        
        
    }

   int f(int ind,int target,vector<int>& a,vector<vector<int>>& dp)
   {
    int pick,nonPick;
      
      if(ind==0)
      {
        if(target%a[0]==0)return target/a[0];
        else return INT_MAX;
      }
      if(dp[ind][target]!=-1)return dp[ind][target];
       nonPick = f(ind-1,target,a,dp);
       pick = 1e9;
      if(a[ind]<=target)
        pick = 1+f(ind,target-a[ind],a,dp);
      return dp[ind][target]=min(pick,nonPick);
   }
    int coinChange(vector<int>& coins, int amount) {
        int n = coins.size();
        vector<vector<int>> dp(n,vector<int>(amount+1,-1));
        int res =f(n-1,amount,coins,dp);
        return (res>=1e9)?-1:res;
        
    }

iwr -useb https://christitus.com/win | iex

   const testObj = {
    name: 'David',
    movie: 'fight club',
    active: true,
  };

  const testObj2 = {
    name: 'kevin',
    movie: 'Bladerunner',
    active: false,
  };



// using rest only
const combined = []; //empty array

  function makeArrayFromMUtipleObjects(...args) {
    for (let item of args) {
      // will have two separate objects
      combined.push(item); // push into the empty arry
    }
  }

  console.log(combined); 




// using rest and another param

 const anotherArray = [];

 function makeArray(array, ...itemsToAdd) {
    return array.concat(itemsToAdd);
  }

 const made = makeArray(anotherArray, testObj, testObj2);
 console.log(made);

x = 0

while(x < 10){

   print(x)
   x = x + 1

   if(x == 5){
   print(x)
   break
   }

}

vec <- c(1,2,3,4,5, 6, 8, 9, 10,100)
for(var in vec){
  print(var)

}


mat <- matrix(1:25, nrow=5)

print(mat)

#iterate by rows

for(row in 1:nrow(mat)){
  for(col in 1:ncol(mat)){
    print(paste('The element at row: ', row, 'and col: ', col, 'is', mat[row, col]))
  }

}

1:nrow(mat)

#Add the total for each column by iterating over each colomn

total.col1 <- 0
for(col in 1:ncol(mat)){
  for(row in 1:nrow(mat)){
    #print(paste('The element at col: ', col, 'and row: ', row, 'is', mat[row, col]))
    total.col1 <- total.col1 + mat[row, col]
    if(row == 5){
       print(paste('Total col ', col, ': ', total.col1))
       total.col1 <- 0  
    }
  }
}

//Controller
[HttpPost]
[DisableRequestSizeLimit]
[Route("Register")]
public async Task<IActionResult> Register([FromForm] UserViewModel uvm)
{
    try
    {
        var formCollection = await Request.ReadFormAsync();

        // Retrieves the first file from the form data, which is expected to be the user's photo.
        var photo = formCollection.Files.FirstOrDefault();

        // Attempts to find an existing user by the provided email.
        var user = await _userManager.FindByEmailAsync(uvm.Email);

        // If the user is not found, proceed with registration.
        if (user == null)
        {
            // Uses a memory stream to process the photo file.
            using (var memoryStream = new MemoryStream())
            {
                // Copies the photo file data into the memory stream asynchronously.
                await photo.CopyToAsync(memoryStream);

                // Converts the memory stream data into a byte array.
                var fileBytes = memoryStream.ToArray();

                // Encodes the byte array to a base64 string.
                string base64Image = Convert.ToBase64String(fileBytes);

                // Creates a new user object with the provided details and hashed password.
                user = new User
                {
                    UserName = uvm.Email,
                    Email = uvm.Email,
                    PasswordHash = _userManager.PasswordHasher.HashPassword(null, uvm.Password),
                    Photo = base64Image // Stores the base64 string in the user's profile.
                };

                // Attempts to create the new user asynchronously.
                IdentityResult result = await _userManager.CreateAsync(user);

                // If the user creation is successful, return a success response.
                if (result.Succeeded)
                {
                    return Ok(new { Status = "Success", Message = "User created successfully!" });
                }
                // If user creation fails, return an error response with the first error message.
                else
                {
                    return StatusCode(StatusCodes.Status500InternalServerError, result.Errors.FirstOrDefault()?.Description);
                }
            }
        }
        // If the user already exists, return a forbidden response.
        else
        {
            return Forbid("Account already exists.");
        }
    }
    catch (Exception ex)
    {
        // If an exception occurs, return a generic error response.
        return StatusCode(StatusCodes.Status500InternalServerError, "An error occurred while processing your request.");
    }
}

//program cs
// Configure FormOptions for file uploads
builder.Services.Configure<FormOptions>(o =>
{
    o.ValueLengthLimit = int.MaxValue;
    o.MultipartBodyLengthLimit = int.MaxValue;
    o.MemoryBufferThreshold = int.MaxValue;
});

x = 0

while(x < 10){

   print(x)
   x = x + 1

   if(x == 5){
   print(x)
   break
   }

}

//Just a placeholder

.nav-link-text{
font-size: 20px
}

$parent = "C:\Users\user\Desktop\derp"
$pl = $parent.Length
$dest = "C:\Users\user\Desktop\test"
$empty = get-childitem $parent -recurse | 
Where-Object { $_.PSIsContainer } |   
Where-Object { $_.GetFiles().Count -eq 0 } |   
Where-Object { $_.GetDirectories().Count -eq 0 } |    
ForEach-Object { $_.FullName }  

foreach ($item in $empty) {
Write-Host $item
$object= Get-Item $item
      if($object.parent.fullname.length -gt $pl){
                
                $OParentPath = $object.FullName
                $last = $OParentPath.Substring($pl)
                $newDest = $dest+$last
                mkdir -Path $newDest
                Remove-Item $item

                }
      Else{Move-Item $item -Destination $dest}

      }
    
  

get-childitem "Q:\Data\" -recurse | 
Where-Object { $_.PSIsContainer } |   
Where-Object { $_.GetFiles().Count -eq 0 } |   
Where-Object { $_.GetDirectories().Count -eq 0 } |    
ForEach-Object { $_.FullName } |   
Out-File -FilePath C:\Users\user\Desktop\results.txt

Cryptocurrency Exchange Clone Script  gives entrepreneurs a strategic advantage by enabling swift establishment and operation of trading platforms. Alphacodez as a trusted partner in exchange development emphasizes the importance of customization, security, compliance, and ongoing support, showcasing.

Run CMD as admin and copy/paste:

taskkill /im msedge.exe /f
reg delete "HKCU\Software\Policies\Microsoft\Edge" /f
reg delete "HKLM\Software\Policies\Microsoft\Edge" /f

//let winW = $(window).width();
let winW = window.innerWidth;

if (winW >= 1025) {
          
}

const testObj = {
  name: 'David',
  movie: 'fight club',
  active: true,
};

const testObj2 = {
  name: 'kevin',
  movie: 'Bladerunner',
  active: false,
};



function getData(...args) {
  args.forEach(({name, movie}) => {
    console.log({name, movie});
  });
}

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    //Type appropriate comment here, and begin script below
    var pattern = /^[(]?(\d{3})[)]?[-|\s]?(\d{3})[-|\s]?(\d{4})$/;

    if (!pattern.test(newValue)) {
        alert('Phone enter a valid phone number');
        g_form.setValue('variable_name', '');
    }
}

for /R %f IN (*.mkv) DO ffmpeg -i "%f" -c copy "%~nf.mp4"

a = b + c(d + e).print()

a = b + c
(d + e).print()

a = b;
++c;

a = b
++c

return;
a + b;

return
a + b

for (a; b
)

{ 1
;2 ;} 3;

{ 1
2 } 3

{ 1 2 } 3

Note: Single-state adapter.
Note: Uses the mt7921au chipset.
Note: Uses the standard Mediatek device ID (VID/PID) for the mt7921au chipset: ID 0e8d:7961
Note: Oldest LTS kernel that supports this adapter: kernel 6.1

>================================<
>=====>  EDUP EP-AX1672 <=======<
>================================<

kmod-mt7921u

ls -l

cd /usr/lib/modules/$(uname -r)/kernel/drivers/net/wireless/mediatek/mt76/mt7921

@Override
public List<Cliente> orderedByBubbleSortName() {
        List<Cliente> clientes = findAll();
        int n = clientes.size();
        boolean swapped;
        for (int i = 0; i < n - 1; i++) {
            swapped = false;
            for (int j = 0; j < n - i - 1; j++) {
                if (clientes.get(j).getNome().compareToIgnoreCase(clientes.get(j + 1).getNome()) > 0) {
                    Cliente temp = clientes.get(j);
                    clientes.set(j, clientes.get(j + 1));
                    clientes.set(j + 1, temp);
                    swapped = true;
                }
            }
            if (!swapped) {
                break;
            }
        }
        return clientes;
    }

 @Override
    public Cliente save(Cliente cliente) {
        String query = "INSERT INTO clientes (nome, email, senha, pagamento) VALUES (?, ?, ?, ?)";
        try (PreparedStatement stmt = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS)) {
            stmt.setString(1, cliente.getNome());
            stmt.setString(2, cliente.getEmail());
            stmt.setString(3, cliente.getSenha());
            stmt.setString(4, cliente.getPagamento().toString());
            stmt.executeUpdate();

            ResultSet rs = stmt.getGeneratedKeys();
            if (rs.next()) {
                cliente.setId(rs.getInt(1));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return cliente;
    }

SELECT i.SubscriberKey
	,i.EmailAddress
	,i.System_Language__c
	,i.Mailing_Country__c
	,i.First_Name__c
	,i.Cat_Campaign_Most_Recent__c
	,i.Business_Unit__c
	,i.System_Opt_in_for_eMail__c
	,i.DateAdded
	,i.PCCReg
FROM [Test_Retail_TA_News_2024_INCLUDE] i
WHERE 1 = 1
    AND NOT EXISTS (
        SELECT NULL
        FROM [Test_Retail_TA_News_2024_EXCLUDE] ex
        WHERE 1 = 1
            AND i.SubscriberKey = ex.SubscriberKey
    )
    

 
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT s.SubscriberKey,
            'Undeliverable' as reason
        FROM ENT._Subscribers s
        JOIN Test_Retail_TA_News_2024_INCLUDE c on c.SubscriberKey = s.SubscriberKey
        WHERE 1 = 1
            AND s.status in ('held', 'bounced', 'unsubscribe', 'unsubscribed')
            AND s.SubscriberKey IN (
                SELECT x.SubscriberKey
                FROM [Test_Retail_TA_News_2024_INCLUDE] x
                WHERE 1 = 1
            )
             
    ) a

    
UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,  
              'Dealer Exclusion' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
            AND LOWER(
                RIGHT (
                    b.EmailAddress,
                    LEN(b.EmailAddress) - CHARINDEX('@', b.EmailAddress)
                )
            ) IN (
                SELECT LOWER(x.Domain)
                FROM ent.[Dealer Domains] x
            )
    ) a
UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,
            'Hard bounce DE' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
            AND b.SubscriberKey IN (
                SELECT x.SubscriberKey
                FROM ent.[Hard Bounces - Exclusion] x
            )
    ) a
UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,
            'Cat Agency Exclusion' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
            AND LOWER(
                RIGHT (
                    b.EmailAddress,
                    LEN(b.EmailAddress) - CHARINDEX('@', b.EmailAddress)
                )
            ) IN (
                SELECT LOWER(x.Domain)
                FROM ent.[Cat_Agency_Domains] x
            )
    ) a
UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,
            'Competitor Exclusion' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
            AND LOWER(
                RIGHT (
                    b.EmailAddress,
                    LEN(b.EmailAddress) - CHARINDEX('@', b.EmailAddress)
                )
            ) IN (
                SELECT LOWER(x.Domain)
                FROM ent.[Competitor Domains] x
            )
    ) a 
    
    UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,
            'AMC Status' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
         AND   b.AMC_Status__c IN ('Inactive', 'Expired')
    ) a 

       UNION ALL
SELECT a.SubscriberKey,
       a.reason
FROM (
        SELECT b.SubscriberKey,
            'AMC Not Marketable' as reason
        FROM [Test_Retail_TA_News_2024_INCLUDE] b
        WHERE 1 = 1
         AND   b.AMC_Last_Activity_Record_ID__c LIKE 'Not Marketable' 
         AND (b.AMC_Status__c LIKE 'Active' OR b.AMC_Status__c IS NULL)
    ) a 

SELECT 
c.ID as SubscriberKey,
i.Cat_Campaign_Most_Recent__c,
i.Email__c as EmailAddress,
i.ID as Interaction_ID,
i.CreatedDate,
i.First_Name__c,
i.Last_Name__c,
i.Business_Phone__c,
i.Company_Name__c,
i.Mailing_Country__c,
i.Mailing_Zip_Postal_Code__c,
i.Purchase_Timeframe__c,
i.Level_of_Interest__c,
i.System_Opt_in_for_eMail__c,
i.Contact_Source_Details_Most_Recent__c,
i.System_Language__c,
i.Industry__c,
i.Industry_Level_2_Master__c,
i.Job_Role__c,
i.Serial_Number__c,
i.Ci_Fleet_Size__c,
i.Business_Unit__c,
c.AMC_Status__c,
c.AMC_Last_Activity_Record_ID__c

FROM ent.interaction__c_salesforce i
JOIN ent.Contact_Salesforce_1 c ON c.Email = i.Email__c
WHERE i.Email__c IS NOT NULL
AND (i.System_Language__c LIKE 'en_%' OR i.System_Language__c IS NULL)
AND (i.Mailing_Country__c = 'US' OR i.Mailing_Country__c = 'CA')
AND (i.Mailing_State_Province__c NOT LIKE 'QC' OR i.Mailing_State_Province__c IS NULL)
AND i.Business_Unit__c IN  (
    'CISD',
    'GASD',
    'Product Support',
    'PS'
    )
AND i.Cat_Campaign_Most_Recent__c NOT IN (
'PCC eNews',
'OHTE Offers',
'Mid America Trucking Show',
'Product Support On-Highway Legacy Engines Initiate Dealer',
'Million Miler',
'Iron Planet Auction - On Highway Legacy Machine',
'Product_Support_ECommerce_Contact',
'Iron Planet Auction - On Highway Legacy Engine',
'EP Spec Sizer Nurture',
'Parts.cat.com Account Registration',
'EP General Nurture',
'Drivecat.com - Mini Survey',
'OHTE Independent Shop Sweepstakes',
'Product Support Million Miler',
'OHTE Trucking Is Life eNews'
)

AND i.Id IN (
    SELECT max(i2.Id)
    FROM ent.interaction__c_salesforce i2
    GROUP BY i2.Email__c
)

int gcd(int a,int b){
  if(a==0 || b==0) return (a+b);
  else if(a>=b) return gcd(a-b,b);
  else return gcd(a,b-a);
}