INSERT INTO foo_table
       ( foo, bar, baz, foo1, bar1, baz1 )
VALUES ( ?,   ?,   ?,   ?,    ?,    ?    )

##</code><code>##

SELECT xx.foo
      ,xx.bar
      ,yy.baz
      ,COUNT(*) AS count
  FROM foo_table xx
      ,bar_table yy
 WHERE xx.abcd      = yy.abcd
   AND xx.asdfghjkl = yy.asdfghjkl
 GROUP BY xx.foo
         ,yy.bar
         ,yy.baz