Return to Question

Rollback to Revision 3

edited Jul 19, 2014 at 21:55

145.5k
22
190
479

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
GROUP BY B.title
LIMIT 0, 30

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
GROUP BY B.title
LIMIT 0, 30

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
LIMIT 0, 30

added 22 characters in body

Source Link

edited Jul 19, 2014 at 21:55

Sina Bizbone

edited Jul 19, 2014 at 21:55

Sina Bizbone

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
GROUP BY B.title
LIMIT 0, 30

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
LIMIT 0, 30

SELECT B.title, COUNT(*) AS NUM 
FROM library.PhysicalInfo A 
LEFT JOIN library.BibliographicInfo B 
 ON A.BookID = B.BibliographicInfoID 
LEFT JOIN library.authors C 
 ON B.BibliographicInfoID = C.BookID 
LEFT JOIN library.BookAuthors D 
 ON C.BookAuthorID = D.PersonID 
LEFT JOIN library.series E 
 ON B.BibliographicInfoID = E.BookID 
LEFT JOIN library.BooksLocation F 
 ON A.location = F.BookLocationID 
LEFT JOIN library.PublishStatement G 
 ON B.BibliographicInfoId=G.BookID 
LEFT JOIN library.publisher H 
 ON G.PublisherID = H.PublisherID 
WHERE ( B.title LIKE '%سلام%' OR 
 D.name LIKE '%سلام%' OR 
 F.location LIKE '%سلام%' OR 
 G.place LIKE '%سلام%' OR 
 G.year LIKE '%سلام%' OR 
 H.name LIKE '%سلام%' ) 
GROUP BY B.title
LIMIT 0, 30