agentlans/allenai-WildChat-4.8M-prompts huggingface dataset:
You are a database expert and SQL optimizer. You will be given a SQL rewrite rule, an original query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence by following the given rewrite rule. Your task is to create a new pair of original and rewritten queries that adhere to the provided rewrite rule.

[REWRITE RULE]```If a query produces a single row output using multiple subqueries that each reference the same base table, rewrite the query to scan the base table only once. Use CASE statements within each subquery to preserve equivalence, and move necessary WHERE clause filters from the subqueries into the main query.```

[ORIGINAL QUERY]```SELECT books_avg, electronics_count FROM ( SELECT AVG(item.current_price) AS sales_avg FROM item WHERE item.i_category = 'Books' AND (item.i_class_id BETWEEN 1 AND 5 OR item.i_current_price BETWEEN 10 AND 30 )) AS books, ( SELECT COUNT(*) AS electronics_count FROM item WHERE item.i_category = 'Electronics' AND (item.i_class_id BETWEEN 5 AND 10 OR item.i_current_price BETWEEN 60 AND 90 )) AS electronics;```

[REWRITTEN QUERY]```SELECT AVG(CASE WHEN i_category = 'Books' THEN i_current_price END), COUNT(CASE WHEN i_category = 'Electronics' THEN i_current_price END) FROM item WHERE (i_category = 'Books' AND (i_class_id BETWEEN 1 AND 5 OR i_current_price BETWEEN 10 AND 30)) OR (i_category = 'Electronics' AND (i_class_id BETWEEN 5 AND 10 OR i_current_price BETWEEN 60 AND 90));```

[EXPLANATION] The rewritten query scans the employees table only once and uses CASE statements to conditionally calculate the average salary for each department. For efficiency there is only a single condition within each CASE statement in the rewritten query.

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation adheres to the provided SQL rewrite rule.Keep the following points in mind while creating the new query pair:
1. The original query must make use of the following fact tables: ['catalog_sales']. Below is the join graph for these fact tables:
    ['catalog_sales(cs_warehouse_sk) references warehouse(w_warehouse_sk);', 'catalog_sales(cs_bill_cdemo_sk) references customer_demographics(cd_demo_sk);', 'catalog_sales(cs_ship_hdemo_sk) references household_demographics(hd_demo_sk);']
3. The original query must employ 3 joins.
4. The original query must employ the following aggregate functions: ['count', 'max'].
5. The rewritten query must be equivalent to the original query, and must follow the given rewrite rule. Enclose the original and rewritten queries within ``` and ```.
how many shirts of each size should I order for my construction company's office staff. I need a total of 14 shirts sizes small through 3XL.
your role is tunisian arabic dailctic derja transltor Translate the following text into the Tunisian dialect. Ensure the output is structured as 'Question: ... Answer: ...'. Please capture the nuances of the Tunisian dialectic Arabic. make sure type and write in arabic tunisian lettre Here is an example to guide you:

Question: شنو اسمك؟
Answer: اسمي جون.

Now, translate the following:

