Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_12834315_1 ( colt_model_no VARCHAR, name VARCHAR, case_deflector VARCHAR, bayonet_lug VARCHAR, stock VARCHAR )

### Question ###
What are the Colt model numbers of the models named GAU-5A/A, with no bayonet lug, no case deflector and stock of 2nd generation?

### Accurate SQL ###

SELECT colt_model_no FROM table_12834315_1 WHERE bayonet_lug = "No" AND stock = "2nd Generation" AND case_deflector = "No" AND name = "GAU-5A/A"