What query string is used to display products in commerce kickstart?
You can use the function commerce_product_load which is documented here. I am sorry if you are saying Drupal is not loaded and you have to use a straight php query.