← back to Eur Recrawl

_mirror_query.sql

2 lines

copy (select coalesce(json_object_agg(sku, json_build_array(shopify_id, mfr_sku)),'{}'::json)
from shopify_products where sku in ('EUR-80417-Sample','EUR-80577-Sample','EUR-90358-Sample','EUR-70168-Sample','EUR-70558-Sample','EUR-90415-Sample','EUR-90530-Sample','EUR-70210-Sample','EUR-70074-Sample','EUR-70279','EUR-70319-Sample','EUR-70330-Sample','EUR-70378-Sample','EUR-70485-Sample','EUR-70655-Sample','EUR-70727-Sample','EUR-70916-Sample','EUR-70953-Sample','EUR-70063-Sample','EUR-70072-Sample','EUR-80514-Sample','EUR-70560-Sample','EUR-70799-Sample','EUR-71372-Sample','EUR-90091-Sample','EUR-90412-Sample','EUR-70820','EUR-80759-Sample','EUR-90261-Sample','EUR-70520-Sample','EUR-70962-Sample','EUR-70966-Sample','EUR-80555-Sample','EUR-90088-Sample','EUR-70472','EUR-71365-Sample','EUR-80143-Sample','EUR-80145-Sample','EUR-80670-Sample','EUR-70067-Sample','EUR-70400-Sample','EUR-70793-Sample','EUR-80483-Sample','EUR-80557-Sample','EUR-70318-Sample','EUR-70354-Sample','EUR-70377','EUR-70388-Sample','EUR-70910-Sample','EUR-80506-Sample','EUR-80513-Sample','EUR-80750-Sample','EUR-80547-Sample','EUR-90325-Sample','EUR-80760-Sample','EUR-70521-Sample','EUR-70679-Sample','EUR-70779','EUR-70903-Sample','EUR-71005-Sample','EUR-80677-Sample','EUR-80710-Sample','EUR-80146-Sample','EUR-80485-Sample','EUR-80580-Sample','EUR-80697-Sample','EUR-80543-Sample','EUR-70213-Sample','EUR-70657-Sample','EUR-70784-Sample','EUR-70794-Sample','EUR-70513-Sample','EUR-70729','EUR-80144-Sample','EUR-80686-Sample','EUR-80713-Sample','EUR-90252-Sample','EUR-70143-Sample','EUR-90090-Sample','EUR-70968-Sample','EUR-71335-Sample','EUR-90416-Sample','EUR-90523-Sample','EUR-70698-Sample','EUR-70738','EUR-70838-Sample','EUR-71381-Sample','EUR-80515-Sample','EUR-80752-Sample','EUR-80479-Sample','EUR-80579-Sample','EUR-90265-Sample','EUR-70865-Sample','EUR-70824-Sample','EUR-70973-Sample','EUR-80507-Sample','EUR-80672-Sample','EUR-80704-Sample','EUR-90170-Sample','EUR-70358','EUR-70474-Sample','EUR-70562-Sample','EUR-71367-Sample','EUR-90375-Sample','EUR-90556-Sample','EUR-70591','EUR-70900-Sample','EUR-70328-Sample','EUR-70351-Sample','EUR-70419-Sample','EUR-70456','EUR-70462-Sample','EUR-70599-Sample','EUR-90092-Sample','EUR-90279-Sample','EUR-90280-Sample','EUR-90413-Sample','EUR-70012-Sample','EUR-70167-Sample','EUR-70522-Sample','EUR-70593','EUR-70678-Sample','EUR-71004-Sample','EUR-80535-Sample','EUR-80682-Sample','EUR-80762-Sample','EUR-90257-Sample','EUR-90264-Sample','EUR-90354-Sample','EUR-90373-Sample','EUR-70144-Sample','EUR-71340-Sample','EUR-70376','EUR-70559-Sample','EUR-80508-Sample','EUR-80610-Sample','EUR-90262-Sample','EUR-70015-Sample','EUR-90253-Sample','EUR-70084-Sample','EUR-70434-Sample','EUR-70588-Sample','EUR-70606-Sample','EUR-70638-Sample','EUR-70640-Sample','EUR-70951-Sample','EUR-71371-Sample','EUR-80478-Sample','EUR-80540-Sample','EUR-80595-Sample','EUR-80669-Sample','EUR-90196-Sample','EUR-90371-Sample','EUR-70016-Sample','EUR-70061-Sample','EUR-70170-Sample','EUR-70538-Sample','EUR-80674-Sample','EUR-90326-Sample','EUR-90529-Sample','EUR-70379-Sample','EUR-70383-Sample','EUR-70435-Sample','EUR-70690-Sample','EUR-70693-Sample','EUR-70786-Sample','EUR-70809','EUR-71358-Sample','EUR-70705-Sample','EUR-70715-Sample','EUR-70896-Sample','EUR-71361-Sample','EUR-80537-Sample','EUR-90355-Sample','EUR-70017-Sample','EUR-70070-Sample','EUR-70276-Sample','EUR-70384-Sample','EUR-70548','EUR-80147-Sample','EUR-90383-Sample','EUR-90510-Sample','EUR-90384-Sample','EUR-70207-Sample','EUR-70212-Sample','EUR-80474-Sample','EUR-80487-Sample','EUR-80486-Sample','EUR-80505-Sample','EUR-80516-Sample','EUR-80517-Sample','EUR-80761-Sample','EUR-80608-Sample','EUR-80532-Sample','EUR-80536-Sample','EUR-80541-Sample','EUR-80548-Sample','EUR-80545-Sample','EUR-80552-Sample','EUR-80550-Sample','EUR-80554-Sample','EUR-80558-Sample','EUR-80620-Sample','EUR-80578-Sample','EUR-80744-Sample','EUR-80747-Sample','EUR-80671-Sample','EUR-80676-Sample','EUR-80753-Sample','EUR-80751-Sample','EUR-80756-Sample','EUR-80683-Sample','EUR-80681-Sample','EUR-80703-Sample','EUR-80709-Sample','EUR-80711-Sample','EUR-80712-Sample','EUR-80732-Sample','EUR-90277-Sample','EUR-90282-Sample','EUR-90169-Sample','EUR-90089-Sample','EUR-90094-Sample','EUR-90195-Sample','EUR-90097-Sample','EUR-90324-Sample','EUR-90193-Sample','EUR-90197-Sample','EUR-90414-Sample','EUR-90357-Sample','EUR-90437-Sample','EUR-90386-Sample','EUR-90254-Sample','EUR-90258-Sample','EUR-90263-Sample','EUR-90410-Sample','EUR-70169-Sample','EUR-70014-Sample','EUR-70018-Sample','EUR-90494-Sample','EUR-70047-Sample','EUR-90517-Sample','EUR-90518-Sample','EUR-90522-Sample','EUR-70064-Sample','EUR-90520-Sample','EUR-70209-Sample','EUR-90524-Sample','EUR-70069-Sample','EUR-70073-Sample','EUR-90528-Sample','EUR-70085-Sample','EUR-70353-Sample','EUR-70360-Sample','EUR-70363-Sample','EUR-70314-Sample','EUR-70369-Sample','EUR-70316-Sample','EUR-70320-Sample','EUR-70373-Sample','EUR-70372-Sample','EUR-70374-Sample','EUR-70331-Sample','EUR-70381-Sample','EUR-70341-Sample','EUR-70385-Sample','EUR-70386-Sample','EUR-70389-Sample','EUR-70508-Sample','EUR-70622-Sample','EUR-70510-Sample','EUR-70519-Sample','EUR-70399-Sample','EUR-70402-Sample','EUR-70629-Sample','EUR-70641-Sample','EUR-70537-Sample','EUR-70649-Sample','EUR-70541-Sample','EUR-70540-Sample','EUR-70654-Sample','EUR-70658-Sample','EUR-70561-Sample','EUR-70433-Sample','EUR-70579-Sample','EUR-70586-Sample','EUR-70455','EUR-70597-Sample','EUR-70607-Sample','EUR-70603-Sample','EUR-70694-Sample','EUR-70611-Sample','EUR-70609-Sample','EUR-70464-Sample','EUR-70465-Sample','EUR-70696-Sample','EUR-70699-Sample','EUR-70701-Sample','EUR-70703-Sample','EUR-70708-Sample','EUR-70858-Sample','EUR-70706-Sample','EUR-70863-Sample','EUR-70866-Sample','EUR-70869-Sample','EUR-70766-Sample','EUR-70770-Sample','EUR-70718-Sample','EUR-70720-Sample','EUR-70874-Sample','EUR-70785-Sample','EUR-70787-Sample','EUR-70876-Sample','EUR-70877-Sample','EUR-70885-Sample','EUR-70887-Sample','EUR-70792-Sample','EUR-70797-Sample','EUR-70897-Sample','EUR-70807','EUR-70899-Sample','EUR-70747-Sample','EUR-70904-Sample','EUR-70906-Sample','EUR-70812-Sample','EUR-70908-Sample','EUR-70913-Sample','EUR-70818','EUR-70917-Sample','EUR-70827-Sample','EUR-70959-Sample','EUR-70961-Sample','EUR-70976','EUR-70978','EUR-71007-Sample','EUR-71342-Sample','EUR-71359-Sample','EUR-71362-Sample','EUR-71366-Sample','EUR-71368-Sample','EUR-71376-Sample','EUR-71378-Sample','EUR-71380-Sample','EUR-71385-Sample','EUR-71388-Sample','EUR-70977','EUR-71389-Sample','EUR-70859-Sample','EUR-70790-Sample','EUR-70322-Sample','EUR-70960-Sample','EUR-70950-Sample','EUR-70952-Sample','EUR-80512-Sample','EUR-80556-Sample','EUR-80539-Sample','EUR-80544-Sample','EUR-80678-Sample','EUR-80680-Sample','EUR-80685-Sample','EUR-80698-Sample','EUR-80729-Sample','EUR-80714-Sample','EUR-80749-Sample','EUR-80748-Sample','EUR-80755-Sample','EUR-80742-Sample','EUR-80757-Sample','EUR-80675-Sample','EUR-70808','EUR-90093-Sample','EUR-90095-Sample','EUR-90159-Sample','EUR-90259-Sample','EUR-90192-Sample','EUR-90198-Sample','EUR-90255-Sample','EUR-90267-Sample','EUR-90276-Sample','EUR-90281-Sample','EUR-90372-Sample','EUR-90327-Sample','EUR-90374-Sample','EUR-90411-Sample','EUR-90370-Sample','EUR-90417-Sample','EUR-70840-Sample','EUR-90493-Sample','EUR-90511-Sample','EUR-90521-Sample','EUR-90512-Sample','EUR-90531-Sample','EUR-90508-Sample','EUR-70010-Sample','EUR-70011-Sample','EUR-70013-Sample','EUR-70025-Sample','EUR-70062-Sample','EUR-70048-Sample','EUR-70066-Sample','EUR-70311-Sample','EUR-70315-Sample','EUR-70375','EUR-70333-Sample','EUR-70362-Sample','EUR-70364-Sample','EUR-70321-Sample','EUR-70355','EUR-70365-Sample','EUR-70420-Sample','EUR-70366-Sample','EUR-70368-Sample','EUR-70370-Sample','EUR-70371-Sample','EUR-70390-Sample','EUR-70357','EUR-70359','EUR-70361-Sample','EUR-70421-Sample','EUR-70380-Sample','EUR-70382-Sample','EUR-70431-Sample','EUR-70475','EUR-70473-Sample','EUR-70487-Sample','EUR-70501-Sample','EUR-70525-Sample','EUR-70503-Sample','EUR-70496-Sample','EUR-70536-Sample','EUR-70539-Sample','EUR-70608-Sample','EUR-70610-Sample','EUR-70627-Sample','EUR-70642-Sample','EUR-70704-Sample','EUR-70687','EUR-70689','EUR-70695-Sample','EUR-70746-Sample','EUR-70749-Sample','EUR-70772-Sample','EUR-70776','EUR-70967-Sample','EUR-70892-Sample','EUR-70907-Sample','EUR-70911-Sample','EUR-71341-Sample','EUR-71363-Sample','EUR-71377-Sample','EUR-71370-Sample','EUR-71379-Sample','EUR-71382-Sample','EUR-71387-Sample','EUR-80754-Sample','EUR-90108-Sample','EUR-70598-Sample','EUR-70524-Sample','EUR-70782-Sample','EUR-71217-Sample','EUR-70902-Sample','EUR-70905-Sample','EUR-70912-Sample','EUR-71360-Sample','EUR-70447-Sample','EUR-70918-Sample','EUR-70750-Sample','EUR-90509-Sample','EUR-80480-Sample','EUR-70175-Sample','EUR-80702-Sample','EUR-90519-Sample','EUR-70273-Sample','EUR-70731-Sample','EUR-80745-Sample','EUR-90087-Sample','EUR-70019-Sample','EUR-90527-Sample','EUR-70142-Sample','EUR-70509-Sample','EUR-70512-Sample','EUR-70592','EUR-70796-Sample','EUR-70889-Sample','EUR-80553-Sample','EUR-80609-Sample','EUR-71384-Sample','EUR-70071-Sample','EUR-70174-Sample','EUR-70880-Sample','EUR-70914-Sample','EUR-90260-Sample','EUR-90283-Sample','EUR-90369-Sample','EUR-90526-Sample','EUR-70060-Sample','EUR-70432-Sample','EUR-70436','EUR-70620-Sample','EUR-70741','EUR-70789-Sample','EUR-70890-Sample','EUR-70535-Sample','EUR-90256-Sample','EUR-90438-Sample','EUR-70778','EUR-80746-Sample','EUR-70915-Sample','EUR-70024-Sample','EUR-70068-Sample','EUR-70391-Sample','EUR-90275-Sample','EUR-70768-Sample','EUR-70624-Sample','EUR-70651-Sample','EUR-70802-Sample','EUR-70909-Sample','EUR-80542-Sample','EUR-70312-Sample','EUR-70466-Sample','EUR-90385-Sample','EUR-70595-Sample','EUR-70650-Sample','EUR-70791-Sample','EUR-71006-Sample','EUR-70049-Sample','EUR-70726-Sample','EUR-80533-Sample','EUR-80551-Sample','EUR-70356','EUR-70596-Sample','EUR-70511-Sample','EUR-70836')) to stdout;