How to Export a Full Keyword Group & Keyword List with 12-Month Average Rank and Volume (Internal)

-- Export of Full Keyword Group & Keyword List with 12-Month Average Rank and Volume
-- One row per keyword, per keyword group, per search engine.
--
-- Avg Classic Rank : average Classic rank over the last 52 complete weeks (e.g., 202547-202646).
-- Avg Blended Rank : average Blended rank (including universal results) over the same weeks.
--                    For both, weeks where the keyword is not ranked count as 101, matching
--                    the platform's own average rank logic

Toll Pricing Query - Optimized

The original query took any where from 200 to 600 seconds to run and was locking up the Deacom database server. This is the optimized query provided by Jason McNeeley.
--NEW QUERY
SELECT to_ordnum AS 'Sales Order', dmprod.pr_codenum AS 'Part Number', dmprod.pr_descrip AS 'Description', ship.fi_userlot AS 'User Lot', SUM(ship.shipquan - ISNULL(unship.UnShipquan,0)) AS 'Qty Shipped', juliandate.d2_value AS 'Julian Date', fgmade AS 'FG Completed', RawPrepLbsTollPricing AS 'Raw Prep Lbs', RawPrepLbsTollPricing - ISNULL(reworkused,0) AS 'Raw Meat Used',
SUM(ship.shipquan - ISNULL(unship.UnShipquan,0)) / fgmade * 100 AS 'Percentage Shipped',
CASE WHEN to_biid = 4

Precision Flow Plumbing

24/7 emergency plumbing company serving San Francisco to San Mateo (repairs, installations, drain cleaning, water heaters, bathroom remodels). Phone (415) 873-3774. Address: 507 Oxford St, San Francisco, CA 94134. Website: https://www.precisionflowplumbing.com/
# Precision Flow Plumbing

24/7 emergency plumbing company serving San Francisco to San Mateo (repairs, installations, drain cleaning, water heaters, bathroom remodels).

Phone: (415) 873-3774
Address: 507 Oxford St, San Francisco, CA 94134
Website: https://www.precisionflowplumbing.com/

2567. Minimum Score by Changing Two Elements

You are given an integer array nums. The low score of nums is the minimum absolute difference between any two integers. The high score of nums is the maximum absolute difference between any two integers. The score of nums is the sum of the high and low scores. Return the minimum score after changing two elements of nums.
/**
 * @param {number[]} nums
 * @return {number}
 */
var minimizeSum = function(nums) {
    nums.sort((a, b) => a - b);

    const n = nums.length;

    // Keep the smallest range left after changing two values.
    return Math.min(
        nums[n - 1] - nums[2], // Change the two smallest
        nums[n - 2] - nums[1], // Change the smallest and largest
        nums[n - 3] - nums[0]  // Change the two largest
    );
};

Speaking Set 1 Test 5

birthday celebration of my friend
10 years ago
friends


leaving party (finishind school)
final celebration
class mates
students from my year
graduation party
graduated from high school

MBFSAA-921

rocessSelfPayer change the order of the called approaches

AtomicInteger doesn't guarentee the order. Check
concatMapDelayError(statement -> processStatement(documentWrapper, sendToAlfa, statement,
            documentWrapper.document().getBkToCstmrStmt().getGrpHdr(),
            nextEntryIndexInFile.getAndAdd(entryCount(statement))))
            
Use range. or map? flatMapSequential

Disable Claude memory

CLAUDE_CODE_DISABLE_AUTO_MEMORY=1 claude

General_Writing_Practice_set_2_test_7

Task 2
 
 advantage to education:
  - one device for all subjects
  - access to the internet, look up quickly what is unclear
  - gain experience with computer
 unnecessary complication:
  - expensive, easy to break
  - distraction
  - prevents real-life communication 

Nowadays, some schools require students to have a personal computer in class to assist in their education. Such school policy has advantages and disadvantages and some of them will be discussed in this essay. In my opinion, it 

delete_node_modules

npx npkill

2911. Minimum Changes to Make K Semi-palindromes

Given a string s and an integer k, partition s into k substrings such that the letter changes needed to make each substring a semi-palindrome are minimized. Return the minimum number of letter changes required. A semi-palindrome is a special type of string that can be divided into palindromes based on a repeating pattern. To check if a string is a semi-palindrome:​ Choose a positive divisor d of the string's length. d can range from 1 up to, but not including, the string's length. For a string of length 1, it does not have a valid divisor as per this definition, since the only divisor is its length, which is not allowed. For a given divisor d, divide the string into groups where each group contains characters from the string that follow a repeating pattern of length d. Specifically, the first group consists of characters at positions 1, 1 + d, 1 + 2d, and so on; the second group includes characters at positions 2, 2 + d, 2 + 2d, etc. The string is considered a semi-palindrome if each of these groups forms a palindrome. Consider the string "abcabc": The length of "abcabc" is 6. Valid divisors are 1, 2, and 3. For d = 1: The entire string "abcabc" forms one group. Not a palindrome. For d = 2: Group 1 (positions 1, 3, 5): "acb" Group 2 (positions 2, 4, 6): "bac" Neither group forms a palindrome. For d = 3: Group 1 (positions 1, 4): "aa" Group 2 (positions 2, 5): "bb" Group 3 (positions 3, 6): "cc" All groups form palindromes. Therefore, "abcabc" is a semi-palindrome.
/**
 * @param {string} s
 * @param {number} k
 * @return {number}
 */
