         dataset (get-in resource [:properties :dataset])
         slice (get-in resource [:properties :slice])
         query (get-in resource [:properties :query])
-        base-href (urls/slice-path dataset slice)        
+        base-href (urls/slice-path dataset slice)
+        dimensions (:dimensions slicedef)
+        metrics (:metrics slicedef)
+        sample-dimension (first (sort #(< (count %1) (count %2)) dimensions))
+        sample-metric (first (sort #(< (count %1) (count %2)) metrics))
         slice-metadata {:name (get-in slicedef [:info :name])
                         :description (get-in slicedef [:info :description])
-                        :dimensions (str/join ", " (:dimensions slicedef))
-                        :metrics (str/join ", " (:metrics slicedef))}
-        dimensions (map #(hash-map :key %
-                                   :name (desc %)
-                                   :value (get-in dimensions [(keyword %)]))
-                        (:dimensions slicedef))
+                        :dimensions (str/join ", " dimensions)
+                        :metrics (str/join ", " metrics)}
+        dimension-form-data (map #(hash-map :key %
+                                            :name (desc %)
+                                            :value (get-in dimensions [(keyword %)]))
+                                 dimensions)
+        placeholders {:select (str/join ", " (vector sample-dimension sample-metric))
+                      :where (str sample-metric " > 10")
+                      :orderBy (str sample-dimension ", " sample-metric " DESC")}
         clauses (->> clauses
                      (map #(assoc-in % [:value] (get-in resource
                                                         [:properties :query (keyword (:key %))])))
+                     (map #(assoc-in % [:placeholder]
+                                     ((keyword (:key %)) placeholders (:placeholder %))))
                      (map #(assoc-in % [:errors] (get-in resource
                                                          [:properties :errors (keyword (:key %))]))))
         data (take 100 (get-in resource [:properties :results]))

  ([content] (layout-html {} content))
  ([resource content]
     (render-file "templates/layout"
                  (merge footer-info {:content content
                                      :resource resource}))))

(defn not-found-html [message]

                   :dataset dataset
                   :slice slice
                   :metadata slice-metadata
                   :dimensions dimension-form-data
                   :clauses clauses
                   :columns columns
                   :start start
