Notes

-- HAKAN SCRAPY DB
SELECT * FROM customerdata.price_category_list where retailer_name = 'Flip';

SELECT * FROM merged_crawling.product_dynamic_hourly_partitioned WHERE retailer_name = 'Flip' and crawling_date = '2022-01-10'order by crawling_timestamp desc
--and not product_availability;

select retailer_name, product_availability, count(distinct product_id) from merged_crawling.product_dynamic_hourly_partitioned where crawling_date = '2021-09-23' and retailer_name = 'Ozon' group by retailer_name, product_availability;

SELECT * FROM crawling.marketplace_scores where retailer like 'Ciceksepeti' order by crawling_timestamp DESC
SELECT * FROM crawling.marketplace_scores where crawling_timestamp > '2021-10-15'ORDER BY crawling_timestamp DESC;
SELECT * FROM content.product where retailer like '%Trendyol%'
select * from merged_crawling.product_dynamic_hourly_partitioned where retailer_name = 'İstegelsin' and crawling_date ='2022-01-10'

select * from customerdata.marketplace_scope where merchant_name_repr = 'Trendyol';
SELECT * FROM crawling.category_position where keyword_name = 'kraker';
--VISSSSSSSSSS
SELECT keyword_name, count(*)
FROM crawling.category_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
WHERE retailer_name IN ('Sbermarket') and crawling_timestamp > '2022-01-14 20:20:57.088037'
GROUP BY keyword_name;

SELECT keyword_name, count(*)
FROM crawling.search_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
WHERE retailer_name IN ('Sbermarket') and crawling_timestamp > '2022-01-14 20:20:57.088037'
GROUP BY keyword_name;

SELECT * FROM merged_crawling.sku_details


SELECT * FROM merged_crawling.product_dynamic_hourly_partitioned pdhp
INNER JOIN validation.product_barcode_sku_matching pbsm
ON pbsm.product_id = pdhp.product_id AND pbsm.retailer_name = pdhp.retailer_name
INNER JOIN merged_crawling.sku_details sd
ON sd.sku_id = pbsm.sku_id
where pbsm.retailer_name = 'Amazon'
and sd.brand_name = 'eti'
and pdhp.crawling_date = validation.today()
and pdhp.product_availability;



SELECT * FROM crawling.marketplace_scores where retailer like '%epeti%' ORDER BY crawling_timestamp DESC;


SELECT keyword_name, count(*)
FROM crawling.search_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
INNER JOIN vp
on vp.retailer = m.retailer_name
and vp.product_id = m.product_id
WHERE retailer_name IN ('Amazon') and s.crawling_timestamp > '2021-10-01 11:44:57.088037'
and keyword_name in ('meyveli kek', 'mini', 'kek', 'çikolatalı kek', 'çikolata', 'bitter çikolata', 'beyaz çikolata',
'fıstıklı çikolata',
'bisküvi', 'kremalı bisküvi', 'yulaflı bisküvi', 'kepekli bisküvi', 'gofret',
'çikolatalı gofret', 'kraker',
'tuzlu kraker', 'diyet kraker', 'baharatlı kraker', 'çubuk kraker', 'peynirli kraker', 'kek',
'kraker')
GROUP BY keyword_name;

SELECT keyword_name, count(distinct vp.product_id)
FROM crawling.search_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
INNER JOIN crawling.visibility_products vp
on vp.retailer = m.retailer_name
and vp.product_id = m.product_id
WHERE retailer_name IN ('Amazon') and s.crawling_timestamp > '2021-10-01 14:50:57.088037'
and keyword_name in ('meyveli kek', 'mini', 'kek', 'çikolatalı kek', 'çikolata', 'bitter çikolata', 'beyaz çikolata',
'fıstıklı çikolata',
'bisküvi', 'kremalı bisküvi', 'yulaflı bisküvi', 'kepekli bisküvi', 'gofret',
'çikolatalı gofret', 'kraker',
'tuzlu kraker', 'diyet kraker', 'baharatlı kraker', 'çubuk kraker', 'peynirli kraker', 'kek',
'kraker')
GROUP BY keyword_name;

SELECT retailer_name, product_availability, count(DISTINCT product_id) AS prev_hour_count
FROM merged_crawling.product_dynamic_hourly_partitioned
WHERE crawling_timestamp >= date_trunc('hour', now() - interval '1 hour')
AND crawling_timestamp < date_trunc('hour', now())
AND crawling_date = validation.today()
GROUP BY retailer_name, product_availability;

