----Log File Rotated--- C:/Program Files/Java/jdk1.6.0\bin\java -client -Xmx512m -XX:NewRatio=2 -XX:MaxPermSize=128m -Dcom.sun.aas.defaultLogFile=C:/Sun/SDK/domains/domain1/logs/server.log -Djava.endorsed.dirs=C:/Sun/SDK/lib/endorsed -Djava.security.policy=C:/Sun/SDK/domains/domain1/config/server.policy -Djava.security.auth.login.config=C:/Sun/SDK/domains/domain1/config/login.conf -Dsun.rmi.dgc.server.gcInterval=3600000 -Dsun.rmi.dgc.client.gcInterval=3600000 -Djavax.net.ssl.keyStore=C:/Sun/SDK/domains/domain1/config/keystore.jks -Djavax.net.ssl.trustStore=C:/Sun/SDK/domains/domain1/config/cacerts.jks -Djava.ext.dirs=C:/Program Files/Java/jdk1.6.0/jre/lib/ext;C:/Sun/SDK/domains/domain1/lib/ext;C:/Sun/SDK/javadb/lib -Djdbc.drivers=org.apache.derby.jdbc.ClientDriver -Djavax.management.builder.initial=com.sun.enterprise.admin.server.core.jmx.AppServerMBeanServerBuilder -Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory -Dcom.sun.enterprise.taglibs=appserv-jstl.jar,jsf-impl.jar -Dcom.sun.enterprise.taglisteners=jsf-impl.jar -Dcom.sun.aas.classloader.optionalOverrideableChain=appserv-ws.jar,commons-logging.jar,commons-launcher.jar -Dcom.sun.aas.classloader.appserverChainJars=admin-cli.jar,admin-cli-ee.jar,dbschema.jar,j2ee-svc.jar -Dcom.sun.aas.classloader.serverClassPath.ee=%HADB_HOME%/lib/hadbjdbc4.jar,C:/Sun/SDK/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,%HADB_HOME%/lib/dbstate.jar,%HADB_HOME%/lib/hadbm.jar,%HADB_HOME%/lib/hadbmgt.jar,C:/Sun/SDK/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar -Dcom.sun.aas.configName=server-config -Ddomain.name=domain1 -Djmx.invoke.getters=true -Dcom.sun.aas.promptForIdentity=true -Dcom.sun.aas.classloader.optionalOverrideableChain.ee= -Dcom.sun.aas.instanceRoot=C:/Sun/SDK/domains/domain1 -Dcom.sun.aas.domainName=domain1 -Dcom.sun.aas.classloader.sharedChainJars=javaee.jar,C:/Program Files/Java/jdk1.6.0/lib/tools.jar,install/applications/jmsra/imqjmsra.jar,commons-launcher.jar,C:/Sun/SDK/imq/lib/jaxm-api.jar,C:/Sun/SDK/imq/lib/fscontext.jar,C:/Sun/SDK/imq/lib/imqbroker.jar,C:/Sun/SDK/imq/lib/imqjmx.jar,C:/Sun/SDK/imq/lib/imqxm.jar,C:/Sun/SDK/lib/ant/lib/ant.jar,appserv-ws.jar,mail.jar,jsf-api.jar,jsf-impl.jar,appserv-jstl.jar,appserv-env.jar,jmxremote_optional.jar,C:/Sun/SDK/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,commons-logging.jar,activation.jar,appserv-rt.jar,appserv-admin.jar,appserv-cmp.jar -Dcom.sun.aas.classloader.sharedChainJars.ee=appserv-se.jar,appserv-ee.jar,%HADB_HOME%/lib/dbstate.jar,%HADB_HOME%/lib/hadbjdbc4.jar,jgroups-all.jar,C:/Sun/SDK/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar -Djava.util.logging.manager=com.sun.enterprise.server.logging.ServerLogManager -Dcom.sun.enterprise.overrideablejavaxpackages=javax.xml.bind,javax.help,javax.portlet -Dcom.sun.aas.classloader.serverClassPath=C:/Sun/SDK/lib/install/applications/jmsra/imqjmsra.jar,C:/Sun/SDK/imq/lib/jaxm-api.jar,C:/Sun/SDK/imq/lib/fscontext.jar,C:/Sun/SDK/imq/lib/imqbroker.jar,C:/Sun/SDK/imq/lib/imqjmx.jar,C:/Sun/SDK/lib/ant/lib/ant.jar,C:/Sun/SDK/lib/SUNWjdmk/5.1/lib/jdmkrt.jar -Dcom.sun.aas.classloader.appserverChainJars.ee= -Dcom.sun.aas.configRoot=C:/Sun/SDK/config -Djava.library.path=C:\Sun\SDK\lib;C:\Sun\SDK\lib;C:\Program Files\Java\jdk1.6.0\bin;.;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\Sun\SDK\lib;C:\Sun\SDK\bin;C:\Sun\SDK\bin;C:\Sun\SDK\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Subversion\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Common Files\Autodesk Shared\;C:\Program Files\Microsoft USB Flash Drive Manager\;C:\Sun\SDK\bin;C:\Sun\AppServer\bin;;C:\Program Files\Fortify Software\SCAS-EE4.0.0;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Subversion\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\QuickTime\QTSystem\;C:\apache-ant-1.6.5\bin;C:\Program Files\Microsoft USB Flash Drive Manager\ -Dcom.sun.aas.instanceName=server -Dcom.sun.aas.processLauncher=SE -Dcom.sun.aas.installRoot=C:/Sun/SDK -Dcom.sun.aas.ClassPathPrefix= -Dcom.sun.aas.ClassPathSuffix=C:\Sun\SDK\addons\accessmanager\amWebServicesProvider.jar;C:\Sun\SDK\addons\accessmanager\amclientsdk.jar;C:\Sun\SDK\domains\domain1\config -Dcom.sun.aas.ServerClassPath= -cp ;C:/Sun/SDK/lib/appserv-launch.jar com.sun.enterprise.server.PELaunch start Starting Sun Java System Application Server Platform Edition 9.0_01 (build b14) ... CORE5098: AS Socket Service Initialization has been completed. CORE5076: Using [Java HotSpot(TM) Client VM, Version 1.6.0-beta] from [Sun Microsystems Inc.] SEC1002: Security Manager is OFF. ADM0001:MBeanServer initialized successfully SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper. sgmt.service_initialized DPL5400:Exception occurred : error in opening zip file. XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 ADM1079: Initialization of AMX MBeans successful ADM1504: Here is the JMXServiceURL for the Standard JMXConnectorServer: [service:jmx:rmi:///jndi/rmi://192.168.1.104:8686/jmxrmi]. This is where the remote administrative clients should connect using the standard JMX connectors ADM1506: Status of Standard JMX Connector: Active = [true] JTS5014: Recoverable JTS instance, serverId = [3700] About to load the system app: MEjbApp LDR5010: All ejb(s) of [MEjbApp] loaded successfully! About to load the system app: __ejb_container_timer_app EJB5109:EJB Timer Service started successfully for datasource [jdbc/__TimerPool] LDR5010: All ejb(s) of [__ejb_container_timer_app] loaded successfully! [TopLink Config]: 2006.11.06 08:16:45.109--ServerSession(9399652)--Thread(Thread[main,5,main])--The alias name for the entity class [class com.schwarcz.enamels.model.Enamel] is being defaulted to: Enamel. [TopLink Config]: 2006.11.06 08:16:45.140--ServerSession(9399652)--Thread(Thread[main,5,main])--The table name for entity [class com.schwarcz.enamels.model.Enamel] is being defaulted to: ENAMEL. [TopLink Config]: 2006.11.06 08:16:45.171--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.Integer com.schwarcz.enamels.model.Enamel.year] is being defaulted to: YEAR. [TopLink Config]: 2006.11.06 08:16:45.171--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Enamel.title] is being defaulted to: TITLE. [TopLink Config]: 2006.11.06 08:16:45.171--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Enamel.descript] is being defaulted to: DESCRIPT. [TopLink Config]: 2006.11.06 08:16:45.187--ServerSession(9399652)--Thread(Thread[main,5,main])--The alias name for the entity class [class com.schwarcz.enamels.model.Exhibition] is being defaulted to: Exhibition. [TopLink Config]: 2006.11.06 08:16:45.187--ServerSession(9399652)--Thread(Thread[main,5,main])--The table name for entity [class com.schwarcz.enamels.model.Exhibition] is being defaulted to: EXHIBITION. [TopLink Config]: 2006.11.06 08:16:45.187--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Exhibition.id] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.Long com.schwarcz.enamels.model.Exhibition.year] is being defaulted to: YEAR. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Exhibition.changedBy] is being defaulted to: CHANGEDBY. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The alias name for the entity class [class com.schwarcz.enamels.model.Showpiece] is being defaulted to: Showpiece. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The table name for entity [class com.schwarcz.enamels.model.Showpiece] is being defaulted to: SHOWPIECE. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.Long com.schwarcz.enamels.model.Showpiece.id] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Showpiece.showId] is being defaulted to: SHOWID. [TopLink Config]: 2006.11.06 08:16:45.203--ServerSession(9399652)--Thread(Thread[main,5,main])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Showpiece.changedBy] is being defaulted to: CHANGEDBY. [TopLink Config]: 2006.11.06 08:16:45.296--ServerSession(9399652)--Thread(Thread[main,5,main])--The target entity (reference) class for the many to many mapping element [private java.util.List com.schwarcz.enamels.model.Enamel.exhibitions] is being defaulted to: class com.schwarcz.enamels.model.Exhibition. [TopLink Config]: 2006.11.06 08:16:45.296--ServerSession(9399652)--Thread(Thread[main,5,main])--The target entity (reference) class for the many to many mapping element [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: class com.schwarcz.enamels.model.Enamel. [TopLink Config]: 2006.11.06 08:16:45.296--ServerSession(9399652)--Thread(Thread[main,5,main])--The source primary key column name for the many to many mapping [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:16:45.296--ServerSession(9399652)--Thread(Thread[main,5,main])--The target primary key column name for the many to many mapping [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: aka. naming.bind **RemoteBusinessJndiName: ExhibitionFacade; remoteBusIntf: com.schwarcz.enamels.model.ExhibitionFacadeRemote LDR5010: All ejb(s) of [EnamelModel] loaded successfully! SMGT0007: Self Management Rules service is enabled Application server startup complete. WEB0302: Starting Sun-Java-System/Application-Server. WEB0100: Loading web module [__default-admingui] in virtual server [__asadmin] at [/] WEB0100: Loading web module [adminapp] in virtual server [__asadmin] at [/web1] WEB0100: Loading web module [admingui] in virtual server [__asadmin] at [/asadmin] XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 XMLScanner#scanComment#text.toString() == XMLScanner#scanComment#c == 32 Initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '/asadmin' Completed initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '/asadmin' Initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '' Completed initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '' WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8080 WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8181 WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 4848 About to load the system app: __JWSappclients WEB0100: Loading web module [__JWSappclients:sys.war] in virtual server [server] at [/__JWSappclients] Input stream has been finalized or forced closed without being explicitly closed; stream instantiation reported in following stack trace java.lang.Throwable at com.sun.enterprise.loader.EJBClassLoader$SentinelInputStream.(EJBClassLoader.java:1123) at com.sun.enterprise.loader.EJBClassLoader$InternalJarURLConnection.getInputStream(EJBClassLoader.java:1216) at java.net.URL.openStream(URL.java:1007) at com.sun.naming.internal.VersionHelper12$InputStreamEnumeration$1.run(VersionHelper12.java:195) at java.security.AccessController.doPrivileged(Native Method) at com.sun.naming.internal.VersionHelper12$InputStreamEnumeration.getNextElement(VersionHelper12.java:190) at com.sun.naming.internal.VersionHelper12$InputStreamEnumeration.hasMore(VersionHelper12.java:210) at com.sun.naming.internal.ResourceManager.getApplicationResources(ResourceManager.java:470) at com.sun.naming.internal.ResourceManager.getInitialEnvironment(ResourceManager.java:159) at javax.naming.InitialContext.init(InitialContext.java:219) at javax.naming.InitialContext.(InitialContext.java:197) at com.sun.enterprise.naming.factory.IIOPObjectFactory.getObjectInstance(IIOPObjectFactory.java:59) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) at com.sun.enterprise.naming.LocalSerialContextProviderImpl.lookup(LocalSerialContextProviderImpl.java:110) at com.sun.enterprise.naming.SerialContext.lookup(SerialContext.java:309) at javax.naming.InitialContext.lookup(InitialContext.java:351) at com.sun.enterprise.naming.NamingManagerImpl.unpublishObject(NamingManagerImpl.java:227) at com.sun.ejb.containers.BaseContainer.undeploy(BaseContainer.java:2854) at com.sun.ejb.containers.StatelessSessionContainer.undeploy(StatelessSessionContainer.java:718) at com.sun.enterprise.server.AbstractLoader.unloadEjbs(AbstractLoader.java:361) at com.sun.enterprise.server.EJBModuleLoader.unload(EJBModuleLoader.java:184) at com.sun.enterprise.server.StandAloneEJBModulesManager.moduleUnDeployed(StandAloneEJBModulesManager.java:360) at com.sun.enterprise.server.StandAloneEJBModulesManager.moduleUnDeployed(StandAloneEJBModulesManager.java:303) at com.sun.enterprise.server.StandAloneEJBModulesManager.moduleUndeployed(StandAloneEJBModulesManager.java:448) at com.sun.enterprise.admin.event.AdminEventMulticaster.invokeModuleDeployEventListener(AdminEventMulticaster.java:956) at com.sun.enterprise.admin.event.AdminEventMulticaster.handleModuleDeployEvent(AdminEventMulticaster.java:941) at com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:448) at com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:160) at com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:296) at com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:203) at com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStopEvent(ServerDeploymentTarget.java:319) at com.sun.enterprise.deployment.phasing.ApplicationStopPhase.runPhase(ApplicationStopPhase.java:119) at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:95) at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:871) at com.sun.enterprise.deployment.phasing.PEDeploymentService.stop(PEDeploymentService.java:606) at com.sun.enterprise.deployment.phasing.PEDeploymentService.stop(PEDeploymentService.java:652) at com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.stop(ApplicationsConfigMBean.java:742) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:353) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:336) at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:448) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:758) at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:77) at $Proxy1.invoke(Unknown Source) at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:297) at com.sun.enterprise.admin.jmx.remote.server.callers.InvokeCaller.call(InvokeCaller.java:56) at com.sun.enterprise.admin.jmx.remote.server.MBeanServerRequestHandler.handle(MBeanServerRequestHandler.java:142) at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.processRequest(RemoteJmxConnectorServlet.java:109) at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.doPost(RemoteJmxConnectorServlet.java:180) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566) at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844) at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287) at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252) at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75) CORE5024: EJB module [EnamelModel] unloaded successfully! DeployedItemRef postDeregistration failed. Load Balancer Monitoring MBeans might be lying around if this application is being load balanced ADM1006:Uploading the file to:[C:\temp\s1astempdomain1server-1036455939\EnamelModel.jar] deployed with moduleid = EnamelModel [TopLink Config]: 2006.11.06 08:17:00.281--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The alias name for the entity class [class com.schwarcz.enamels.model.Enamel] is being defaulted to: Enamel. [TopLink Config]: 2006.11.06 08:17:00.281--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The table name for entity [class com.schwarcz.enamels.model.Enamel] is being defaulted to: ENAMEL. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.Integer com.schwarcz.enamels.model.Enamel.year] is being defaulted to: YEAR. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Enamel.title] is being defaulted to: TITLE. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Enamel.descript] is being defaulted to: DESCRIPT. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The alias name for the entity class [class com.schwarcz.enamels.model.Exhibition] is being defaulted to: Exhibition. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The table name for entity [class com.schwarcz.enamels.model.Exhibition] is being defaulted to: EXHIBITION. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Exhibition.id] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.Long com.schwarcz.enamels.model.Exhibition.year] is being defaulted to: YEAR. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Exhibition.changedBy] is being defaulted to: CHANGEDBY. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The alias name for the entity class [class com.schwarcz.enamels.model.Showpiece] is being defaulted to: Showpiece. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The table name for entity [class com.schwarcz.enamels.model.Showpiece] is being defaulted to: SHOWPIECE. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.Long com.schwarcz.enamels.model.Showpiece.id] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Showpiece.showId] is being defaulted to: SHOWID. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The column name for element [private java.lang.String com.schwarcz.enamels.model.Showpiece.changedBy] is being defaulted to: CHANGEDBY. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The target entity (reference) class for the many to many mapping element [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: class com.schwarcz.enamels.model.Enamel. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The source primary key column name for the many to many mapping [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: ID. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The target primary key column name for the many to many mapping [private java.util.List com.schwarcz.enamels.model.Exhibition.enamels] is being defaulted to: aka. [TopLink Config]: 2006.11.06 08:17:00.296--ServerSession(7607074)--Thread(Thread[httpWorkerThread-4848-0,10,Grizzly])--The target entity (reference) class for the many to many mapping element [private java.util.List com.schwarcz.enamels.model.Enamel.exhibitions] is being defaulted to: class com.schwarcz.enamels.model.Exhibition. naming.bind **RemoteBusinessJndiName: ExhibitionFacade; remoteBusIntf: com.schwarcz.enamels.model.ExhibitionFacadeRemote LDR5010: All ejb(s) of [EnamelModel] loaded successfully! -- listing properties -- log4j.logger.org.hibernate.type=info log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.logger.com.schwarcz.enamels.model.ExhibitionFacadeBean=debug log4j.rootLogger=info, stdout log4j.logger.org.hibernate.tool.hbm2ddl=debug log4j.logger.org.hibernate=info log4j.logger.com.schwarcz.enamels=info log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n log4j.logger.org.hibernate.hql.ast.AST=debug log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.Target=System.out log4j.logger.org.hibernate.ejb=debug 08:28:47,312 INFO enamels:67 - Logging initialized 08:28:47,312 INFO ExhibitionFacadeBean:41 - init complete 08:28:47,328 INFO ExhibitionFacadeBean:51 - findByEnamel 08:28:47,328 DEBUG ExhibitionFacadeBean:58 - query = SELECT ex FROM Showpiece AS sh, Exhibition AS ex WHERE sh.enamelId = :enamelId AND sh.showId = ex.id ORDER BY ex.year [TopLink Config]: 2006.11.06 08:28:47.328--ServerSession(7607074)--Thread(Thread[p: thread-pool-1; w: 2,5,main])--property toplink.server.platform.class.name is deprecated, property toplink.target-server should be used instead. topLink_version application_server_name_and_version dbPlaformHelper_detectedVendorPlatform platform=>MySQL4Platform user name=> "" connector=>JNDIConnector datasource name=>null );|connecting ;|connected_user_database_driver platform=>MySQL4Platform user name=> "" connector=>JNDIConnector datasource name=>null );|connecting ;|connected_user_database_driver login_successful 08:28:49,453 DEBUG ExhibitionFacadeBean:60 - param enamelId = 0301 SELECT t0.ID, t0.YEAR, t0.CHANGEDBY, t0.descript FROM EXHIBITION t0, SHOWPIECE t1 WHERE ((t1.pieceAka = ?) AND (t1.SHOWID = t0.ID)) ORDER BY t0.YEAR ASC bind => [0301] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [58Syracuse] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0301] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [64DeYoung] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0312] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0311] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0319] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0325A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0327] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [57Syracuse] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90Highline] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0777] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [82LA] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0332] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [71Zurich] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0591] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72Germany] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0479] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66Diego] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0420] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Phillips] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0386] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0372] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [63LACounty] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0382] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0384] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65UCB] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0407] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0391] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [63Newport] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0387] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0392] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [64World] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0399] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Contemp] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0419] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Wash] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0431] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0349] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [62Skidmore] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0308] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Crocker] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0341] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [61Fresno] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0335A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0348] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0339] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0333A] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87Tulsa] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0815] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Elem] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0702] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0723] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Rome] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Rome2] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0724] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87Fresno] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0670] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76ND] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0469] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66Long] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0485] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66CAComm] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0487] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [70Fresno] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0519] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0516] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0548] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [69Ames] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0472] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [67Ball] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [68Marin] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0458] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66Wash] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0424] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0492] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0493] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [67Laguna] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0456] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65SFArt] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0455] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0504] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [69Third] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0543] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [69SD] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0545] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [73Friends] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0589] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72Yaw] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0603] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [74Marin] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0549] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [70Gold] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0540] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [73Kent] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0614] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [73WI] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0583] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0585] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [75Metal] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0616] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Del] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0662] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Duhl] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0582] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0596] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72TN] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0379] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Nine] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0401] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0410] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0413] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0426] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0531] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0555] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [70Alliance] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [75Skid] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0647] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Forty] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0338] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0347] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [84Oak] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0348A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0538] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [01Bard] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0551] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72PA] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0586] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [73Paltz] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0568] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0562] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Foot] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0388] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [63Oakland] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0383] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90Crafts] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0978] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98NY] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0911] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1002] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1049] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1086] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1094] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2032] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2089] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2063] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1023] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90CA] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1041] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Masters] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2135] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2130] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Ont] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2084] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [03June] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0561] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0629] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [74Gold] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0626] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Hunts] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0573] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0625] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [74Renwick] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0624] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0636] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0644] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [75Ark] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0580] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [74Bloom] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0572] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [71X] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0571] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [73SD] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [75France] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76LJ] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0683] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0665] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [93Sybaris] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0796] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1018] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0892] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83SFFolk2] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0646] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [75Worc] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0659] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Bronx] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0716] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83Great] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0727] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Valley] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0637] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77James] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0631] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77Scars] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0654] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0694] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0663] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0689] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83StLouis] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0779] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0802] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Gold] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0703] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Mont] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [84Basket] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0666] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77Craft] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0550] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0581] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Mont] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0661] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0675] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Laguna] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0691] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77Est] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0692] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77Phil] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0706] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0704] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Artis] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0762] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0765] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0776] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [96Denver] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0316] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0491] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0734] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0899] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [84AZ] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0863] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83SFFolk] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0781] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0818] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Germany] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85Croker] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0707] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0882] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87Taft] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0839] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0915] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [86Bellas] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0879] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85Kent] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0912] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0921] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [86Susan] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0913] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0931] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0934] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [86SD] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0880] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0929] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85Susan] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0797] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0908] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0926] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0927] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0928] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0942] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0943] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0944] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87OR] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0887] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83Wisc] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0884] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85KY] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [84Jewel] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0709] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Old] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0695] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0836] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [82Limoge] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0875] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [95Sybaris] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0883] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0909] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0959A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0983] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0993] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1001] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1038] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1046] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1058C] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1062] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2047] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2048] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87Crain] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0914] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0916] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0925] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0799] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0865] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0868] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [83SF] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0849] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0861] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0856] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0878] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85Jewish] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0924] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [85Salem] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0872] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0923] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0904] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0907] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0930] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0932] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0933] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0935] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0936] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0940] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90Limoge] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1025] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [92NY] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1091] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1040] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1043] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90NY] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0990] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1036] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0964] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1020] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0963] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0886] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87PA] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0965] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0894] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [93Richmond] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0714] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0971] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1051] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1052] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1057] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2000] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2012] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Laguna] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2013] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [93Rapp] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0992] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1008] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [96Gumps] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1044] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1096] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [92Crafts] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [01India] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2020] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1050] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1059] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1061] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1081] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2003] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [93AK] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2001] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [02Ark] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2150] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Change] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1065] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2021] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2033] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2119] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [02Memphis] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2030] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2072] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2103] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Seafirst] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0820] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0874] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0885] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0905] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1032] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2062] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2066] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2040] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2017] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2046] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Shoebox] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [84TN] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0784A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0680] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78ND] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0732] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0733] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0737] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Bowl] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0795] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0745] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [81Brook] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [92Redwood] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1005] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0987] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0823] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0845] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0719] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0721] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0791] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0822] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0831] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0838] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0851] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0864] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0867] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0870] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0871] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0873] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0717] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [80Flux] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0780] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0728] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0730] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0767A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0858] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0866] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0869] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0876] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0877] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0881] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0853] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Elements] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0602] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0621] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0628] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0651] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76Potter] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0687] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76James] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0678] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [78Baskets] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0634] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [76SD] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0681] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0684] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0674] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0668] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0843] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0682] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0792] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0784] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0888] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0889] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0891] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0893] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0896] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0897] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0898] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0900] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2015] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [98Bench] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2115] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0679] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0828] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0829] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0834] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0840] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0939] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0953] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [87Guild] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0955] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0960] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2044] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [95NY] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2095] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2141] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2172] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2182] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2192] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [03PaloAlto] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2200] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2215] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2211] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1013] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0592] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0597] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72TX] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0574] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0588] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0618] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0633] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0640] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0672] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0685] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0693] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0696] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0587] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0767] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0833] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0917] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [86CraftNY] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0958] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1047] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [90Fortunoff] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1048] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1063] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1076] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [1092] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2006] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2025] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2060] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2061] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2073] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2082] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [96Mont] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2087] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2094] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2099] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2105] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [2110] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0652] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0567] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0518] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0552] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0563] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [96Craft] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0575] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0595] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0632] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0669] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0676] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [77Focus] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0642] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0593] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0486] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0604] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0605] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0422] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0496] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66SFArt] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0460] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0480] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66SDColl] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0397] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [69Monte] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0497] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [70Metal] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0598] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0510] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0511] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0494] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0416] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0381] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0352] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0398A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0501] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0474] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66SJ] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0476] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0477] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0508] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [67West] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0495] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [67UCSF] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0498] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [68X] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0514] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0513] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0507] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [68KA] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0520] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [72CAFair] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0415] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0523] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0462] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0547] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0517] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0554] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0559] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0560] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0470] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0488] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0557] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0558] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0553] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0528] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0556] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0464] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0606] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0623] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0638] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0650] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0653] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0667] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0671] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0673] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0677] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0469A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0660] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0760] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0826] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0830] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0835] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0922] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0950] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0952] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0956] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0741] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0769] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0794] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0806] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0808] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0810] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0811] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0817] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0787] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0812] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0813] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0814] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0751] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0752] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0771] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0356] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0409] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0333] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0423] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [66Syrac] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0403] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0414] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0431A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0445] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0447] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0453] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0461] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0463] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0466] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0467] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0468] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0353] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0402] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0429] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0471] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0417] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0395] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0389] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0421] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [65Provo] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0434] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0432] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0425] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0457] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0534] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0578] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [71Oak] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0579] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0584] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0536] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [69Contemp] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0539] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0655] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0656] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0768] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0821] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0832] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0846] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0847] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0848] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0850] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [82Wash] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0859] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0854] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0986] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0329] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0329A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0332A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0335] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0337] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0350] SELECT t1.aka, t1.TITLE, t1.DESCRIPT, t1.YEAR FROM showpiece t0, ENAMEL t1 WHERE ((t0.showId = ?) AND (t1.aka = t0.pieceAka)) bind => [62SFArt] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0370A] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0371] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0378] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0380] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0385] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0394] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0404] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0405] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0406] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0408] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0411] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0412] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0418] SELECT t1.ID, t1.YEAR, t1.CHANGEDBY, t1.descript FROM showpiece t0, EXHIBITION t1 WHERE ((t0.pieceAka = ?) AND (t1.ID = t0.showId)) bind => [0326A] INSERT INTO showpiece (pieceAka, showId) VALUES (?, ?) bind => [0871, 83SFFolk2] Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`))Error Code: 1452 Call:INSERT INTO showpiece (pieceAka, showId) VALUES (?, ?) bind => [0871, 83SFFolk2] Query:DataModifyQuery() at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:242) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:222) at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect(StatementQueryMechanism.java:129) at oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:71) at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609) at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937) at oracle.toplink.essentials.mappings.ManyToManyMapping.insertAddedObjectEntry(ManyToManyMapping.java:693) at oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent(ManyToManyMapping.java:891) at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:199) at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:2428) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:177) at oracle.toplink.essentials.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:116) at oracle.toplink.essentials.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:76) at com.sun.ejb.containers.ContainerSynchronization.beforeCompletion(ContainerSynchronization.java:154) at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:395) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:357) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3653) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:110) at $Proxy44.findByEnamel(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:121) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:650) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:193) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1705) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1565) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:947) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:178) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:717) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:473) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1270) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:479) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`)) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632) ... 49 more Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`))Error Code: 1452 Call:INSERT INTO showpiece (pieceAka, showId) VALUES (?, ?) bind => [0871, 83SFFolk2] Query:DataModifyQuery() at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:242) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:222) at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect(StatementQueryMechanism.java:129) at oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:71) at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609) at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937) at oracle.toplink.essentials.mappings.ManyToManyMapping.insertAddedObjectEntry(ManyToManyMapping.java:693) at oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent(ManyToManyMapping.java:891) at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:199) at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:2428) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:177) at oracle.toplink.essentials.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:116) at oracle.toplink.essentials.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:76) at com.sun.ejb.containers.ContainerSynchronization.beforeCompletion(ContainerSynchronization.java:154) at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:395) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:357) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3653) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:110) at $Proxy44.findByEnamel(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:121) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:650) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:193) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1705) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1565) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:947) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:178) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:717) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:473) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1270) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:479) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`)) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632) ... 49 more EJB5071: Some remote or transactional roll back exception occurred Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`))Error Code: 1452 Call:INSERT INTO showpiece (pieceAka, showId) VALUES (?, ?) bind => [0871, 83SFFolk2] Query:DataModifyQuery() at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:242) at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:222) at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect(StatementQueryMechanism.java:129) at oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:71) at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609) at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218) at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937) at oracle.toplink.essentials.mappings.ManyToManyMapping.insertAddedObjectEntry(ManyToManyMapping.java:693) at oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent(ManyToManyMapping.java:891) at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:199) at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112) at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:2428) at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:177) at oracle.toplink.essentials.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:116) at oracle.toplink.essentials.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:76) at com.sun.ejb.containers.ContainerSynchronization.beforeCompletion(ContainerSynchronization.java:154) at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:395) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:357) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3653) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:110) at $Proxy44.findByEnamel(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:121) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:650) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:193) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1705) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1565) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:947) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:178) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:717) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:473) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1270) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:479) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`sample/showpiece`, CONSTRAINT `FK6EA25F1742F15CF` FOREIGN KEY (`exhibition`) REFERENCES `exhibition` (`id`)) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632) ... 49 more EJB5018: An exception was thrown during an ejb invocation on [ExhibitionFacadeBean] javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException: Transaction marked for rollback. javax.transaction.RollbackException: Transaction marked for rollback. at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:416) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:357) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3653) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:110) at $Proxy44.findByEnamel(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:121) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:650) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:193) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1705) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1565) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:947) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:178) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:717) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:473) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1270) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:479) javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException: Transaction marked for rollback. at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3659) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:110) at $Proxy44.findByEnamel(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:121) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:650) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:193) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1705) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1565) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:947) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:178) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:717) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:473) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1270) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:479)