All Downloads are FREE. Search and download functionalities are using the official Maven repository.

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')




© 2015 - 2024 Weber Informatics LLC | Privacy Policy