Is it possible to write a query to display the following in one pass?

products_id
products_model
customid
products_attributes_id
options_id
options_values_id
products_options_values_name

I have been trying to get a query to work, but have not been successful.