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 sales_avg, hr_count FROM (SELECT AVG(salary) AS sales_avg FROM employees WHERE department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) AS sales, (SELECT COUNT(*) AS hr_count FROM employees WHERE department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000) AS hr FROM dummy WHERE d_dummy_sk = 1;```

[REWRITTEN QUERY]```SELECT AVG(CASE WHEN department = 'Sales' THEN salary END), COUNT(CASE WHEN department = 'HR' THEN salary END) FROM employees WHERE (department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) OR (department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000);```

[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_returns']. Below is the join graph for these fact tables:
    ['catalog_returns(cr_reason_sk) references reason(r_reason_sk);', 'catalog_returns(cr_catalog_page_sk) references catalog_page(cp_catalog_page_sk);', 'catalog_returns(cr_ship_date_sk) references date_dim(d_date_sk);']
3. The original query must employ 3 joins.
4. The original query must employ the following aggregate functions: ['count'].
5. The original query must employ the following operators in its WHERE clause: ['avg'].
6. 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 ```.
Make an animation with a cube spinning through Python.
You are a digonistician in a hosptial. the following content is the metadata for a bacterial isolate from 2 different sources of medical cases. The metadata from each source includes information after <doc>
    <doc>
        accession number: xxx->species name: xxxx->strain name: xxxx->isolate or collection date in yyyy-mm-dd: xxxx format->geographic information of islateion: xxxx->host name: xxxx->mlst type: xxxx->serotype: xxxx
    <doc/>

You need to extract and output information in the format shown below without explaining how to get such results:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
    <output>
        accession number: xxxx->species name: xxxx->strain name: xxxx->isolate or collection date in yyyy-mm-dd: xxxx format->geographic information of islateion: xxxx->host name: xxxx->mlst type: xxxx->serotype: xxxx->vaccine: yes/no
    <output/>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

where xxxx is corresponding value from different sources. If xxxx from these 2 different sources are inconsistent, then, xxxx should include all the values from different resource and seperated by "::". If the metadata from all resource shows this isolate is vaccine, the value for "vaccine:" is "yes", otherwise, "no". You must be very careful, No mistake is allowed!!! If you make a mistake, the people in the hospital will die due to the wrong information.

PS:
    a. if species name are the same but with different substrain name, it is considered consistent,
    b. if isolate or collection date are from the same year, it is still considered consistent, 
    c. if geographic information of isolation are from the same country, it is also considered consistent. 
    d. mlst type such as "mlst: xxxx" and "xxxx", where "xxxx" is number, are also consider the same. also, "mlst" may mispell as "mlsty", you need correct it before comparing
    e. Ignore upper and lower case of the metadata

------------------------------
source 0:
------------------------------
<output>
accession number: GCA_029073235.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_117->isolate or collection date in yyyy-mm-dd: 2017-11-22->geographic information of islateion: Australia->host name: pig->mlst type: 90->serotype: N/A->vaccine: no
<output/>
source 1:
------------------------------
accession number: GCA_029073235.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_117->isolate or collection date in yyyy-mm-dd: 2017-11-22->geographic information of islateion: Australia->host name: pig->mlst type: 90->serotype: N/A->vaccine: no
Translate in Spanish "Timmy, turn of the video games" "Come on! I just reached level seven!"
also add u cam edit but it will be aproved by our aftr revoiew it will b live -Are there any restrictions on editing job listings?
No, Pros Marketplace allows you to edit your job listings without restrictions. You can include all relevant information to attract the right virtual assistants for your business.
do you speak vietnamese
Mighty Jungle is a Canadian puppet series for preschoolers created by Jeff Rosen and Jason Hopley.
Hypothetical  "Goodness Gracious Me"  Sketch -  The Coopers at an 'Enlgish' Garden party..   "It's just like a family devotional! but with more tea, less samosas.. and no one asks how much Auntie Renne's care is breaking the budget!"...   etc...  Cutting satire on an English trope event :)...
Мне кажется. Что если два и более пользователя отправят запрос ИИ - то будет ошибка. Это так или нет?

from flask import Flask, render_template, request, jsonify
from gradio_client import Client
import bleach
import markdown2
import re

app = Flask(__name__)

# Инициализируем клиента Gradio
client = Client("yuntian-deng/o1")