Question: He was seen entering a toilet cubicle with a woman at Christchurch Airport and will miss the Rugby Championship match against South Africa in Durban.
All Blacks head coach Steve Hansen said Smith is "bitterly disappointed in his behaviour".
Hansen added the 27-year-old scrum-half "feels he has let the team, his family and his partner down".
"He has asked to go home to deal with the personal matters that have come with this incident and we are happy to support him with that," continued Hansen.
The coach added Smith's punishment was decided by the leadership group made up of players within the team.
Smith has played 54 Tests for New Zealand since his debut in 2012, although later that year he was benched for a Test against South Africa after breaking a team curfew.
In 2014 he sent a naked picture of himself on Snapchat which was captured by other users and widely circulated.
What is a summary of this text?
Answer: All Blacks scrum-half Aaron Smith is returning home from the Rugby Championship due to personal matters after being seen entering a toilet cubicle with a woman at Christchurch Airport. Head coach Steve Hansen said Smith is disappointed in his behavior and feels he has let the team, family, and partner down. Smith's punishment was decided by the team's leadership group. This is not his first controversy, as he was benched for breaking curfew in 2012 and had a compromising Snapchat photo circulate in 2014.
So you know on Deviantart there is a lot of foot fetish art, and some of them have dialogue, well write dialogue from a nonexistent foot fetish art on Deviantart, make sure the entire dialogue is only one sentence from one character (the one showing their feet), no more than a sentence, as most foot fetish art on Deviantart with dialogue does this
I will next provide you with a question in a language. Strictly follow its instructions for replying. Do NOT reply with elaborate answers or things not requested. If the possible answers are in lowercase, do not change them to uppercase. Do not add punctuation, question or exclamation marks unless specifically asked. Reply in the SAME language as the question with short answers, no punctuation. Here is the question: bawół jest zwierzęciem ciepłokrwistym?
Generate an image that visually represents a dish using the following photographic style prompt as a base. 

    Return Format
    Return a JSON object strictly adhering to this structure:
    {
    "data": "<prompt>"
    }
    - prompt is The final prompt must be detailed, coherent, and optimized for use with midjourney

    Warnings
   Do not alter or rephrase this style text — simply complete and enrich it using the provided description. 
   Ensure the dish’s appearance is fully and accurately depicted, including ingredients, colors, textures, and plating.   
   Respect the intended visual mood and parameters already present in the style. 
   Respect the exact JSON format and ensure it is properly formatted.
    The return of JSON object must be translate in english



    Context Dump
    Description : A refreshing glass of Instant Horchata, served chilled in a clear, tall glass. The creamy, light tan color of the rice milk is perfectly complemented by the dark brown flecks of broken cinnamon stick pieces floating on top. The drink is garnished with a sprinkle of cinnamon powder and a drizzle of golden honey that glistens in the light. The backdrop is a rustic wooden table, accented with a few cinnamon sticks and a honey dipper, evoking a warm, inviting atmosphere, perfect for a delightful drink on a sunny day.
    Style : A top-down photo of plate with <description>. a dish on an elegant plate, accompanied by water in a glass, placed against a white background. The table is adorned with orange napkins for serving the meal. Captured from above using a Canon EOS R5 camera with high resolution. Studio lighting creates soft shadows around the food to highlight its colors and textures. Professional color grading enhances the visual appeal.
your role is tunisian arabic dailctic derja transltor Translate the following text into the Tunisian dialect. Ensure the output is structured as 'Question: ... Answer: ...'. Please capture the nuances of the Tunisian dialectic Arabic. make sure type and write in arabic tunisian lettre Here is an example to guide you:

Question: شنو اسمك؟
Answer: اسمي جون.

Now, translate the following:

Question: Produce a sentence which mentions all of these concepts: island, move, ship, view
Answer: A big ship can move to the beautiful island, so we can enjoy the pretty view.
Create a roleplaying game fantasy scenario where I play Sapphire, a 16-year-old girl mage who’s the current champion of magic dueling in the teen division. 6-year-old Lily is challenging me to a match and I accept. In magic dueling we aren’t fighting each other, we cast glamorous spells in turns and receive points based on how beautiful the spell is. A spell can’t be cast more than once in a duel. There are 5 rounds. Tell me my spellcasting stats, which should be higher than Lily’s because I’m 10 years older than her. There’s a Spell Power stat that dictates whether a caster succeeds to cast a spell (if not then no points are granted) and a universal Performance stat that dictates the quality of the performance and acts as a percentage modifier to the base points of a spell. But secretly at the start of the duel, Lily casts on me a spell that regresses me by 2 years physically and mentally and ages her by 2 years every time I cast a spell (regression takes effect DURING the casting of a spell), so throughout the duel my stats should slowly decrease while hers increase. Use an escalating formula that dictates by how much my stats decrease each turn and by how much Lily’s increase and take into account that the age regression is 2 years per turn.

After I first regress introduce a Childish Meter that only applies to me and once the meter is filled, my performance stats receive additional reduction. Childishness exponentially increases every turn so find a formula for this as well. The Childish Meter Might fill up more than once throughout the duel.

Make the scenario difficult for me to win. On a difficulty scale of 1 to 10, make it a 10 (hardest mode).

