0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select * from comments where PostId IN 


(select 

p1.Id as QId
--p2.Id as Aid

from posts p1 INNER JOIN posts p2 ON p1.Id = p2.ParentId

where p1.posttypeid = 1

-- recent
-- and p1.CreationDate > '2020-01-01'
-- and p1.CreationDate < '2016-01-01'
and p1.Score > 0
-- question body has words like api/library
-- and (p1.Body like '% api%' or p1.Body like '% library%' or p1.Body like '% libraries%')

-- tags for aspect Performance

and (p1.Tags like '%<performance>%' or p1.Tags like '%<optimization>%' or p1.Tags like '%<speed>%' or p1.Tags like '%<efficiency>%' or p1.Tags like '%<scalability>%' or p1.Tags like '%<parallelism>%' or p1.Tags like '%<multithreading>%' or p1.Tags like '%<memory-management>%' or p1.Tags like '%<cpu-usage>%' or p1.Tags like '%<network-optimization>%' or p1.Tags like '%<scaling>%' or p1.Tags like '%<throughput>%' or p1.Tags like '%<latency>%' or p1.Tags like '%<caching>%' or p1.Tags like '%<load-balancing>%' or p1.Tags like '%<profiling>%')

and p1.AcceptedAnswerId != ''
--and (p1.Tags like '%<java>%' or p1.Tags like '%<python>%')

and (p1.Tags like '%<javax>%' 
or p1.Tags like '%<javax.imageio>%' 
or p1.Tags like '%<javafx>%' 
or p1.Tags like '%<spring>%' 
or p1.Tags like '%<spring-security>%' 
or p1.Tags like '%<apache-commons>%' 
or p1.Tags like '%<lucene>%' 
or p1.Tags like '%<guava>%' 
or p1.Tags like '%<google-guava-cache>%' 
or p1.Tags like '%<log4j>%' 
or p1.Tags like '%<junit>%' 
or p1.Tags like '%<jackson>%' 
or p1.Tags like '%<hibernate>%'
or p1.Tags like '%<slf4j>%'
or p1.Tags like '%<lombok>%'
or p1.Tags like '%<gson>%'
or p1.Tags like '%<thymeleaf>%'
or p1.Tags like '%<mybatis>%'
or p1.Tags like '%<rxjava>%'
or p1.Tags like '%<httpclient>%'
or p1.Tags like '%<okhttp>%'
or p1.Tags like '%<apache-poi>%'
or p1.Tags like '%<jodatime>%'
or p1.Tags like '%<quartz-scheduler>%'
or p1.Tags like '%<ehcache>%'
or p1.Tags like '%<flyway>%'
or p1.Tags like '%<mockito>%'
or p1.Tags like '%<guice>%'
or p1.Tags like '%<apache-camel>%'
or p1.Tags like '%<selenium>%'
or p1.Tags like '%<apache-kafka>%'
or p1.Tags like '%<fasterxml>%'
or p1.Tags like '%<jsoup>%'
or p1.Tags like '%<liquibase>%'
or p1.Tags like '%<hazelcast>%'
or p1.Tags like '%<swagger>%'
or p1.Tags like '%<apache-camel>%'
or p1.Tags like '%<hystrix>%'
or p1.Tags like '%<event-bus>%'
or p1.Tags like '%<querydsl>%'
or p1.Tags like '%<assertj>%'
or p1.Tags like '%<jaxb>%'
or p1.Tags like '%<jasypt>%'
or p1.Tags like '%<undertow>%'
or p1.Tags like '%<mapstruct>%'
or p1.Tags like '%<vavr>%'
or p1.Tags like '%<jooq>%'
or p1.Tags like '%<jhipster>%'
or p1.Tags like '%<retrofit>%'
or p1.Tags like '%<aws-sdk>%'
or p1.Tags like '%<jboss-weld>%'
or p1.Tags like '%<vert.x>%'
or p1.Tags like '%<byte-buddy>%'
or p1.Tags like '%<resttemplate>%'
or p1.Tags like '%<javassist>%'
or p1.Tags like '%<kryo>%'
or p1.Tags like '%<jhipster-registry>%'
or p1.Tags like '%<rx-java>%'
or p1.Tags like '%<rx-java2>%'
or p1.Tags like '%<jedis>%'
or p1.Tags like '%<caffeine-cache>%'
or p1.Tags like '%<java-money>%'
or p1.Tags like '%<openfeign>%'
or p1.Tags like '%<jdbi>%'
or p1.Tags like '%<mockserver>%'
or p1.Tags like '%<apache-flink>%'
or p1.Tags like '%<hikaricp>%'
or p1.Tags like '%<spark-java>%'
or p1.Tags like '%<cxf>%'
or p1.Tags like '%<jogl>%'
or p1.Tags like '%<wiremock>%'
or p1.Tags like '%<logback>%'
or p1.Tags like '%<junitparams>%'
or p1.Tags like '%<apache-commons-beanutils>%'
or p1.Tags like '%<serenity-bdd>%'
or p1.Tags like '%<vaadin>%'
or p1.Tags like '%<camunda>%'
or p1.Tags like '%<rest-assured>%'
or p1.Tags like '%<powermock>%'
or p1.Tags like '%<maven>%'
or p1.Tags like '%<jgrapht>%'
or p1.Tags like '%<graalvm>%'
or p1.Tags like '%<lettuce>%'
or p1.Tags like '%<testcontainers>%'
or p1.Tags like '%<gauge>%'
or p1.Tags like '%<java-melody>%'
or p1.Tags like '%<keycloak>%'
or p1.Tags like '%<micronaut>%'
or p1.Tags like '%<testng>%'
or p1.Tags like '%<jlayer>%'
or p1.Tags like '%<numpy>%'
or p1.Tags like '%<pandas>%'
or p1.Tags like '%<matplotlib>%'
or p1.Tags like '%<scikit-learn>%'
or p1.Tags like '%<tensorflow>%'
or p1.Tags like '%<pytorch>%'
or p1.Tags like '%<requests>%'
or p1.Tags like '%<beautifulsoup>%'
or p1.Tags like '%<django>%'
or p1.Tags like '%<flask>%'
or p1.Tags like '%<sqlalchemy>%'
or p1.Tags like '%<flask-sqlalchemy>%'
or p1.Tags like '%<pytest>%'
or p1.Tags like '%<selenium>%'
or p1.Tags like '%<opencv>%'
or p1.Tags like '%<nltk>%'
or p1.Tags like '%<spacy>%'
or p1.Tags like '%<scrapy>%'
or p1.Tags like '%<flask-restful>%'
or p1.Tags like '%<fastapi>%'
or p1.Tags like '%<celery>%'
or p1.Tags like '%<redis-py>%'
or p1.Tags like '%<flask-socketio>%'
or p1.Tags like '%<twisted>%'
or p1.Tags like '%<pyqt>%'
or p1.Tags like '%<pyside>%'
or p1.Tags like '%<keras>%'
or p1.Tags like '%<plotly-dash>%'
or p1.Tags like '%<pygame>%'
or p1.Tags like '%<gevent>%'
or p1.Tags like '%<tornado>%'
or p1.Tags like '%<fabric>%'
or p1.Tags like '%<arrow-python>%'
or p1.Tags like '%<pyarrow>%'
or p1.Tags like '%<pyqtgraph>%'
or p1.Tags like '%<dask>%'
or p1.Tags like '%<fasttext>%'
or p1.Tags like '%<wtforms>%'
or p1.Tags like '%<bokeh>%'
or p1.Tags like '%<pyinstaller>%'
or p1.Tags like '%<networkx>%'
or p1.Tags like '%<folium>%'
or p1.Tags like '%<pytorch-lightning>%'
or p1.Tags like '%<xgboost>%'
or p1.Tags like '%<pymongo>%'
or p1.Tags like '%<psycopg2>%'
or p1.Tags like '%<fuzzywuzzy>%'
or p1.Tags like '%<pytest-django>%'
or p1.Tags like '%<scapy>%'
or p1.Tags like '%<redis>%'
or p1.Tags like '%<speech-recognition-api>%'
or p1.Tags like '%<pyyaml>%'
or p1.Tags like '%<pytorch-geometric>%'
or p1.Tags like '%<sqlalchemy-utils>%'
or p1.Tags like '%<pyside>%'
or p1.Tags like '%<tweepy>%'
or p1.Tags like '%<sanic>%'
or p1.Tags like '%<pandas-profiling>%'
or p1.Tags like '%<gspread>%'
or p1.Tags like '%<pyjwt>%'
or p1.Tags like '%<faker>%'
or p1.Tags like '%<scrapy-splash>%'
or p1.Tags like '%<py-telegram-bot-api>%'
or p1.Tags like '%<pyodbc>%'
or p1.Tags like '%<pyopenssl>%'
or p1.Tags like '%<falcon>%'
or p1.Tags like '%<uvicorn>%'
or p1.Tags like '%<zeromq>%'
or p1.Tags like '%<boto3>%'
or p1.Tags like '%<pytest-cov>%'
or p1.Tags like '%<pymongo>%'
or p1.Tags like '%<rabbitmq>%'
or p1.Tags like '%<cherrypy>%'
or p1.Tags like '%<pydantic>%'
or p1.Tags like '%<peewee>%'
or p1.Tags like '%<pymysql>%'
or p1.Tags like '%<pyinstaller>%'
or p1.Tags like '%<gunicorn>%'
or p1.Tags like '%<textblob>%'
or p1.Tags like '%<pytest-asyncio>%'
or p1.Tags like '%<pep8>%'
or p1.Tags like '%<pydub>%'
or p1.Tags like '%<statsmodels>%'
or p1.Tags like '%<flask-security>%'
or p1.Tags like '%<pytest-html>%'
or p1.Tags like '%<pyinstaller>%'
or p1.Tags like '%<django-rest-framework>%'
or p1.Tags like '%<kivy>%'
or p1.Tags like '%<psutil>%'
or p1.Tags like '%<pandasql>%'
or p1.Tags like '%<python-docx>%'
or p1.Tags like '%<watchdog>%'
or p1.Tags like '%<python-watchdog>%'
or p1.Tags like '%<reactjs>%'
or p1.Tags like '%<vue.js>%'
or p1.Tags like '%<angularjs>%'
or p1.Tags like '%<jquery>%'
or p1.Tags like '%<node.js>%'
or p1.Tags like '%<d3.js>%'
or p1.Tags like '%<redux>%'
or p1.Tags like '%<lodash>%'
or p1.Tags like '%<webpack>%'
or p1.Tags like '%<babeljs>%'
or p1.Tags like '%<three.js>%'
or p1.Tags like '%<socket.io>%'
or p1.Tags like '%<underscore.js>%'
or p1.Tags like '%<chart.js>%'
or p1.Tags like '%<next.js>%'
or p1.Tags like '%<jestjs>%'
or p1.Tags like '%<ramda.js>%'
or p1.Tags like '%<axios>%'
or p1.Tags like '%<graphql-js>%'
or p1.Tags like '%<firebase>%'
or p1.Tags like '%<mongoose>%'
or p1.Tags like '%<sass>%'
or p1.Tags like '%<gulp>%'
or p1.Tags like '%<rxjs>%'
or p1.Tags like '%<chai>%'
or p1.Tags like '%<mocha.js>%'
or p1.Tags like '%<nuxt.js>%'
or p1.Tags like '%<storybook>%'
or p1.Tags like '%<immutable.js>%'
or p1.Tags like '%<leaflet>%'
or p1.Tags like '%<svelte>%'
or p1.Tags like '%<cypress>%'
or p1.Tags like '%<popper.js>%'
or p1.Tags like '%<rxdb>%'
or p1.Tags like '%<phaserjs>%'
or p1.Tags like '%<quill>%'
or p1.Tags like '%<semantic-ui>%'
or p1.Tags like '%<highcharts>%'
or p1.Tags like '%<recharts>%'
or p1.Tags like '%<buefy>%'
or p1.Tags like '%<mithril.js>%'
or p1.Tags like '%<nestjs>%'
or p1.Tags like '%<sails.js>%'
or p1.Tags like '%<webapi>%'
or p1.Tags like '%<fetch-api>%'
or p1.Tags like '%<google-ajax-api>%'
or p1.Tags like '%<websocket>%'
or p1.Tags like '%<indexeddb>%'
)
)

fork query

edited dec 9 23

created nov 30 23 anonymous