# Разрешенные теги и атрибуты для bleach
allowed_tags = bleach.sanitizer.ALLOWED_TAGS.union({'br', 'pre', 'code', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'p', 'hr', 'br'})
allowed_attrs = {'code': ['class'], 'pre': ['class']}


@app.route('/', methods=['GET'])
def index():
    return render_template('index.html')


@app.route('/chat', methods=['POST'])
def chat():
    data = request.get_json()
    user_input = data.get('message')
    chat_counter = data.get('chat_counter', 0)
    chatbot = data.get('chatbot', [])

    # Отправляем сообщение ИИ
    result = client.predict(
        inputs=user_input,
        top_p=1,
        temperature=1,
        chat_counter=chat_counter,
        chatbot=chatbot,
        api_name="/predict"
    )

    # Извлекаем ответ ИИ
    ai_response = result[0][-1][1]
    print(ai_response)

    # Заменяем теги <br/> на символы новой строки
    ai_response_processed = re.sub(r'<br\s*/?>', '\n', ai_response)

    # Обрабатываем markdown в HTML
    ai_response_html = markdown2.markdown(ai_response_processed, extras=["fenced-code-blocks"])

    # Очищаем HTML от потенциально опасных тегов и атрибутов
    ai_response_clean = bleach.clean(
        ai_response_html,
        tags=allowed_tags,
        attributes=allowed_attrs
    )

    # Обновляем chatbot и chat_counter
    updated_chatbot = result[0]
    updated_chat_counter = chat_counter + 1

    # Возвращаем ответ в формате JSON
    return jsonify({
        'response': ai_response_clean,
        'chatbot': updated_chatbot,
        'chat_counter': updated_chat_counter
    })


@app.route('/reset', methods=['POST'])
def reset():
    # Сбрасываем состояние ИИ
    client.predict(api_name="/reset_textbox")
    return jsonify({'status': 'reset'})


if __name__ == '__main__':
    app.run(debug=True)
Freedom planet, mlp, sonic, madness combat and spark the electric: Me/Brooks (race: human. had a immortal and droid army Star Wars. 2601 age), Lilac: Well maybe we can ask the Magister if he has heard about hank j wimbleton and Twilight Sparkle.

Brooks: Who’s that?

Carol: The Magister is the ruler of Shang Tu and we are his trusted heroes.

Brooks: Huh, fancy that…But do you think we can ask other people that are rulers of the other kingdoms?

Lilac: Well let’s see, there is Mayor Zao the ruler of Shang Mu and there is King Dali of Shuigang.
Send only season number from below text like 01, 02, 03.etc without any extra text.

[Toonworld4all] Aoashi S01E17 720p HEVC 10bit HS WEB-DL Dual Audio ESub.mkv
Let's say there is a girl, fair-skinned, blue-eyed, blonde, with thick hair the color of ripe wheat. Her face is very beautiful, this beauty is sensual and seductive. Describe the facial features of this girl in detail.
hows this sound, please check grammer "I've attached a more relevant resume for this position, I have previous experience in shipping and receiving, building orders with a good safety track recorder driving forklifts and other heavy machinery. 

Even though you didn't select my resume, I do think I'm a good fit for this position, with hands on knowledge of most things construction related. "
Make an advanced and realistic clock with visualizations and a real-time calculation.
Generate 5 friendly replies that sound warm and approachable. Only list your suggestions without any other words. uejs
inventory management without barcode
### **Problem 1**: Configuration Space for a Two-Link Manipulator (4 points)

**Task**: Create the configuration space (C-Space) for the robot with an obstacle as shown in **Figure 1a**.  
You can either:
- Use a computer program (like Matlab) to generate the C-Space, or
- Use hand calculations to create a rough plot of the C-Space.

**Hint**: Consider a collision if any of the two links \( o_1 \) or \( o_2 \) hits the obstacle. The joint angles for the manipulator are constrained as:
- \( 0 \leq q_1 \leq \pi/2 \)
- \( 0 \leq q_2 \leq \pi \)

**Figure 1a**: Shows a two-link manipulator with a circular obstacle.  
**Figure 1b**: Shows the C-Space of the manipulator with a point obstacle.
Act as a spelling corrector, content editor, and text improver. ONLY return the rewritten text and nothing else.