SELECT *
FROM crawling.category_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
-- INNER JOIN crawling.visibility_products vp
-- on vp.retailer = m.retailer_name
-- and vp.product_id = m.product_id
WHERE retailer_name IN ('Sbermarket') and s.crawling_timestamp > '2022-01-14 20:20:57.088037'
ORDER BY crawling_timestamp DESC;

SELECT *
FROM crawling.search_position s
INNER JOIN crawling.mindsite_ids m
ON m.mindsite_id = s.mindsite_id
-- INNER JOIN crawling.visibility_products vp
-- on vp.retailer = m.retailer_name
-- and vp.product_id = m.product_id
WHERE retailer_name IN ('Arbuz')
ORDER BY crawling_timestamp DESC;

SELECT * FROM crawling.search_position ORDER BY crawling_timestamp DESC;
SELECT * FROM crawling.category_position where retailer_name = 'Sbermarket' ORDER BY crawling_timestamp DESC;
SELECT * FROM crawling.visibility_products_staging where retailer = 'Sbermarket' ORDER BY crawling_timestamp DESC;
--and crawling_timestamp < '2021-10-06 11:03:57.088037'

select * from crawling_info.visibility_input where visibility_type = 'category' and retailer = 'Ozon'

SELECT sdp.mindsite_id, keyword_name, category_position, product_price, vp.* FROM crawling.category_position sdp
INNER JOIN crawling.mindsite_ids mids ON sdp.mindsite_id = mids.mindsite_id
LEFT JOIN crawling.visibility_products vp on vp.retailer = mids.retailer_name and vp.product_id = mids.product_id
where retailer like 'Eva' order BY crawling_timestamp DESC; --and sdp.crawling_timestamp > '2021-10-05 16:20:51.647488';

