sqls.asin.x.sql Maven / Gradle / Ivy
The newest version!
-- noinspection SqlDialectInspectionForFile
-- noinspection SqlResolveForFile
-- noinspection SqlNoDataSourceInspectionForFile
select
dom_first_text(dom, '#productTitle') as `title`,
dom_first_text(dom, '#price tr td:contains(List Price) ~ td') as `listprice`,
dom_first_text(dom, '#price tr td:matches(^Price) ~ td, #price_inside_buybox') as `price`,
array_join_to_string(dom_all_texts(dom, '#wayfinding-breadcrumbs_container ul li a'), '|') as `categories`,
dom_base_uri(dom) as `baseUri`
from
load_and_select('https://www.amazon.com/dp/B0C1H26C46', ':root')