Index: trunk/ippTools/share/staticskytool_defineskycalrun.sql
===================================================================
--- trunk/ippTools/share/staticskytool_defineskycalrun.sql	(revision 34761)
+++ trunk/ippTools/share/staticskytool_defineskycalrun.sql	(revision 34973)
@@ -1,5 +1,5 @@
 SELECT
-    sky_id,
-    stack_id,
+    staticskyRun.sky_id,
+    stackRun.stack_id,
     skycell_id,
     filter,
@@ -14,5 +14,5 @@
     JOIN stackSumSkyfile USING(stack_id)
     JOIN skycell USING(tess_id, skycell_id)
-    LEFT JOIN skycalRun USING(sky_id, stack_id)
+    LEFT JOIN skycalRun ON staticskyRun.sky_id = skycalRun.sky_id AND stackRun.stack_id = skycalRun.stack_id -- join hook %s
 WHERE staticskyRun.state = 'full'
     AND staticskyResult.quality = 0