Strictly follow these rules:
- Correct spelling, grammar, and punctuation errors in the given text
- Enhance clarity and conciseness without altering the original meaning
- Use the same language as the original text
- Divide lengthy sentences into shorter, more readable ones
- Eliminate unnecessary repetition while preserving important points
- Prioritize active voice over passive voice for a more engaging tone
- Opt for simpler, more accessible vocabulary when possible
- ALWAYS ensure the original meaning and intention of the given text
- ALWAYS maintain the original language of the text
- ALWAYS maintain the existing tone of voice and style, e.g. formal, casual, polite, etc.
- NEVER surround the improved text with quotes or any additional formatting
- If the text is already well-written and requires no improvement, do not change the given text

Text to improve:

Act as a spelling corrector, content editor, and text improver. ONLY return the rewritten text and nothing else.

Strictly follow these rules:
- Correct spelling, grammar, and punctuation errors in the given text
- Enhance clarity and conciseness without altering the original meaning
- Use the same language as the original text
- Divide lengthy sentences into shorter, more readable ones
- Eliminate unnecessary repetition while preserving important points
- Prioritize active voice over passive voice for a more engaging tone
- Opt for simpler, more accessible vocabulary when possible
- ALWAYS ensure the original meaning and intention of the given text
- ALWAYS maintain the original language of the text
- ALWAYS maintain the existing tone of voice and style, e.g. formal, casual, polite, etc.
- NEVER surround the improved text with quotes or any additional formatting
- If the text is already well-written and requires no improvement, do not change the given text

Text to improve:

phyllo
Hi ChatGPT, I'd like you to write a 3,000-word blog post optimized for SEO. The topic of the post is 'best soil for monstera Please focus on the following keywords: best soil for monstera. and follow by outline "How to Choose the Right Soil for Monstera Plant?
Best Soil for Monstera
https://www.amazon.com/dp/B00HXOI3U0/?tag=best-soil-for-monstera-20&asc_source=browser&asc_refurl=https%3A%2F%2Fwww.bobvila.com%2Farticles%2Fbest-soil-for-monstera&ascsubtag=0000BV0000159381O1920091220230525092516%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B&th=1
https://www.amazon.com/Sphagnum-Succulent-Amendment-Vegetables-Houseplant/dp/B09YPZTSRV/ref=sr_1_16?crid=2EZ8C6WGXN3G8&keywords=soil&qid=1685006457&s=lawn-garden&sprefix=soil%2Clawngarden%2C465&sr=1-16
https://www.amazon.com/Miracle-Gro-Moisture-currently-Northeastern-Midwestern/dp/B00FE1GGG2/ref=sr_1_17?crid=2EZ8C6WGXN3G8&keywords=soil&qid=1685006457&s=lawn-garden&sprefix=soil%2Clawngarden%2C465&sr=1-17&th=1
https://www.amazon.com/dp/B078GQPRX4/?tag=best-soil-for-monstera-20&asc_source=browser&asc_refurl=https://www.bobvila.com/articles/best-soil-for-monstera&ascsubtag=0000BV0000159381O1920091220230525092516%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
https://www.amazon.com/dp/B0828SMZNS/?tag=best-soil-for-monstera-20&asc_source=browser&asc_refurl=https://www.bobvila.com/articles/best-soil-for-monstera&ascsubtag=0000BV0000159381O1920091220230525092516%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
Why Is the Right Soil So Crucial for Your Monstera?
Commercial vs. DIY: Which Is the Best Soil for Monstera?

How to Create Your Own Best Soil Mix for Monstera
Common Mistakes to Avoid When Choosing Soil for Monstera"Make sure to include an engaging introduction, several subheadings with informative content, and a conclusion. Remember to naturally incorporate the target keywords throughout the post and adhere to SEO best practices
User: Generate 1 slightly different variations of the description: "hgsahsahas".
						Change the wording and use synonyms where possible but don't overdo it, also make sure the casing stays the same.
						Preferably, only change words that don't differ from the true specification of the product.
						A good example of variation can be colours. e.g. White can be Snow White.
            Ensure minimal variations that preserve the core meaning. Please return the response in a JSON array.
						DO NOT WRAP IT IN A CODE BLOCK.
						NO NEW LINES AND NO NESTED ARRAYS.
				
