SELECT
state.title AS statetitle,
city.title AS citytitle ,
agencies.Fullaganyname AS agenciesFullaganyname ,
recordLog.bookptitle AS recordLogbookptitle ,
recordLog.pubperntitle AS recordLogpubperntitle ,
bookDetails.name AS bookDetailsname ,
bookDetails.id AS bookDetailsid
FROM WordsState AS state,
WordsCity AS city
, WordsShopAgencyCenter AS agencies
, IOLog_AgancyCenter AS recordLog
, WordsBookDetail AS bookDetails
WHERE state.id=recordLog.agancystateid
AND city.id=recordLog.agancycityid
AND agencies.id=recordLog.ShopAgencyCenterid
AND bookDetails.id=recordLog.bid
LIMIT 0,20
|
Download
