ImageSearch
Query Google custom search engines for images.
Table Specific Information
When querying this table the SearchTerms parameter must be specified. For example, to search in ImageSearch for the term 'technology' use the following query:
SELECT * FROM ImageSearch WHERE SearchTerms = 'technology'
To filter out certain queries and include other queries, use a mix of operators on the SearchTerms field:
SELECT * FROM ImageSearch WHERE SearchTerms = 'search1' AND SearchTerms != 'search2' AND SearchTerms > 'x' AND SearchTerms < 'y' OR SearchTerms = 'or this'
To include a site in the search, execute a query like the following:
SELECT * FROM ImageSearch WHERE SearchTerms = 'technology' AND Site = 'https://wikipedia.com/'
Likewise, to exclude a site from the search, execute a query like the following:
SELECT * FROM ImageSearch WHERE SearchTerms = 'technology' AND Site != 'https://wikipedia.com/'
Google search has an aggregate function called TotalResults() that is similar like Count(*).
TotalResults() can be used if you want to get the number of result based on your query.
The Google Search API limits the number of item returned to 100 so count(*) will not be the actual number of search results.
SELECT TotalResults() FROM ImageSearch WHERE SearchTerms = 'ancient artifact'
Columns
| Name | Type | References | Description |
| SearchTerms | String | The search expression. | |
| Title | String | The title of the search result, in plain text. | |
| HtmlTitle | String | The title of the search result, in HTML. | |
| Link | String | The full URL the search result points to. | |
| DisplayLink | String | An abridged version of the search result URL. | |
| Snippet | String | The snippet of the search result, in plain text. | |
| HtmlSnippet | String | The snippet of the search result, in HTML. | |
| ImageWidth | Integer | The width of the image in pixels. | |
| ImageHeight | Integer | The height of the image in pixels. | |
| Size | Integer | The size of the image in bytes. | |
| ImageThumbnail | String | The link to the thumbnail. | |
| ImageContext | String | The URL of the web page hosting the image. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| TraditionalChineseSearch | Boolean | Enable or disable searches in both Simplified and Traditional Chinese Search. | |
| CountryRestrictions | String | Restrict search results to documents originating in a particular country. This input accepts ISO 3166 2-digit codes. | |
| Date | Datetime | Filter events created after this date. | |
| FileType | String | Filter the results to match the specified file types. | |
| DuplicateFilter | Boolean | Turn on or off the duplicate content filter. | |
| Geolocation | String | Focus the search to a two-letter country code. | |
| UserInterfaceLanguage | String | Specify the interface language (host language) of your user interface. | |
| ImageColorType | String | Return images of a specific color type: color, gray, or mono.
The allowed values are color, gray, mono. | |
| ImageDominantColor | String | Return images of a specific dominant color: black, blue, brown, gray, green, pink, purple, teal, white, or yellow.
The allowed values are black, blue, brown, gray, green, pink, purple, teal, white, yellow. | |
| ImageSize | String | Return images of a specific size: huge, icon, large, medium, small, large, xlarge, or xxlarge.
The allowed values are huge, icon, large, medium, small, large, xlarge, xxlarge. | |
| ImageType | String | Return images of a specific type: clipart, face, lineart, news, or photo.
The allowed values are clipart, face, lineart, news, photo. | |
| LinkSite | String | Specify that all search results should contain a link to a particular URL. | |
| LanguageRestrictions | String | Restrict the search results to certain languages. For example: lang_en.
The allowed values are lang_ar, lang_bg, lang_ca, lang_cs, lang_da, lang_de, lang_el, lang_en, lang_es, lang_et, lang_fi, lang_fr, lang_hr, lang_hu, lang_id, lang_is, lang_it, lang_iw, lang_ja, lang_ko, lang_lt, lang_lv, lang_nl, lang_no, lang_pl, lang_pt, lang_ro, lang_ru, lang_sk, lang_sl, lang_sr, lang_sv, lang_tr, lang_zh-cn, lang_zh-tw. | |
| RelatedSite | String | Include results that have a URL to the specified related URL. | |
| Rights | String | Filter results based on the reserved rights: cc_publicdomain, cc_attribute, cc_sharealike, cc_noncommercial, or cc_nonderived.
The allowed values are cc_publicdomain, cc_attribute, cc_sharealike, cc_noncommercial, cc_nonderived. | |
| SearchSafety | String | Search safety level: high, medium, or off.
The allowed values are high, medium, off. | |
| Site | String | Restrict all search results to pages from the specified site. |