select retailer,brand,category,subcategory,category_type,product_url,product_id,server_id,
insertion_timestamp
FROM crawling_info.price_product_url_input
WHERE retailer;
select * from token_dispense.token_list
SELECT *
FROM crawling_info.price_product_url_input
WHERE retailer = 'Ciceksepeti';
{"accessToken": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbmNyeXB0ZWREYXRhIjoidXFCYUpSZmFIM08vSWZwQUVONnU5dlJrcXByZlQyMHJjZlBPQk05d1JIVzNIYlRzVjB3dis0U3Z1Sng2M29hTC91UWFpVjhVcU1CdUdsNXIvdFBobUpHRHVqejdyK0syeFVWN0F1REJkK0VBMDhtRDIzN0RoZ2l0Ry9ER1BUR3c0WVM0ZG1oSWlTMVZjRldoZG1FVngwcHVWbVhuTVFhaVVxQTRRanhmcmx0ZFo4cUw3ZlpIam0zMjJiMGdoYXRFRmE2TnFkL05HQzk5OWxhekNLU28yVmlRQmRTREQ4elhtUUtqajU3V0g3RDZEUUUrV0gzdDBFemNXQlJFcWRwT3p6UUdkS2RYYjY1MllZcFhhZlkxTXc9PSIsImlhdCI6MTY0MTk4MDIzNCwiZXhwIjoxNjQyMDA5MDM0LCJpc3MiOiJhdXRoLXNlcnZpY2UifQ.QgDCACSVETHiQEWUzhTGC37L9T0leSC3USI357xEO0c", "refreshToken": "252043ca-7256-4f05-bbeb-3672f575b07e", "category_token": "nqVjb0t1pi3CbGL12Bf7q", "promotions_token": "eyJ2IjpbMCwxXSwiZCI6eyJ0eSI6IkJyb3dzZXIiLCJhYyI6IjE0NjAxNzEiLCJhcCI6Ijc0NTI2OTA0NSIsImlkIjoiNzUyYzFjNTNmMWZhNzZiZSIsInRyIjoiYmM5NGVhZTUyNmNhZDU1ZjYwOWFlN2FjYjI5ZDBmMTAiLCJ0aSI6MTY0MTk5MTc4MzgxOH19", "promotions_cookie": "language=tr; _gat_UA-66449776-5=1; cto_bundle=3X2TYl9JWjZ5amZTRTk1TVFrbUVNeUolMkZzZmtYZHJSTGVTdERaT0JiektVTWI2djVZZzNmSTNwTUdoJTJGSWc5T3BQcEJZalp3ZFBNN21jNWg4VGoyMnRtbFFaWFhGRSUyRmIlMkZ5TkxlYU53OFR5VU5odUVFVDJ4YVhkUGFIODhpVm9TU2J2ZWVmNnJIWVBWcTNxM0clMkJaVFJkbWx4YTI4eUpkdTJmT3h5Slc0a2VPJTJCY0dMNWNlUXNKelRBMDAxWHFDOHZiUTglMkZGdA; _fbp=fb.1.1641980159613.1358732634; ajs_anonymous_id=%22fee2e244-fdb3-4f08-8908-04c69a559d9a%22; _gcl_au=1.1.1111696566.1641980131; appType=GETIR; deviceId=e8e06ff1-9b6d-429d-b94a-1c13f7810be1; language=tr; location=%7B%22lat%22%3A41.0414629%2C%22lon%22%3A29.0046264%2C%22id%22%3A%2261dea16198c7dd84e3be7ec8%22%2C%22name%22%3A%22Ev%22%2C%22createdAt%22%3A%222022-01-12T09%3A37%3A37.489Z%22%2C%22description%22%3A%22123%22%2C%22address%22%3A%22Be%C5%9Fikta%C5%9F%20Cad.%2C%20No%3A2A%22%2C%22aptNo%22%3A%221%22%2C%22doorNo%22%3A%221%22%2C%22floor%22%3A%221%22%2C%22addressType%22%3A1%2C%22emojiId%22%3A19%2C%22emojiURL%22%3A%22https%3A%2F%2Fcdn.getir.com%2Fmisc%2Femoji%2Fhouse.png%22%7D; accessToken=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbmNyeXB0ZWREYXRhIjoidXFCYUpSZmFIM08vSWZwQUVONnU5dlJrcXByZlQyMHJjZlBPQk05d1JIVzNIYlRzVjB3dis0U3Z1Sng2M29hTC91UWFpVjhVcU1CdUdsNXIvdFBobUpHRHVqejdyK0syeFVWN0F1REJkK0VBMDhtRDIzN0RoZ2l0Ry9ER1BUR3c0WVM0ZG1oSWlTMVZjRldoZG1FVngwcHVWbVhuTVFhaVVxQTRRanhmcmx0ZFo4cUw3ZlpIam0zMjJiMGdoYXRFRmE2TnFkL05HQzk5OWxhekNLU28yVmlRQmRTREQ4elhtUUtqajU3V0g3RDZEUUUrV0gzdDBFemNXQlJFcWRwT3p6UUdkS2RYYjY1MllZcFhhZlkxTXc9PSIsImlhdCI6MTY0MTk4MDIzNCwiZXhwIjoxNjQyMDA5MDM0LCJpc3MiOiJhdXRoLXNlcnZpY2UifQ.QgDCACSVETHiQEWUzhTGC37L9T0leSC3USI357xEO0c; refreshToken=252043ca-7256-4f05-bbeb-3672f575b07e; selectedAddressId=61dea16198c7dd84e3be7ec8; userId=61c97dfb7af751f530b82e9b; trueClientIp=109.198.34.96; _gid=GA1.2.1414321270.1641980159; gsm=%7B%22countryCode%22%3A%2290%22%2C%22gsmWithoutCountryCode%22%3A%225434596568%22%7D; isWarehouseRequestSended=false; defaultToken=16419802343336f3a02d536a4121344063c468494fdee351d76d029e756d996bf425f11879b22; trueClientIp=109.198.34.96; appType=GETIR; _ga_1GZP24F3YP=GS1.1.1641983238.2.1.1641991763.60; _ga=GA1.2.1433859409.1641980134", "promotions_cookie_getir_buyuk": "language=tr; _gat_UA-66449776-5=1; cto_bundle=3X2TYl9JWjZ5amZTRTk1TVFrbUVNeUolMkZzZmtYZHJSTGVTdERaT0JiektVTWI2djVZZzNmSTNwTUdoJTJGSWc5T3BQcEJZalp3ZFBNN21jNWg4VGoyMnRtbFFaWFhGRSUyRmIlMkZ5TkxlYU53OFR5VU5odUVFVDJ4YVhkUGFIODhpVm9TU2J2ZWVmNnJIWVBWcTNxM0clMkJaVFJkbWx4YTI4eUpkdTJmT3h5Slc0a2VPJTJCY0dMNWNlUXNKelRBMDAxWHFDOHZiUTglMkZGdA; _fbp=fb.1.1641980159613.1358732634; ajs_anonymous_id=%22fee2e244-fdb3-4f08-8908-04c69a559d9a%22; _gcl_au=1.1.1111696566.1641980131; appType=GETIR; deviceId=e8e06ff1-9b6d-429d-b94a-1c13f7810be1; language=tr; location=%7B%22lat%22%3A41.0414629%2C%22lon%22%3A29.0046264%2C%22id%22%3A%2261dea16198c7dd84e3be7ec8%22%2C%22name%22%3A%22Ev%22%2C%22createdAt%22%3A%222022-01-12T09%3A37%3A37.489Z%22%2C%22description%22%3A%22123%22%2C%22address%22%3A%22Be%C5%9Fikta%C5%9F%20Cad.%2C%20No%3A2A%22%2C%22aptNo%22%3A%221%22%2C%22doorNo%22%3A%221%22%2C%22floor%22%3A%221%22%2C%22addressType%22%3A1%2C%22emojiId%22%3A19%2C%22emojiURL%22%3A%22https%3A%2F%2Fcdn.getir.com%2Fmisc%2Femoji%2Fhouse.png%22%7D; accessToken=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbmNyeXB0ZWREYXRhIjoidXFCYUpSZmFIM08vSWZwQUVONnU5dlJrcXByZlQyMHJjZlBPQk05d1JIVzNIYlRzVjB3dis0U3Z1Sng2M29hTC91UWFpVjhVcU1CdUdsNXIvdFBobUpHRHVqejdyK0syeFVWN0F1REJkK0VBMDhtRDIzN0RoZ2l0Ry9ER1BUR3c0WVM0ZG1oSWlTMVZjRldoZG1FVngwcHVWbVhuTVFhaVVxQTRRanhmcmx0ZFo4cUw3ZlpIam0zMjJiMGdoYXRFRmE2TnFkL05HQzk5OWxhekNLU28yVmlRQmRTREQ4elhtUUtqajU3V0g3RDZEUUUrV0gzdDBFemNXQlJFcWRwT3p6UUdkS2RYYjY1MllZcFhhZlkxTXc9PSIsImlhdCI6MTY0MTk4MDIzNCwiZXhwIjoxNjQyMDA5MDM0LCJpc3MiOiJhdXRoLXNlcnZpY2UifQ.QgDCACSVETHiQEWUzhTGC37L9T0leSC3USI357xEO0c; refreshToken=252043ca-7256-4f05-bbeb-3672f575b07e; selectedAddressId=61dea16198c7dd84e3be7ec8; userId=61c97dfb7af751f530b82e9b; trueClientIp=109.198.34.96; _gid=GA1.2.1414321270.1641980159; gsm=%7B%22countryCode%22%3A%2290%22%2C%22gsmWithoutCountryCode%22%3A%225434596568%22%7D; isWarehouseRequestSended=false; defaultToken=16419802343336f3a02d536a4121344063c468494fdee351d76d029e756d996bf425f11879b22; trueClientIp=109.198.34.96; appType=GETIR_MARKET; _ga_1GZP24F3YP=GS1.1.1641983238.2.1.1641992053.0; _ga=GA1.1.1433859409.1641980134"}
--INPUTSSS
select * from crawling_info.visibility_input where visibility_type = 'category' and retailer in ('Migros Sanalmarket', 'Trendyol', 'Hepsiburada') and url in ('https://www.migros.com.tr/bulasik-makinesi-urunleri-c-488', 'https://www.hepsiburada.com/bulasik-makinasi-tablet-jeller-c-28002654', 'https://www.hepsiburada.com/bulasik-makinasi-tablet-jeller-c-28002654', '0')
SELECT * FROM multilocation.location_input where retailer = 'GetirBüyük'
select * from crawling_info.visibility_input where visibility_type = 'search' and retailer = 'Flip'
select * from crawling_info.visibility_input where visibility_type = 'search' and retailer = 'Sbermarket'
select * from crawling_info.visibility_input where visibility_type = 'category' and retailer = 'Sbermarket'
SELECT * FROM crawling_info.price_input where retailer like '%Ozon%';
SELECT * FROM crawling_info.price_product_url_input where retailer = 'N11'
select * from crawling_info.content_input where retailer = 'N11';
select * from content_masterdata.masterdata where retailer = 'Migros Sanalmarket' and product_id = '20000037550534';
SELECT * FROM crawling_info.marketplace_score_input where retailer like '%sepeti%';
select * from crawling.visibility_products where retailer = 'Flip'
select * from content_masterdata.masterdata where retailer = 'N11'
-- VIS TOOLn
select * from customerdata.category_list where retailer_name = 'Trendyol' and keyword_name in ('bulaşık deterjanı', 'prezervatif');
select * from customerdata.keyword_list where retailer_name = 'Amazon';
select * from crawling.russia_product_urls where retailer = 'Ostrov' and product_id ='460614400734'
select * from crawling.russia_product_urls replace(product_url, 'ostrov-shop', 'zhs')
UPDATE
crawling_info.price_input
SET
category_url --- = REPLACE(category_url, 'ostrov-shop', 'zhs')
where category_url like '%ostrov-shop%'




SELECT * FROM crawling.search_position_reduce();
SELECT * FROM crawling.category_position_reduce();
SELECT * FROM crawling.visibility_products_upsert();
select * from crawling.visibility_products where retailer = 'Sbermarket' order by crawling_timestamp = '2022-01-18';
SELECT distinct product_id FROM crawling_info.russia_crawled_ids
WHERE retailer_name = 'Flip'
--where brand = 'palmolive men'
SELECT * FROM crawling.mindsite_ids;
---ALERTTTTTS
SELECT * FROM crawling_health.alerts order by alert_timestamp DESC;


select crawling_health.fix_crawling_alert(ARRAY['Amazon'], 'visibility_crawling');

SELECT * FROM crawling.search_daily_position where retailer_name = 'Getir';
select * from crawling_info.banner_input_view
select * from crawling_info.banner_input

SELECT retailer, crawling_timestamp::date , count(DISTINCT product_id) FILTER ( WHERE result ) FROM content_checks.image
where retailer in ('Flip', 'Arbuz', 'Sbermarket') and crawling_timestamp::date > '2022-01-15'
GROUP BY crawling_timestamp::date, retailer;
--grant all privileges on
select count(DISTINCT product_id) from content_checks.image where retailer = 'Getir Büyük' and crawling_timestamp::date = '2022-01-12'

select * from content_checks.image where retailer ='Flip' and crawling_timestamp::date = '2021-12-25'
--???
select * from crawling.corrupt_data_entry;
select * from customer.customer_users
select * from crawling.visibility_brand_map;
SELECT * FROM crawling_info.ip_map;
SELECT * FROM content_checks.image;

SELECT product_id FROM crawling_info.russia_crawled_ids WHERE retailer_name='Eva'
SELECT * FROM yedek.eti_rakipid_201021 eti
LEFT JOIN crawling.product_crawling_data pcd
ON eti.product_id = pcd.product_id
where pcd.product_id is not null
and source_url is null;

select * from crawling.product_crawling_data where product_id = '30008229';

select * from customer.customer_users;

select * from content.listings_staging;

SELECT * FROM customerdata.price_category_list WHERE retailer_name = 'Wildberries'
SELECT distinct product_id FROM crawling_info.russia_crawled_ids



SELECT * FROM yedek.eti_rakipid_201021 eti
LEFT JOIN crawling.product_crawling_data pcd
ON eti.product_id = pcd.product_id
where pcd.product_id is not null
and source_url is null


-- retailer = 'Carrefour'
-- and crawling_date = '2021-11-17'


SELECT * FROM merged_crawling.product_dynamic_hourly_partitioned where retailer_name = 'Happy Center' and crawling_date = '2021-12-19' and product_availability = false

SELECT * FROM merged_crawling.product_dynamic_hourly_partitioned
WHERE retailer_name = 'Ostrov' and product_id in ('460614400776') and crawling_date in ('2021-12-20', '2021-12-19', '2021-12-18', '2021-12-17') ;

SELECT * FROM crawling.product_crawling_data
where product_title like '%Galaxy M31S Duos 128 GB SM-M317%'
and retailer = 'Ciceksepeti'


SELECT * FROM crawling.product_crawling_data where product_id = '20000037550534'
SELECT * FROM merged_crawling.product_dynamic_hourly_partitioned where crawling_date = validation.today()
and retailer_name = 'Sbermarket'


SELECT distinct product_id FROM validation.product_barcode_sku_matching
where retailer_name = 'Migros Sanalmarket'

SELECT * FROM (
SELECT *
FROM crawling_info.price_product_url_input
where retailer = 'Migros Sanalmarket'
and category like '%getir_091221%'
) ppp
LEFT JOIN crawling.product_crawling_data pcd
ON ppp.category = pcd.category

--2)
SELECT * FROM crawling.product_crawling_data
where product_id
= '20000003118472'
and retailer = 'Migros Sanalmarket'

