{"id":22173,"date":"2021-03-10T21:42:39","date_gmt":"2021-03-11T02:42:39","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/wordpress-approx-5-6-sqls-to-find-all-big-data-ml-ai-related-category-ids-term-ids\/"},"modified":"2021-03-10T21:42:39","modified_gmt":"2021-03-11T02:42:39","slug":"wordpress-approx-5-6-sqls-to-find-all-big-data-ml-ai-related-category-ids-term-ids","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=22173","title":{"rendered":"WordPress ( approx 5.6 ) sqls to find all big data, ml, ai, related category ids (term ids)"},"content":{"rendered":"

WordPress ( approx: 5.6 ) sqls to find all big data, ml, ai, related category ids (term ids)
\n<\/strong><\/p>\n

SELECT wt.term_id FROM `wp_terms` wt
\ninner join wp_term_taxonomy wtt on (wtt.term_id = wt.term_id) and (wtt.taxonomy=’category’)
\nWHERE<\/p>\n

(name like ‘%big data%’)
\nor ((name like ‘%cloud%’))
\nor ((name like ‘%machine learning%’))
\nor ((name like ‘%security%’))
\nor ((name like ‘AI’))
\nor (name like ‘%artificial intelligence%’)
\nor (name like ‘%data science%’)
\nor (name like ‘nlp’)
\nor (name like ‘%hadoop%’)
\nor (name like ‘%analytics%’)
\nor (name like ‘%business intelligence%’)
\nor (name like ‘BI’)
\nor (name like ‘%database%’)
\nor (name like ‘%DBMS%’)
\nor (name like ‘%data warehouse%’)
\nor (name like ‘%robotics%’)
\nor (name like ‘%visualization%’)
\nor (name like ‘%data visualization%’)
\nor (name like ‘%data mining%’)
\nor (name like ‘%graph minining%’)
\nor (name like ‘%optimization%’)
\nor (name like ‘%combinatorics%’)
\nor (name like ‘%hive%’)
\nor (name like ‘pig’)
\nor (name like ‘%spark%’)
\nor (name like ‘aws’)
\nor (name like ‘%elastic search%’)
\nor (name like ‘%bayesian%’)
\nor (name like ‘%tracking%’)
\nor (name like ‘%estimation%’)
\nor (name like ‘%deep learning%’)
\nor (name like ‘%reinforcement learning%’)
\nor (name like ‘%neural network%’)
\nor (name like ‘%natural language processing%’)
\nor (name like ‘%statistics%’)
\nor (name like ‘%algorithms for big data%’)<\/p>\n

order by name<\/p>\n

Note: All the or as used in the above could be simplified and\/or made better in terms of syntax, easy of use, efficiency, extensibility. This is just quick.<\/strong><\/p>\n

*** . *** *** . *** . *** . ***<\/p>\n

Courses: <\/strong>http:\/\/Training.SitesTree.com<\/a> (Big Data, Cloud, Security, Machine Learning)<\/em>
\nBlog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a><\/em>
\n8112223 Canada Inc.\/JustEtc<\/strong>: http:\/\/JustEtc.net<\/a><\/em><\/p>\n

Shop Online: <\/strong><\/em>https:\/\/www.ShopForSoul.com\/<\/a>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a><\/em><\/p>\n

Medium<\/strong>: https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

WordPress ( approx: 5.6 ) sqls to find all big data, ml, ai, related category ids (term ids) SELECT wt.term_id FROM `wp_terms` wt inner join wp_term_taxonomy wtt on (wtt.term_id = wt.term_id) and (wtt.taxonomy=’category’) WHERE (name like ‘%big data%’) or ((name like ‘%cloud%’)) or ((name like ‘%machine learning%’)) or ((name like ‘%security%’)) or ((name like ‘AI’)) … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-22173","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":78364,"url":"http:\/\/bangla.sitestree.com\/?p=78364","url_meta":{"origin":22173,"position":0},"title":"Query Strings in C#","author":"Sayed","date":"August 5, 2025","format":false,"excerpt":"Here\u2019s a complete, copyright-free guide to Query Strings in C# \/ ASP.NET, including definition, examples, use cases, limitations, performance, and security. You can freely copy-paste this on your blog or Facebook page. \ud83d\udd17 Query String in C# ASP.NET \u2013 Complete Guide \ud83d\udcd8 Definition A query string is a part of\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16051,"url":"http:\/\/bangla.sitestree.com\/?p=16051","url_meta":{"origin":22173,"position":1},"title":"Data Visualization in Python (R)","author":"Sayed","date":"September 4, 2019","format":false,"excerpt":"Python Treemaps with Squarify & Matplotlib https:\/\/fcpython.com\/visualisation\/python-treemaps-squarify-matplotlib --- Treemaps With Squarify https:\/\/galaxydatatech.com\/2018\/03\/20\/treemaps-with-squarify\/ --- 200 Basic Treemap with python https:\/\/python-graph-gallery.com\/200-basic-treemap-with-python\/ --- Dendrograms in Python https:\/\/plot.ly\/python\/dendrogram\/ https:\/\/python-graph-gallery.com\/dendrogram\/ --- HIERARCHICAL CLUSTERING IN R: THE ESSENTIALS https:\/\/www.datanovia.com\/en\/lessons\/examples-of-dendrograms-visualization\/ --- Geographic Data with Basemap https:\/\/jakevdp.github.io\/PythonDataScienceHandbook\/04.13-geographic-data-with-basemap.html --- Plotting data on a map (Example Gallery)\u00b6 https:\/\/matplotlib.org\/basemap\/users\/examples.html --- A\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16059,"url":"http:\/\/bangla.sitestree.com\/?p=16059","url_meta":{"origin":22173,"position":2},"title":"Data Visualization Misc","author":"Sayed","date":"September 5, 2019","format":false,"excerpt":"Data Visualization Overview: ---------------------------- Data Visualization: About Data Visualization http:\/\/guides.library.duke.edu\/c.php?g=289678&p=1930713 I Can See Clearly Now: A Survey of Data Visualization Techniques & Practice https:\/\/www.slideshare.net\/myles_harrison\/i-can-see-clearly-now-a-survey-of-data-visualization-techniques-practice-31179055 Visualization in Data Science: What is it for? http:\/\/guides.library.duke.edu\/c.php?g=289678&p=1930713 Anscombe's quartet https:\/\/en.wikipedia.org\/wiki\/Anscombe's_quartet Storytelling and data visualization\u2026\u00a0So what? https:\/\/www.dapresy.com\/storytelling-and-data-visualization\/ Visualization Types https:\/\/guides.library.duke.edu\/datavis\/vis_types Junk Charts https:\/\/junkcharts.typepad.com\/junk_charts\/2012\/10\/expanding-circles-of-error.html Visualization Analysis\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78362,"url":"http:\/\/bangla.sitestree.com\/?p=78362","url_meta":{"origin":22173,"position":3},"title":"Cookies in C#","author":"Sayed","date":"August 5, 2025","format":false,"excerpt":"By AI: Here\u2019s a clear, blog- and Facebook-ready explanation of Cookies in C# (ASP.NET) with their pros and cons, including examples. You can freely copy, share, or repost it anywhere. \ud83c\udf6a Cookies in C# ASP.NET \u2013 Pros and Cons In web development with ASP.NET, cookies are used to store small\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16171,"url":"http:\/\/bangla.sitestree.com\/?p=16171","url_meta":{"origin":22173,"position":4},"title":"PERCEPTION and Data Visualization: Concepts, Examples, Code, Projects","author":"Sayed","date":"September 10, 2019","format":false,"excerpt":"PERCEPTION Data Visualization for Human Perception \"Data visualization is the graphical display of abstract information for two purposes: sense-making (also called data analysis) and communication. ... In other words, to visualize data effectively, we must follow design principles that are derived from an understanding of human perception.\" https:\/\/www.interaction-design.org\/literature\/book\/the-encyclopedia-of-human-computer-interaction-2nd-ed\/data-visualization-for-human-perception The Role\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16626,"url":"http:\/\/bangla.sitestree.com\/?p=16626","url_meta":{"origin":22173,"position":5},"title":"linkedin profile","author":"Sayed","date":"January 10, 2020","format":false,"excerpt":"Director\/Course Designer\/Trainer Justetc (Just Et Cetera) Social Services Non-profit. As we can basis, as time and schedule permit basis. Courses: https:\/\/SitesTree.com\/training (Free and\/or low cost workshops and training). Events: http:\/\/facebook.com\/justetcsocial. Subject areas in order: Big-Data & Machine Learning (ML, DL, NN, RL, NLP, Visualization), Cloud, Linux\/System Admin, Security, DBMS\/BI, Web\/Mobile\/Software\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/22173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22173"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/22173\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22173"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}