Quote:
|
Originally Posted by woj
400....
This 400 spot sponsored by:
 |
I got this error
Got error 28 from storage engine
002
SELECT scenesDB.sceneID,scenesDB.name,scenesDB.nickname,s cenesDB.age,scenesDB.height,scenesDB.weight,scenes DB.measurements,scenesDB.story,scenesDB.folderName ,scenesDB.minVideo,scenesDB.moviePics,scenesDB.num Pics,scenesDB.searchKeys,scenesDB.websiteURL,siteS cenes.ssID,siteScenes.sceneNum,siteScenes.schedSta rt,siteScenes.story,siteScenes.nickname,siteScenes .currentlyFeat,siteScenes.pageClass,siteScenes.loc kClass,siteScenes.votes FROM siteScenes LEFT JOIN scenesDB ON scenesDB.sceneID=siteScenes.sceneID LEFT JOIN cGroups ON scenesDB.cgID=cGroups.cgID LEFT JOIN cgPermissions ON cGroups.cgID=cgPermissions.cgID LEFT JOIN sites ON cgPermissions.siteID=sites.siteID WHERE siteScenes.status='active' AND sites.siteID=1 ORDER BY siteScenes.totalClicks DESC LIMIT 10
simpleQuery ("siteScenes LEFT JOIN scenesDB ON scenesDB.sceneID=siteScenes.sceneID LEFT JOIN cGroups ON scenesDB.cgID=cGroups.cgID LEFT JOIN cgPermissions ON cGroups.cgID=cgPermissions.cgID LEFT JOIN sites ON cgPermissions.siteID=sites.siteID","scenesDB.scene ID,scenesDB.name,scenesDB.nickname,scenesDB.age,sc enesDB.height,scenesDB.weight,scenesDB.measurement s,scenesDB.story,scenesDB.folderName,scenesDB.minV ideo,scenesDB.moviePics,scenesDB.numPics,scenesDB. searchKeys,scenesDB.websiteURL,siteScenes.ssID,sit eScenes.sceneNum,siteScenes.schedStart,siteScenes. story,siteScenes.nickname,siteScenes.currentlyFeat ,siteScenes.pageClass,siteScenes.lockClass,siteSce nes.votes","WHERE siteScenes.status='active' AND sites.siteID=1","ORDER BY siteScenes.totalClicks DESC LIMIT 10")