--3)
SELECT * FROM crawling.product_crawling_data_staging
where product_id = '200000051077858'
and retailer = 'Migros Sanalmarket'

SELECT count(DISTINCT product_id) FROM content.product
WHERE retailer = 'Flip' AND crawling_timestamp::date = '2022-01-18' AND status = 'IN_STOCK' AND product_id IN (SELECT DISTINCT product_id FROM customerdata.colgate_russia_content_masterdata_011221
WHERE subcategory in
(
'зубная щетка',
'жидкое мыло',Ostrov
'зубная паста',
'мыло',
'гель для душа',
'ополаскиватель для полости рта',
'туалетное мыло' ) AND retailer = 'Ostrov' AND is_power_sku)

SELECT count(*) FROM content.product WHERE retailer = 'N11';

SELECT count(DISTINCT status), count(distinct product_id) from content.product where retailer = '' and status= 'IN_STOCK' and crawling_timestamp ='2022-01-15';

--eva ostrov 16

select count(distinct product_id), count(distinct product_availability)from merged_crawling.product_dynamic_hourly_partitioned where retailer_name = 'Flip' and crawling_date < '2021-12-25' group by crawling_date
select count(distinct product_id), count(distinct status)from content.product retailer = 'Ostrov' and crawling_date < '2021-12-20' and crawling_date > '2021-12-12' group by crawling_date