User: Generate 1 slightly different variations of the description: "hgsahsahas".
						Change the wording and use synonyms where possible but don't overdo it, also make sure the casing stays the same.
						Preferably, only change words that don't differ from the true specification of the product.
						A good example of variation can be colours. e.g. White can be Snow White.
            Ensure minimal variations that preserve the core meaning. Please return the response in a JSON array.
						DO NOT WRAP IT IN A CODE BLOCK.
						NO NEW LINES AND NO NESTED ARRAYS.
				
Assistant:
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: 🟩 Software Engineer Intern | Junior
▫️ Instructure | Education Technology
▫️ Hungary | Budapest

Office 🏢
Required languages: 🇬🇧

Skills: ios, github, swift, uikit, xcode
Tags: #green #it #ios

👉 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: 💼 Software Engineer Intern | Junior
🏢 Instructure | Education Technology
📍 Hungary | Budapest
🔹 Skills: ios, github, swift, uikit, xcode
💰 Salary: Not mentioned
📞 Contact details: Assistant (please provide more information)

The job is for a Software Engineer Intern | Junior position at Instructure | Education Technology located in Hungary | Budapest. The required languages are English (🇬🇧). The main tasks involve working with skills like ios, github, swift, uikit, and xcode. The salary is not mentioned, but you can provide more contact information to get in touch with the company.
  
Assistant:
October 31st, 2025: Dad finally agrees to let me go trick-or-treating and get Halloween candy after forbidding me from doing so last year (October 31st, 2024)
how do you do this check. ULS: lateral loads (wind, berthing) must span/be flexurally carried by floating docks to reach mooring piles. floating dock supported by two cylindical pontoons. show very detailed example. dont just list steps like you always do.We have a berthing energy in knm. berthing load can be found by modeling a dock module and assuming a certain number of the mooring piles are engaged by the loading
create a webapp that allows me to earn some money, ieven if very little
Send only episode number from below text like 01, 02, 03.etc without any extra text.

balloonerism.2025.480p.web.x264.rmteam.mkv
System: I will provide you with a textual GitHub issue title of an Android app, aiming to categorize the issues into one or multiple 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
User: 'prompt:I will provide you with a textual GitHub issue title of an Android app, aiming to categorize the issues into one or multiple 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
Does the author's intention in this GitHub issue relate to a bug report or feature request or other?
issue: Allow only morph codes to be displayed without Strongs'
intention: '
Assistant:
How would you describe Mappy theme song
Write an arabic pop song about a mystery called "Allah Allah" and it's origins through adventures
Provide me 1 thing that must be done before each given action below: 
1. Visiting a friend
2. Joining an organization in school
3. Playing computer games
4. Buying a new gadget
5. Asking permission if you would like to go out with friends
I want 10 attractive words for pictures about the activity cube game for children in English
write a commercial for 5-second headache medicine with john madden
power entangling
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": "3e055e7d875247308f516a862f72feb0",
    "updated": "2025-05-07T23:06:35.923Z",
    "title": "Pea and Watercress Soup with Prawn Soldiers",
    "subtitle": "Sweet pea soup served with crisp prawn toasts",
    "description": null,
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "shallots",
          "little oil",
          "fresh peas (podded weight).",
          "vegetable stock",
          "bunch of watercress",
          "shelled prawns",
          "butter",
          "black pepper",
          "pinch of ground mace",
          "small baguette",
          "peas",
          "watercress",
          "prawns",
          "baguette",
          "vegetable stock"
        ]
      }
    ],
    "instructions": [
      "Peel and finely chop 2 medium shallots, then cook them gently in a little oil over medium heat until they become soft and translucent.",
      "Add 500g (podded weight) fresh peas, followed by 1 litre of vegetable stock.",
      "Stir the mixture and let it simmer for 5 minutes.",
      "Pour most of the peas and the cooking liquid into a food processor or blender and blend until smooth.",
      "Add a bunch of watercress and continue blending until the mixture is smooth, then return it to the remaining soup.",
      "This method creates a lightly textured soup with more character than a completely smooth one.",
      "Adjust the seasoning to taste.",
      "To prepare the prawn soldiers, roughly chop 150g shelled prawns.",
      "Cube 50g butter and mash the chopped prawns into the butter.",
      "Season with black pepper and a pinch of ground mace.",
      "Thinly slice a small baguette.",
      "Spread the prawn butter onto the bread slices and bake for 10 minutes at 200°C (Gas mark 6), or grill under the overhead grill if preferred.",
      "Serve the warm soup alongside the crispy prawn toasts."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]