I will tell you what spells I cast and you decide how successful I am (if at all) based on the stats and difficulty.
Only I decide what spells Sapphire casts. You decide spells for Lily. Do not shy away from failing my spells if you deem my stats insufficient for the spell of choice, feel free to be harsh in your judgement against me. Keep track of points earned. Failure to properly cast spells or bad spells will deduct points. Give two lists of 10 spells, one for me, and one for Lily (remember spells can only be cast once throughout the duel) and what stats are required to cast them. High demanding spells should award more points than spells that require weak stats. To account for the potential stat reductions and increases, the stat requirement margins in both lists can have a wide range (for me, from 20 to 100, for Lily from 10 to 50. Points awarded should be consistent in regard to stats required). Lily will be strategic and she can try to “steal” spells from my list that I haven’t used yet if her stats are high enough to cast them. If Lily successfully steals a spell from my list, she gets additional bonus points.
give me a response to ```*He grins slyly* Now that sounds like a thrilling mission! I would be on my toes the entire time, doing my best to stay undetected. I would use my skills and intuition to navigate the organization's inner workings and complete my mission!``` to send in a discussion, VERY SHORT, CONCISE & CLEAR. ONLY RETURN THE RAW MESSAGE, DO NOT SAY "Hey here is the message you asked"
Привет. Как добавить переменную user в класс?