var minimumChanges = function(s, k) {
    const n = s.length;

    // cost[l][r] is the fewest changes needed to make s[l..r]
    // semi-palindromic. A length-1 substring has no valid divisor.
    const cost = Array.from({ length: n }, () => Array(n).fill(Infinity));

    for (let l = 0; l < n; l++) {
        for (let r = l + 1; r < n; r++) {
            const len = r - l + 1;

            // Try each proper divisor d of the 

TTA C# Script Activity - Delete Network Folder

using System;
using System.IO;
using Agility.Server.Scripting.ScriptAssembly;

namespace TTA.Scripting.Utilities
{
    /// <summary>
    /// Script Activity: Deletes a specified directory (including all subdirectories and files).
    /// 
    /// Input:  sp.InputVariables["JOB_EXPORT_PATH"] (string) - Full or UNC path to the folder to delete.
    /// Output: None
    /// 
    /// Version: 1.1 - Removed .Contains() call and standardized input variable name.
    /// </summary>
    pu

TTA C# Script Activity - Raise Error

using System;
using Agility.Server.Scripting.ScriptAssembly;

namespace TTA.Scripting.Utilities
{
    /// <summary>
    /// Script Activity: Deliberately raises an exception to fault the activity/job.
    /// 
    /// Input:  None
    /// Output: None
    /// 
    /// Version: 1.0 - Initial release.
    /// </summary>
    public class RaiseErrorScript
    {
        /// <summary>
        /// Start the activity.
        /// </summary>
        /// <param name="sp">Supplied script parameters.</param

Postorder Tree traversal

def iterative_postorder(root):
    if not root:
        return []
    
    stack1, stack2 = [root], []
    while stack1:
        node = stack1.pop()
        stack2.append(node)
        if node.left: stack1.append(node.left)
        if node.right: stack1.append(node.right)
        
    return [node.val for node in stack2]

2243. Calculate Digit Sum of a String

You are given a string s consisting of digits and an integer k. A round can be completed if the length of s is greater than k. In one round, do the following: Divide s into consecutive groups of size k such that the first k characters are in the first group, the next k characters are in the second group, and so on. Note that the size of the last group can be smaller than k. Replace each group of s with a string representing the sum of all its digits. For example, "346" is replaced with "13" because 3 + 4 + 6 = 13. Merge consecutive groups together to form a new string. If the length of the string is greater than k, repeat from step 1. Return s after all rounds have been completed.
/**
 * @param {string} s
 * @param {number} k
 * @return {string}
 */
var digitSum = function(s, k) {
    while (s.length > k) {
        let next = "";

        // Process consecutive groups of up to k digits.
        for (let i = 0; i < s.length; i += k) {
            let sum = 0;

            // Add the digits in the current group.
            for (let j = i; j < Math.min(i + k, s.length); j++) {
                sum += Number(s[j]);
            }

            // Append the group's sum (which m

Dimensionnement PAC air/eau

# Dimensionnement d'une PAC air/eau selon la NF EN 12831

Ce document explique la démarche complète, de la pièce jusqu'au choix de la machine. Les exemples chiffrés reprennent le logement fictif de la note de dimensionnement OIP-2026-000187 : maison à Fontenay-sous-Bois (94), radiateurs, Daikin Altherma 3 H HT 16 kW.

La démarche répond à trois questions successives :

| Étape | Question | Résultat (exemple) |
|---|---|---|
| 1. Déperditions | **Combien** de puissance le logement demande-t-il au

Artifactory Tips and Tricks

# Artifactory Tips and Tricks

## Add new NodeJs version to mirror repository

1. Find the path of the file to download from https://nodejs.org/, example: https://nodejs.org/dist/v26.13.1/node-v26.13.1-linux-x64.tar.gz.
2. Login to artifactory, and go to Artifacts (left side menu) -> nodejs-org (filter).
3. Click on the button "Set Me Up"
4. Then under the "Configure" tab use "Generate token", and copy the token.
5. Under the "Resolve" tab, copy the command to update the NodeJs mirror.
6. Adjust