select code,name from states order by name
select contacts.contact_id from session,contacts where session.contact_id=contacts.contact_id and session.hash='' and ip='38.107.191.88' and end_time>1268474419
select contact_id from contacts where email=''
select type_id from vehicle_types where name='Cars'
select type_id from vehicle_types where name='Pick-Up Truck'
select type_id from vehicle_types where name='Sport Utility'
select type_id from vehicle_types where name='Mini-Van'
select make_id from makes where name='Volkswagen'
select make_id from makes where name='Toyota'
select make_id from makes where name='Suzuki'
select make_id from makes where name='Subaru'
select make_id from makes where name='Saturn'
select make_id from makes where name='Pontiac'
select make_id from makes where name='Plymouth'
select make_id from makes where name='Oldsmobile'
select make_id from makes where name='Nissan'
select make_id from makes where name='Mitsubishi'
select make_id from makes where name='Mercury'
select make_id from makes where name='Mercedes'
select make_id from makes where name='Mazda'
select make_id from makes where name='Lincoln'
select make_id from makes where name='Lexus'
select make_id from makes where name='Jeep'
select make_id from makes where name='Isuzu'
select make_id from makes where name='Infiniti'
select make_id from makes where name='Honda'
select make_id from makes where name='GMC'
select make_id from makes where name='Ford'
select make_id from makes where name='Dodge'
select make_id from makes where name='Chrysler'
select make_id from makes where name='Chevrolet'
select make_id from makes where name='Cadillac'
select make_id from makes where name='Buick'
select make_id from makes where name='BMW'
select make_id from makes where name='Audi'