WITH urls AS (
SELECT product_id, retailer_name, bool_or(product_availability) ava FROM merged_crawling.product_dynamic_hourly_partitioned WHERE product_id IN (
SELECT DISTINCT product_barcode_sku_matching.product_id FROM validation.product_barcode_sku_matching
where sku_id in (
SELECT sku_id
FROM validation.sku_details
where brand_name = 'teno'
)) AND crawling_date = '2021-12-16'
GROUP BY product_id, retailer_name)
SELECT DISTINCT u.product_id, u.retailer_name, ava, first_value(mids.link) OVER (PARTITION BY u.product_id, u.retailer_name) FROM urls u
SELECT DISTINCT u.product_id, u.retailer_name, ava, first_value(mids.link) OVER (PARTITION BY u.product_id, u.retailer_name) FROM urls u
LEFT JOIN merged_crawling.mindsite_ids mids
ON mids.retailer_name = u.retailer_name AND mids.product_id = u.product_id order by ava, retailer_name

---rapor cheecck

--arbuz
content: 15<
select * from content.product where retailer = 'N11'


SELECT crawling_date, retailer_name, count(DISTINCT product_id) as total, count(DISTINCT product_id) FILTER ( WHERE product_availability ) as stock_count FROM merged_crawling.product_dynamic_hourly_partitioned
where crawling_date > '2022-01-15' and retailer_name IN ('Flip', 'Arbuz', 'Sbermarket') and product_availability
group by crawling_date, retailer_name;

SELECT crawling_timestamp::date, retailer, count(DISTINCT product_id) as total, count(DISTINCT product_id) as stock_count FROM content.product
where crawling_timestamp::date > '2022-01-15' and retailer IN ('Flip', 'Arbuz', 'Sbermarket')
group by crawling_timestamp::date, retailer
SELECT token_data FROM token_dispense.token_list where retailer = 'Getir'

select count(product_id) as total from content.product where retailer in ('Flip', 'Arbuz', 'Sbermarket') and crawling_timestamp::date = '2022-01-15' group by crawling_timestamp::date