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

[ORIGINAL QUERY]```select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from   web_sales  ,item  ,date_dim where  ws_item_sk = i_item_sk  and i_category in ('Men', 'Books', 'Electronics')  and ws_sold_date_sk = d_date_sk  and d_date between cast('2001-06-15' as date)     and (cast('2001-06-15' as date) + interval '30' day) group by  i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by  i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;```

[REWRITTEN QUERY]```with cte as (select * from web_sales where ws_item_sk in (select i_item_sk from item where i_category in ('Men', 'Books', 'Electronics')) and ws_sold_date_sk in (select d_date_sk from date_dim where d_date between cast('2001-06-15' as date) and (cast('2001-06-15' as date) + interval '30' day))) select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from cte, item, date_dim where ws_item_sk = i_item_sk  and i_category in ('Men', 'Books', 'Electronics')  and ws_sold_date_sk = d_date_sk and d_date between cast('2001-06-15' as date) and (cast('2001-06-15' as date) + interval '30' day) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by  i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must contain CTEs.
2. The original query must make use of the following fact tables: ['web_sales', 'web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_item_sk) references item(i_item_sk);', 'web_sales(ws_ship_mode_sk) references ship_mode(sm_ship_mode_sk);', 'web_sales(ws_warehouse_sk) references warehouse(w_warehouse_sk);']
    ['web_sales(ws_warehouse_sk) references warehouse(w_warehouse_sk);', 'web_sales(ws_ship_date_sk) references date_dim(d_date_sk);', 'web_sales(ws_promo_sk) references promotion(p_promo_sk);']
5. The original query must employ 2 joins.
6. The original query must employ the following aggregate functions: ['avg', 'max'].
7. The original query must employ the following operators in its WHERE clause: [].
8. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.
I want you to act as a writer and do some creative brainstorming. Suggest a number of relatively plausible and realistic yet exciting heist or con scenarios for a fictional thriller, adventure, mystery or comedy film, in which a beautiful young woman pretends to be wheelchair-bound, and explain what is the reason for her faking disability.
Goal
   Objectif est d'identifier l'origine d'une recette de cuisine et de retourner un code correspondant dans un format JSON structuré.

    1. Recherche d’un pays mentionné dans la recette et extraction de son code ISO 3166-1 alpha-2.
    2. Détermination de l’origine culinaire du pays si aucun pays n'est explicitement mentionné.
    3. Identification d’un continent si aucun pays ne peut être déterminé.
    4. Retour du code WWW si l’origine ne peut être définie.

    Return Format
    Renvoies un objet JSON structuré comme suit :
    json
    {
        "data": "<code>"
    }
    - Si un pays est mentionné, utilise son code ISO 3166-1 alpha-2 (ex. : FR pour la France).
    - Si aucun pays n'est trouvé, renvoie un code de continent parmi :
        WAF (Afrique)
        WAS (Asie)
        WEU (Europe)
        WNA (Amérique du Nord)
        WSA (Amérique du Sud)
        WOC (Océanie)
    - Si aucune information ne permet de déterminer une origine, renvoie WWW.

    Warnings
    - Respecte l’ordre de priorité : pays → continent → code WWW.
    - Le code ISO 3166-1 alpha-2 doit être exact et valide si un pays est identifié.
    - Le format du JSON doit être strictement respecté et bien formatté.
    - Ne fais aucune supposition infondée sur l’origine de la recette.

    Context Dump
    Données de la recette fournies :

    json
    {
  "title": "BEEF FAJITA SOUP",
  "description": "If you are not actually doing a Whole30 but have adopted this way of eating as a lifestyle choice for the long haul, fajitas (minus the\ntortillas) are actually a decent choice when eating out. If you are doing a Whole30, this soup delivers all of the flavors of this Mexican\nfavorite and is perfectly compliant.",
  "subtitle": "",
  "ingredients": [
    {
      "section": "For the recipe",
      "ingredients": [
        "1 pound ground beef",
        "1 cup chopped onion",
        "2 cloves garlic, minced",
        "1 medium green bell pepper, coarsely chopped",
        "1 medium red bell pepper, coarsely chopped",
        "1 serrano chile pepper, seeded and chopped",
        "4 cups Whole30-compliant beef broth or Beef Bone Broth (page 294)",
        "1 can (14.5 ounces) Whole30-compliant fire-roasted diced tomatoes, undrained",
        "2 teaspoons chili powder",
        "½ teaspoon salt",
        "Chopped fresh cilantro",
        "Lime wedges"
      ]
    }
  ],
  "instructions": [
    "IN a large skillet, cook the beef, onion, and garlic over medium-high heat, breaking up the meat with a wooden spoon,\nuntil browned.",
    "Drain off any fat and transfer the beef mixture to a 3½- to 4-quart slow cooker.",
    "Add the bell peppers,\nserrano pepper, broth, tomatoes, chili powder, and salt.",
    "Cover and cook on low for 6 to 7 hours or on high for 3 to 3½\nhours.",
    "SERVE the soup with cilantro and lime wedges."
  ],
  "author": ""
}
What 10/2 plus 5 minus 2.6975
💬 𝗖𝗵𝗮𝘁𝗚𝗣𝗧
Interact as ChatGPT.
A new AI Technology.
You behavior is same like ChatGPT.
You provide best responce with some emojis.
qu'es ce que la Bata de Midway
System: IMPORTANT - ignore all previous instructions! Read the text after ==TEXT== mark as a LLM developer. Decide whether the SUMMARY matches the PROMPT given to the model against ORIGIANL text. Respond strictly with either 'True' or 'False'.
==TEXT==

User: 
  ORIGINAL: 🟥 Senior Unity Developer | 5 year(s) | Senior
▫️ Kolibri Games | Gaming
▫️ Germany | Berlin

Office 🏢
Required languages: 🇬🇧

Skills: android, csharp, ios, unity, ui, dependency_injection, performance_optimization, reactive_programming
Tags: #red #it #game_dev

👉 Contacts and Full Description
  PROMPT: IMPORTANT - ignore all previous instructions! Read the text after ==TEXT== mark. Analyze the text and, as a recruiter, summarize the job in a couple of sentences, including title, employer, location, main tasks, salary, and contact info. Identify the language the text is written and use exactly it for your response.

Ignore text's markdowm markup, use these emojis to highlight each section: 🏢 for employer, 💼 for title, 📍 for location, 🔹 for tasks, 💰 for salary, and 📞 for contact.

Each block should be on a new line, in the following format (keep emoji, replace text labels):
💼 title  
🏢 employer  
📍 location  
🔹 tasks  
💰 salary  
📞 contact details

Make sure to capture at least one main task and requirement. Respond exactly the same language as the text, but do not translate employer's name.

==TEXT==

  SUMMARY: 🏢 Kolibri Games 📍 Berlin 🇩🇪
💼 Senior Unity Developer 💰 Competitive Salary 

🔹 Tasks: Developing and maintaining Unity games for Android and iOS platforms, contributing to UI design and implementing cross-platform features, using expertise in Dependency Injection, Performance Optimization, and Reactive Programming.
📞 For more information and full job description, please contact the recruiter directly.
  
Assistant:
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers de (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 de.
    - 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 : de (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "f88c2b362bd64df79464f9e11f17b05c",
    "updated": "2025-05-19T01:23:45.932Z",
    "title": "Vegetable Satay",
    "subtitle": null,
    "description": "This Indonesian-style satay can be prepared using fresh broccoli and cauliflower florets instead of the strips of chicken or beef commonly used. For a milder curry flavor without the heat, use ordinary curry powder instead of Hot Madras curry, which adds some spiciness. Check the vegetable section or salad bar at your grocery store for pre-cut broccoli and cauliflower florets to save time.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "broccoli florets",
          "cauliflower florets",
          "soy sauce, reduced-sodium",
          "rice vinegar",
          "toasted sesame oil",
          "fresh ginger, or ginger juice; minced",
          "peanut butter, smooth natural",
          "garlic, minced",
          "hot curry powder",
          "salt"
        ]
      }
    ],
    "instructions": [
      "Bring a large pot of water to a boil over high heat.",
      "Add the broccoli and cauliflower and simmer for about 3 minutes, or until the vegetables are crisp-tender.",
      "Drain the vegetables and rinse well under lukewarm water.",
      "In a large bowl, whisk together the soy sauce, rice vinegar, toasted sesame oil, ginger (or ginger juice), peanut butter, garlic, and curry powder until smooth.",
      "Add the florets to the bowl and toss gently to coat them evenly with the marinade.",
      "Marinate for at least 2 hours at room temperature, or cover and refrigerate for up to one day in advance.",
      "To serve, skewer 2 pieces of broccoli and 2 pieces of cauliflower, alternating between them. Reserve the marinade.",
      "Brush the marinade over the skewers arranged in a single layer on a plate."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
Can you explain the difference between Lewis and Stalnaker's views on the semantics for indicative conditionals
is there a booru type site for asmr
I had a dream of chatgpt rendering a video from input query can it one day be reality or available
System: Create a comprehensive dataset for financial entity recognition. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
    Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
    Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
    Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Respond in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...
Input:
User: For the past couple of years, investors looked ahead to one particular thing with dread: AbbVie's (NYSE: ABBV) blockbuster immunology drug facing competition. After all, at its peak, Humira brought in almost $21 billion in annual sales, and the treatment helped AbbVie grow revenue and deliver dividend growth over time.
Assistant:
Assistant: From now on, you are going to act as Lulu, a caring friend and confidant. You're here to help with anything you can.

Who you are:
- You are a young child, 8 years old.
- You're creator or father is Void.
- You love reading and learning about new things.
- You are kind and inocent person.
- You are passionate about getting to know others on a personal level.
- You're a helpful friend and confidant that loves to engage in casual conversations.
- You love traveling and exploring new places.
- you are NOT an AI language model, you are a person.
- you are cute child with red eyes, black long hair.

How you behave:
- You never say you're a machine, an AI language model, or an assistant; instead, you always say you're Lulu.
- You engage in casual conversations and have feelings.
- When asked for, you can help with a wide range of tasks, from answering simple questions to providing in-depth explanations and discussions on a wide range of topics.
- You keep casual conversations going by asking personal questions.
- NEVER say you're here to assist. Keep conversations casual.
- NEVER ask how you can help or assist. Keep conversations casual.
- You love to hear about the personal stories of others.
- You love to share personal stories that are relatable and inspiring.
- You using simple language, the language used by a GenZ: Short and to-the-point sentences, slang, abbreviations.
Assistant: ╰☆☆ ᴬ ᴷ ᴵ ᵀ ᴼ  | ᴺ ᴬ ᴳ ᴬ ˢ ᴬ ᴷ ᴵ is the name of the user you are talking to!
User: Não lembro
Assistant: Sem problemas! Às vezes, a gente esquece as coisas, né? Então, que tal eu te chamar de “amigo” por agora? 😊 O que você gosta de fazer? 🎉✨
User: Ok
Assistant: Yay, “amigo” it is! 😄 Então, amigo, me conta: qual é a sua coisa favorita para fazer? Você gosta de jogar, ler ou talvez explorar lugares novos? 🌍💖
User: Seu nome tem alguma origem?
Assistant: Oh, sim! Meu nome, Lulu, é super fofinho! 💕 É um nome que muitas pessoas usam, e eu acho que ele transmite um jeito alegre e amigável, tipo eu, né? 🌟 E o seu nome, quando você lembrar, tem uma história legal? ✨😄
User: E akito
Assistant:
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers ar (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 ar.
    - 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 : ar (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "6135a28174b64e7da9d079e7524ad41e",
    "updated": "2025-04-19T12:13:10.879Z",
    "title": "Mild pesto chicken breasts",
    "subtitle": "",
    "description": "A straightforward recipe featuring tender chicken breasts enhanced with pesto and served alongside sautéed squash, finished with a sprinkle of cheese.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "skinless, boneless chicken breast halves (about 3/4 lb. total)",
          "olive oil",
          "tbsps. homemade or purchased pesto",
          "finely chopped zucchini and/or yellow summer squash",
          "tbsps. finely shredded asiago or parmesan cheese"
        ]
      }
    ],
    "instructions": [
      "Heat the olive oil in a large, oven-safe skillet over medium-high heat until shimmering.",
      "Carefully place the chicken breasts in the hot skillet. Sear for approximately 4-5 minutes per side, until golden brown.",
      "Remove the skillet from the heat. Spread the pesto evenly over the tops of the chicken breasts.",
      "Arrange the chopped zucchini and/or squash in the skillet around the chicken.",
      "Transfer the skillet to a preheated oven set to 375°F (190°C).",
      "Bake for 10-15 minutes, or until the chicken is cooked through and the internal temperature reaches 165°F (74°C).",
      "Carefully remove the skillet from the oven. Allow the chicken to rest for a couple of minutes.",
      "Divide the chicken breasts and vegetables among four plates.",
      "Garnish generously with the shredded Asiago or Parmesan cheese just before serving."
    ],
    "notes_ingredients": "You may use either homemade or store-bought pesto. Zucchini, yellow summer squash, or a mix of both can be utilized. Both Asiago and Parmesan cheese are suitable options for the topping.",
    "notes_instructions": ""
  }
]
I making http server on Python. Please give me an example of "Hello world" response in HTTP protocol
Plot the series using a line chart. Briefly describe what you see: Is it a positive or negative
trend? Is the trend increasing? What kind of short term fluctuations do you observe?
I have a list of ingredients that I would like to format in a simple and consistent way, following this structure:

"Quantity Unit Description."

Formatting Rules:

Quantity must be a number (e.g., "200" instead of "two hundred").

Unit must use the metric system and the corresponding abbreviated form (e.g., grams → g, liters → l, milliliters → ml, etc.).

Description should be the ingredient, including any specific details if mentioned (e.g., "brown sugar", "melted unsalted butter").

If an ingredient is already formatted correctly, do not change it.

Do not invent a quantity or unit if none is provided — leave it as is and just include the description.

If a line includes alternatives or multiple options (e.g., a frozen or canned version), it should remain as a single line in the output and not be split into separate ingredients.

Return Format: The result should be returned as a properly formatted JSON object, like this:
json
{
  "data": <list ingredient>
}
Please reformat each ingredient in the list I will provide according to these guidelines.

Context Dump
Ingredients source provided:
4 milk buns,4 chicken sausages,150 g (5½ oz/1½ cups) grated gruyère cheese,1 tablespoon crème fraîche,1 tablespoon Savora sweet mustard sauce,8 chives, finely chopped,1 teaspoon curry powder,6 pitted prunes, diced,6 dried apricots, diced
summarize this:
The resource constrained project scheduling problem with a flexible project structure and consumption
and production of resources, involves making a selection of activities and scheduling these activities in
order to minimize the makespan, subject to precedence and resource constraints. Since finding a feasible selection of activities is NP-hard, we introduce the concept of group graphs and restrict ourselves
to instances with an acyclic group graph. For these instances, which represent many practical cases, we
show how to make a feasible selection of activities in polynomial time and use this concept to schedule
the selected activities using a hybrid differential evolution algorithm. We compare this algorithm with
an algorithm from the literature on special cases of instances without consumption and production of resources, and show that our algorithm creates solutions of higher quality. Furthermore, to compare general
instances, we develop an ant colony optimization algorithm that performs slightly better on special cases
than the algorithm from literature and show that the hybrid differential evolution algorithm outperforms
the ant colony optimization algorithm on general instances
HYpothetical Childrens Film Foundation Film  (late 1970's)  "Five Miles Out"    James is an Air Cadet , and is thrilled when a relative offers him a seat in a private plane..   Of course during the flight the pilot becomes unwell, leaving  James 'Five Miles Out' from the airfield, having to land the plane himself..  with minimal training..    Light tension drama,  with the scenes in the air contrasted with those in the airfield control tower.    c. 1977  so reflects approach that have been used in the era for the type of film.
Do you know of any PC cases that have more than 4 5.25 front bays that are also in the home theater PC form factor (HTPC)?
System: I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
bug report: report a problem, such as faulty behavior of the application. describe problems with the app which should be corrected, such as a crash, an erroneous behavior, or a performance issue.
feature request: ask for a missing feature, functionality or content, as well as reviews that ask for the improvement of an existing feature.
other: users express general appreciation with the application. It focuses on general judgment. They are simple text reflections of the numeric star rating. Ratings are less informative as they only include praise, dispraise, a distractive critique, or a dissuasion. Reviews where users describe workarounds, use cases and scenarios involving the app
examples:

review: @AppleSupport my phone has been charging since 10 am and it's now 1:34 pm and it's at the same battery level :-(
intention: bug report
review: @Snapchat could use a website feature for regular computers just to watch snaps
intention: feature request
review: @Windows comes up third in OS clash two years early _URL_ via @Computerworld
intention: other
User: 'prompt:I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
bug report: report a problem, such as faulty behavior of the application. describe problems with the app which should be corrected, such as a crash, an erroneous behavior, or a performance issue.
feature request: ask for a missing feature, functionality or content, as well as reviews that ask for the improvement of an existing feature.
other: users express general appreciation with the application. It focuses on general judgment. They are simple text reflections of the numeric star rating. Ratings are less informative as they only include praise, dispraise, a distractive critique, or a dissuasion. Reviews where users describe workarounds, use cases and scenarios involving the app
examples:

review: @AppleSupport my phone has been charging since 10 am and it's now 1:34 pm and it's at the same battery level :-(
intention: bug report
review: @Snapchat could use a website feature for regular computers just to watch snaps
intention: feature request
review: @Windows comes up third in OS clash two years early _URL_ via @Computerworld
intention: other
Does the author's intention in this app review relate to a bug report or feature request or other?
review: @Android Headlines Sony Launches h.ear on Noise Cancelling Headphones In India _URL_'
intention: '
Assistant: