Vyhledat sortiment podle obrázku pomocí AI?
Náhled schránky
Moje poslední hledané obrázky
0 Cart : 0,00 EUR incl. VAT
EN:
r Home 8 Categories 7 Menu s Search g Cart
SELECT TOP (20) TargetTerm, RepresentativeId, Pocet, PosledniHledani FROM ( SELECT TargetTerm, MAX(CASE WHEN RowNumInGroup = 1 THEN ID END) AS RepresentativeId, COUNT(id) AS Pocet, MAX(CAS) AS PosledniHledani FROM ( SELECT ID, TargetTerm, CAS, ROW_NUMBER() OVER (PARTITION BY TargetTerm ORDER BY CAS DESC, ID DESC) AS RowNumInGroup FROM [dbo].[IB_SEARCHED] WITH (NOLOCK) WHERE ZAZNAMU > 0 AND CISLO_IB = 1 AND Visible = 1 AND JAZYK = 1 AND IdUser IN ('-1') AND TargetTerm IS NOT NULL AND TargetTerm <> '' AND LEN(LTRIM(RTRIM(TargetTerm))) >= 2 AND CAS >= DATEADD(DAY, -90, GETDATE()) ) Filtered GROUP BY TargetTerm ) Grouped ORDER BY PosledniHledani DESC, Pocet DESC