Facebook
From Voluminous Marmoset, 1 Year ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 164
  1. 1.SELECT k.Tytul, CONCAT(a.Imie," ",a.Nazwisko) AS Dane FROM ksiazki AS k INNER JOIN autorzy AS a ON k.AutorID = a.IDAutor
  2. 2.SELECT ksiazki.Wydawnictwo ,CONCAT("(",COUNT(Wydawnictwo),")") AS Pole FROM ksiazki GROUP BY Wydawnictwo
  3. 3.SELECT e.IDEgzemplarz, k.Tytul, CONCAT(a.Imie," ",a.Nazwisko) AS Dane
  4. FROM ksiazki AS k
  5. INNER JOIN autorzy AS a
  6. ON k.AutorID = a.IDAutor
  7. INNER JOIN egzemplarze as e
  8. ON k.IDKsiazki=e.KsiazkaID
  9. WHERE e.DoWypozyczenia=1
  10. Order BY Tytul,Dane
  11. 4.SELECT ksiazki.Wydawnictwo FROM ksiazki GROUP BY Wydawnictwo
  12. 5.SELECT e.IDEgzemplarz, k.Tytul, CONCAT(a.Imie," ",a.Nazwisko) AS Dane
  13. FROM ksiazki AS k
  14. INNER JOIN autorzy AS a
  15. ON k.AutorID = a.IDAutor
  16. INNER JOIN egzemplarze as e
  17. ON k.IDKsiazki=e.KsiazkaID
  18. WHERE e.DoWypozyczenia=0
  19. Order BY Tytul,Dane

Replies to Untitled rss

Title Name Language When
Re: Untitled Soiled Macaque text 1 Year ago.