Facebook

eeee safest cryptocurrency exchange

From Ja, 1 Month ago, written in Plain Text.
URL https://pastebin.pl/view/772fb736
Embed
Download Paste or View Raw
Hits: 129
  1. SELECT  
  2.     Name,
  3.     IFNULL(ProductCount, 0) AS Liczebność,
  4.     IFNULL(MinDate, 'Brak danych') AS DATA
  5. FROM
  6.     productcategory
  7. LEFT JOIN (
  8.     SELECT
  9.         COUNT(*) AS ProductCount,
  10.         CategoryId
  11.     FROM
  12.         product
  13.     GROUP BY
  14.         CategoryId
  15. ) AS CategoryCount ON CategoryCount.CategoryId = productcategory.Id
  16. LEFT JOIN (
  17.     SELECT
  18.         MIN(OrderDate) as MinDate,
  19.         product.CategoryId
  20.     FROM
  21.         orders
  22.     INNER JOIN
  23.         orderdetails ON orderdetails.OrderId = orders.Id
  24.     INNER JOIN
  25.         product ON product.Id = orderdetails.ProductId
  26.     GROUP BY
  27.         product.CategoryId
  28. ) AS Orders ON Orders.CategoryId = productcategory.Id;

Reply to "eeee"