• Home
• ai.platon.pulsar
• pulsar-client
• 1.13.1
• source code
• asin.x.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sqls.asin.x.sql Maven / Gradle / Ivy

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