by AutoCheck a part of Experian

 

Most Popular Cars Overall

Browse All Makes of Cars

AC
AMC
ATK
BMW
GEM
Geo
GMC
Kia
MCC
MG
Ram
TVR
UAZ
 
All Content © Experian 2011
(default) 17 queries took 82 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';0134
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'makes' AND table_schema = 'public' ORDER BY position059
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'countries' AND table_schema = 'public' ORDER BY position036
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'cars' AND table_schema = 'public' ORDER BY position065
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'car_years' AND table_schema = 'public' ORDER BY position045
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vehicles' AND table_schema = 'public' ORDER BY position0196
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'users' AND table_schema = 'public' ORDER BY position0246
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vehicle_images' AND table_schema = 'public' ORDER BY position0106
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'comments' AND table_schema = 'public' ORDER BY position055
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'flags' AND table_schema = 'public' ORDER BY position0106
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'checks' AND table_schema = 'public' ORDER BY position045
12SELECT "Make"."id" AS "Make__id", "Make"."name" AS "Make__name", "Make"."created" AS "Make__created", "Make"."country_id" AS "Make__country_id", "Make"."vehicle_count" AS "Make__vehicle_count", "Country"."id" AS "Country__id", "Country"."name" AS "Country__name", "Country"."countrycode" AS "Country__countrycode" FROM "makes" AS "Make" LEFT JOIN "countries" AS "Country" ON ("Make"."country_id" = "Country"."id") WHERE 1 = 1 ORDER BY "Make"."name" asc 01703
13SELECT "Vehicle"."id" AS "Vehicle__id", "Vehicle"."date_purchased" AS "Vehicle__date_purchased", "Vehicle"."date_sold" AS "Vehicle__date_sold", "Vehicle"."year" AS "Vehicle__year", "Vehicle"."vin" AS "Vehicle__vin", "Vehicle"."check_count" AS "Vehicle__check_count", "Make"."name" AS "Make__name", "Car"."name" AS "Car__name", "User"."username" AS "User__username", "User"."id" AS "User__id", "User"."first_name" AS "User__first_name", "Make"."id" AS "Make__id", "Car"."id" AS "Car__id" FROM "vehicles" AS "Vehicle" LEFT JOIN "makes" AS "Make" ON ("Vehicle"."make_id" = "Make"."id") LEFT JOIN "cars" AS "Car" ON ("Vehicle"."car_id" = "Car"."id") LEFT JOIN "users" AS "User" ON ("Vehicle"."user_id" = "User"."id") WHERE "Vehicle"."check_count" is not null ORDER BY "Vehicle"."check_count" DESC, "User"."id" IS NOT NULL ASC LIMIT 40412
14SELECT "VehicleImage"."id" AS "VehicleImage__id", "VehicleImage"."vehicle_id" AS "VehicleImage__vehicle_id" FROM "vehicle_images" AS "VehicleImage" WHERE "VehicleImage"."active" = '1' AND "VehicleImage"."vehicle_id" = ('255') LIMIT 1011
15SELECT "VehicleImage"."id" AS "VehicleImage__id", "VehicleImage"."vehicle_id" AS "VehicleImage__vehicle_id" FROM "vehicle_images" AS "VehicleImage" WHERE "VehicleImage"."active" = '1' AND "VehicleImage"."vehicle_id" = ('15') LIMIT 1011
16SELECT "VehicleImage"."id" AS "VehicleImage__id", "VehicleImage"."vehicle_id" AS "VehicleImage__vehicle_id" FROM "vehicle_images" AS "VehicleImage" WHERE "VehicleImage"."active" = '1' AND "VehicleImage"."vehicle_id" = ('12') LIMIT 1011
17SELECT "VehicleImage"."id" AS "VehicleImage__id", "VehicleImage"."vehicle_id" AS "VehicleImage__vehicle_id" FROM "vehicle_images" AS "VehicleImage" WHERE "VehicleImage"."active" = '1' AND "VehicleImage"."vehicle_id" = ('46') LIMIT 1001