People who viewed this Chevrolet Corvette also viewed similar Chevrolet listed at ClassicDigest
Other cars listed for sale by this dealer
# | type | message |
---|---|---|
1 | Routing | connect "/captcha" |
2 | Context | initialization |
3 | Controller | initialization |
4 | Routing | match route [na_vif] "/:make/:model/:id" |
5 | Request | request parameters array ( 'make' => 'chevrolet', 'model' => 'corvette', 'id' => '199770', 'module' => 'home', 'action' => 'view',) |
6 | Routing | connect "/sf_cache_partial/:module/:action/:sf_cache_key" |
7 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
8 | Creole | prepareStatement(): SET time_zone = '+01:00' |
9 | Creole | executeUpdate(): SET time_zone = '+01:00' |
10 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
11 | Creole | prepareStatement(): SET time_zone = '+01:00' |
12 | Creole | executeUpdate(): SET time_zone = '+01:00' |
13 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
14 | Creole | prepareStatement(): SET time_zone = '+01:00' |
15 | Creole | executeUpdate(): SET time_zone = '+01:00' |
16 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
17 | Creole | prepareStatement(): SET time_zone = '+01:00' |
18 | Creole | executeUpdate(): SET time_zone = '+01:00' |
19 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
20 | Creole | prepareStatement(): SET time_zone = '+01:00' |
21 | Creole | executeUpdate(): SET time_zone = '+01:00' |
22 | Controller | dispatch request |
23 | Filter | executing filter "sfRenderingFilter" |
24 | Filter | executing filter "sfWebDebugFilter" |
25 | Filter | executing filter "sfCarViewFilter" |
26 | Filter | executing filter "naBreadcrumbFilter" |
27 | Filter | executing filter "sfCacheFilter" |
28 | Filter | executing filter "sfCommonFilter" |
29 | Filter | executing filter "sfFlashFilter" |
30 | Filter | executing filter "sfExecutionFilter" |
31 | Action | call "homeActions->executeView()" |
32 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=? AND car.STATUS=? |
33 | Creole | executeQuery(): [5.02 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=199770 AND car.STATUS='F' |
34 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
35 | Creole | executeQuery(): [3.01 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (1204) |
36 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=? |
37 | Creole | executeQuery(): [3.80 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=199770 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [5.88 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199770 |
40 | Creole | prepareStatement(): SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=? |
41 | Creole | executeQuery(): [28.59 ms] SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=199770 |
42 | Creole | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
43 | Creole | executeQuery(): [5.56 ms] SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (1204) |
44 | Creole | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
45 | Creole | executeQuery(): [7.05 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199770 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
46 | Creole | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
47 | Creole | executeQuery(): [2.98 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1' |
48 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199770) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [13.37 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199770) ORDER BY carimg.ORD ASC |
50 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
51 | Creole | executeQuery(): [5.64 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (1204) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [12.97 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1204 AND dealer_permission.WHICH='Q' |
54 | Creole | prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE |
55 | Creole | executeQuery(): [7.60 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=35 AND model.ID=384 AND make.ID=model.ID_MAKE |
56 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 199770 AND car.ID_MODEL = '384' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 199770 AND car.ID_MODEL = '384' ) ORDER BY ID DESC |
57 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 199770 AND car.ID_MODEL = '384' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 199770 AND car.ID_MODEL = '384' ) ) AS count |
58 | Creole | executeQuery(): [48.54 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 199770 AND car.ID_MODEL = '384' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 199770 AND car.ID_MODEL = '384' ) ) AS count |
59 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 199770 AND car.ID_MODEL = '384' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 199770 AND car.ID_MODEL = '384' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [64.99 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 199770 AND car.ID_MODEL = '384' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 199770 AND car.ID_MODEL = '384' ) ORDER BY ID DESC LIMIT 5 |
61 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199955,199932,199892,199880,199828) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [8.30 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199955,199932,199892,199880,199828) ORDER BY carimg.ORD ASC |
63 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) ORDER BY ID DESC |
64 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) ) AS count |
65 | Creole | executeQuery(): [21.93 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) ) AS count |
66 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [35.77 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '199770' AND car.ID_NETTI_USER = '1204' ) ORDER BY ID DESC LIMIT 5 |
68 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199933,199880,199879,199825,199719) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [18.74 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199933,199880,199879,199825,199719) ORDER BY carimg.ORD ASC |
70 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
71 | Creole | executeQuery(): [18.84 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=35 AND car.ID_MODEL=384 AND car.STATUS='F' |
72 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
73 | Creole | executeQuery(): [129.06 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=35 AND sold_car.ID_MODEL=384 AND sold_car.STATUS='S' |
74 | Creole | prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (19166,19167,19168,25686,28239,35554,44767,65769,65774,65777,65816,110321,118189,127034,134586,137568,139759,140950,140951,142204,142928,142929,145118,145672,145992,150535,153163,153187,153207,153237,153714,153733,154272,154278,154282,154283,154284,154287,154814,154820,154839,155188,155189,155475,155476,155841,155856,156405,157052,157058,157077,157078,157109,157594,158813,162236,163283,164496,165742,166765,166896,168080,168474,169110,169718,170244,170411,170528,170562,170811,170812,171165,171453,171543,171876,171945,171952,171958,172131,172139,172442,172448,172449,172710,173019,173059,173069,173074,173490,174584,174707,174742,174934,174941,174959,175300,175726,176262,176760,176803,176867,176898,176933,177045,177088,177148,177306,177361,177428,177484,177503,177641,177746,177773,177937,178084,178175,178182,178265,178309,178650,178676,179118,179468,179550,179913,180212,180338,180433,180643,180927,180995,181206,181585,181646,181681,181729,181843,182179,182266,182570,182595,182599,183422,184085,184185,184322,184573,184574,184575,185341,185357,185624,185837,186893,186910,187041,187169,187451,187600,188076,188104,188348,188632,188676,189309,189317,189334,189614,189850,190205,190431,190457,190591,191318,191416,191432,191666,191926,191974,192346,192461,192462,192498,192588,192589,192702,192709,192711,192775,192777,192974,193190,193225,193256,193276,193294,193366,193377,193398,193512,193526,193543,193544,193644,193648,193664,193777,193842,193860,193861,193881,193984,194097,194220,194253,194358,194391,194450,194477,194548,194661,194685,194687,194690,194769,194773,194793,194796,194845,194887,194893,194945,194983,194990,195244,195347,195417,195501,195502,195503,195504,195552,195583,195625,195707,195757,195759,195788,195824,195835,195849,195986,196055,196087,196189,196225,196240,196243,196274,196287,196360,196397,196450,196452,196529,196540,196570,196634,196645,196666,196688,196708,196750,196816,196826,196864,196867,196893,196984,197043,197048,197093,197172,197177,197178,197212,197219,197242,197244,197357,197425,197440,197467,197497,197564,197565,197574,197575,197582,197585,197618,197640,197649,197688,197694,197697,197701,197728,197730,197766,197794,197807,197862,197894,197899,197913,197942,198178,198189,198217,198218,198287,198297,198499,198500,198503,198532,198562,198564,198583,198600,198622,198630,198666,198683,198685,198749,198750,198801,198806,198807,198831,198855,198861,198869,198891,198899,198914,198941,198971,198982,198983,199015,199020,199040,199048,199058,199100,199134,199146,199237,199241,199247,199250,199253,199295,199319,199370,199416,199434,199456,199457,199464,199617,199653,199690,199770,199774,199813,199814,199815,199828,199880,199892,199932,199955) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [10.95 ms] SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (19166,19167,19168,25686,28239,35554,44767,65769,65774,65777,65816,110321,118189,127034,134586,137568,139759,140950,140951,142204,142928,142929,145118,145672,145992,150535,153163,153187,153207,153237,153714,153733,154272,154278,154282,154283,154284,154287,154814,154820,154839,155188,155189,155475,155476,155841,155856,156405,157052,157058,157077,157078,157109,157594,158813,162236,163283,164496,165742,166765,166896,168080,168474,169110,169718,170244,170411,170528,170562,170811,170812,171165,171453,171543,171876,171945,171952,171958,172131,172139,172442,172448,172449,172710,173019,173059,173069,173074,173490,174584,174707,174742,174934,174941,174959,175300,175726,176262,176760,176803,176867,176898,176933,177045,177088,177148,177306,177361,177428,177484,177503,177641,177746,177773,177937,178084,178175,178182,178265,178309,178650,178676,179118,179468,179550,179913,180212,180338,180433,180643,180927,180995,181206,181585,181646,181681,181729,181843,182179,182266,182570,182595,182599,183422,184085,184185,184322,184573,184574,184575,185341,185357,185624,185837,186893,186910,187041,187169,187451,187600,188076,188104,188348,188632,188676,189309,189317,189334,189614,189850,190205,190431,190457,190591,191318,191416,191432,191666,191926,191974,192346,192461,192462,192498,192588,192589,192702,192709,192711,192775,192777,192974,193190,193225,193256,193276,193294,193366,193377,193398,193512,193526,193543,193544,193644,193648,193664,193777,193842,193860,193861,193881,193984,194097,194220,194253,194358,194391,194450,194477,194548,194661,194685,194687,194690,194769,194773,194793,194796,194845,194887,194893,194945,194983,194990,195244,195347,195417,195501,195502,195503,195504,195552,195583,195625,195707,195757,195759,195788,195824,195835,195849,195986,196055,196087,196189,196225,196240,196243,196274,196287,196360,196397,196450,196452,196529,196540,196570,196634,196645,196666,196688,196708,196750,196816,196826,196864,196867,196893,196984,197043,197048,197093,197172,197177,197178,197212,197219,197242,197244,197357,197425,197440,197467,197497,197564,197565,197574,197575,197582,197585,197618,197640,197649,197688,197694,197697,197701,197728,197730,197766,197794,197807,197862,197894,197899,197913,197942,198178,198189,198217,198218,198287,198297,198499,198500,198503,198532,198562,198564,198583,198600,198622,198630,198666,198683,198685,198749,198750,198801,198806,198807,198831,198855,198861,198869,198891,198899,198914,198941,198971,198982,198983,199015,199020,199040,199048,199058,199100,199134,199146,199237,199241,199247,199250,199253,199295,199319,199370,199416,199434,199456,199457,199464,199617,199653,199690,199770,199774,199813,199814,199815,199828,199880,199892,199932,199955) GROUP BY cmonth ORDER BY date_create |
76 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (20610,20611,20612,20613,20614,20615,20810,20908,21233,21234,21260,21347,21348,21415,22016,22158,22315,22366,22401,22657,22687,22689,22706,22711,22730,22732,22758,22779,22789,22799,22810,22833,22837,22844,22847,22855,22857,22858,22867,22882,22897,22904,22905,22931,23000,23001,23002,23003,23004,23005,23006,23007,23076,23083,23099,23102,23128,23140,23193,23213,23373,23377,23378,23386,23450,23648,23649,23850,23909,24040,24041,24043,24190,24519,24846,24847,24848,24849,24933,24960,25123,25157,25203,25246,25334,25363,25369,25370,25371,25400,25445,25499,25599,25653,25654,25656,25669,25703,25713,25718,25721,25783,25949,26008,26009,26021,26025,26026,26128,26198,26227,26358,26462,26500,26559,26752,26772,26814,26982,27330,27350,27406,27490,27727,27728,27729,27730,27731,27732,28240,29587,29588,29608,29699,30149,31050,31506,31816,32806,33596,33926,33965,35041,35056,35069,35080,35085,35090,35352,35411,35538,35734,35780,36208,36454,36455,36619,36620,36622,36856,38660,38691,38830,38831,38989,41988,42493,42495,42496,42581,43107,43119,43224,44049,45664,45665,45806,46306,46326,46327,46328,46329,46830,46831,46832,46833,46834,47116,47744,47870,48474,48598,49093,49376,49602,49689,50331,50420,50684,50685,50830,50980,51887,51982,52061,52572,52622,52645,53060,53723,53858,54043,54246,54247,54248,54249,55471,55799,55837,55847,55865,55866,55873,55881,55886,55888,55889,55893,55895,55900,55901,55903,55933,55969,56000,56019,56023,56054,56062,56079,56085,56094,56116,56146,56161,56176,56177,56198,56199,56208,56224,56230,56231,56232,56238,56244,56245,56253,56254,56261,56263,56265,56266,56270,56280,56284,56285,56287,56289,56290,56385,56386,56387,56388,56389,56390,56391,56392,56393,56394,56395,56396,56397,56398,56399,56400,56401,56402,56403,56404,56405,56406,56784,56790,56802,56803,56808,56809,56811,56813,56816,56818,56820,56861,56866,56879,56887,56903,56911,56917,56918,56919,56925,56929,56938,56939,56943,56945,56949,56992,56998,57004,57005,57006,57017,57042,57043,57068,57069,57070,57089,57090,57104,57123,57124,57126,57133,57136,57262,57263,57311,57312,57314,57318,57328,57352,57357,57360,57380,57388,57402,57408,57412,57413,57414,57415,57418,57425,57426,57427,57460,57464,57467,57473,57474,57480,57497,57611,57634,57660,57667,57673,57674,57675,57679,57685,57686,57711,57728,57731,57756,57757,57778,57781,57783,57784,57785,57786,57791,57807,57815,58185,58187,58192,58193,58219,58220,58236,58251,58262,58272,58276,58277,58278,58279,58280,58298,58302,58355,58371,58380,58475,58476,58517,58543,58555,58590,58591,58611,58640,58663,58690,58706,58707,58714,58726,58801,58930,58931,58934,59022,59091,59097,59390,59396,59423,59441,59463,59464,59536,59930,59981,59984,59987,60045,60046,60047,60048,60049,60256,60267,60268,60269,60277,60282,60286,60290,60301,60302,60303,60647,60648,60649,60654,60724,60726,60727,60728,60732,60746,60839,60841,60860,60873,60995,61013,61077,61079,61081,61154,61397,61435,61667,62121,62126,62199,62434,62436,62437,62439,62835,62929,62930,63012,63023,63024,63119,63217,63229,63714,63715,63818,63884,63889,63899,63954,64025,64027,64028,64048,64440,64464,64554,64556,64562,64592,64661,64662,64665,64724,64731,64735,64737,64744,65063,65079,65080,65146,65164,65186,65222,65375,65489,65499,65501,65504,65506,65630,65634,65643,65714,65723,65724,65727,65729,65732,65736,65750,65794,65796,65799,65876,66385,66442,66794,66801,66802,66807,66966,66980,67486,67823,67917,67995,67997,68002,68016,68453,68630,68730,68732,68743,68769,69242,69243,69309,69320,69536,69538,69631,69653,70094,70100,70179,70296,70297,70305,70306,70417,70423,70427,70431,70434,70457,70987,70997,71015,71016,71017,71018,71019,71098,71188,71281,71282,71299,71304,71768,71774,71808,71819,71821,71822,71823,71868,71926,71968,71984,71985,72065,72069,72095,72555,72584,72644,72655,72682,72711,72871,72873,72961,72981,72985,73439,73531,73581,73723,73774,74267,74371,74529,75059,75066,75164,75218,75349,75354,75371,75886,75887,75926,76018,76019,76020,76176,76177,76614,76687,76818,76831,76912,77001,77006,77372,77376,77392,77627,77644,77686,77696,77725,77726,77730,78184,78197,78207,78209,78231,78245,78281,78297,78353,78374,78389,78390,78406,78412,78419,78565,78622,78637,78648,78689,78694,78702,78703,78705,78795,79696,79708,79710,80461,80933,80938,80939,81206,81230,81249,81337,81338,81339,81481,81487,81859,81875,81885,81901,81912,81953,81967,81978,82010,82425,82445,82452,82453,82467,82468,82502,82503,82506,82508,82511,82529,82530,82554,82937,82951,82965,82971,82976,83027,83051,83053,83077,83119,83121,83268,83272,83719,84108,84112,84120,84303,84788,84807,84808,84809,85036,85149,85160,85161,85162,85228,85290,85334,85337,85667,85724,85726,85734,85965,86046,86153,86227,86239,86285,86300,86386,86388,86390,86394,86441,86445,86449,86451,86452,86456,86458,86459,86519,86520,86585,86643,86768,86771,86828,86968,86985,87012,87021,87047,87073,87156,87165,87258,87321,87324,87325,87859,87886,87923,88051,88052,88435,88440,88704,88955,89006,89007,89014,89105,89350,89459,89468,89626,89642,90102,90148,90414,90721,90743,91041,92204,92205,92222,92223,92492,92861,92880,92881,93011,93062,93069,93505,93686,93705,93714,93719,93769,94143,94160,94163,94333,94493,94545,94561,94961,94966,94997,95013,95074,95075,95085,95087,95089,95129,95149,95250,95260,95367,95377,95389,95561,95689,95742,95743,95746,95786,95812,95885,95976,96183,96191,97803,97811,97815,97817,97946,98054,98055,98074,98185,98193,98195,98225,98226,98414,98415,98416,98453,98753,98763,98781,98803,98804,98805,98991,99003,99251,99262,99459,100013,100014,100030,100204,100205,100206,100207,100222,100560,100562,100775,100870,100880,100888,101125,101127,101202,101231,101232,101314,101315,101723,101739,101742,101813,101815,101820,101844,102082,102136,102194,102200,102231,102326,102345,102360,102362,102370,102371,102381,102391,102397,102408,102414,102438,102745,102756,102993,102998,103005,103006,103007,103091,103092,103132,103151,103248,103412,103435,103510,103514,103546,103547,103780,103793,103794,103797,103806,103891,103900,104326,104328,104335,104470,104481,104484,104781,105089,105174,105175,105274,105287,105298,105299,105313,105334,105335,105338,105344,105351,105354,105356,105363,105508,105512,105514,105518,105549,105695,105696,105772,105791,105841,105888,105891,105900,105910,106390,106399,106403,106578,106579,106592,106687,106760,106763,106764,106778,106786,106793,106794,106797,106798,106813,106836,106904,107036,107039,107111,107131,107143,107152,107157,107173,107192,107251,107256,107336,107358,107417,107505,107508,108011,108019,108020,108026,108027,108044,108045,108046,108047,108048,108062,108063,108064,108065,108098,108143,108144,108152,108158,108168,108255,108296,108360,108381,108501,108514,108515,108517,108523,108524,108525,108526,108527,108528,108533,108536,108537,108544,108546,108548,108560,108562,108567,108713,108715,108720,108748,108819,108826,108828,108830,108989,109004,109044,109060,109061,109066,109077,109142,109217,109498,109595,109596,109602,109726,109734,109915,109960,110100,110104,110118,110119,110120,110121,110122,110123,110290,110318,110319,110320,110382,110410,110454,110456,110460,110571,110732,110736,110749,110934,111002,111198,111208,111612,111720,112131,112351,112514,112515,112516,112539,112623,112680,112783,112956,112957,112962,112965,112990,113041,113083,113084,113152,113205,113389,113394,113454,113582,113660,113685,113771,113778,113786,113883,113887,113956,114116,114165,114168,114174,114176,114181,114184,114185,114188,114190,114216,114223,114243,114245,114248,114254,114257,114260,114302,114309,114310,114471,114492,114495,114501,114504,114506,114510,114545,114552,114561,114569,114597,114734,114740,114780,114790,114798,114805,114811,114812,114838,114840,114848,114855,114863,114865,114883,114954,114980,114992,115008,115010,115025,115084,115150,115158,115160,115161,115165,115174,115193,115200,115228,115230,115241,115320,115325,115333,115340,115342,115468,115469,115470,115478,115482,115490,115511,115520,115539,115610,115611,115612,115613,115713,115718,116040,116065,116069,116076,116077,116123,116137,116211,116215,116226,116268,116269,116335,116351,116387,116392,116410,116426,116445,116461,116464,116465,116466,116492,116508,116528,116538,116574,116622,116641,116775,116940,116955,116959,116968,117124,117128,117129,117130,117145,117155,117215,117218,117219,117226,117299,117319,117445,117466,117520,117524,117649,117744,117746,117840,117841,117848,117860,117901,117919,117939,117965,117992,118132,118141,118190,118229,118232,118239,118274,118295,118296,118317,118321,118389,118392,118420,118421,118432,118516,118524,118525,118539,118606,118616,118785,118823,118826,118827,118866,118872,118882,118885,118960,119017,119032,119098,119122,119309,119310,119316,119321,119356,119362,119365,120116,120125,120136,120174,120424,120428,120496,120497,120498,120510,120535,120579,120580,120581,120582,120637,120654,120684,120692,120712,120713,120724,120739,120740,120752,120887,120968,120974,120978,120979,120980,120981,120994,121009,121019,121052,121102,121115,121116,121117,121118,121123,121131,121143,121144,121145,121159,121164,121239,121241,121279,121301,121312,121334,121335,121352,121363,121410,121417,121434,121440,121441,121442,121443,121635,121657,121695,121708,121726,121729,121733,121735,121838,121847,121943,122048,122161,122177,122258,122324,122335,122352,122419,122433,122445,122617,122635,122636,122665,122700,122713,122723,122792,122840,122841,122857,122866,122903,123041,123044,123047,123053,123057,123079,123125,123132,123140,123298,123299,123302,123309,123317,123319,123377,123385,123445,123446,123447,123460,123595,123748,123749,123813,123830,123835,123863,123873,123943,123971,124008,124043,124084,124119,124120,124125,124185,124195,124201,124205,124235,124257,124323,124390,124391,124394,125309,125317,125321,125373,125385,125391,125433,125442,125518,125523,125582,125597,125603,125633,125720,125758,125764,125788,125789,125800,125801,125804,125833,125838,125839,125907,125918,125951,125952,125974,125980,126001,126007,126027,126033,126037,126051,126150,126151,126165,126166,126167,126202,126228,126297,126298,126302,126303,126337,126339,126349,126383,126384,126400,126409,126412,126424,126434,126466,126473,126505,126507,126517,126608,126621,126622,126623,126631,126645,126696,126702,126731,126748,126758,126760,126778,126794,126799,126892,126894,126928,126962,126963,126978,126993,127019,127020,127043,127053,127133,127138,127140,127182,127186,127212,127215,127238,127241,127261,127266,127282,127285,127287,127307,127308,127332,127339,127388,127413,127445,127459,127461,127481,127482,127520,127531,127535,127575,127612,127626,127651,127653,127687,127720,127730,127757,127779,127781,127812,127834,127838,127868,127877,127895,127929,127930,127934,127951,127957,127983,128011,128024,128078,128106,128123,128140,128148,128155,128158,128228,128245,128268,128292,128293,128321,128322,128326,128333,128387,128460,128467,128474,128498,128504,128505,128509,128511,128513,128515,128539,128583,128615,128641,128703,128711,128713,128721,128727,128742,128811,128830,128831,128832,128854,128928,128948,128952,128977,128995,128999,129000,129004,129011,129013,129023,129063,129083,129112,129194,129207,129251,129267,129268,129281,129303,129307,129325,129332,129333,129339,129403,129407,129408,130035,130036,130038,130223,130689,131871,131872,131877,131983,132023,132080,132081,132132,132176,132243,132250,132253,132256,132294,132301,132352,132355,132467,132529,132533,132537,132591,132619,132723,132779,132938,132939,132951,133007,133042,133043,133116,133140,133222,133252,133359,133391,133567,133603,133821,133864,133870,133871,133872,133990,134168,134204,134998,134999,135062,135174,135187,135619,135620,135656,135659,135660,135661,135662,135924,135947,136056,136073,136263,136268,136274,136276,136277,136382,136405,136557,136597,136598,136607,136608,136613,136614,136615,136619,136620,136621,136622,136635,136660,136666,136672,136676,136767,136768,136974,136976,136984,136986,136988,137001,137044,137057,137082,137104,137105,137107,137121,137212,137234,137238,137250,137273,137274,137279,137285,137286,137287,137291,137295,137317,137324,137325,137329,137376,137385,137387,137388,137396,137398,137468,137494,137495,137630,137643,137656,137666,137676,137689,137691,137692,137699,137700,137706,137707,137752,137764,137781,137786,137794,137811,137816,137822,137830,137832,137840,137870,137871,137885,138002,138025,138030,138039,138049,138057,138064,138073,138075,138078,138079,138092,138098,138103,138106,138109,138113,138116,138169,138193,138194,138196,138201,138214,138216,138218,138223,138228,138234,138235,138245,138248,138253,138254,138257,138295,138296,138318,138319,138334,138341,138344,138346,138357,138361,138426,138439,138452,138464,138466,138471,138476,138477,138521,138546,138549,138556,138575,138577,138582,138610,138614,138621,138626,138658,138659,138661,138664,138665,138668,138674,138679,138714,138717,138729,138730,138768,138774,138787,138881,138882,138883,138884,138885,138886,138887,138888,138889,138890,138891,138892,138893,138894,139116,139118,139129,139339,139341,139351,139384,139390,139394,139430,139431,139432,139687,139782,140427,140445,140446,140485,141018,141040,141097,141103,141233,141245,141417,141419,141420,141431,141515,141516,141521,141529,141530,141540,141611,141650,141672,141744,141778,141869,141894,141911,141928,142001,142006,142007,142063,142145,142195,142225,142228,142229,142265,142305,142306,142311,142312,142318,142376,142385,142402,142404,142410,142454,142461,142465,142469,142475,142477,142497,142508,142510,142516,142527,142535,142543,142546,142547,142550,142551,142581,142587,142594,142702,142743,142836,142839,142845,142852,142924,142954,143004,143006,143020,143278,143281,143292,143310,143332,143336,143337,143356,143365,143374,143415,143471,143487,143506,143511,143516,143580,143602,143610,143652,143655,143659,143721,143743,143807,143819,143852,143871,143893,143899,143902,143947,143954,143970,143971,143972,143973,143982,144012,144049,144089,144153,144187,144212,144214,144231,144256,144299,144380,144434,144465,144472,144493,144494,144514,144534,144559,144561,144660,144681,144719,144735,144775,144776,144787,144788,144791,144798,144806,144837,144863,144869,144871,144879,144887,144897,144900,144904,144908,144941,144944,144958,145003,145056,145076,145078,145087,145091,145096,145106,145150,145196,145263,145266,145280,145301,145303,145304,145307,145309,145314,145317,145319,145328,145337,145339,145342,145349,145382,145450,145471,145499,145547,145548,145549,145600,145605,145606,145608,145617,145618,145619,145620,145642,145648,145659,145684,145695,145700,145702,145724,145745,145746,145771,145772,145808,145809,145831,145837,145859,145860,145863,145991,145998,146018,146022,146033,146039,146127,146129,146135,146149,146198,146205,146213,146225,146226,146229,146380,146382,146383,146387,146388,146396,146412,146415,146424,146431,146437,146440,146441,146461,146463,146478,146509,146588,146756,146789,146883,146886,146887,146888,146925,146977,146981,147007,147022,147024,147036,147052,147062,147073,147096,147107,147183,147187,147192,147208,147212,147229,147230,147259,147343,147375,147437,147496,147516,147517,147573,147578,147579,147580,147626,147631,147689,147731,147732,147848,147931,147937,147938,147940,147943,147946,147990,148010,148030,148056,148071,148129,148133,148136,148175,148190,148194,148221,148246,148247,148248,148284,148306,148319,148324,148335,148341,148383,148399,148409,148449,148511,148571,148624,148637,148638,148651,148715,148716,148732,148826,148836,148839,148856,148866,148892,148955,148978,148981,148997,148998,149023,149024,149041,149082,149085,149086,149094,149257,149310,149324,149345,149349,149351,149365,149367,149371,149381,149390,149418,149437,149457,149532,149543,149558,149564,149568,149621,149661,149709,149730,149798,149811,149967,149977,149987,150002,150024,150025,150107,150129,150149,150169,150208,150230,150243,150247,150251,150285,150336,150444,150510,150544,150574,150575,150614,150620,150639,150649,150650,150843,150929,150960,150970,150981,151160,151172,151228,151236,151238,151307,151373,151422,151549,151581,151672,151719,151743,151744,151840,151841,151888,151920,151995,151997,152032,152067,152087,152141,152152,152176,152333,152441,152576,152577,152578,152580,152583,152584,152586,152591,152592,152593,152610,152611,152757,153071,153150,153178,153281,153283,153347,153367,153375,153393,153421,153455,153477,153505,153525,153530,153535,153552,153578,153614,153616,153620,153638,153646,153658,153662,153709,153712,153800,153801,153805,153828,153831,153834,153844,153863,153872,153898,153904,153922,153934,153944,153945,153965,153972,153975,153995,154001,154027,154032,154035,154047,154052,154063,154064,154068,154089,154113,154122,154130,154140,154150,154167,154226,154242,154243,154246,154250,154251,154255,154256,154313,154314,154316,154319,154320,154330,154336,154381,154386,154388,154393,154400,154413,154422,154437,154453,154467,154468,154489,154492,154494,154500,154501,154502,154505,154506,154563,154564,154570,154604,154617,154624,154639,154654,154656,154660,154661,154665,154688,154689,154690,154729,154735,154781,154846,154856,154863,154868,154869,154870,154878,154880,154887,154889,154890,154892,154901,154913,154917,154920,154929,154935,154956,154973,154976,154999,155015,155071,155077,155086,155112,155115,155116,155117,155120,155145,155152,155248,155249,155273,155312,155316,155355,155389,155404,155410,155412,155450,155513,155530,155546,155597,155625,155634,155638,155706,155707,155742,155753,155754,155779,155805,155811,155813,155815,155823,156115,156165,156176,156177,156194,156233,156257,156331,156334,156339,156340,156341,156359,156476,156477,156482,156494,156504,156505,156550,156560,156579,156586,156657,156693,156696,156721,156736,156830,156892,156904,156907,156935,156936,156937,157037,157107,157122,157160,157268,157270,157303,157321,157349,157358,157371,157377,157551,157605,157621,157630,157635,157644,157688,157691,157700,157726,157730,157762,157822,157886,157897,157905,157913,158018,158074,158087,158093,158120,158121,158154,158173,158191,158302,158308,158356,158359,158381,158382,158576,158613,158635,158650,158656,158700,158721,158734,158762,158801,158807,158808,158809,158810,158811,158812,158814,158815,158816,158817,158818,158819,158820,158852,158901,158904,158997,159072,159114,159127,159162,159165,159191,159192,159193,159194,159195,159196,159258,159353,159356,159370,159414,159430,159496,159525,159537,159617,159730,159772,159805,159809,159827,159834,159859,159860,159861,159868,159871,159905,159911,159928,160019,160020,160149,160154,160176,160177,160206,160242,160244,160256,160257,160284,160304,160474,160476,160478,160535,160546,160612,160653,160815,160817,161391,161396,161815,161820,161824,161887,161952,162007,162008,162055,162103,162148,162149,162150,162151,162204,162293,162297,162322,162395,162405,162415,162422,162443,162543,162553,162652,162655,162689,162725,162749,162879,162935,162968,163081,163118,163145,163181,163182,163183,163239,163260,163263,163314,163434,163443,163444,163446,163487,163580,163874,163897,163944,164003,164060,164090,164128,164240,164265,164266,164267,164339,164394,164418,164466,164532,164560,164633,164665,164670,164694,164783,164810,164811,164812,164813,164834,164837,164883,164960,165093,165095,165187,165221,165225,165276,165304,165326,165327,165344,165371,165393,165402,165583,165613,165653,165694,165771,165844,165845,165876,165882,165927,165940,165942,165961,165971,165972,165984,166071,166075,166078,166079,166184,166284,166289,166317,166318,166319,166327,166380,166385,166407,166408,166438,166457,166520,166528,166569,166614,166635,166656,166686,166687,166688,166711,166779,166830,166860,166872,166873,166880,166894,166936,166942,166974,167005,167031,167050,167074,167151,167153,167154,167165,167169,167374,167506,167565,167780,167797,167823,167846,167919,167945,167967,167981,168038,168040,168047,168090,168125,168128,168129,168138,168140,168228,168230,168245,168301,168332,168337,168338,168362,168388,168419,168483,168502,168520,168521,168536,168554,168580,168631,168698,168706,168755,168759,168774,168778,168786,168816,168852,168935,168937,168938,168967,168976,168977,168980,168988,169043,169047,169054,169100,169131,169135,169145,169198,169305,169307,169315,169334,169351,169374,169460,169492,169603,169608,169610,169613,169627,169659,169757,169801,169808,169855,169863,169864,169903,169925,169967,169980,169990,170053,170064,170137,170203,170220,170225,170265,170281,170303,170311,170313,170341,170374,170379,170382,170472,170498,170533,170668,170671,170749,170758,170759,170782,170880,170887,170942,170953,170987,171067,171113,171175,171185,171188,171193,171194,171196,171201,171231,171290,171295,171346,171424,171430,171498,171508,171521,171523,171527,171800,171877,171908,171944,171946,171947,171948,171949,171950,171951,171953,171954,171955,171956,171957,171994,171998,172028,172041,172059,172095,172096,172100,172102,172118,172123,172148,172271,172343,172396,172400,172417,172421,172458,172481,172522,172553,172574,172604,172738,172742,172743,172825,172828,172829,172860,172863,172879,172884,172889,172950,172952,172954,172963,172971,172986,173033,173090,173091,173102,173103,173105,173112,173138,173153,173155,173179,173183,173245,173248,173266,173275,173282,173284,173291,173305,173327,173340,173356,173374,173377,173420,173444,173447,173457,173468,173470,173474,173495,173496,173522,173533,173570,173577,173583,173597,173685,173738,173758,173851,173854,173869,173872,173934,173943,173949,173955,173988,174027,174043,174077,174086,174088,174098,174103,174104,174121,174159,174197,174303,174355,174358,174384,174385,174418,174441,174493,174494,174504,174531,174611,174612,174655,174658,174717,174724,174726,174729,174752,174763,174768,174785,174786,174790,174793,174795,174830,174832,174858,174862,174910,174973,174981,174988,175000,175010,175055,175073,175078,175081,175136,175163,175181,175224,175242,175245,175249,175313,175319,175332,175382,175424,175441,175450,175503,175514,175523,175540,175589,175610,175641,175648,175658,175683,175705,175727,175772,175800,175804,175849,175912,175915,175928,176023,176052,176127,176159,176170,176171,176173,176174,176176,176218,176257,176272,176273,176361,176407,176411,176466,176470,176505,176507,176515,176533,176534,176544,176545,176548,176549,176643,176660,176664,176671,176705,176730,176732,176733,176744,176754,176763,176764,176781,176847,176916,176921,176946,176997,177003,177006,177011,177043,177122,177128,177144,177151,177152,177154,177185,177238,177292,177308,177309,177312,177335,177491,177502,177504,177505,177559,177572,177579,177595,177658,177672,177698,177724,177725,177738,177762,177774,177787,177881,177910,177912,177913,177918,177938,177961,178079,178099,178107,178123,178186,178205,178225,178243,178244,178301,178321,178323,178471,178477,178496,178497,178498,178501,178508,178549,178592,178609,178724,178814,178998,179132,179296,179308,179457,179545,179556,179642,179651,179720,179737,179778,179780,179790,179793,179799,179860,179898,179920,179991,180001,180067,180101,180159,180222,180261,180266,180319,180341,180425,180470,180478,180479,180533,180555,180648,180667,180694,180698,180702,180759,180786,180787,180838,180862,180867,180948,180953,180977,180987,180990,180997,181048,181049,181050,181085,181090,181100,181105,181109,181113,181159,181160,181183,181186,181188,181209,181226,181231,181243,181261,181264,181297,181305,181314,181356,181358,181423,181428,181435,181473,181501,181537,181540,181616,181661,181705,181760,181770,181771,181785,181786,181800,181803,181815,181816,181827,181835,181846,181847,181885,181906,181922,181932,181942,181946,181952,181958,181990,182015,182016,182059,182139,182185,182186,182191,182224,182226,182267,182297,182446,182598,182602,182679,182823,182851,182968,182994,183067,183072,183141,183178,183184,183219,183240,183246,183248,183261,183267,183418,183419,183646,183650,183651,183674,183675,183689,183690,183691,183692,183693,183695,183698,183723,183724,183764,183841,183915,183917,183918,183922,183941,184017,184028,184029,184047,184084,184135,184195,184214,184246,184249,184286,184291,184341,184351,184355,184356,184430,184433,184462,184520,184531,184543,184607,184626,184679,184761,184762,184766,184821,184840,184866,184901,184904,184905,184917,184933,184945,184953,184955,184963,184972,185006,185043,185050,185130,185133,185191,185194,185245,185278,185296,185344,185379,185440,185446,185451,185452,185645,185743,185781,185841,185843,185875,185917,185942,185982,186033,186044,186054,186060,186062,186080,186135,186137,186176,186180,186181,186190,186195,186201,186292,186293,186304,186307,186350,186359,186367,186377,186416,186421,186423,186424,186456,186502,186598,186607,186611,186628,186675,186681,186684,186737,186738,186743,186770,186777,186785,186838,186913,186914,186918,186961,186988,187000,187069,187179,187181,187183,187184,187216,187218,187272,187281,187318,187325,187339,187355,187415,187494,187515,187546,187561,187610,187611,187617,187618,187682,187684,187736,187834,187849,187916,187964,187965,187970,187979,187983,187987,188058,188115,188116,188177,188196,188211,188293,188402,188407,188416,188493,188507,188533,188537,188587,188645,188726,188735,188760,188792,188808,188810,188830,188863,188871,188882,188901,188906,188907,188917,188922,188924,188927,188937,188941,188942,189017,189046,189048,189062,189065,189067,189150,189182,189197,189274,189335,189388,189440,189447,189552,189566,189699,189704,189774,189777,189837,189845,189861,189923,189965,190036,190037,190106,190147,190151,190238,190240,190246,190247,190297,190315,190393,190405,190413,190421,190428,190464,190661,190726,190980,191154,191175,191195,191202,191218,191239,191313,191324,191329,191367,191413,191430,191445,191523,191575,191587,191611,191657,191665,191678,191682,191693,191723,191781,191788,191797,191801,191802,191867,191922,191945,191946,191973,192085,192098,192102,192107,192109,192155,192233,192236,192275,192340,192360,192368,192369,192372,192374,192463,192494,192506,192643,192670,192679,192707,192708,192769,192793,192828,193011,193054,193129,193140,193157,193189,193199,193200,193201,193211,193259,193261,193263,193324,193388,193404,193409,193470,193506,193548,193621,193632,193646,193650,193775,193824,193872,193909,193919,193993,194063,194106,194145,194152,194223,194298,194507,194515,194537,194549,194607,194694,194695,195022,195162,195263,195329,195378,195406,195460,195514,195623,195636,195671,195674,195708,195779,195850,195872,195948,195958,195982,196092,196262,196391,196532,196617,196632,196899,197145,197245,197248,197306,197316,197352,197452,197470,197512,197535,197552,197737,197792,198230,198284,198475,198778,198908,199028,199075,199344) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [103.85 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (20610,20611,20612,20613,20614,20615,20810,20908,21233,21234,21260,21347,21348,21415,22016,22158,22315,22366,22401,22657,22687,22689,22706,22711,22730,22732,22758,22779,22789,22799,22810,22833,22837,22844,22847,22855,22857,22858,22867,22882,22897,22904,22905,22931,23000,23001,23002,23003,23004,23005,23006,23007,23076,23083,23099,23102,23128,23140,23193,23213,23373,23377,23378,23386,23450,23648,23649,23850,23909,24040,24041,24043,24190,24519,24846,24847,24848,24849,24933,24960,25123,25157,25203,25246,25334,25363,25369,25370,25371,25400,25445,25499,25599,25653,25654,25656,25669,25703,25713,25718,25721,25783,25949,26008,26009,26021,26025,26026,26128,26198,26227,26358,26462,26500,26559,26752,26772,26814,26982,27330,27350,27406,27490,27727,27728,27729,27730,27731,27732,28240,29587,29588,29608,29699,30149,31050,31506,31816,32806,33596,33926,33965,35041,35056,35069,35080,35085,35090,35352,35411,35538,35734,35780,36208,36454,36455,36619,36620,36622,36856,38660,38691,38830,38831,38989,41988,42493,42495,42496,42581,43107,43119,43224,44049,45664,45665,45806,46306,46326,46327,46328,46329,46830,46831,46832,46833,46834,47116,47744,47870,48474,48598,49093,49376,49602,49689,50331,50420,50684,50685,50830,50980,51887,51982,52061,52572,52622,52645,53060,53723,53858,54043,54246,54247,54248,54249,55471,55799,55837,55847,55865,55866,55873,55881,55886,55888,55889,55893,55895,55900,55901,55903,55933,55969,56000,56019,56023,56054,56062,56079,56085,56094,56116,56146,56161,56176,56177,56198,56199,56208,56224,56230,56231,56232,56238,56244,56245,56253,56254,56261,56263,56265,56266,56270,56280,56284,56285,56287,56289,56290,56385,56386,56387,56388,56389,56390,56391,56392,56393,56394,56395,56396,56397,56398,56399,56400,56401,56402,56403,56404,56405,56406,56784,56790,56802,56803,56808,56809,56811,56813,56816,56818,56820,56861,56866,56879,56887,56903,56911,56917,56918,56919,56925,56929,56938,56939,56943,56945,56949,56992,56998,57004,57005,57006,57017,57042,57043,57068,57069,57070,57089,57090,57104,57123,57124,57126,57133,57136,57262,57263,57311,57312,57314,57318,57328,57352,57357,57360,57380,57388,57402,57408,57412,57413,57414,57415,57418,57425,57426,57427,57460,57464,57467,57473,57474,57480,57497,57611,57634,57660,57667,57673,57674,57675,57679,57685,57686,57711,57728,57731,57756,57757,57778,57781,57783,57784,57785,57786,57791,57807,57815,58185,58187,58192,58193,58219,58220,58236,58251,58262,58272,58276,58277,58278,58279,58280,58298,58302,58355,58371,58380,58475,58476,58517,58543,58555,58590,58591,58611,58640,58663,58690,58706,58707,58714,58726,58801,58930,58931,58934,59022,59091,59097,59390,59396,59423,59441,59463,59464,59536,59930,59981,59984,59987,60045,60046,60047,60048,60049,60256,60267,60268,60269,60277,60282,60286,60290,60301,60302,60303,60647,60648,60649,60654,60724,60726,60727,60728,60732,60746,60839,60841,60860,60873,60995,61013,61077,61079,61081,61154,61397,61435,61667,62121,62126,62199,62434,62436,62437,62439,62835,62929,62930,63012,63023,63024,63119,63217,63229,63714,63715,63818,63884,63889,63899,63954,64025,64027,64028,64048,64440,64464,64554,64556,64562,64592,64661,64662,64665,64724,64731,64735,64737,64744,65063,65079,65080,65146,65164,65186,65222,65375,65489,65499,65501,65504,65506,65630,65634,65643,65714,65723,65724,65727,65729,65732,65736,65750,65794,65796,65799,65876,66385,66442,66794,66801,66802,66807,66966,66980,67486,67823,67917,67995,67997,68002,68016,68453,68630,68730,68732,68743,68769,69242,69243,69309,69320,69536,69538,69631,69653,70094,70100,70179,70296,70297,70305,70306,70417,70423,70427,70431,70434,70457,70987,70997,71015,71016,71017,71018,71019,71098,71188,71281,71282,71299,71304,71768,71774,71808,71819,71821,71822,71823,71868,71926,71968,71984,71985,72065,72069,72095,72555,72584,72644,72655,72682,72711,72871,72873,72961,72981,72985,73439,73531,73581,73723,73774,74267,74371,74529,75059,75066,75164,75218,75349,75354,75371,75886,75887,75926,76018,76019,76020,76176,76177,76614,76687,76818,76831,76912,77001,77006,77372,77376,77392,77627,77644,77686,77696,77725,77726,77730,78184,78197,78207,78209,78231,78245,78281,78297,78353,78374,78389,78390,78406,78412,78419,78565,78622,78637,78648,78689,78694,78702,78703,78705,78795,79696,79708,79710,80461,80933,80938,80939,81206,81230,81249,81337,81338,81339,81481,81487,81859,81875,81885,81901,81912,81953,81967,81978,82010,82425,82445,82452,82453,82467,82468,82502,82503,82506,82508,82511,82529,82530,82554,82937,82951,82965,82971,82976,83027,83051,83053,83077,83119,83121,83268,83272,83719,84108,84112,84120,84303,84788,84807,84808,84809,85036,85149,85160,85161,85162,85228,85290,85334,85337,85667,85724,85726,85734,85965,86046,86153,86227,86239,86285,86300,86386,86388,86390,86394,86441,86445,86449,86451,86452,86456,86458,86459,86519,86520,86585,86643,86768,86771,86828,86968,86985,87012,87021,87047,87073,87156,87165,87258,87321,87324,87325,87859,87886,87923,88051,88052,88435,88440,88704,88955,89006,89007,89014,89105,89350,89459,89468,89626,89642,90102,90148,90414,90721,90743,91041,92204,92205,92222,92223,92492,92861,92880,92881,93011,93062,93069,93505,93686,93705,93714,93719,93769,94143,94160,94163,94333,94493,94545,94561,94961,94966,94997,95013,95074,95075,95085,95087,95089,95129,95149,95250,95260,95367,95377,95389,95561,95689,95742,95743,95746,95786,95812,95885,95976,96183,96191,97803,97811,97815,97817,97946,98054,98055,98074,98185,98193,98195,98225,98226,98414,98415,98416,98453,98753,98763,98781,98803,98804,98805,98991,99003,99251,99262,99459,100013,100014,100030,100204,100205,100206,100207,100222,100560,100562,100775,100870,100880,100888,101125,101127,101202,101231,101232,101314,101315,101723,101739,101742,101813,101815,101820,101844,102082,102136,102194,102200,102231,102326,102345,102360,102362,102370,102371,102381,102391,102397,102408,102414,102438,102745,102756,102993,102998,103005,103006,103007,103091,103092,103132,103151,103248,103412,103435,103510,103514,103546,103547,103780,103793,103794,103797,103806,103891,103900,104326,104328,104335,104470,104481,104484,104781,105089,105174,105175,105274,105287,105298,105299,105313,105334,105335,105338,105344,105351,105354,105356,105363,105508,105512,105514,105518,105549,105695,105696,105772,105791,105841,105888,105891,105900,105910,106390,106399,106403,106578,106579,106592,106687,106760,106763,106764,106778,106786,106793,106794,106797,106798,106813,106836,106904,107036,107039,107111,107131,107143,107152,107157,107173,107192,107251,107256,107336,107358,107417,107505,107508,108011,108019,108020,108026,108027,108044,108045,108046,108047,108048,108062,108063,108064,108065,108098,108143,108144,108152,108158,108168,108255,108296,108360,108381,108501,108514,108515,108517,108523,108524,108525,108526,108527,108528,108533,108536,108537,108544,108546,108548,108560,108562,108567,108713,108715,108720,108748,108819,108826,108828,108830,108989,109004,109044,109060,109061,109066,109077,109142,109217,109498,109595,109596,109602,109726,109734,109915,109960,110100,110104,110118,110119,110120,110121,110122,110123,110290,110318,110319,110320,110382,110410,110454,110456,110460,110571,110732,110736,110749,110934,111002,111198,111208,111612,111720,112131,112351,112514,112515,112516,112539,112623,112680,112783,112956,112957,112962,112965,112990,113041,113083,113084,113152,113205,113389,113394,113454,113582,113660,113685,113771,113778,113786,113883,113887,113956,114116,114165,114168,114174,114176,114181,114184,114185,114188,114190,114216,114223,114243,114245,114248,114254,114257,114260,114302,114309,114310,114471,114492,114495,114501,114504,114506,114510,114545,114552,114561,114569,114597,114734,114740,114780,114790,114798,114805,114811,114812,114838,114840,114848,114855,114863,114865,114883,114954,114980,114992,115008,115010,115025,115084,115150,115158,115160,115161,115165,115174,115193,115200,115228,115230,115241,115320,115325,115333,115340,115342,115468,115469,115470,115478,115482,115490,115511,115520,115539,115610,115611,115612,115613,115713,115718,116040,116065,116069,116076,116077,116123,116137,116211,116215,116226,116268,116269,116335,116351,116387,116392,116410,116426,116445,116461,116464,116465,116466,116492,116508,116528,116538,116574,116622,116641,116775,116940,116955,116959,116968,117124,117128,117129,117130,117145,117155,117215,117218,117219,117226,117299,117319,117445,117466,117520,117524,117649,117744,117746,117840,117841,117848,117860,117901,117919,117939,117965,117992,118132,118141,118190,118229,118232,118239,118274,118295,118296,118317,118321,118389,118392,118420,118421,118432,118516,118524,118525,118539,118606,118616,118785,118823,118826,118827,118866,118872,118882,118885,118960,119017,119032,119098,119122,119309,119310,119316,119321,119356,119362,119365,120116,120125,120136,120174,120424,120428,120496,120497,120498,120510,120535,120579,120580,120581,120582,120637,120654,120684,120692,120712,120713,120724,120739,120740,120752,120887,120968,120974,120978,120979,120980,120981,120994,121009,121019,121052,121102,121115,121116,121117,121118,121123,121131,121143,121144,121145,121159,121164,121239,121241,121279,121301,121312,121334,121335,121352,121363,121410,121417,121434,121440,121441,121442,121443,121635,121657,121695,121708,121726,121729,121733,121735,121838,121847,121943,122048,122161,122177,122258,122324,122335,122352,122419,122433,122445,122617,122635,122636,122665,122700,122713,122723,122792,122840,122841,122857,122866,122903,123041,123044,123047,123053,123057,123079,123125,123132,123140,123298,123299,123302,123309,123317,123319,123377,123385,123445,123446,123447,123460,123595,123748,123749,123813,123830,123835,123863,123873,123943,123971,124008,124043,124084,124119,124120,124125,124185,124195,124201,124205,124235,124257,124323,124390,124391,124394,125309,125317,125321,125373,125385,125391,125433,125442,125518,125523,125582,125597,125603,125633,125720,125758,125764,125788,125789,125800,125801,125804,125833,125838,125839,125907,125918,125951,125952,125974,125980,126001,126007,126027,126033,126037,126051,126150,126151,126165,126166,126167,126202,126228,126297,126298,126302,126303,126337,126339,126349,126383,126384,126400,126409,126412,126424,126434,126466,126473,126505,126507,126517,126608,126621,126622,126623,126631,126645,126696,126702,126731,126748,126758,126760,126778,126794,126799,126892,126894,126928,126962,126963,126978,126993,127019,127020,127043,127053,127133,127138,127140,127182,127186,127212,127215,127238,127241,127261,127266,127282,127285,127287,127307,127308,127332,127339,127388,127413,127445,127459,127461,127481,127482,127520,127531,127535,127575,127612,127626,127651,127653,127687,127720,127730,127757,127779,127781,127812,127834,127838,127868,127877,127895,127929,127930,127934,127951,127957,127983,128011,128024,128078,128106,128123,128140,128148,128155,128158,128228,128245,128268,128292,128293,128321,128322,128326,128333,128387,128460,128467,128474,128498,128504,128505,128509,128511,128513,128515,128539,128583,128615,128641,128703,128711,128713,128721,128727,128742,128811,128830,128831,128832,128854,128928,128948,128952,128977,128995,128999,129000,129004,129011,129013,129023,129063,129083,129112,129194,129207,129251,129267,129268,129281,129303,129307,129325,129332,129333,129339,129403,129407,129408,130035,130036,130038,130223,130689,131871,131872,131877,131983,132023,132080,132081,132132,132176,132243,132250,132253,132256,132294,132301,132352,132355,132467,132529,132533,132537,132591,132619,132723,132779,132938,132939,132951,133007,133042,133043,133116,133140,133222,133252,133359,133391,133567,133603,133821,133864,133870,133871,133872,133990,134168,134204,134998,134999,135062,135174,135187,135619,135620,135656,135659,135660,135661,135662,135924,135947,136056,136073,136263,136268,136274,136276,136277,136382,136405,136557,136597,136598,136607,136608,136613,136614,136615,136619,136620,136621,136622,136635,136660,136666,136672,136676,136767,136768,136974,136976,136984,136986,136988,137001,137044,137057,137082,137104,137105,137107,137121,137212,137234,137238,137250,137273,137274,137279,137285,137286,137287,137291,137295,137317,137324,137325,137329,137376,137385,137387,137388,137396,137398,137468,137494,137495,137630,137643,137656,137666,137676,137689,137691,137692,137699,137700,137706,137707,137752,137764,137781,137786,137794,137811,137816,137822,137830,137832,137840,137870,137871,137885,138002,138025,138030,138039,138049,138057,138064,138073,138075,138078,138079,138092,138098,138103,138106,138109,138113,138116,138169,138193,138194,138196,138201,138214,138216,138218,138223,138228,138234,138235,138245,138248,138253,138254,138257,138295,138296,138318,138319,138334,138341,138344,138346,138357,138361,138426,138439,138452,138464,138466,138471,138476,138477,138521,138546,138549,138556,138575,138577,138582,138610,138614,138621,138626,138658,138659,138661,138664,138665,138668,138674,138679,138714,138717,138729,138730,138768,138774,138787,138881,138882,138883,138884,138885,138886,138887,138888,138889,138890,138891,138892,138893,138894,139116,139118,139129,139339,139341,139351,139384,139390,139394,139430,139431,139432,139687,139782,140427,140445,140446,140485,141018,141040,141097,141103,141233,141245,141417,141419,141420,141431,141515,141516,141521,141529,141530,141540,141611,141650,141672,141744,141778,141869,141894,141911,141928,142001,142006,142007,142063,142145,142195,142225,142228,142229,142265,142305,142306,142311,142312,142318,142376,142385,142402,142404,142410,142454,142461,142465,142469,142475,142477,142497,142508,142510,142516,142527,142535,142543,142546,142547,142550,142551,142581,142587,142594,142702,142743,142836,142839,142845,142852,142924,142954,143004,143006,143020,143278,143281,143292,143310,143332,143336,143337,143356,143365,143374,143415,143471,143487,143506,143511,143516,143580,143602,143610,143652,143655,143659,143721,143743,143807,143819,143852,143871,143893,143899,143902,143947,143954,143970,143971,143972,143973,143982,144012,144049,144089,144153,144187,144212,144214,144231,144256,144299,144380,144434,144465,144472,144493,144494,144514,144534,144559,144561,144660,144681,144719,144735,144775,144776,144787,144788,144791,144798,144806,144837,144863,144869,144871,144879,144887,144897,144900,144904,144908,144941,144944,144958,145003,145056,145076,145078,145087,145091,145096,145106,145150,145196,145263,145266,145280,145301,145303,145304,145307,145309,145314,145317,145319,145328,145337,145339,145342,145349,145382,145450,145471,145499,145547,145548,145549,145600,145605,145606,145608,145617,145618,145619,145620,145642,145648,145659,145684,145695,145700,145702,145724,145745,145746,145771,145772,145808,145809,145831,145837,145859,145860,145863,145991,145998,146018,146022,146033,146039,146127,146129,146135,146149,146198,146205,146213,146225,146226,146229,146380,146382,146383,146387,146388,146396,146412,146415,146424,146431,146437,146440,146441,146461,146463,146478,146509,146588,146756,146789,146883,146886,146887,146888,146925,146977,146981,147007,147022,147024,147036,147052,147062,147073,147096,147107,147183,147187,147192,147208,147212,147229,147230,147259,147343,147375,147437,147496,147516,147517,147573,147578,147579,147580,147626,147631,147689,147731,147732,147848,147931,147937,147938,147940,147943,147946,147990,148010,148030,148056,148071,148129,148133,148136,148175,148190,148194,148221,148246,148247,148248,148284,148306,148319,148324,148335,148341,148383,148399,148409,148449,148511,148571,148624,148637,148638,148651,148715,148716,148732,148826,148836,148839,148856,148866,148892,148955,148978,148981,148997,148998,149023,149024,149041,149082,149085,149086,149094,149257,149310,149324,149345,149349,149351,149365,149367,149371,149381,149390,149418,149437,149457,149532,149543,149558,149564,149568,149621,149661,149709,149730,149798,149811,149967,149977,149987,150002,150024,150025,150107,150129,150149,150169,150208,150230,150243,150247,150251,150285,150336,150444,150510,150544,150574,150575,150614,150620,150639,150649,150650,150843,150929,150960,150970,150981,151160,151172,151228,151236,151238,151307,151373,151422,151549,151581,151672,151719,151743,151744,151840,151841,151888,151920,151995,151997,152032,152067,152087,152141,152152,152176,152333,152441,152576,152577,152578,152580,152583,152584,152586,152591,152592,152593,152610,152611,152757,153071,153150,153178,153281,153283,153347,153367,153375,153393,153421,153455,153477,153505,153525,153530,153535,153552,153578,153614,153616,153620,153638,153646,153658,153662,153709,153712,153800,153801,153805,153828,153831,153834,153844,153863,153872,153898,153904,153922,153934,153944,153945,153965,153972,153975,153995,154001,154027,154032,154035,154047,154052,154063,154064,154068,154089,154113,154122,154130,154140,154150,154167,154226,154242,154243,154246,154250,154251,154255,154256,154313,154314,154316,154319,154320,154330,154336,154381,154386,154388,154393,154400,154413,154422,154437,154453,154467,154468,154489,154492,154494,154500,154501,154502,154505,154506,154563,154564,154570,154604,154617,154624,154639,154654,154656,154660,154661,154665,154688,154689,154690,154729,154735,154781,154846,154856,154863,154868,154869,154870,154878,154880,154887,154889,154890,154892,154901,154913,154917,154920,154929,154935,154956,154973,154976,154999,155015,155071,155077,155086,155112,155115,155116,155117,155120,155145,155152,155248,155249,155273,155312,155316,155355,155389,155404,155410,155412,155450,155513,155530,155546,155597,155625,155634,155638,155706,155707,155742,155753,155754,155779,155805,155811,155813,155815,155823,156115,156165,156176,156177,156194,156233,156257,156331,156334,156339,156340,156341,156359,156476,156477,156482,156494,156504,156505,156550,156560,156579,156586,156657,156693,156696,156721,156736,156830,156892,156904,156907,156935,156936,156937,157037,157107,157122,157160,157268,157270,157303,157321,157349,157358,157371,157377,157551,157605,157621,157630,157635,157644,157688,157691,157700,157726,157730,157762,157822,157886,157897,157905,157913,158018,158074,158087,158093,158120,158121,158154,158173,158191,158302,158308,158356,158359,158381,158382,158576,158613,158635,158650,158656,158700,158721,158734,158762,158801,158807,158808,158809,158810,158811,158812,158814,158815,158816,158817,158818,158819,158820,158852,158901,158904,158997,159072,159114,159127,159162,159165,159191,159192,159193,159194,159195,159196,159258,159353,159356,159370,159414,159430,159496,159525,159537,159617,159730,159772,159805,159809,159827,159834,159859,159860,159861,159868,159871,159905,159911,159928,160019,160020,160149,160154,160176,160177,160206,160242,160244,160256,160257,160284,160304,160474,160476,160478,160535,160546,160612,160653,160815,160817,161391,161396,161815,161820,161824,161887,161952,162007,162008,162055,162103,162148,162149,162150,162151,162204,162293,162297,162322,162395,162405,162415,162422,162443,162543,162553,162652,162655,162689,162725,162749,162879,162935,162968,163081,163118,163145,163181,163182,163183,163239,163260,163263,163314,163434,163443,163444,163446,163487,163580,163874,163897,163944,164003,164060,164090,164128,164240,164265,164266,164267,164339,164394,164418,164466,164532,164560,164633,164665,164670,164694,164783,164810,164811,164812,164813,164834,164837,164883,164960,165093,165095,165187,165221,165225,165276,165304,165326,165327,165344,165371,165393,165402,165583,165613,165653,165694,165771,165844,165845,165876,165882,165927,165940,165942,165961,165971,165972,165984,166071,166075,166078,166079,166184,166284,166289,166317,166318,166319,166327,166380,166385,166407,166408,166438,166457,166520,166528,166569,166614,166635,166656,166686,166687,166688,166711,166779,166830,166860,166872,166873,166880,166894,166936,166942,166974,167005,167031,167050,167074,167151,167153,167154,167165,167169,167374,167506,167565,167780,167797,167823,167846,167919,167945,167967,167981,168038,168040,168047,168090,168125,168128,168129,168138,168140,168228,168230,168245,168301,168332,168337,168338,168362,168388,168419,168483,168502,168520,168521,168536,168554,168580,168631,168698,168706,168755,168759,168774,168778,168786,168816,168852,168935,168937,168938,168967,168976,168977,168980,168988,169043,169047,169054,169100,169131,169135,169145,169198,169305,169307,169315,169334,169351,169374,169460,169492,169603,169608,169610,169613,169627,169659,169757,169801,169808,169855,169863,169864,169903,169925,169967,169980,169990,170053,170064,170137,170203,170220,170225,170265,170281,170303,170311,170313,170341,170374,170379,170382,170472,170498,170533,170668,170671,170749,170758,170759,170782,170880,170887,170942,170953,170987,171067,171113,171175,171185,171188,171193,171194,171196,171201,171231,171290,171295,171346,171424,171430,171498,171508,171521,171523,171527,171800,171877,171908,171944,171946,171947,171948,171949,171950,171951,171953,171954,171955,171956,171957,171994,171998,172028,172041,172059,172095,172096,172100,172102,172118,172123,172148,172271,172343,172396,172400,172417,172421,172458,172481,172522,172553,172574,172604,172738,172742,172743,172825,172828,172829,172860,172863,172879,172884,172889,172950,172952,172954,172963,172971,172986,173033,173090,173091,173102,173103,173105,173112,173138,173153,173155,173179,173183,173245,173248,173266,173275,173282,173284,173291,173305,173327,173340,173356,173374,173377,173420,173444,173447,173457,173468,173470,173474,173495,173496,173522,173533,173570,173577,173583,173597,173685,173738,173758,173851,173854,173869,173872,173934,173943,173949,173955,173988,174027,174043,174077,174086,174088,174098,174103,174104,174121,174159,174197,174303,174355,174358,174384,174385,174418,174441,174493,174494,174504,174531,174611,174612,174655,174658,174717,174724,174726,174729,174752,174763,174768,174785,174786,174790,174793,174795,174830,174832,174858,174862,174910,174973,174981,174988,175000,175010,175055,175073,175078,175081,175136,175163,175181,175224,175242,175245,175249,175313,175319,175332,175382,175424,175441,175450,175503,175514,175523,175540,175589,175610,175641,175648,175658,175683,175705,175727,175772,175800,175804,175849,175912,175915,175928,176023,176052,176127,176159,176170,176171,176173,176174,176176,176218,176257,176272,176273,176361,176407,176411,176466,176470,176505,176507,176515,176533,176534,176544,176545,176548,176549,176643,176660,176664,176671,176705,176730,176732,176733,176744,176754,176763,176764,176781,176847,176916,176921,176946,176997,177003,177006,177011,177043,177122,177128,177144,177151,177152,177154,177185,177238,177292,177308,177309,177312,177335,177491,177502,177504,177505,177559,177572,177579,177595,177658,177672,177698,177724,177725,177738,177762,177774,177787,177881,177910,177912,177913,177918,177938,177961,178079,178099,178107,178123,178186,178205,178225,178243,178244,178301,178321,178323,178471,178477,178496,178497,178498,178501,178508,178549,178592,178609,178724,178814,178998,179132,179296,179308,179457,179545,179556,179642,179651,179720,179737,179778,179780,179790,179793,179799,179860,179898,179920,179991,180001,180067,180101,180159,180222,180261,180266,180319,180341,180425,180470,180478,180479,180533,180555,180648,180667,180694,180698,180702,180759,180786,180787,180838,180862,180867,180948,180953,180977,180987,180990,180997,181048,181049,181050,181085,181090,181100,181105,181109,181113,181159,181160,181183,181186,181188,181209,181226,181231,181243,181261,181264,181297,181305,181314,181356,181358,181423,181428,181435,181473,181501,181537,181540,181616,181661,181705,181760,181770,181771,181785,181786,181800,181803,181815,181816,181827,181835,181846,181847,181885,181906,181922,181932,181942,181946,181952,181958,181990,182015,182016,182059,182139,182185,182186,182191,182224,182226,182267,182297,182446,182598,182602,182679,182823,182851,182968,182994,183067,183072,183141,183178,183184,183219,183240,183246,183248,183261,183267,183418,183419,183646,183650,183651,183674,183675,183689,183690,183691,183692,183693,183695,183698,183723,183724,183764,183841,183915,183917,183918,183922,183941,184017,184028,184029,184047,184084,184135,184195,184214,184246,184249,184286,184291,184341,184351,184355,184356,184430,184433,184462,184520,184531,184543,184607,184626,184679,184761,184762,184766,184821,184840,184866,184901,184904,184905,184917,184933,184945,184953,184955,184963,184972,185006,185043,185050,185130,185133,185191,185194,185245,185278,185296,185344,185379,185440,185446,185451,185452,185645,185743,185781,185841,185843,185875,185917,185942,185982,186033,186044,186054,186060,186062,186080,186135,186137,186176,186180,186181,186190,186195,186201,186292,186293,186304,186307,186350,186359,186367,186377,186416,186421,186423,186424,186456,186502,186598,186607,186611,186628,186675,186681,186684,186737,186738,186743,186770,186777,186785,186838,186913,186914,186918,186961,186988,187000,187069,187179,187181,187183,187184,187216,187218,187272,187281,187318,187325,187339,187355,187415,187494,187515,187546,187561,187610,187611,187617,187618,187682,187684,187736,187834,187849,187916,187964,187965,187970,187979,187983,187987,188058,188115,188116,188177,188196,188211,188293,188402,188407,188416,188493,188507,188533,188537,188587,188645,188726,188735,188760,188792,188808,188810,188830,188863,188871,188882,188901,188906,188907,188917,188922,188924,188927,188937,188941,188942,189017,189046,189048,189062,189065,189067,189150,189182,189197,189274,189335,189388,189440,189447,189552,189566,189699,189704,189774,189777,189837,189845,189861,189923,189965,190036,190037,190106,190147,190151,190238,190240,190246,190247,190297,190315,190393,190405,190413,190421,190428,190464,190661,190726,190980,191154,191175,191195,191202,191218,191239,191313,191324,191329,191367,191413,191430,191445,191523,191575,191587,191611,191657,191665,191678,191682,191693,191723,191781,191788,191797,191801,191802,191867,191922,191945,191946,191973,192085,192098,192102,192107,192109,192155,192233,192236,192275,192340,192360,192368,192369,192372,192374,192463,192494,192506,192643,192670,192679,192707,192708,192769,192793,192828,193011,193054,193129,193140,193157,193189,193199,193200,193201,193211,193259,193261,193263,193324,193388,193404,193409,193470,193506,193548,193621,193632,193646,193650,193775,193824,193872,193909,193919,193993,194063,194106,194145,194152,194223,194298,194507,194515,194537,194549,194607,194694,194695,195022,195162,195263,195329,195378,195406,195460,195514,195623,195636,195671,195674,195708,195779,195850,195872,195948,195958,195982,196092,196262,196391,196532,196617,196632,196899,197145,197245,197248,197306,197316,197352,197452,197470,197512,197535,197552,197737,197792,198230,198284,198475,198778,198908,199028,199075,199344) GROUP BY sold_week ORDER BY scs.date_actual_sold |
78 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (20610,20611,20612,20613,20614,20615,20810,20908,21233,21234,21260,21347,21348,21415,22016,22158,22315,22366,22401,22657,22687,22689,22706,22711,22730,22732,22758,22779,22789,22799,22810,22833,22837,22844,22847,22855,22857,22858,22867,22882,22897,22904,22905,22931,23000,23001,23002,23003,23004,23005,23006,23007,23076,23083,23099,23102,23128,23140,23193,23213,23373,23377,23378,23386,23450,23648,23649,23850,23909,24040,24041,24043,24190,24519,24846,24847,24848,24849,24933,24960,25123,25157,25203,25246,25334,25363,25369,25370,25371,25400,25445,25499,25599,25653,25654,25656,25669,25703,25713,25718,25721,25783,25949,26008,26009,26021,26025,26026,26128,26198,26227,26358,26462,26500,26559,26752,26772,26814,26982,27330,27350,27406,27490,27727,27728,27729,27730,27731,27732,28240,29587,29588,29608,29699,30149,31050,31506,31816,32806,33596,33926,33965,35041,35056,35069,35080,35085,35090,35352,35411,35538,35734,35780,36208,36454,36455,36619,36620,36622,36856,38660,38691,38830,38831,38989,41988,42493,42495,42496,42581,43107,43119,43224,44049,45664,45665,45806,46306,46326,46327,46328,46329,46830,46831,46832,46833,46834,47116,47744,47870,48474,48598,49093,49376,49602,49689,50331,50420,50684,50685,50830,50980,51887,51982,52061,52572,52622,52645,53060,53723,53858,54043,54246,54247,54248,54249,55471,55799,55837,55847,55865,55866,55873,55881,55886,55888,55889,55893,55895,55900,55901,55903,55933,55969,56000,56019,56023,56054,56062,56079,56085,56094,56116,56146,56161,56176,56177,56198,56199,56208,56224,56230,56231,56232,56238,56244,56245,56253,56254,56261,56263,56265,56266,56270,56280,56284,56285,56287,56289,56290,56385,56386,56387,56388,56389,56390,56391,56392,56393,56394,56395,56396,56397,56398,56399,56400,56401,56402,56403,56404,56405,56406,56784,56790,56802,56803,56808,56809,56811,56813,56816,56818,56820,56861,56866,56879,56887,56903,56911,56917,56918,56919,56925,56929,56938,56939,56943,56945,56949,56992,56998,57004,57005,57006,57017,57042,57043,57068,57069,57070,57089,57090,57104,57123,57124,57126,57133,57136,57262,57263,57311,57312,57314,57318,57328,57352,57357,57360,57380,57388,57402,57408,57412,57413,57414,57415,57418,57425,57426,57427,57460,57464,57467,57473,57474,57480,57497,57611,57634,57660,57667,57673,57674,57675,57679,57685,57686,57711,57728,57731,57756,57757,57778,57781,57783,57784,57785,57786,57791,57807,57815,58185,58187,58192,58193,58219,58220,58236,58251,58262,58272,58276,58277,58278,58279,58280,58298,58302,58355,58371,58380,58475,58476,58517,58543,58555,58590,58591,58611,58640,58663,58690,58706,58707,58714,58726,58801,58930,58931,58934,59022,59091,59097,59390,59396,59423,59441,59463,59464,59536,59930,59981,59984,59987,60045,60046,60047,60048,60049,60256,60267,60268,60269,60277,60282,60286,60290,60301,60302,60303,60647,60648,60649,60654,60724,60726,60727,60728,60732,60746,60839,60841,60860,60873,60995,61013,61077,61079,61081,61154,61397,61435,61667,62121,62126,62199,62434,62436,62437,62439,62835,62929,62930,63012,63023,63024,63119,63217,63229,63714,63715,63818,63884,63889,63899,63954,64025,64027,64028,64048,64440,64464,64554,64556,64562,64592,64661,64662,64665,64724,64731,64735,64737,64744,65063,65079,65080,65146,65164,65186,65222,65375,65489,65499,65501,65504,65506,65630,65634,65643,65714,65723,65724,65727,65729,65732,65736,65750,65794,65796,65799,65876,66385,66442,66794,66801,66802,66807,66966,66980,67486,67823,67917,67995,67997,68002,68016,68453,68630,68730,68732,68743,68769,69242,69243,69309,69320,69536,69538,69631,69653,70094,70100,70179,70296,70297,70305,70306,70417,70423,70427,70431,70434,70457,70987,70997,71015,71016,71017,71018,71019,71098,71188,71281,71282,71299,71304,71768,71774,71808,71819,71821,71822,71823,71868,71926,71968,71984,71985,72065,72069,72095,72555,72584,72644,72655,72682,72711,72871,72873,72961,72981,72985,73439,73531,73581,73723,73774,74267,74371,74529,75059,75066,75164,75218,75349,75354,75371,75886,75887,75926,76018,76019,76020,76176,76177,76614,76687,76818,76831,76912,77001,77006,77372,77376,77392,77627,77644,77686,77696,77725,77726,77730,78184,78197,78207,78209,78231,78245,78281,78297,78353,78374,78389,78390,78406,78412,78419,78565,78622,78637,78648,78689,78694,78702,78703,78705,78795,79696,79708,79710,80461,80933,80938,80939,81206,81230,81249,81337,81338,81339,81481,81487,81859,81875,81885,81901,81912,81953,81967,81978,82010,82425,82445,82452,82453,82467,82468,82502,82503,82506,82508,82511,82529,82530,82554,82937,82951,82965,82971,82976,83027,83051,83053,83077,83119,83121,83268,83272,83719,84108,84112,84120,84303,84788,84807,84808,84809,85036,85149,85160,85161,85162,85228,85290,85334,85337,85667,85724,85726,85734,85965,86046,86153,86227,86239,86285,86300,86386,86388,86390,86394,86441,86445,86449,86451,86452,86456,86458,86459,86519,86520,86585,86643,86768,86771,86828,86968,86985,87012,87021,87047,87073,87156,87165,87258,87321,87324,87325,87859,87886,87923,88051,88052,88435,88440,88704,88955,89006,89007,89014,89105,89350,89459,89468,89626,89642,90102,90148,90414,90721,90743,91041,92204,92205,92222,92223,92492,92861,92880,92881,93011,93062,93069,93505,93686,93705,93714,93719,93769,94143,94160,94163,94333,94493,94545,94561,94961,94966,94997,95013,95074,95075,95085,95087,95089,95129,95149,95250,95260,95367,95377,95389,95561,95689,95742,95743,95746,95786,95812,95885,95976,96183,96191,97803,97811,97815,97817,97946,98054,98055,98074,98185,98193,98195,98225,98226,98414,98415,98416,98453,98753,98763,98781,98803,98804,98805,98991,99003,99251,99262,99459,100013,100014,100030,100204,100205,100206,100207,100222,100560,100562,100775,100870,100880,100888,101125,101127,101202,101231,101232,101314,101315,101723,101739,101742,101813,101815,101820,101844,102082,102136,102194,102200,102231,102326,102345,102360,102362,102370,102371,102381,102391,102397,102408,102414,102438,102745,102756,102993,102998,103005,103006,103007,103091,103092,103132,103151,103248,103412,103435,103510,103514,103546,103547,103780,103793,103794,103797,103806,103891,103900,104326,104328,104335,104470,104481,104484,104781,105089,105174,105175,105274,105287,105298,105299,105313,105334,105335,105338,105344,105351,105354,105356,105363,105508,105512,105514,105518,105549,105695,105696,105772,105791,105841,105888,105891,105900,105910,106390,106399,106403,106578,106579,106592,106687,106760,106763,106764,106778,106786,106793,106794,106797,106798,106813,106836,106904,107036,107039,107111,107131,107143,107152,107157,107173,107192,107251,107256,107336,107358,107417,107505,107508,108011,108019,108020,108026,108027,108044,108045,108046,108047,108048,108062,108063,108064,108065,108098,108143,108144,108152,108158,108168,108255,108296,108360,108381,108501,108514,108515,108517,108523,108524,108525,108526,108527,108528,108533,108536,108537,108544,108546,108548,108560,108562,108567,108713,108715,108720,108748,108819,108826,108828,108830,108989,109004,109044,109060,109061,109066,109077,109142,109217,109498,109595,109596,109602,109726,109734,109915,109960,110100,110104,110118,110119,110120,110121,110122,110123,110290,110318,110319,110320,110382,110410,110454,110456,110460,110571,110732,110736,110749,110934,111002,111198,111208,111612,111720,112131,112351,112514,112515,112516,112539,112623,112680,112783,112956,112957,112962,112965,112990,113041,113083,113084,113152,113205,113389,113394,113454,113582,113660,113685,113771,113778,113786,113883,113887,113956,114116,114165,114168,114174,114176,114181,114184,114185,114188,114190,114216,114223,114243,114245,114248,114254,114257,114260,114302,114309,114310,114471,114492,114495,114501,114504,114506,114510,114545,114552,114561,114569,114597,114734,114740,114780,114790,114798,114805,114811,114812,114838,114840,114848,114855,114863,114865,114883,114954,114980,114992,115008,115010,115025,115084,115150,115158,115160,115161,115165,115174,115193,115200,115228,115230,115241,115320,115325,115333,115340,115342,115468,115469,115470,115478,115482,115490,115511,115520,115539,115610,115611,115612,115613,115713,115718,116040,116065,116069,116076,116077,116123,116137,116211,116215,116226,116268,116269,116335,116351,116387,116392,116410,116426,116445,116461,116464,116465,116466,116492,116508,116528,116538,116574,116622,116641,116775,116940,116955,116959,116968,117124,117128,117129,117130,117145,117155,117215,117218,117219,117226,117299,117319,117445,117466,117520,117524,117649,117744,117746,117840,117841,117848,117860,117901,117919,117939,117965,117992,118132,118141,118190,118229,118232,118239,118274,118295,118296,118317,118321,118389,118392,118420,118421,118432,118516,118524,118525,118539,118606,118616,118785,118823,118826,118827,118866,118872,118882,118885,118960,119017,119032,119098,119122,119309,119310,119316,119321,119356,119362,119365,120116,120125,120136,120174,120424,120428,120496,120497,120498,120510,120535,120579,120580,120581,120582,120637,120654,120684,120692,120712,120713,120724,120739,120740,120752,120887,120968,120974,120978,120979,120980,120981,120994,121009,121019,121052,121102,121115,121116,121117,121118,121123,121131,121143,121144,121145,121159,121164,121239,121241,121279,121301,121312,121334,121335,121352,121363,121410,121417,121434,121440,121441,121442,121443,121635,121657,121695,121708,121726,121729,121733,121735,121838,121847,121943,122048,122161,122177,122258,122324,122335,122352,122419,122433,122445,122617,122635,122636,122665,122700,122713,122723,122792,122840,122841,122857,122866,122903,123041,123044,123047,123053,123057,123079,123125,123132,123140,123298,123299,123302,123309,123317,123319,123377,123385,123445,123446,123447,123460,123595,123748,123749,123813,123830,123835,123863,123873,123943,123971,124008,124043,124084,124119,124120,124125,124185,124195,124201,124205,124235,124257,124323,124390,124391,124394,125309,125317,125321,125373,125385,125391,125433,125442,125518,125523,125582,125597,125603,125633,125720,125758,125764,125788,125789,125800,125801,125804,125833,125838,125839,125907,125918,125951,125952,125974,125980,126001,126007,126027,126033,126037,126051,126150,126151,126165,126166,126167,126202,126228,126297,126298,126302,126303,126337,126339,126349,126383,126384,126400,126409,126412,126424,126434,126466,126473,126505,126507,126517,126608,126621,126622,126623,126631,126645,126696,126702,126731,126748,126758,126760,126778,126794,126799,126892,126894,126928,126962,126963,126978,126993,127019,127020,127043,127053,127133,127138,127140,127182,127186,127212,127215,127238,127241,127261,127266,127282,127285,127287,127307,127308,127332,127339,127388,127413,127445,127459,127461,127481,127482,127520,127531,127535,127575,127612,127626,127651,127653,127687,127720,127730,127757,127779,127781,127812,127834,127838,127868,127877,127895,127929,127930,127934,127951,127957,127983,128011,128024,128078,128106,128123,128140,128148,128155,128158,128228,128245,128268,128292,128293,128321,128322,128326,128333,128387,128460,128467,128474,128498,128504,128505,128509,128511,128513,128515,128539,128583,128615,128641,128703,128711,128713,128721,128727,128742,128811,128830,128831,128832,128854,128928,128948,128952,128977,128995,128999,129000,129004,129011,129013,129023,129063,129083,129112,129194,129207,129251,129267,129268,129281,129303,129307,129325,129332,129333,129339,129403,129407,129408,130035,130036,130038,130223,130689,131871,131872,131877,131983,132023,132080,132081,132132,132176,132243,132250,132253,132256,132294,132301,132352,132355,132467,132529,132533,132537,132591,132619,132723,132779,132938,132939,132951,133007,133042,133043,133116,133140,133222,133252,133359,133391,133567,133603,133821,133864,133870,133871,133872,133990,134168,134204,134998,134999,135062,135174,135187,135619,135620,135656,135659,135660,135661,135662,135924,135947,136056,136073,136263,136268,136274,136276,136277,136382,136405,136557,136597,136598,136607,136608,136613,136614,136615,136619,136620,136621,136622,136635,136660,136666,136672,136676,136767,136768,136974,136976,136984,136986,136988,137001,137044,137057,137082,137104,137105,137107,137121,137212,137234,137238,137250,137273,137274,137279,137285,137286,137287,137291,137295,137317,137324,137325,137329,137376,137385,137387,137388,137396,137398,137468,137494,137495,137630,137643,137656,137666,137676,137689,137691,137692,137699,137700,137706,137707,137752,137764,137781,137786,137794,137811,137816,137822,137830,137832,137840,137870,137871,137885,138002,138025,138030,138039,138049,138057,138064,138073,138075,138078,138079,138092,138098,138103,138106,138109,138113,138116,138169,138193,138194,138196,138201,138214,138216,138218,138223,138228,138234,138235,138245,138248,138253,138254,138257,138295,138296,138318,138319,138334,138341,138344,138346,138357,138361,138426,138439,138452,138464,138466,138471,138476,138477,138521,138546,138549,138556,138575,138577,138582,138610,138614,138621,138626,138658,138659,138661,138664,138665,138668,138674,138679,138714,138717,138729,138730,138768,138774,138787,138881,138882,138883,138884,138885,138886,138887,138888,138889,138890,138891,138892,138893,138894,139116,139118,139129,139339,139341,139351,139384,139390,139394,139430,139431,139432,139687,139782,140427,140445,140446,140485,141018,141040,141097,141103,141233,141245,141417,141419,141420,141431,141515,141516,141521,141529,141530,141540,141611,141650,141672,141744,141778,141869,141894,141911,141928,142001,142006,142007,142063,142145,142195,142225,142228,142229,142265,142305,142306,142311,142312,142318,142376,142385,142402,142404,142410,142454,142461,142465,142469,142475,142477,142497,142508,142510,142516,142527,142535,142543,142546,142547,142550,142551,142581,142587,142594,142702,142743,142836,142839,142845,142852,142924,142954,143004,143006,143020,143278,143281,143292,143310,143332,143336,143337,143356,143365,143374,143415,143471,143487,143506,143511,143516,143580,143602,143610,143652,143655,143659,143721,143743,143807,143819,143852,143871,143893,143899,143902,143947,143954,143970,143971,143972,143973,143982,144012,144049,144089,144153,144187,144212,144214,144231,144256,144299,144380,144434,144465,144472,144493,144494,144514,144534,144559,144561,144660,144681,144719,144735,144775,144776,144787,144788,144791,144798,144806,144837,144863,144869,144871,144879,144887,144897,144900,144904,144908,144941,144944,144958,145003,145056,145076,145078,145087,145091,145096,145106,145150,145196,145263,145266,145280,145301,145303,145304,145307,145309,145314,145317,145319,145328,145337,145339,145342,145349,145382,145450,145471,145499,145547,145548,145549,145600,145605,145606,145608,145617,145618,145619,145620,145642,145648,145659,145684,145695,145700,145702,145724,145745,145746,145771,145772,145808,145809,145831,145837,145859,145860,145863,145991,145998,146018,146022,146033,146039,146127,146129,146135,146149,146198,146205,146213,146225,146226,146229,146380,146382,146383,146387,146388,146396,146412,146415,146424,146431,146437,146440,146441,146461,146463,146478,146509,146588,146756,146789,146883,146886,146887,146888,146925,146977,146981,147007,147022,147024,147036,147052,147062,147073,147096,147107,147183,147187,147192,147208,147212,147229,147230,147259,147343,147375,147437,147496,147516,147517,147573,147578,147579,147580,147626,147631,147689,147731,147732,147848,147931,147937,147938,147940,147943,147946,147990,148010,148030,148056,148071,148129,148133,148136,148175,148190,148194,148221,148246,148247,148248,148284,148306,148319,148324,148335,148341,148383,148399,148409,148449,148511,148571,148624,148637,148638,148651,148715,148716,148732,148826,148836,148839,148856,148866,148892,148955,148978,148981,148997,148998,149023,149024,149041,149082,149085,149086,149094,149257,149310,149324,149345,149349,149351,149365,149367,149371,149381,149390,149418,149437,149457,149532,149543,149558,149564,149568,149621,149661,149709,149730,149798,149811,149967,149977,149987,150002,150024,150025,150107,150129,150149,150169,150208,150230,150243,150247,150251,150285,150336,150444,150510,150544,150574,150575,150614,150620,150639,150649,150650,150843,150929,150960,150970,150981,151160,151172,151228,151236,151238,151307,151373,151422,151549,151581,151672,151719,151743,151744,151840,151841,151888,151920,151995,151997,152032,152067,152087,152141,152152,152176,152333,152441,152576,152577,152578,152580,152583,152584,152586,152591,152592,152593,152610,152611,152757,153071,153150,153178,153281,153283,153347,153367,153375,153393,153421,153455,153477,153505,153525,153530,153535,153552,153578,153614,153616,153620,153638,153646,153658,153662,153709,153712,153800,153801,153805,153828,153831,153834,153844,153863,153872,153898,153904,153922,153934,153944,153945,153965,153972,153975,153995,154001,154027,154032,154035,154047,154052,154063,154064,154068,154089,154113,154122,154130,154140,154150,154167,154226,154242,154243,154246,154250,154251,154255,154256,154313,154314,154316,154319,154320,154330,154336,154381,154386,154388,154393,154400,154413,154422,154437,154453,154467,154468,154489,154492,154494,154500,154501,154502,154505,154506,154563,154564,154570,154604,154617,154624,154639,154654,154656,154660,154661,154665,154688,154689,154690,154729,154735,154781,154846,154856,154863,154868,154869,154870,154878,154880,154887,154889,154890,154892,154901,154913,154917,154920,154929,154935,154956,154973,154976,154999,155015,155071,155077,155086,155112,155115,155116,155117,155120,155145,155152,155248,155249,155273,155312,155316,155355,155389,155404,155410,155412,155450,155513,155530,155546,155597,155625,155634,155638,155706,155707,155742,155753,155754,155779,155805,155811,155813,155815,155823,156115,156165,156176,156177,156194,156233,156257,156331,156334,156339,156340,156341,156359,156476,156477,156482,156494,156504,156505,156550,156560,156579,156586,156657,156693,156696,156721,156736,156830,156892,156904,156907,156935,156936,156937,157037,157107,157122,157160,157268,157270,157303,157321,157349,157358,157371,157377,157551,157605,157621,157630,157635,157644,157688,157691,157700,157726,157730,157762,157822,157886,157897,157905,157913,158018,158074,158087,158093,158120,158121,158154,158173,158191,158302,158308,158356,158359,158381,158382,158576,158613,158635,158650,158656,158700,158721,158734,158762,158801,158807,158808,158809,158810,158811,158812,158814,158815,158816,158817,158818,158819,158820,158852,158901,158904,158997,159072,159114,159127,159162,159165,159191,159192,159193,159194,159195,159196,159258,159353,159356,159370,159414,159430,159496,159525,159537,159617,159730,159772,159805,159809,159827,159834,159859,159860,159861,159868,159871,159905,159911,159928,160019,160020,160149,160154,160176,160177,160206,160242,160244,160256,160257,160284,160304,160474,160476,160478,160535,160546,160612,160653,160815,160817,161391,161396,161815,161820,161824,161887,161952,162007,162008,162055,162103,162148,162149,162150,162151,162204,162293,162297,162322,162395,162405,162415,162422,162443,162543,162553,162652,162655,162689,162725,162749,162879,162935,162968,163081,163118,163145,163181,163182,163183,163239,163260,163263,163314,163434,163443,163444,163446,163487,163580,163874,163897,163944,164003,164060,164090,164128,164240,164265,164266,164267,164339,164394,164418,164466,164532,164560,164633,164665,164670,164694,164783,164810,164811,164812,164813,164834,164837,164883,164960,165093,165095,165187,165221,165225,165276,165304,165326,165327,165344,165371,165393,165402,165583,165613,165653,165694,165771,165844,165845,165876,165882,165927,165940,165942,165961,165971,165972,165984,166071,166075,166078,166079,166184,166284,166289,166317,166318,166319,166327,166380,166385,166407,166408,166438,166457,166520,166528,166569,166614,166635,166656,166686,166687,166688,166711,166779,166830,166860,166872,166873,166880,166894,166936,166942,166974,167005,167031,167050,167074,167151,167153,167154,167165,167169,167374,167506,167565,167780,167797,167823,167846,167919,167945,167967,167981,168038,168040,168047,168090,168125,168128,168129,168138,168140,168228,168230,168245,168301,168332,168337,168338,168362,168388,168419,168483,168502,168520,168521,168536,168554,168580,168631,168698,168706,168755,168759,168774,168778,168786,168816,168852,168935,168937,168938,168967,168976,168977,168980,168988,169043,169047,169054,169100,169131,169135,169145,169198,169305,169307,169315,169334,169351,169374,169460,169492,169603,169608,169610,169613,169627,169659,169757,169801,169808,169855,169863,169864,169903,169925,169967,169980,169990,170053,170064,170137,170203,170220,170225,170265,170281,170303,170311,170313,170341,170374,170379,170382,170472,170498,170533,170668,170671,170749,170758,170759,170782,170880,170887,170942,170953,170987,171067,171113,171175,171185,171188,171193,171194,171196,171201,171231,171290,171295,171346,171424,171430,171498,171508,171521,171523,171527,171800,171877,171908,171944,171946,171947,171948,171949,171950,171951,171953,171954,171955,171956,171957,171994,171998,172028,172041,172059,172095,172096,172100,172102,172118,172123,172148,172271,172343,172396,172400,172417,172421,172458,172481,172522,172553,172574,172604,172738,172742,172743,172825,172828,172829,172860,172863,172879,172884,172889,172950,172952,172954,172963,172971,172986,173033,173090,173091,173102,173103,173105,173112,173138,173153,173155,173179,173183,173245,173248,173266,173275,173282,173284,173291,173305,173327,173340,173356,173374,173377,173420,173444,173447,173457,173468,173470,173474,173495,173496,173522,173533,173570,173577,173583,173597,173685,173738,173758,173851,173854,173869,173872,173934,173943,173949,173955,173988,174027,174043,174077,174086,174088,174098,174103,174104,174121,174159,174197,174303,174355,174358,174384,174385,174418,174441,174493,174494,174504,174531,174611,174612,174655,174658,174717,174724,174726,174729,174752,174763,174768,174785,174786,174790,174793,174795,174830,174832,174858,174862,174910,174973,174981,174988,175000,175010,175055,175073,175078,175081,175136,175163,175181,175224,175242,175245,175249,175313,175319,175332,175382,175424,175441,175450,175503,175514,175523,175540,175589,175610,175641,175648,175658,175683,175705,175727,175772,175800,175804,175849,175912,175915,175928,176023,176052,176127,176159,176170,176171,176173,176174,176176,176218,176257,176272,176273,176361,176407,176411,176466,176470,176505,176507,176515,176533,176534,176544,176545,176548,176549,176643,176660,176664,176671,176705,176730,176732,176733,176744,176754,176763,176764,176781,176847,176916,176921,176946,176997,177003,177006,177011,177043,177122,177128,177144,177151,177152,177154,177185,177238,177292,177308,177309,177312,177335,177491,177502,177504,177505,177559,177572,177579,177595,177658,177672,177698,177724,177725,177738,177762,177774,177787,177881,177910,177912,177913,177918,177938,177961,178079,178099,178107,178123,178186,178205,178225,178243,178244,178301,178321,178323,178471,178477,178496,178497,178498,178501,178508,178549,178592,178609,178724,178814,178998,179132,179296,179308,179457,179545,179556,179642,179651,179720,179737,179778,179780,179790,179793,179799,179860,179898,179920,179991,180001,180067,180101,180159,180222,180261,180266,180319,180341,180425,180470,180478,180479,180533,180555,180648,180667,180694,180698,180702,180759,180786,180787,180838,180862,180867,180948,180953,180977,180987,180990,180997,181048,181049,181050,181085,181090,181100,181105,181109,181113,181159,181160,181183,181186,181188,181209,181226,181231,181243,181261,181264,181297,181305,181314,181356,181358,181423,181428,181435,181473,181501,181537,181540,181616,181661,181705,181760,181770,181771,181785,181786,181800,181803,181815,181816,181827,181835,181846,181847,181885,181906,181922,181932,181942,181946,181952,181958,181990,182015,182016,182059,182139,182185,182186,182191,182224,182226,182267,182297,182446,182598,182602,182679,182823,182851,182968,182994,183067,183072,183141,183178,183184,183219,183240,183246,183248,183261,183267,183418,183419,183646,183650,183651,183674,183675,183689,183690,183691,183692,183693,183695,183698,183723,183724,183764,183841,183915,183917,183918,183922,183941,184017,184028,184029,184047,184084,184135,184195,184214,184246,184249,184286,184291,184341,184351,184355,184356,184430,184433,184462,184520,184531,184543,184607,184626,184679,184761,184762,184766,184821,184840,184866,184901,184904,184905,184917,184933,184945,184953,184955,184963,184972,185006,185043,185050,185130,185133,185191,185194,185245,185278,185296,185344,185379,185440,185446,185451,185452,185645,185743,185781,185841,185843,185875,185917,185942,185982,186033,186044,186054,186060,186062,186080,186135,186137,186176,186180,186181,186190,186195,186201,186292,186293,186304,186307,186350,186359,186367,186377,186416,186421,186423,186424,186456,186502,186598,186607,186611,186628,186675,186681,186684,186737,186738,186743,186770,186777,186785,186838,186913,186914,186918,186961,186988,187000,187069,187179,187181,187183,187184,187216,187218,187272,187281,187318,187325,187339,187355,187415,187494,187515,187546,187561,187610,187611,187617,187618,187682,187684,187736,187834,187849,187916,187964,187965,187970,187979,187983,187987,188058,188115,188116,188177,188196,188211,188293,188402,188407,188416,188493,188507,188533,188537,188587,188645,188726,188735,188760,188792,188808,188810,188830,188863,188871,188882,188901,188906,188907,188917,188922,188924,188927,188937,188941,188942,189017,189046,189048,189062,189065,189067,189150,189182,189197,189274,189335,189388,189440,189447,189552,189566,189699,189704,189774,189777,189837,189845,189861,189923,189965,190036,190037,190106,190147,190151,190238,190240,190246,190247,190297,190315,190393,190405,190413,190421,190428,190464,190661,190726,190980,191154,191175,191195,191202,191218,191239,191313,191324,191329,191367,191413,191430,191445,191523,191575,191587,191611,191657,191665,191678,191682,191693,191723,191781,191788,191797,191801,191802,191867,191922,191945,191946,191973,192085,192098,192102,192107,192109,192155,192233,192236,192275,192340,192360,192368,192369,192372,192374,192463,192494,192506,192643,192670,192679,192707,192708,192769,192793,192828,193011,193054,193129,193140,193157,193189,193199,193200,193201,193211,193259,193261,193263,193324,193388,193404,193409,193470,193506,193548,193621,193632,193646,193650,193775,193824,193872,193909,193919,193993,194063,194106,194145,194152,194223,194298,194507,194515,194537,194549,194607,194694,194695,195022,195162,195263,195329,195378,195406,195460,195514,195623,195636,195671,195674,195708,195779,195850,195872,195948,195958,195982,196092,196262,196391,196532,196617,196632,196899,197145,197245,197248,197306,197316,197352,197452,197470,197512,197535,197552,197737,197792,198230,198284,198475,198778,198908,199028,199075,199344) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [121.19 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (20610,20611,20612,20613,20614,20615,20810,20908,21233,21234,21260,21347,21348,21415,22016,22158,22315,22366,22401,22657,22687,22689,22706,22711,22730,22732,22758,22779,22789,22799,22810,22833,22837,22844,22847,22855,22857,22858,22867,22882,22897,22904,22905,22931,23000,23001,23002,23003,23004,23005,23006,23007,23076,23083,23099,23102,23128,23140,23193,23213,23373,23377,23378,23386,23450,23648,23649,23850,23909,24040,24041,24043,24190,24519,24846,24847,24848,24849,24933,24960,25123,25157,25203,25246,25334,25363,25369,25370,25371,25400,25445,25499,25599,25653,25654,25656,25669,25703,25713,25718,25721,25783,25949,26008,26009,26021,26025,26026,26128,26198,26227,26358,26462,26500,26559,26752,26772,26814,26982,27330,27350,27406,27490,27727,27728,27729,27730,27731,27732,28240,29587,29588,29608,29699,30149,31050,31506,31816,32806,33596,33926,33965,35041,35056,35069,35080,35085,35090,35352,35411,35538,35734,35780,36208,36454,36455,36619,36620,36622,36856,38660,38691,38830,38831,38989,41988,42493,42495,42496,42581,43107,43119,43224,44049,45664,45665,45806,46306,46326,46327,46328,46329,46830,46831,46832,46833,46834,47116,47744,47870,48474,48598,49093,49376,49602,49689,50331,50420,50684,50685,50830,50980,51887,51982,52061,52572,52622,52645,53060,53723,53858,54043,54246,54247,54248,54249,55471,55799,55837,55847,55865,55866,55873,55881,55886,55888,55889,55893,55895,55900,55901,55903,55933,55969,56000,56019,56023,56054,56062,56079,56085,56094,56116,56146,56161,56176,56177,56198,56199,56208,56224,56230,56231,56232,56238,56244,56245,56253,56254,56261,56263,56265,56266,56270,56280,56284,56285,56287,56289,56290,56385,56386,56387,56388,56389,56390,56391,56392,56393,56394,56395,56396,56397,56398,56399,56400,56401,56402,56403,56404,56405,56406,56784,56790,56802,56803,56808,56809,56811,56813,56816,56818,56820,56861,56866,56879,56887,56903,56911,56917,56918,56919,56925,56929,56938,56939,56943,56945,56949,56992,56998,57004,57005,57006,57017,57042,57043,57068,57069,57070,57089,57090,57104,57123,57124,57126,57133,57136,57262,57263,57311,57312,57314,57318,57328,57352,57357,57360,57380,57388,57402,57408,57412,57413,57414,57415,57418,57425,57426,57427,57460,57464,57467,57473,57474,57480,57497,57611,57634,57660,57667,57673,57674,57675,57679,57685,57686,57711,57728,57731,57756,57757,57778,57781,57783,57784,57785,57786,57791,57807,57815,58185,58187,58192,58193,58219,58220,58236,58251,58262,58272,58276,58277,58278,58279,58280,58298,58302,58355,58371,58380,58475,58476,58517,58543,58555,58590,58591,58611,58640,58663,58690,58706,58707,58714,58726,58801,58930,58931,58934,59022,59091,59097,59390,59396,59423,59441,59463,59464,59536,59930,59981,59984,59987,60045,60046,60047,60048,60049,60256,60267,60268,60269,60277,60282,60286,60290,60301,60302,60303,60647,60648,60649,60654,60724,60726,60727,60728,60732,60746,60839,60841,60860,60873,60995,61013,61077,61079,61081,61154,61397,61435,61667,62121,62126,62199,62434,62436,62437,62439,62835,62929,62930,63012,63023,63024,63119,63217,63229,63714,63715,63818,63884,63889,63899,63954,64025,64027,64028,64048,64440,64464,64554,64556,64562,64592,64661,64662,64665,64724,64731,64735,64737,64744,65063,65079,65080,65146,65164,65186,65222,65375,65489,65499,65501,65504,65506,65630,65634,65643,65714,65723,65724,65727,65729,65732,65736,65750,65794,65796,65799,65876,66385,66442,66794,66801,66802,66807,66966,66980,67486,67823,67917,67995,67997,68002,68016,68453,68630,68730,68732,68743,68769,69242,69243,69309,69320,69536,69538,69631,69653,70094,70100,70179,70296,70297,70305,70306,70417,70423,70427,70431,70434,70457,70987,70997,71015,71016,71017,71018,71019,71098,71188,71281,71282,71299,71304,71768,71774,71808,71819,71821,71822,71823,71868,71926,71968,71984,71985,72065,72069,72095,72555,72584,72644,72655,72682,72711,72871,72873,72961,72981,72985,73439,73531,73581,73723,73774,74267,74371,74529,75059,75066,75164,75218,75349,75354,75371,75886,75887,75926,76018,76019,76020,76176,76177,76614,76687,76818,76831,76912,77001,77006,77372,77376,77392,77627,77644,77686,77696,77725,77726,77730,78184,78197,78207,78209,78231,78245,78281,78297,78353,78374,78389,78390,78406,78412,78419,78565,78622,78637,78648,78689,78694,78702,78703,78705,78795,79696,79708,79710,80461,80933,80938,80939,81206,81230,81249,81337,81338,81339,81481,81487,81859,81875,81885,81901,81912,81953,81967,81978,82010,82425,82445,82452,82453,82467,82468,82502,82503,82506,82508,82511,82529,82530,82554,82937,82951,82965,82971,82976,83027,83051,83053,83077,83119,83121,83268,83272,83719,84108,84112,84120,84303,84788,84807,84808,84809,85036,85149,85160,85161,85162,85228,85290,85334,85337,85667,85724,85726,85734,85965,86046,86153,86227,86239,86285,86300,86386,86388,86390,86394,86441,86445,86449,86451,86452,86456,86458,86459,86519,86520,86585,86643,86768,86771,86828,86968,86985,87012,87021,87047,87073,87156,87165,87258,87321,87324,87325,87859,87886,87923,88051,88052,88435,88440,88704,88955,89006,89007,89014,89105,89350,89459,89468,89626,89642,90102,90148,90414,90721,90743,91041,92204,92205,92222,92223,92492,92861,92880,92881,93011,93062,93069,93505,93686,93705,93714,93719,93769,94143,94160,94163,94333,94493,94545,94561,94961,94966,94997,95013,95074,95075,95085,95087,95089,95129,95149,95250,95260,95367,95377,95389,95561,95689,95742,95743,95746,95786,95812,95885,95976,96183,96191,97803,97811,97815,97817,97946,98054,98055,98074,98185,98193,98195,98225,98226,98414,98415,98416,98453,98753,98763,98781,98803,98804,98805,98991,99003,99251,99262,99459,100013,100014,100030,100204,100205,100206,100207,100222,100560,100562,100775,100870,100880,100888,101125,101127,101202,101231,101232,101314,101315,101723,101739,101742,101813,101815,101820,101844,102082,102136,102194,102200,102231,102326,102345,102360,102362,102370,102371,102381,102391,102397,102408,102414,102438,102745,102756,102993,102998,103005,103006,103007,103091,103092,103132,103151,103248,103412,103435,103510,103514,103546,103547,103780,103793,103794,103797,103806,103891,103900,104326,104328,104335,104470,104481,104484,104781,105089,105174,105175,105274,105287,105298,105299,105313,105334,105335,105338,105344,105351,105354,105356,105363,105508,105512,105514,105518,105549,105695,105696,105772,105791,105841,105888,105891,105900,105910,106390,106399,106403,106578,106579,106592,106687,106760,106763,106764,106778,106786,106793,106794,106797,106798,106813,106836,106904,107036,107039,107111,107131,107143,107152,107157,107173,107192,107251,107256,107336,107358,107417,107505,107508,108011,108019,108020,108026,108027,108044,108045,108046,108047,108048,108062,108063,108064,108065,108098,108143,108144,108152,108158,108168,108255,108296,108360,108381,108501,108514,108515,108517,108523,108524,108525,108526,108527,108528,108533,108536,108537,108544,108546,108548,108560,108562,108567,108713,108715,108720,108748,108819,108826,108828,108830,108989,109004,109044,109060,109061,109066,109077,109142,109217,109498,109595,109596,109602,109726,109734,109915,109960,110100,110104,110118,110119,110120,110121,110122,110123,110290,110318,110319,110320,110382,110410,110454,110456,110460,110571,110732,110736,110749,110934,111002,111198,111208,111612,111720,112131,112351,112514,112515,112516,112539,112623,112680,112783,112956,112957,112962,112965,112990,113041,113083,113084,113152,113205,113389,113394,113454,113582,113660,113685,113771,113778,113786,113883,113887,113956,114116,114165,114168,114174,114176,114181,114184,114185,114188,114190,114216,114223,114243,114245,114248,114254,114257,114260,114302,114309,114310,114471,114492,114495,114501,114504,114506,114510,114545,114552,114561,114569,114597,114734,114740,114780,114790,114798,114805,114811,114812,114838,114840,114848,114855,114863,114865,114883,114954,114980,114992,115008,115010,115025,115084,115150,115158,115160,115161,115165,115174,115193,115200,115228,115230,115241,115320,115325,115333,115340,115342,115468,115469,115470,115478,115482,115490,115511,115520,115539,115610,115611,115612,115613,115713,115718,116040,116065,116069,116076,116077,116123,116137,116211,116215,116226,116268,116269,116335,116351,116387,116392,116410,116426,116445,116461,116464,116465,116466,116492,116508,116528,116538,116574,116622,116641,116775,116940,116955,116959,116968,117124,117128,117129,117130,117145,117155,117215,117218,117219,117226,117299,117319,117445,117466,117520,117524,117649,117744,117746,117840,117841,117848,117860,117901,117919,117939,117965,117992,118132,118141,118190,118229,118232,118239,118274,118295,118296,118317,118321,118389,118392,118420,118421,118432,118516,118524,118525,118539,118606,118616,118785,118823,118826,118827,118866,118872,118882,118885,118960,119017,119032,119098,119122,119309,119310,119316,119321,119356,119362,119365,120116,120125,120136,120174,120424,120428,120496,120497,120498,120510,120535,120579,120580,120581,120582,120637,120654,120684,120692,120712,120713,120724,120739,120740,120752,120887,120968,120974,120978,120979,120980,120981,120994,121009,121019,121052,121102,121115,121116,121117,121118,121123,121131,121143,121144,121145,121159,121164,121239,121241,121279,121301,121312,121334,121335,121352,121363,121410,121417,121434,121440,121441,121442,121443,121635,121657,121695,121708,121726,121729,121733,121735,121838,121847,121943,122048,122161,122177,122258,122324,122335,122352,122419,122433,122445,122617,122635,122636,122665,122700,122713,122723,122792,122840,122841,122857,122866,122903,123041,123044,123047,123053,123057,123079,123125,123132,123140,123298,123299,123302,123309,123317,123319,123377,123385,123445,123446,123447,123460,123595,123748,123749,123813,123830,123835,123863,123873,123943,123971,124008,124043,124084,124119,124120,124125,124185,124195,124201,124205,124235,124257,124323,124390,124391,124394,125309,125317,125321,125373,125385,125391,125433,125442,125518,125523,125582,125597,125603,125633,125720,125758,125764,125788,125789,125800,125801,125804,125833,125838,125839,125907,125918,125951,125952,125974,125980,126001,126007,126027,126033,126037,126051,126150,126151,126165,126166,126167,126202,126228,126297,126298,126302,126303,126337,126339,126349,126383,126384,126400,126409,126412,126424,126434,126466,126473,126505,126507,126517,126608,126621,126622,126623,126631,126645,126696,126702,126731,126748,126758,126760,126778,126794,126799,126892,126894,126928,126962,126963,126978,126993,127019,127020,127043,127053,127133,127138,127140,127182,127186,127212,127215,127238,127241,127261,127266,127282,127285,127287,127307,127308,127332,127339,127388,127413,127445,127459,127461,127481,127482,127520,127531,127535,127575,127612,127626,127651,127653,127687,127720,127730,127757,127779,127781,127812,127834,127838,127868,127877,127895,127929,127930,127934,127951,127957,127983,128011,128024,128078,128106,128123,128140,128148,128155,128158,128228,128245,128268,128292,128293,128321,128322,128326,128333,128387,128460,128467,128474,128498,128504,128505,128509,128511,128513,128515,128539,128583,128615,128641,128703,128711,128713,128721,128727,128742,128811,128830,128831,128832,128854,128928,128948,128952,128977,128995,128999,129000,129004,129011,129013,129023,129063,129083,129112,129194,129207,129251,129267,129268,129281,129303,129307,129325,129332,129333,129339,129403,129407,129408,130035,130036,130038,130223,130689,131871,131872,131877,131983,132023,132080,132081,132132,132176,132243,132250,132253,132256,132294,132301,132352,132355,132467,132529,132533,132537,132591,132619,132723,132779,132938,132939,132951,133007,133042,133043,133116,133140,133222,133252,133359,133391,133567,133603,133821,133864,133870,133871,133872,133990,134168,134204,134998,134999,135062,135174,135187,135619,135620,135656,135659,135660,135661,135662,135924,135947,136056,136073,136263,136268,136274,136276,136277,136382,136405,136557,136597,136598,136607,136608,136613,136614,136615,136619,136620,136621,136622,136635,136660,136666,136672,136676,136767,136768,136974,136976,136984,136986,136988,137001,137044,137057,137082,137104,137105,137107,137121,137212,137234,137238,137250,137273,137274,137279,137285,137286,137287,137291,137295,137317,137324,137325,137329,137376,137385,137387,137388,137396,137398,137468,137494,137495,137630,137643,137656,137666,137676,137689,137691,137692,137699,137700,137706,137707,137752,137764,137781,137786,137794,137811,137816,137822,137830,137832,137840,137870,137871,137885,138002,138025,138030,138039,138049,138057,138064,138073,138075,138078,138079,138092,138098,138103,138106,138109,138113,138116,138169,138193,138194,138196,138201,138214,138216,138218,138223,138228,138234,138235,138245,138248,138253,138254,138257,138295,138296,138318,138319,138334,138341,138344,138346,138357,138361,138426,138439,138452,138464,138466,138471,138476,138477,138521,138546,138549,138556,138575,138577,138582,138610,138614,138621,138626,138658,138659,138661,138664,138665,138668,138674,138679,138714,138717,138729,138730,138768,138774,138787,138881,138882,138883,138884,138885,138886,138887,138888,138889,138890,138891,138892,138893,138894,139116,139118,139129,139339,139341,139351,139384,139390,139394,139430,139431,139432,139687,139782,140427,140445,140446,140485,141018,141040,141097,141103,141233,141245,141417,141419,141420,141431,141515,141516,141521,141529,141530,141540,141611,141650,141672,141744,141778,141869,141894,141911,141928,142001,142006,142007,142063,142145,142195,142225,142228,142229,142265,142305,142306,142311,142312,142318,142376,142385,142402,142404,142410,142454,142461,142465,142469,142475,142477,142497,142508,142510,142516,142527,142535,142543,142546,142547,142550,142551,142581,142587,142594,142702,142743,142836,142839,142845,142852,142924,142954,143004,143006,143020,143278,143281,143292,143310,143332,143336,143337,143356,143365,143374,143415,143471,143487,143506,143511,143516,143580,143602,143610,143652,143655,143659,143721,143743,143807,143819,143852,143871,143893,143899,143902,143947,143954,143970,143971,143972,143973,143982,144012,144049,144089,144153,144187,144212,144214,144231,144256,144299,144380,144434,144465,144472,144493,144494,144514,144534,144559,144561,144660,144681,144719,144735,144775,144776,144787,144788,144791,144798,144806,144837,144863,144869,144871,144879,144887,144897,144900,144904,144908,144941,144944,144958,145003,145056,145076,145078,145087,145091,145096,145106,145150,145196,145263,145266,145280,145301,145303,145304,145307,145309,145314,145317,145319,145328,145337,145339,145342,145349,145382,145450,145471,145499,145547,145548,145549,145600,145605,145606,145608,145617,145618,145619,145620,145642,145648,145659,145684,145695,145700,145702,145724,145745,145746,145771,145772,145808,145809,145831,145837,145859,145860,145863,145991,145998,146018,146022,146033,146039,146127,146129,146135,146149,146198,146205,146213,146225,146226,146229,146380,146382,146383,146387,146388,146396,146412,146415,146424,146431,146437,146440,146441,146461,146463,146478,146509,146588,146756,146789,146883,146886,146887,146888,146925,146977,146981,147007,147022,147024,147036,147052,147062,147073,147096,147107,147183,147187,147192,147208,147212,147229,147230,147259,147343,147375,147437,147496,147516,147517,147573,147578,147579,147580,147626,147631,147689,147731,147732,147848,147931,147937,147938,147940,147943,147946,147990,148010,148030,148056,148071,148129,148133,148136,148175,148190,148194,148221,148246,148247,148248,148284,148306,148319,148324,148335,148341,148383,148399,148409,148449,148511,148571,148624,148637,148638,148651,148715,148716,148732,148826,148836,148839,148856,148866,148892,148955,148978,148981,148997,148998,149023,149024,149041,149082,149085,149086,149094,149257,149310,149324,149345,149349,149351,149365,149367,149371,149381,149390,149418,149437,149457,149532,149543,149558,149564,149568,149621,149661,149709,149730,149798,149811,149967,149977,149987,150002,150024,150025,150107,150129,150149,150169,150208,150230,150243,150247,150251,150285,150336,150444,150510,150544,150574,150575,150614,150620,150639,150649,150650,150843,150929,150960,150970,150981,151160,151172,151228,151236,151238,151307,151373,151422,151549,151581,151672,151719,151743,151744,151840,151841,151888,151920,151995,151997,152032,152067,152087,152141,152152,152176,152333,152441,152576,152577,152578,152580,152583,152584,152586,152591,152592,152593,152610,152611,152757,153071,153150,153178,153281,153283,153347,153367,153375,153393,153421,153455,153477,153505,153525,153530,153535,153552,153578,153614,153616,153620,153638,153646,153658,153662,153709,153712,153800,153801,153805,153828,153831,153834,153844,153863,153872,153898,153904,153922,153934,153944,153945,153965,153972,153975,153995,154001,154027,154032,154035,154047,154052,154063,154064,154068,154089,154113,154122,154130,154140,154150,154167,154226,154242,154243,154246,154250,154251,154255,154256,154313,154314,154316,154319,154320,154330,154336,154381,154386,154388,154393,154400,154413,154422,154437,154453,154467,154468,154489,154492,154494,154500,154501,154502,154505,154506,154563,154564,154570,154604,154617,154624,154639,154654,154656,154660,154661,154665,154688,154689,154690,154729,154735,154781,154846,154856,154863,154868,154869,154870,154878,154880,154887,154889,154890,154892,154901,154913,154917,154920,154929,154935,154956,154973,154976,154999,155015,155071,155077,155086,155112,155115,155116,155117,155120,155145,155152,155248,155249,155273,155312,155316,155355,155389,155404,155410,155412,155450,155513,155530,155546,155597,155625,155634,155638,155706,155707,155742,155753,155754,155779,155805,155811,155813,155815,155823,156115,156165,156176,156177,156194,156233,156257,156331,156334,156339,156340,156341,156359,156476,156477,156482,156494,156504,156505,156550,156560,156579,156586,156657,156693,156696,156721,156736,156830,156892,156904,156907,156935,156936,156937,157037,157107,157122,157160,157268,157270,157303,157321,157349,157358,157371,157377,157551,157605,157621,157630,157635,157644,157688,157691,157700,157726,157730,157762,157822,157886,157897,157905,157913,158018,158074,158087,158093,158120,158121,158154,158173,158191,158302,158308,158356,158359,158381,158382,158576,158613,158635,158650,158656,158700,158721,158734,158762,158801,158807,158808,158809,158810,158811,158812,158814,158815,158816,158817,158818,158819,158820,158852,158901,158904,158997,159072,159114,159127,159162,159165,159191,159192,159193,159194,159195,159196,159258,159353,159356,159370,159414,159430,159496,159525,159537,159617,159730,159772,159805,159809,159827,159834,159859,159860,159861,159868,159871,159905,159911,159928,160019,160020,160149,160154,160176,160177,160206,160242,160244,160256,160257,160284,160304,160474,160476,160478,160535,160546,160612,160653,160815,160817,161391,161396,161815,161820,161824,161887,161952,162007,162008,162055,162103,162148,162149,162150,162151,162204,162293,162297,162322,162395,162405,162415,162422,162443,162543,162553,162652,162655,162689,162725,162749,162879,162935,162968,163081,163118,163145,163181,163182,163183,163239,163260,163263,163314,163434,163443,163444,163446,163487,163580,163874,163897,163944,164003,164060,164090,164128,164240,164265,164266,164267,164339,164394,164418,164466,164532,164560,164633,164665,164670,164694,164783,164810,164811,164812,164813,164834,164837,164883,164960,165093,165095,165187,165221,165225,165276,165304,165326,165327,165344,165371,165393,165402,165583,165613,165653,165694,165771,165844,165845,165876,165882,165927,165940,165942,165961,165971,165972,165984,166071,166075,166078,166079,166184,166284,166289,166317,166318,166319,166327,166380,166385,166407,166408,166438,166457,166520,166528,166569,166614,166635,166656,166686,166687,166688,166711,166779,166830,166860,166872,166873,166880,166894,166936,166942,166974,167005,167031,167050,167074,167151,167153,167154,167165,167169,167374,167506,167565,167780,167797,167823,167846,167919,167945,167967,167981,168038,168040,168047,168090,168125,168128,168129,168138,168140,168228,168230,168245,168301,168332,168337,168338,168362,168388,168419,168483,168502,168520,168521,168536,168554,168580,168631,168698,168706,168755,168759,168774,168778,168786,168816,168852,168935,168937,168938,168967,168976,168977,168980,168988,169043,169047,169054,169100,169131,169135,169145,169198,169305,169307,169315,169334,169351,169374,169460,169492,169603,169608,169610,169613,169627,169659,169757,169801,169808,169855,169863,169864,169903,169925,169967,169980,169990,170053,170064,170137,170203,170220,170225,170265,170281,170303,170311,170313,170341,170374,170379,170382,170472,170498,170533,170668,170671,170749,170758,170759,170782,170880,170887,170942,170953,170987,171067,171113,171175,171185,171188,171193,171194,171196,171201,171231,171290,171295,171346,171424,171430,171498,171508,171521,171523,171527,171800,171877,171908,171944,171946,171947,171948,171949,171950,171951,171953,171954,171955,171956,171957,171994,171998,172028,172041,172059,172095,172096,172100,172102,172118,172123,172148,172271,172343,172396,172400,172417,172421,172458,172481,172522,172553,172574,172604,172738,172742,172743,172825,172828,172829,172860,172863,172879,172884,172889,172950,172952,172954,172963,172971,172986,173033,173090,173091,173102,173103,173105,173112,173138,173153,173155,173179,173183,173245,173248,173266,173275,173282,173284,173291,173305,173327,173340,173356,173374,173377,173420,173444,173447,173457,173468,173470,173474,173495,173496,173522,173533,173570,173577,173583,173597,173685,173738,173758,173851,173854,173869,173872,173934,173943,173949,173955,173988,174027,174043,174077,174086,174088,174098,174103,174104,174121,174159,174197,174303,174355,174358,174384,174385,174418,174441,174493,174494,174504,174531,174611,174612,174655,174658,174717,174724,174726,174729,174752,174763,174768,174785,174786,174790,174793,174795,174830,174832,174858,174862,174910,174973,174981,174988,175000,175010,175055,175073,175078,175081,175136,175163,175181,175224,175242,175245,175249,175313,175319,175332,175382,175424,175441,175450,175503,175514,175523,175540,175589,175610,175641,175648,175658,175683,175705,175727,175772,175800,175804,175849,175912,175915,175928,176023,176052,176127,176159,176170,176171,176173,176174,176176,176218,176257,176272,176273,176361,176407,176411,176466,176470,176505,176507,176515,176533,176534,176544,176545,176548,176549,176643,176660,176664,176671,176705,176730,176732,176733,176744,176754,176763,176764,176781,176847,176916,176921,176946,176997,177003,177006,177011,177043,177122,177128,177144,177151,177152,177154,177185,177238,177292,177308,177309,177312,177335,177491,177502,177504,177505,177559,177572,177579,177595,177658,177672,177698,177724,177725,177738,177762,177774,177787,177881,177910,177912,177913,177918,177938,177961,178079,178099,178107,178123,178186,178205,178225,178243,178244,178301,178321,178323,178471,178477,178496,178497,178498,178501,178508,178549,178592,178609,178724,178814,178998,179132,179296,179308,179457,179545,179556,179642,179651,179720,179737,179778,179780,179790,179793,179799,179860,179898,179920,179991,180001,180067,180101,180159,180222,180261,180266,180319,180341,180425,180470,180478,180479,180533,180555,180648,180667,180694,180698,180702,180759,180786,180787,180838,180862,180867,180948,180953,180977,180987,180990,180997,181048,181049,181050,181085,181090,181100,181105,181109,181113,181159,181160,181183,181186,181188,181209,181226,181231,181243,181261,181264,181297,181305,181314,181356,181358,181423,181428,181435,181473,181501,181537,181540,181616,181661,181705,181760,181770,181771,181785,181786,181800,181803,181815,181816,181827,181835,181846,181847,181885,181906,181922,181932,181942,181946,181952,181958,181990,182015,182016,182059,182139,182185,182186,182191,182224,182226,182267,182297,182446,182598,182602,182679,182823,182851,182968,182994,183067,183072,183141,183178,183184,183219,183240,183246,183248,183261,183267,183418,183419,183646,183650,183651,183674,183675,183689,183690,183691,183692,183693,183695,183698,183723,183724,183764,183841,183915,183917,183918,183922,183941,184017,184028,184029,184047,184084,184135,184195,184214,184246,184249,184286,184291,184341,184351,184355,184356,184430,184433,184462,184520,184531,184543,184607,184626,184679,184761,184762,184766,184821,184840,184866,184901,184904,184905,184917,184933,184945,184953,184955,184963,184972,185006,185043,185050,185130,185133,185191,185194,185245,185278,185296,185344,185379,185440,185446,185451,185452,185645,185743,185781,185841,185843,185875,185917,185942,185982,186033,186044,186054,186060,186062,186080,186135,186137,186176,186180,186181,186190,186195,186201,186292,186293,186304,186307,186350,186359,186367,186377,186416,186421,186423,186424,186456,186502,186598,186607,186611,186628,186675,186681,186684,186737,186738,186743,186770,186777,186785,186838,186913,186914,186918,186961,186988,187000,187069,187179,187181,187183,187184,187216,187218,187272,187281,187318,187325,187339,187355,187415,187494,187515,187546,187561,187610,187611,187617,187618,187682,187684,187736,187834,187849,187916,187964,187965,187970,187979,187983,187987,188058,188115,188116,188177,188196,188211,188293,188402,188407,188416,188493,188507,188533,188537,188587,188645,188726,188735,188760,188792,188808,188810,188830,188863,188871,188882,188901,188906,188907,188917,188922,188924,188927,188937,188941,188942,189017,189046,189048,189062,189065,189067,189150,189182,189197,189274,189335,189388,189440,189447,189552,189566,189699,189704,189774,189777,189837,189845,189861,189923,189965,190036,190037,190106,190147,190151,190238,190240,190246,190247,190297,190315,190393,190405,190413,190421,190428,190464,190661,190726,190980,191154,191175,191195,191202,191218,191239,191313,191324,191329,191367,191413,191430,191445,191523,191575,191587,191611,191657,191665,191678,191682,191693,191723,191781,191788,191797,191801,191802,191867,191922,191945,191946,191973,192085,192098,192102,192107,192109,192155,192233,192236,192275,192340,192360,192368,192369,192372,192374,192463,192494,192506,192643,192670,192679,192707,192708,192769,192793,192828,193011,193054,193129,193140,193157,193189,193199,193200,193201,193211,193259,193261,193263,193324,193388,193404,193409,193470,193506,193548,193621,193632,193646,193650,193775,193824,193872,193909,193919,193993,194063,194106,194145,194152,194223,194298,194507,194515,194537,194549,194607,194694,194695,195022,195162,195263,195329,195378,195406,195460,195514,195623,195636,195671,195674,195708,195779,195850,195872,195948,195958,195982,196092,196262,196391,196532,196617,196632,196899,197145,197245,197248,197306,197316,197352,197452,197470,197512,197535,197552,197737,197792,198230,198284,198475,198778,198908,199028,199075,199344) GROUP BY sold_month ORDER BY scs.date_actual_sold |
80 | Creole | prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
81 | Creole | executeQuery(): [3638.18 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
82 | Action | change layout to "view_layout" |
83 | View | initialize view for "home/view" |
84 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
85 | View | initialize view for "home/_vif_images" |
86 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
87 | PartialHelper | Generate cache key |
88 | View | initialize view for "common_page/_social_buttons" |
89 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
90 | PartialHelper | Generate cache key |
91 | View | initialize view for "home/_vif_info" |
92 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
93 | PartialHelper | Generate cache key |
94 | View | initialize view for "home/_hoover_user_info" |
95 | View | render "sf_app_dir/modules/home/templates/_hoover_user_info.php" |
96 | PartialHelper | Generate cache key |
97 | View | initialize view for "common_page/_price_development_graph" |
98 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
99 | PartialHelper | Generate cache key |
100 | View | initialize view for "common_page/_sell_time_price_graph" |
101 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
102 | PartialHelper | Generate cache key |
103 | View | initialize view for "common_page/_price_gauge_graph" |
104 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
105 | PartialHelper | Generate cache key |
106 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
107 | Creole | executeQuery(): [10.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199955 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [2.83 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199932 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199892 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199880 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.66 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199828 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199933 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.84 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199880 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [0.73 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199879 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199825 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199719 |
126 | View | initialize view for "common_page/_include_vif_js" |
127 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php" |
128 | PartialHelper | Generate cache key |
129 | View | initialize view for "common_page/_fancybox_javascript" |
130 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
131 | PartialHelper | Generate cache key |
132 | View | decorate content with "sf_app_dir/templates/view_layout.php" |
133 | View | render "sf_app_dir/templates/view_layout.php" |
134 | View | initialize view for "common_page/_responsive_javascript" |
135 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php" |
136 | PartialHelper | Generate cache key |
137 | View | initialize view for "common_page/_google_analytics" |
138 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php" |
139 | PartialHelper | Generate cache key |
140 | View | initialize view for "common_page/_header_links" |
141 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php" |
142 | View | initialize view for "common_page/_fancybox_javascript" |
143 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
144 | PartialHelper | Generate cache key |
145 | View | initialize view for "common_page/_cookie_policy" |
146 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php" |
147 | PartialHelper | Generate cache key |
148 | PartialHelper | Generate cache key |
149 | View | initialize view for "common_page/_responsive_top_menu" |
150 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php" |
151 | PartialHelper | Generate cache key |
152 | View | initialize view for "common_page/_top_menu" |
153 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php" |
154 | PartialHelper | Generate cache key |
155 | View | initialize view for "common_page/_footer_javascript" |
156 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php" |
157 | PartialHelper | Generate cache key |
158 | View | initialize view for "common_page/_footer" |
159 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php" |
160 | PartialHelper | Generate cache key |
--- parameterHolder: symfony/default: ID_AD: 199770 action: view id: 199770 make: chevrolet model: corvette module: home attributeHolder: symfony/default: HOME_LINK: <a title="cap_na_default_title_3" href="https://www.classicdigest.com/cars/index_dev.php">Classic Cars</a> base_domain: .classicdigest.com display_que_ans_setction: Y show_cookie_policy: 1
--- cookies: httpHeaders: Content-Type: text/html; charset=utf-8 parameterHolder: helper/asset/auto/httpmeta: Content-Type: text/html; charset=utf-8 helper/asset/auto/javascript: /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main helper/asset/auto/meta: author: Fiare description: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy keywords: auto, autot, vaihtoautot, vaihtoauto, vaihtoautoliike, bensa, polttoaine, käytetyt, netiauto, osta, myy, käytetty, etsi, haku, ilmastointi, stereot, amatööri, moottori, katsastus, kesäauto, automaatti, kova, halpa, halvalla, kone, hyvä, nopea, ilmainen, ilmaiseksi, second hand, used, car, cars, hot, fast, good, cheap language: et,Estonian,ru,russia,fi,soumeksi,en,English other: Mach1 Oy:n kehittämä vaihtoautosivusto. netiauto.ee on sivusto yksityisille ilmoittajille sekä autoliikkeille. netiauto.ee:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtoautoa etsivää. revisit-after: 15 days robots: follow,index title: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy helper/asset/auto/stylesheet: /sf/sf_web_debug/css/main: symfony/action/view: home_view_layout: view_layout symfony/response/http/headers: Content-Type: text/html; charset=utf-8 symfony/view/asset: javascripts_included: stylesheets_included:
--- app_params_adbox_slot: 6 app_params_image_limit: 25 app_params_pdf_limit: 1 app_params_site: Classic Cars app_params_tot_limit_na: 50 app_params_tot_per_month_limit: 50 app_params_web_master: administrator@classicdigest.com app_params_www: www.classicdigest.com/cars app_url_na: https://www.classicdigest.com/cars/index_dev.php app_url_nm: https://www.classicdigest.com/motorcycles/index_dev.php app_url_site_url: https://www.classicdigest.com/cars/index_dev.php css_jquery_ui_custom: jquery-ui-1.8.23.custom.min.css css_jsquares: jsquares.min.css css_responsive: responsive.min.css css_style: style.min.css homepage_sms_slots: 12 html_direction: ltr html_left: left html_right: right jquery_url: https://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js js_banner: banner.min.js js_common: common.min.js js_effects: effects.js js_html5_printshiv: html5shiv-printshiv.min.js js_html5shiv: html5shiv.min.js js_jsquares: mosiac/jquery.jsquares.min.js js_lazy: lazyload/jquery.lazy.min.js js_netiauto: netiauto js_prototype: prototype.js js_slider: slider.min.js mod_home_enabled: 1 mod_home_is_internal: mod_home_view_class: sfPHP quick_search_max_price: 10000000 quick_search_min_price: 0 sf_admin_web_dir: /sf/sf_admin sf_app: cars sf_app_config_dir: /web/classicdigest.com/apps/cars/config sf_app_config_dir_name: config sf_app_dir: /web/classicdigest.com/apps/cars sf_app_i18n_dir: /web/classicdigest.com/lib/i18n sf_app_i18n_dir_name: i18n sf_app_lib_dir: /web/classicdigest.com/apps/cars/lib sf_app_lib_dir_name: lib sf_app_module_action_dir_name: actions sf_app_module_config_dir_name: config sf_app_module_dir: /web/classicdigest.com/apps/cars/modules sf_app_module_dir_name: modules sf_app_module_i18n_dir_name: i18n sf_app_module_lib_dir_name: lib sf_app_module_template_dir_name: templates sf_app_module_validate_dir_name: validate sf_app_module_view_dir_name: views sf_app_template_dir: /web/classicdigest.com/apps/cars/templates sf_app_template_dir_name: templates sf_apps_dir_name: apps sf_autoloading_functions: sf_available: 1 sf_base_cache_dir: /web/classicdigest.com/cache/cars sf_bin_dir: /web/classicdigest.com/batch sf_bin_dir_name: batch sf_cache: 1 sf_cache_dir: /web/classicdigest.com/cache/cars/dev sf_cache_dir_name: cache sf_calendar_web_dir: /sf/calendar sf_charset: utf-8 sf_check_lock: sf_check_symfony_version: sf_compressed: sf_config_cache_dir: /web/classicdigest.com/cache/cars/dev/config sf_config_dir: /web/classicdigest.com/config sf_config_dir_name: config sf_data_dir: /web/classicdigest.com/data sf_data_dir_name: data sf_debug: 1 sf_default_action: index sf_default_module: default sf_doc_dir: /web/classicdigest.com/data/doc sf_doc_dir_name: doc sf_enabled_modules: - default - user - faSms - user_mail - faDealer - dealer_person - statistics - vote - faErrors - feedback - sfTCPDF - static - article - news - que_ans - favorite - category - sfCaptchaGD - service_index - club - sfLightboxPlugin - sfPropelNorthIdPlugin - facebook - tag_cloud - adbox - apijson - findAgent - fb_connect - fbGeneral sf_environment: dev sf_error_404_action: error404 sf_error_404_module: faErrors sf_error_reporting: 2037 sf_escaping_method: ESC_ENTITIES sf_escaping_strategy: bc sf_etag: sf_i18n: 1 sf_i18n_cache: 1 sf_i18n_cache_dir: /web/classicdigest.com/cache/cars/dev/i18n sf_i18n_debug: sf_i18n_default_culture: en sf_i18n_source: gettext sf_i18n_untranslated_prefix: [T] sf_i18n_untranslated_suffix: [/T] sf_lazy_cache_key: sf_lib_dir: /web/classicdigest.com/lib sf_lib_dir_name: lib sf_lightbox_css_dir: https://www.classicdigest.com/entity/css/sfLightboxPlugin/ sf_lightbox_images_dir: https://www.classicdigest.com/entity/images/sfLightboxPlugin/ sf_lightbox_js_dir: https://www.classicdigest.com/entity/js/sfLightboxPlugin/ sf_log_dir: /web/classicdigest.com/log sf_log_dir_name: log sf_logging_enabled: 1 sf_logging_history: 10 sf_logging_level: debug sf_logging_period: 7 sf_logging_purge: 1 sf_logging_rotate: sf_login_action: loginRequired sf_login_module: faErrors sf_max_forwards: 5 sf_model_dir_name: model sf_model_lib_dir: /web/classicdigest.com/lib/model sf_module_cache_dir: /web/classicdigest.com/cache/cars/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: sf_orm: propel sf_path_info_array: SERVER sf_path_info_key: PATH_INFO sf_plugins_dir: /web/classicdigest.com/plugins sf_plugins_dir_name: plugins sf_prototype_web_dir: /sf/prototype sf_rich_text_js_dir: js/tiny_mce sf_root_cache_dir: /web/classicdigest.com/cache sf_root_dir: /web/classicdigest.com sf_routing_defaults: sf_culture: en sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - Form - Date - faNettiX - faClient - Javascript - Validation - Object - Lightbox sf_strip_comments: 1 sf_suffix: . sf_symfony_data_dir: /web/clssymfony/data sf_symfony_lib_dir: /web/clssymfony/lib sf_template_cache_dir: /web/classicdigest.com/cache/cars/dev/template sf_test: sf_test_cache_dir: /web/classicdigest.com/cache/cars/dev/test sf_test_dir: /web/classicdigest.com/test sf_test_dir_name: test sf_timeout: 1800 sf_timer_start: 1734982479.7173 sf_unavailable_action: maintenance sf_unavailable_module: util sf_upload_dir: /web/classicdigest.com/web/uploads sf_upload_dir_name: uploads sf_url_format: PATH sf_use_database: 1 sf_use_flash: 1 sf_use_process_cache: 1 sf_use_security: 1 sf_validation_error_class: form_error sf_validation_error_id_prefix: error_for_ sf_validation_error_prefix: sf_validation_error_suffix: sf_web_debug: 1 sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /web/classicdigest.com/web sf_web_dir_name: web
--- cookie: env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/chevrolet/corvette/199770 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/lib/nginx HTTPS: on HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/chevrolet/corvette/199770 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /chevrolet/corvette/199770 PATH_TRANSLATED: /web/classicdigest.com/web/chevrolet/corvette/199770 PHP_SELF: /cars/index_dev.php/chevrolet/corvette/199770 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 18.226.52.26 REMOTE_PORT: 33969 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1734982479 REQUEST_TIME_FLOAT: 1734982479.7159 REQUEST_URI: /cars/index_dev.php/chevrolet/corvette/199770 SCRIPT_FILENAME: /web/classicdigest.com/web/cars/index_dev.php SCRIPT_NAME: /cars/index_dev.php SERVER_ADDR: 10.8.1.209 SERVER_NAME: www.classicdigest.com SERVER_PORT: 443 SERVER_PROTOCOL: HTTP/1.1 SERVER_SOFTWARE: nginx/1.18.0 USER: nginx session: visit_page: - home/view
--- php: 7.2.34 os: Linux classicdigestprod1 4.14.336-179.559.amzn1.x86_64 #1 SMP Tue Feb 13 10:34:24 UTC 2024 x86_64 extensions: - Core - date - libxml - openssl - pcre - zlib - filter - hash - Reflection - SPL - session - standard - cgi-fcgi - bz2 - calendar - ctype - curl - dom - mbstring - fileinfo - ftp - gd - gettext - iconv - json - exif - mysqlnd - PDO - Phar - posix - shmop - SimpleXML - sockets - sqlite3 - sysvmsg - sysvsem - sysvshm - tokenizer - xml - xmlwriter - xsl - zip - mcrypt - mysqli - pdo_mysql - pdo_sqlite - wddx - xmlreader - memcache
type | calls | time (ms) |
---|---|---|
Configuration | 13 | 1.70 |
Action "home/view" | 1 | 4401.87 |
Database | 34 | 4340.41 |
View "Success" for "home/view" | 1 | 64.63 |
Partial "home/_vif_images" | 1 | 0.47 |
Partial "common_page/_social_buttons" | 1 | 0.07 |
Partial "home/_vif_info" | 1 | 0.15 |
Partial "home/_hoover_user_info" | 1 | 0.06 |
Partial "common_page/_price_development_graph" | 1 | 0.05 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.04 |
Partial "common_page/_price_gauge_graph" | 1 | 0.04 |
Partial "common_page/_include_vif_js" | 1 | 0.07 |
Partial "common_page/_fancybox_javascript" | 2 | 0.18 |
Partial "common_page/_responsive_javascript" | 1 | 0.05 |
Partial "common_page/_google_analytics" | 1 | 0.04 |
Partial "common_page/_header_links" | 1 | 0.67 |
Partial "common_page/_cookie_policy" | 1 | 0.07 |
Partial "common_page/_responsive_top_menu" | 1 | 0.11 |
Partial "common_page/_top_menu" | 1 | 0.12 |
Partial "common_page/_footer_javascript" | 1 | 0.10 |
Partial "common_page/_footer" | 1 | 0.10 |