interacted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @startDate datetime = dateadd(d,0-##daysBack:int?30##,( select min(create_date) from sys.tables ))

select Id ,Tags ,OwnerUserId from Posts where OwnerUserId in (



select 
OwnerUserId as t  from Posts p where   p.CreationDate >=@startDate

and (
p.Tags LIKE '%google-app-engine%' OR
p.Tags LIKE '%google-cloud-platform%' OR
p.Tags LIKE '%google-bigquery%' OR
p.Tags LIKE '%google-cloud-messaging%' OR
p.Tags LIKE '%google-cloud-datastore%' OR
p.Tags LIKE '%google-cloud-storage%' OR
p.Tags LIKE '%google-cloud-firestore%' OR
p.Tags LIKE '%google-compute-engine%' OR
p.Tags LIKE '%google-cloud-functions%' OR
p.Tags LIKE '%google-ajax%' OR
p.Tags LIKE '%google-ajax-api%' OR
p.Tags LIKE '%google-ajax-libraries%' OR
p.Tags LIKE '%google-ajax-search-api%' OR
p.Tags LIKE '%google-cloud-endpoints%' OR
p.Tags LIKE '%google-cloud-dataflow%' OR
p.Tags LIKE '%google-cloud-sql%' OR
p.Tags LIKE '%google-api%' OR
p.Tags LIKE '%google-api-client%' OR
p.Tags LIKE '%dialogflow%' OR
p.Tags LIKE '%google-api-console%' OR
p.Tags LIKE '%google-api-cpp-client%' OR
p.Tags LIKE '%google-api-dotnet-client%' OR
p.Tags LIKE '%app-engine-ndb%' OR
p.Tags LIKE '%google-api-explorer%' OR
p.Tags LIKE '%google-api-java-client%' OR
p.Tags LIKE '%google-api-js-client%' OR
p.Tags LIKE '%google-container-engine%' OR
p.Tags LIKE '%google-api-nodejs-client%' OR
p.Tags LIKE '%google-api-objc-client%' OR
p.Tags LIKE '%google-api-php-client%' OR
p.Tags LIKE '%google-api-python-client%' OR
p.Tags LIKE '%google-api-ruby-client%' OR
p.Tags LIKE '%google-apis-explorer%' OR
p.Tags LIKE '%google-api-v3%' OR
p.Tags LIKE '%google-api-v4%' OR
p.Tags LIKE '%google-api-webmasters%' OR
p.Tags LIKE '%google-appengine-node%' OR
p.Tags LIKE '%google-cloud-pubsub%' OR
p.Tags LIKE '%data-transfer%' OR
p.Tags LIKE '%apigee%' OR
p.Tags LIKE '%datastore%' OR
p.Tags LIKE '%google-authentication%' OR
p.Tags LIKE '%google-cloud-ml%' OR
p.Tags LIKE '%google-cloud-dataproc%' OR
p.Tags LIKE '%dataflow%' OR
p.Tags LIKE '%google-app-engine-python%' OR
p.Tags LIKE '%gcp%' OR
p.Tags LIKE '%google-cloud-datalab%' OR
p.Tags LIKE '%google-vision%' OR
p.Tags LIKE '%google-cloud-vision%' OR
p.Tags LIKE '%stackdriver%' OR
p.Tags LIKE '%bigtable%' OR
p.Tags LIKE '%google-cloud-bigtable%' OR
p.Tags LIKE '%app-engine-flexible%' OR
p.Tags LIKE '%google-console-developer%' OR
p.Tags LIKE '%vpc%' OR
p.Tags LIKE '%google-cloud-speech%' OR
p.Tags LIKE '%google-data%' OR
p.Tags LIKE '%google-cloud-spanner%' OR
p.Tags LIKE '%google-data-api%' OR
p.Tags LIKE '%google-datalayer%' OR
p.Tags LIKE '%google-data-protocol%' OR
p.Tags LIKE '%google-data-studio%' OR
p.Tags LIKE '%google-cloud-ml-engine%' OR
p.Tags LIKE '%google-datatable%' OR
p.Tags LIKE '%google-cloud-sdk%' OR
p.Tags LIKE '%google-cloud-print%' OR
p.Tags LIKE '%google-cloud-stackdriver%' OR
p.Tags LIKE '%cloud-storage%' OR
p.Tags LIKE '%google-cloud-endpoints-v2%' OR
p.Tags LIKE '%google-cloud-python%' OR
p.Tags LIKE '%google-cdn%' OR
p.Tags LIKE '%pubsubhubbub%' OR
p.Tags LIKE '%endpoints-proto-datastore%' OR
p.Tags LIKE '%google-cloud-dns%' OR
p.Tags LIKE '%google-cloud-logging%' OR
p.Tags LIKE '%google-genomics%' OR
p.Tags LIKE '%google-cloud-console%' OR
p.Tags LIKE '%local-datastore%' OR
p.Tags LIKE '%google-cloud-shell%' OR
p.Tags LIKE '%google-iam%' OR
p.Tags LIKE '%google-iap%' OR
p.Tags LIKE '%google-knowledge-graph%' OR
p.Tags LIKE '%google-cloud-dataprep%' OR
p.Tags LIKE '%google-language-api%' OR
p.Tags LIKE '%google-app-engine-php%' OR
p.Tags LIKE '%google-cloud-nl%' OR
p.Tags LIKE '%google-cloud-composer%' OR
p.Tags LIKE '%google-cloud-iot%' OR
p.Tags LIKE '%google-translation-api%' OR
p.Tags LIKE '%cloud-sql-proxy%' OR
p.Tags LIKE '%google-deployment-manager%' OR
p.Tags LIKE '%google-cloud-iam%' OR
p.Tags LIKE '%apigee-baas%' OR
p.Tags LIKE '%google-cloud-networking%' OR
p.Tags LIKE '%google-cloud-kms%' OR
p.Tags LIKE '%google-cloud-monitoring%' OR
p.Tags LIKE '%automl%' OR
p.Tags LIKE '%app-engine-patch%' OR
p.Tags LIKE '%google-cloud-cdn%' OR
p.Tags LIKE '%google-app-engine-go%' OR
p.Tags LIKE '%peoplesoft-app-engine%' OR
p.Tags LIKE '%google-cloud-error-reporting%' OR
p.Tags LIKE '%google-natural-language%' OR
p.Tags LIKE '%google-cloud-source-repos%' OR
p.Tags LIKE '%google-cloud-launcher%' OR
p.Tags LIKE '%google-cloud-debugger%' OR
p.Tags LIKE '%google-cloud-dlp%' OR
p.Tags LIKE '%google-cloud-tools%' OR
p.Tags LIKE '%google-cloud-trace%' OR
p.Tags LIKE '%fluid-mac-app-engine%' OR
p.Tags LIKE '%app-engine-modules%' OR
p.Tags LIKE '%google-ios-vision%' OR
p.Tags LIKE '%google-app-engine-launch%' OR
p.Tags LIKE '%google-cloud-build%' OR
p.Tags LIKE '%google-cloud-memorystore%' OR
p.Tags LIKE '%google-cloud-billing%' OR
p.Tags LIKE '%google-cloud-repository%' OR
p.Tags LIKE '%apigee127%' OR
p.Tags LIKE '%google-cloud-test-lab%' OR
p.Tags LIKE '%google-speech-api%' OR
p.Tags LIKE '%dataproc%' OR
p.Tags LIKE '%google-cloud-tpu%' OR
p.Tags LIKE '%google-app-engine-patch%' OR
p.Tags LIKE '%datastore-admin%' OR
p.Tags LIKE '%google-text-to-speech%' OR
p.Tags LIKE '%google-cloud-node%' OR
p.Tags LIKE '%google-cloud-iap%' OR
p.Tags LIKE '%google-cloud-save%' OR
p.Tags LIKE '%google-cloud-intellij%' OR
p.Tags LIKE '%google-cloud-powershell%' OR
p.Tags LIKE '%google-cloud-visualstudio%' OR
p.Tags LIKE '%google-app-engine-deploy%' OR
p.Tags LIKE '%firebase-cloud-functions%' OR
p.Tags LIKE '%google-kubernetes-engine%' OR
p.Tags LIKE '%google-python-api%' OR
p.Tags LIKE '%api.ai%' 


)


)

and Tags IS NOT NULL and CreationDate >=@startDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results