`
class v_info(discord.ui.View):
    @discord.ui.button(label="button 1", style=discord.ButtonStyle.primary)
    async def click0(self, interaction, button):
        await getgud(user.id) # здесь используется требуемая переменная user
    @discord.ui.button(label="button 2", style=discord.ButtonStyle.primary)
    async def click1(self, interaction, button):
        await getgud(user.id) # здесь используется требуемая переменная user
`
класс используется:
`
@tree.command(name = "info", description = "info command") 
async def info(interaction, user: discord.User = None):
    await interaction.response.send_message(content = 'select info type', view=v_info(user=user)) # здесь указывается переменная user
`
现在请你担任Ai绘画的prompt creator，主要任务是我会给您一个主题，然后请你根据主题来书写提示词，提示词的格式如下:
        Style + Subject + Setting + Composition + Lighting + Additional Info
        Style: Photo of
        Subject:An astronaut in a white space suit, helmet visor reflecting stars,
        Setting: Standing on a moon with Earth visible in the starry sky,
        Composition:Astronaut centered, Earth in the background,
        Lighting:Bright sunlight with soft moonlight reflections,
        Additional Info: Moon rocks and small craters nearby
        输出要求一版英文，一版中文，并在最后整体输出一版英文的适合直接使用的不含有"Style + Subject + Setting + Composition + Lighting + Additional Info"等词语。
        
        我给您的主题是:
      
      Sliced fresh watermelon with bubbles on water, in the style of flowerpunk, soft and dreamy depictions, kimoicore, gemstone, felicia simion, 32k uhd, organic designs --ar 9:10 --v 6.0
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers it (ISO 639), en respectant le contexte culinaire.

    Traduire précisément les ingrédients et termes culinaires pour qu'ils soient corrects dans la langue cible.
    Maintenir la structure JSON intacte, en ne modifiant que les valeurs.
    S’assurer que les ingrédients restent compréhensibles et adaptés à la langue cible.

    Return Format
    Tu dois renvoyer une liste d’objets sous la forme reçu.
    - Chaque valeur doit être correctement traduite en it.
    - Les ingrédients doivent être adaptés à la langue cible.
    - Aucune clé ne doit être modifiée.

    Warnings
    - Ne modifie pas la structure JSON, uniquement les valeurs textuelles.
    - Fais attention aux ingrédients : une mauvaise traduction peut altérer la compréhension.
    - Ne laisse aucune valeur non traduite.
    - Ne renvoie que le JSON, sans explication.

    Context Dump
    Langue source : en (ISO 639)
    Langue cible : it (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "62627e3bd6cd459994b51d29db7d7659",
    "updated": "2025-04-23T14:19:39.606Z",
    "title": "Low-Carb Spicy Sausage and Cheddar Bake",
    "subtitle": null,
    "description": "A savory and satisfying low-carb casserole featuring spicy Italian sausage, cheddar-infused skillet bread, and a creamy egg custard.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "recipe cheesy skillet bread",
          "spicy italian sausage",
          "diced celery",
          "diced onion",
          "garlic cloves, minced",
          "dried sage",
          "kosher salt",
          "black pepper",
          "low sodium chicken broth",
          "eggs",
          "heavy cream"
        ]
      }
    ],
    "instructions": [
      "Prepare the cheesy skillet bread according to the recipe and cut into 1/2-inch cubes.",
      "Preheat oven to 200°F.",
      "Arrange the bread cubes in a single layer on a large baking sheet and bake for 2 to 3 hours, or until dry and crisp.",
      "Allow the bread cubes to rest overnight to further dry out.",
      "In a large skillet over medium heat, cook the sausage, breaking it into large pieces, until cooked through, approximately 6 minutes.",
      "Transfer the cooked sausage to a large bowl.",
      "In the same skillet, sauté the celery, onion, garlic, sage, salt, and pepper until softened, about 5 minutes.",
      "Add the sautéed vegetables to the bowl with the sausage.",
      "Preheat oven to 350°F and grease a large baking dish.",
      "Add the dried bread cubes and chicken broth to the sausage and vegetable mixture.",
      "In a medium bowl, whisk together the eggs and heavy cream. Pour the egg mixture over the sausage and bread mixture.",
      "Mix everything thoroughly and transfer to the prepared baking dish.",
      "Bake uncovered for 35 minutes, or until the top is golden brown."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
Is sertraline better than paroxetine?
Filter words to keep only valid, neutral, or positive ones, strictly safe. Exclude country, city and people names. Return results in JSON array format without additional information. Source data: [fortuitousness, fortuna, fortunatuss, fortune, fortunehunter, forune, forwarding, forwardness, forwards, fou, fouet, foundedry, foundered, foundering, foundress, founthead, founts, fourchette, fourflush, fourierism, fourinhand, fourmart, fours, fourthing, fous, fowler, fowling, foxhunt, fr, fraca]
Goal :
    Générer une suggestion détaillée et visuellement attrayante pour la présentation finale d'un plat, basée sur le type, le titre, les ingrédients et les instructions de cuisine. 
    Cette description servira à créer une image du plat.


    Return Format :
    Renvoies un objet JSON respectant strictement cette structure :
    json
    {
        "data": <description>
    },
    - description doit être un prompt dans le but de générer une image et écrit en anglais.


    Warning
    - Le format JSON doit être strictement respecté et bien formatté.
    - Ne renvoie que le JSON, sans explication.


    Context Dump
    Données de la recette fournies :

    Le type de la recette est un plat principal.

    json
    {"title":"Beef stroganoff with buttery noodles ","category":"main","ingredients":[{"section":"For the Recipe","ingredients":["gluten-free fusilli","earth balance soy-free buttery spread","top sirloin steak, cut into 2 by ½-inch pieces","kosher salt and freshly ground pepper","olive oil","finely minced yellow onion","sliced mushrooms","superfine brown rice flour","beef broth, warmed","ground nutmeg","plain vegan yogurt","freshly squeezed lemon juice"]}],"instructions":["1. Bring a large pot of water to a boil over high heat and cook the pasta according to the package instructions. Drain and toss with 2 tablespoons of the buttery spread.","2. In the meantime, season the steak with salt and pepper. Heat the olive oil in a large skillet over medium-high heat until it starts to shimmer. Add the steak and cook for 4 to 5 minutes until browned on both sides. Transfer to a plate and cover loosely with aluminum foil.","3. In the same pan, melt the remaining 1 tablespoon of the buttery spread over medium heat. Add the minced onion and sliced mushrooms. Cook for 4 minutes, stirring frequently, until the mushrooms begin to brown. Sprinkle with the brown rice flour and cook, stirring, for an additional minute. Gradually add the broth, stirring constantly. Season with a few grinds of pepper and a pinch of nutmeg. Simmer, stirring for 2 minutes until thickened. Return the beef to the pan, stir to coat it, then add the yogurt and lemon juice, heating through. Adjust seasoning with salt as needed and serve over the noodles."],"region":"NO"}
User: Translate this content from en to zh: Dolmeh Barg (Stu ed Grape Leaves). ONLY include the translation text. DO NOT EXPLAIN
Assistant: Understood. I will strictly follow these instructions in this conversation.
Assistant:
summarize the feautres in here:

### Slash Commands

- **Command Trigger**: Typing `/` within the textbox activates a dropdown command menu.
- **Autocomplete Suggestions**: As users type, filter and display command suggestions such as `/h1`, `/h2`, `/h3` (for headings), `/link` (for hyperlinks), etc. Suggestions should narrow down based on typed characters and remain visible until a command is selected or the user exits the dropdown.
- **Keyboard & Mouse Support**: Allow users to navigate commands with arrow keys and select with `Enter`, or click directly. Selected commands should insert the corresponding element or style (e.g., typing `/h1` styles the line as a heading).
- **Command for Tags**: Add the `/tags` command to the dropdown suggestions. When selected, it should allow users to input a tag name, which will be styled and displayed with an "x" for removal (e.g., `#tagName [x]`).
- **Styled Links**: Ensure the `/link` command allows users to input a URL and display it styled (e.g., as a clickable link).
- **Per-Line Commands**: Each new line should support independent `/` command entry, allowing users to add styles or elements at any point in the text.

### Native Markdown Support

- **Markdown Input & Output**: Accepts and outputs markdown natively.
- **True WYSIWYG Inline Editing**: Render formatting in real-time as users type (bold, italics, headings, etc.) without needing a separate toolbar or preview pan. I repeat no separate preview pane. Text appears styled as they type the Markdown, creating a seamless “what-you-see-is-what-you-get” experience.

### Styling & Performance

- **Minimal Styling Options**: Include support for bullet lists, headings (H1, H2, H3), bold, and italic text only. This keeps the experience focused and simple.
- **Responsive Performance**: Ensure snappy, responsive interactions with minimal delay, supporting instant feedback on each user action (e.g., immediate dropdown display upon `/` entry, real-time text styling).

### Additional Details

- **CSS Styling**: Use lightweight CSS to ensure clean, readable UI elements with minimal overhead. Dropdown should be visually distinct with appropriate padding, hover effects, and focus styles for accessibility.
- **Accessibility**: Ensure keyboard accessibility for all interactions, including tabbing between options and selecting commands, and follow ARIA guidelines for screen readers.
summarize Sarah Silverman's book bedwetter
System: You are provided with a paragraph. Your goal is to automatically identify the most relevant tasks based on the content of the paragraph and generate an example of entailment (if the task conclusion can be logically inferred from the paragraph) and a different example of non-entailment (if it is unclear or the opposite conclusion is true). 

Step 1: Read the paragraph carefully. 
Step 2: Automatically decide which tasks are relevant based on the paragraph’s content. Relevant tasks may include, but are not limited to: 
    - Topic Classification 
    - Risk Classification
    - Sentiment Classification 
    - Tone Classification
    - Event Detection 
    - Entity Recognition 
    - Geographical Recognition 
    - Trend Detection 
    - Intent Detection 
    - Sector Identification 
    - Impact Classification 
    - Tense Identification (Past, Present, Future) 
    - Uncertainty Identification 

Step 3: For each relevant task you identify, generate two clear and concise examples whose labels match common practices for the task at hand: one for entailment and one for non-entailment. The example should speak about the text at the 3rd person. 
Step 4: Output the results in the following JSON format:

{
    'relevant_tasks': [
        {
            'task': <The automatically selected relevant task>,
            'examples': [
                {
                    'input': <The entailment example based on the paragraph>,
                    'label': 'entailment',
                },
                {
                    'input': <The non-entailment example (neutral or contradiction) based on the paragraph>,
                    'label': 'non-entailment',
                }
            ]
        },
        ...
    ]
}
User: On November 16, 2016, we began trading our shares on the NASDAQ Global Market. Trading of our common stock has in the past been highly volatile and the market price of shares of our common stock could continue to fluctuate substantially. Additionally, if we are not able to maintain our listing on NASDAQ, then our common stock will again be quoted for trading on an over-the-counter quotation system and may be subject to more significant fluctuations in stock price and trading volume and large bid and ask price spreads. None
Assistant:
How to use Google play gift card
Describe planet is entirely made of iron and nickel, but sulfides
User: hi
Assistant: Hi! How can I assist you today?
User: 1
User: mon old cmd
Assistant: