Index: branches/eam_branches/ipp-20130509/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20130509/ippTools/share/Makefile.am	(revision 35565)
+++ branches/eam_branches/ipp-20130509/ippTools/share/Makefile.am	(revision 35594)
@@ -449,4 +449,5 @@
 	diffphottool_data.sql \
 	laptool_definerun.sql \
+	laptool_definerunbyrelease.sql \
 	laptool_exposures.sql \
 	laptool_inactiveexp.sql \
Index: branches/eam_branches/ipp-20130509/ippTools/share/chiptool_find_rawexp.sql
===================================================================
--- branches/eam_branches/ipp-20130509/ippTools/share/chiptool_find_rawexp.sql	(revision 35565)
+++ branches/eam_branches/ipp-20130509/ippTools/share/chiptool_find_rawexp.sql	(revision 35594)
@@ -6,5 +6,5 @@
 FROM rawExp
 JOIN newExp using (exp_id)
-LEFT JOIN chipRun USING (exp_id)
+LEFT JOIN chipRun ON chipRun.exp_id = rawExp.exp_id -- JOIN hook %s
 WHERE
     rawExp.fault = 0
Index: branches/eam_branches/ipp-20130509/ippTools/share/laptool_definerunbyrelease.sql
===================================================================
--- branches/eam_branches/ipp-20130509/ippTools/share/laptool_definerunbyrelease.sql	(revision 35594)
+++ branches/eam_branches/ipp-20130509/ippTools/share/laptool_definerunbyrelease.sql	(revision 35594)
@@ -0,0 +1,23 @@
+select
+	rel.exp_id AS exp_id,
+	rel.chip_id AS chip_id,
+	false AS private,
+	false AS active,
+	false AS pairwise
+FROM
+	(select exp_id,chip_id FROM ippRelease
+	 JOIN relExp USING(rel_id)
+	 JOIN rawExp USING(exp_id)
+	 WHERE
+	 @RELWHERE@
+	) AS rel
+LEFT JOIN
+	(select MIN(lap_id) AS lap_id,
+	 exp_id,chip_id FROM lapRun
+	 JOIN lapExp USING(lap_id)
+	 WHERE
+	 @LAPWHERE@
+	 GROUP BY exp_id,chip_id
+	) AS lap
+USING(exp_id)
+WHERE lap_id IS NULL