| # |
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' => 'ford', 'model' => 'mustang', 'id' => '141808', '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(): [2.18 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=141808 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(): [0.57 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 (1011) |
| 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(): [1.12 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=141808 |
| 38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
| 39 | Creole | executeQuery(): [1.27 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=141808 |
| 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(): [8.08 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=141808 |
| 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(): [1.03 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 (1011) |
| 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(): [0.61 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=141808 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(): [0.36 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 (141808) ORDER BY carimg.ORD ASC |
| 49 | Creole | executeQuery(): [0.55 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 (141808) 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(): [0.82 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 (1011) |
| 52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
| 53 | Creole | executeQuery(): [1.24 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1011 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(): [0.76 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=63 AND model.ID=748 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) ) AS count |
| 58 | Creole | executeQuery(): [15.36 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) ) 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 60 | Creole | executeQuery(): [29.94 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 != 141808 AND car.ID_MODEL = '748' ) 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 != 141808 AND car.ID_MODEL = '748' ) 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 (199756,199736,199686,199666,199626) ORDER BY carimg.ORD ASC |
| 62 | Creole | executeQuery(): [1.54 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 (199756,199736,199686,199666,199626) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) ) AS count |
| 65 | Creole | executeQuery(): [2.00 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 67 | Creole | executeQuery(): [2.71 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 != '141808' AND car.ID_NETTI_USER = '1011' ) 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 (142946,142171,142170,141809,141461) ORDER BY carimg.ORD ASC |
| 69 | Creole | executeQuery(): [2.45 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 (142946,142171,142170,141809,141461) 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(): [5.57 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=748 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(): [36.90 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=748 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 (23177,29880,31401,32395,32397,51562,63696,65737,65738,65751,65753,65758,65760,65764,65765,65773,65779,65782,65785,65786,65800,65803,65805,65806,65807,65808,65814,65815,65828,65832,65842,65843,65848,65851,66420,66986,70155,84035,84488,84629,98111,98374,98375,98376,98377,104882,106435,107565,108219,110907,112077,112993,112994,115284,115763,117057,117173,118182,118501,119651,119814,121237,122217,122392,122572,122737,125791,130116,130171,130172,130251,130351,130597,130659,130661,130848,130977,131011,131044,131300,131382,131383,131488,131489,131602,131603,132174,132190,132873,133020,133214,133476,134143,134631,134634,134635,134966,135150,135202,135324,135435,135553,135559,135808,135819,136411,136518,136739,137547,139098,139237,139238,140120,140315,140649,140953,141061,141165,141305,141499,141511,141808,141809,142049,142050,142080,142081,142108,142206,142284,142800,142817,142874,142875,142946,142996,143106,143110,143114,143115,143116,145110,148061,148263,148695,149447,149448,149750,150180,151147,151586,151590,152216,153227,153279,153717,153737,153752,154299,154307,154815,154821,155200,155201,155202,155469,155473,155487,155499,155500,155507,155863,156426,157042,157080,158618,159554,164190,166320,166324,166479,168087,168322,168545,168704,168707,168837,169220,169661,170181,170240,170242,170402,170560,170809,170815,171063,171075,171103,171283,172016,172270,172387,172593,172596,172760,172761,172762,172767,172995,173000,173001,173003,174453,175507,175812,176002,176102,176826,176827,177091,177364,177365,177469,177663,177950,177998,178280,178707,179111,179310,179462,179843,180075,180213,180408,180410,180413,180419,180501,180591,180639,180740,181208,181391,181764,182096,182097,182843,183092,183254,183322,183471,183472,183847,184529,185079,185231,185345,185418,185739,185744,185784,186173,186177,187043,187381,187452,187780,188055,188072,188535,188789,188824,188825,189117,189201,189265,189323,189624,189638,190093,190257,190592,190671,190732,191268,191371,191568,191569,191725,191803,191949,191951,191960,192029,192053,192104,192114,192222,192238,192247,192474,192529,192776,192830,192850,192871,192909,193015,193021,193156,193260,193281,193358,193362,193365,193626,193635,193760,193781,193784,193825,193961,194015,194090,194091,194099,194110,194146,194148,194222,194230,194246,194249,194262,194263,194308,194343,194366,194370,194377,194384,194396,194508,194520,194522,194608,194644,194670,194740,194774,194794,194802,194803,194805,194806,194811,194904,194907,194909,195157,195255,195366,195370,195397,195414,195463,195464,195512,195513,195535,195544,195550,195572,195606,195617,195748,195760,195822,195862,195889,195892,195957,195959,195961,195970,195996,195998,195999,196064,196099,196106,196151,196247,196316,196332,196362,196436,196437,196444,196445,196492,196493,196517,196528,196537,196547,196551,196568,196635,196663,196739,196855,196897,196946,196947,196994,196995,196996,197049,197088,197109,197162,197175,197213,197215,197350,197363,197378,197397,197416,197463,197474,197510,197515,197529,197580,197616,197629,197691,197712,197731,197763,197805,197808,197847,197859,197866,197892,197903,198198,198220,198226,198298,198497,198512,198516,198534,198649,198728,198730,198773,198942,198951,198975,198980,199012,199019,199097,199136,199147,199168,199211,199226,199232,199244,199274,199275,199287,199297,199298,199352,199357,199544,199620,199626,199666,199686,199736,199756) GROUP BY cmonth ORDER BY date_create |
| 75 | Creole | executeQuery(): [3.74 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 (23177,29880,31401,32395,32397,51562,63696,65737,65738,65751,65753,65758,65760,65764,65765,65773,65779,65782,65785,65786,65800,65803,65805,65806,65807,65808,65814,65815,65828,65832,65842,65843,65848,65851,66420,66986,70155,84035,84488,84629,98111,98374,98375,98376,98377,104882,106435,107565,108219,110907,112077,112993,112994,115284,115763,117057,117173,118182,118501,119651,119814,121237,122217,122392,122572,122737,125791,130116,130171,130172,130251,130351,130597,130659,130661,130848,130977,131011,131044,131300,131382,131383,131488,131489,131602,131603,132174,132190,132873,133020,133214,133476,134143,134631,134634,134635,134966,135150,135202,135324,135435,135553,135559,135808,135819,136411,136518,136739,137547,139098,139237,139238,140120,140315,140649,140953,141061,141165,141305,141499,141511,141808,141809,142049,142050,142080,142081,142108,142206,142284,142800,142817,142874,142875,142946,142996,143106,143110,143114,143115,143116,145110,148061,148263,148695,149447,149448,149750,150180,151147,151586,151590,152216,153227,153279,153717,153737,153752,154299,154307,154815,154821,155200,155201,155202,155469,155473,155487,155499,155500,155507,155863,156426,157042,157080,158618,159554,164190,166320,166324,166479,168087,168322,168545,168704,168707,168837,169220,169661,170181,170240,170242,170402,170560,170809,170815,171063,171075,171103,171283,172016,172270,172387,172593,172596,172760,172761,172762,172767,172995,173000,173001,173003,174453,175507,175812,176002,176102,176826,176827,177091,177364,177365,177469,177663,177950,177998,178280,178707,179111,179310,179462,179843,180075,180213,180408,180410,180413,180419,180501,180591,180639,180740,181208,181391,181764,182096,182097,182843,183092,183254,183322,183471,183472,183847,184529,185079,185231,185345,185418,185739,185744,185784,186173,186177,187043,187381,187452,187780,188055,188072,188535,188789,188824,188825,189117,189201,189265,189323,189624,189638,190093,190257,190592,190671,190732,191268,191371,191568,191569,191725,191803,191949,191951,191960,192029,192053,192104,192114,192222,192238,192247,192474,192529,192776,192830,192850,192871,192909,193015,193021,193156,193260,193281,193358,193362,193365,193626,193635,193760,193781,193784,193825,193961,194015,194090,194091,194099,194110,194146,194148,194222,194230,194246,194249,194262,194263,194308,194343,194366,194370,194377,194384,194396,194508,194520,194522,194608,194644,194670,194740,194774,194794,194802,194803,194805,194806,194811,194904,194907,194909,195157,195255,195366,195370,195397,195414,195463,195464,195512,195513,195535,195544,195550,195572,195606,195617,195748,195760,195822,195862,195889,195892,195957,195959,195961,195970,195996,195998,195999,196064,196099,196106,196151,196247,196316,196332,196362,196436,196437,196444,196445,196492,196493,196517,196528,196537,196547,196551,196568,196635,196663,196739,196855,196897,196946,196947,196994,196995,196996,197049,197088,197109,197162,197175,197213,197215,197350,197363,197378,197397,197416,197463,197474,197510,197515,197529,197580,197616,197629,197691,197712,197731,197763,197805,197808,197847,197859,197866,197892,197903,198198,198220,198226,198298,198497,198512,198516,198534,198649,198728,198730,198773,198942,198951,198975,198980,199012,199019,199097,199136,199147,199168,199211,199226,199232,199244,199274,199275,199287,199297,199298,199352,199357,199544,199620,199626,199666,199686,199736,199756) 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 (20628,20629,20630,20631,20769,20854,20855,20952,21350,21565,22018,22019,22020,22021,22083,22162,22163,22218,22219,22271,22546,22570,22587,22588,22594,22606,22616,22707,22728,22740,22749,22770,22781,22803,22805,22828,22866,22895,22902,23033,23034,23035,23036,23044,23148,23205,23222,23301,23395,23548,23552,23553,23664,23665,23702,23834,23901,23907,24042,24049,24050,24100,24110,24158,24299,24307,24693,24860,24861,24949,24963,24978,24983,25007,25073,25092,25100,25102,25116,25121,25135,25188,25221,25247,25250,25252,25254,25316,25324,25524,25569,25576,25577,25582,25716,25788,25809,25863,25952,25954,26039,26191,26223,26295,26317,26351,26504,26523,26526,26528,26592,26774,26828,27021,27067,27348,27351,27388,27449,27665,27679,27680,27689,27741,27961,27962,27963,27964,28034,28035,28036,28198,28411,29139,29431,29443,29630,29631,29632,29837,29838,29839,29840,29841,29843,29883,29991,30004,30117,30258,30495,30501,30571,30572,30574,30934,30935,30936,30937,30938,30939,31057,31058,31059,31060,31241,31612,31613,31614,31818,31931,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32307,32390,32391,32392,32393,32394,32487,32488,32621,32803,32804,32854,32897,32898,32899,32926,32947,32960,33051,33076,33161,33162,33203,33259,33309,33310,33451,33489,33523,33525,33541,33676,33933,33934,34039,34309,34384,34446,34794,35021,35057,35059,35088,35113,35138,35256,35305,35306,35324,35415,35429,35546,35621,35622,36226,36435,36516,36517,36571,36604,36610,36866,36867,36909,36991,36992,36993,36994,36995,37046,38653,38666,38688,38693,38707,38728,38783,38804,38807,38816,38859,38860,38939,39484,39508,39522,39523,39550,39578,39581,39660,39667,39668,39683,39739,40344,41891,41901,41977,42002,42395,42416,42433,42494,42506,42625,42651,42669,43021,43088,43089,43090,43101,43102,43122,43123,43124,43192,43274,43361,43365,43366,43368,43842,43925,43926,43927,43936,43955,44005,44059,44424,44425,44754,44798,45309,45389,45390,45466,45763,46212,46235,46236,46303,46336,46426,46850,46993,46994,46995,46996,46997,47034,47101,47109,47154,47190,47598,47599,47747,47748,47884,47885,47904,47907,47936,47937,48356,48457,48461,48552,48627,48790,48823,48824,49126,49382,49528,49605,49606,49642,49662,49692,49821,49896,49897,49898,49899,50170,50204,50218,50219,50232,50233,50295,50296,50297,50298,50319,50333,50431,50432,50704,50753,50800,50801,50802,50816,50826,50837,50855,50889,51029,51030,51044,51045,51656,51657,51919,51991,52024,52039,52040,52218,52219,52436,52443,52468,52562,52595,52966,52974,52977,53112,53147,53148,53261,53267,53290,53326,53573,53656,53657,53658,53659,53660,53661,53696,53724,53739,53766,53801,53811,53993,54099,54100,54101,54102,54103,54171,54250,54251,54252,54339,54635,54739,54782,55178,55273,55325,55375,55379,55387,55450,55451,55452,55453,55817,55818,55824,55834,55849,55862,55890,55891,55897,55946,55947,55952,55953,55954,55960,55961,55962,55981,55990,55991,56118,56119,56120,56121,56122,56123,56135,56136,56137,56148,56149,56163,56180,56201,56211,56226,56313,56314,56458,56459,56460,56461,56462,56463,56464,56465,56466,56467,56468,56469,56470,56599,56600,56602,56603,56604,56605,56606,56608,56753,56754,56755,56756,56763,56780,56870,56871,56875,56876,56881,56951,57021,57022,57033,57034,57035,57045,57071,57085,57086,57087,57092,57098,57099,57100,57101,57143,57147,57150,57269,57270,57281,57305,57306,57329,57361,57362,57366,57375,57381,57393,57397,57409,57420,57422,57466,57470,57471,57478,57479,57481,57487,57488,57494,57499,57508,57546,57547,57548,57603,57635,57636,57638,57641,57642,57651,57682,57684,57735,57736,57737,57738,57746,57758,57759,57760,57763,57766,57767,57779,57808,57809,58198,58201,58202,58203,58210,58211,58212,58245,58254,58264,58286,58299,58300,58304,58345,58547,58548,58562,58576,58577,58578,58595,58596,58597,58617,58658,58727,58772,58806,58807,58826,58827,58894,58928,58935,59028,59036,59071,59089,59090,59096,59098,59110,59412,59492,59494,59495,59496,59497,59498,59499,59500,59501,59526,59548,59638,59644,59646,59982,60016,60017,60018,60090,60171,60194,60217,60218,60219,60258,60270,60276,60278,60314,60315,60316,60317,60657,60735,60751,60765,60766,60767,60768,60769,60770,60780,60797,60798,60811,60812,60813,60814,60815,60829,60840,60876,60950,60951,60952,60953,60986,61012,61020,61072,61073,61082,61087,61092,61093,61094,61095,61107,61169,61191,61358,61396,61399,61402,61407,61434,61436,61440,61466,61503,61663,61665,61666,61820,62104,62110,62116,62125,62135,62141,62179,62180,62201,62202,62203,62204,62205,62225,62226,62332,62352,62353,62405,62422,62425,62426,62429,62441,62442,62834,62841,62896,62932,62933,62955,62956,62958,62959,62960,62961,63006,63007,63017,63077,63115,63141,63171,63719,63756,63762,63794,63795,63796,63821,63822,63849,63850,63893,63894,63919,63957,63959,63972,64020,64039,64387,64406,64408,64424,64441,64466,64467,64468,64519,64520,64521,64564,64565,64649,64680,64719,64728,64732,65139,65140,65142,65143,65144,65147,65152,65189,65190,65268,65380,65384,65487,65561,65625,65709,65715,65717,65725,65726,65730,65798,65839,65840,65847,65850,66398,66400,66421,66438,66439,66454,66562,66563,66646,66655,66821,66860,66861,66976,67498,67517,67667,67670,67732,67733,67784,67785,67786,67787,67894,67906,67923,67992,68000,68020,68021,68441,68488,68631,68636,68651,68701,68745,68768,69299,69310,69317,69318,69342,69374,69375,69395,69396,69397,69398,69399,69400,69401,69402,69444,69445,69446,69449,69462,69478,69550,69556,69566,69602,69603,69632,70039,70091,70092,70109,70110,70154,70176,70182,70183,70213,70233,70234,70289,70298,70300,70309,70322,70418,70443,70448,70449,70468,70516,70986,70993,71002,71020,71049,71050,71088,71094,71116,71167,71186,71208,71209,71230,71257,71284,71297,71301,71781,71782,71785,71816,71817,71825,71826,71832,71870,71873,71894,71895,71896,71897,71927,71993,72562,72585,72653,72686,72733,72734,72735,72736,72737,72738,72884,72886,72891,72900,72933,73400,73402,73403,73417,73420,73433,73434,73443,73462,73548,73549,73550,73551,73584,73595,73674,73686,73687,74204,74211,74212,74246,74269,74270,74281,74282,74329,74368,74385,74450,74532,74533,74551,75037,75038,75039,75042,75071,75119,75120,75161,75169,75170,75276,75343,75353,75355,75819,75844,75845,75847,75850,75854,75857,75894,75896,75898,75964,75965,76027,76032,76034,76035,76109,76114,76119,76120,76162,76170,76574,76648,76691,76692,76734,76738,76739,76740,76741,76742,76743,76766,76822,76823,76829,76886,76893,76903,76906,76923,76941,76993,77004,77384,77385,77413,77414,77423,77424,77425,77426,77480,77515,77566,77567,77568,77569,77570,77571,77572,77573,77623,77633,77635,77637,77647,77654,77655,77661,77667,77700,77727,77729,78179,78185,78189,78191,78211,78283,78310,78422,78546,78547,78605,78650,78651,78809,78810,79705,79706,79707,80458,80459,80471,80934,81208,81258,81330,81340,81341,81471,81501,81852,81864,81865,81870,81881,81886,81898,81939,81940,81954,81966,81979,81980,81982,81989,82429,82440,82441,82446,82450,82475,82476,82499,82528,82943,82948,82960,82972,83003,83025,83029,83031,83078,83095,83096,83098,83116,83245,83252,83253,83285,83286,83287,83389,83429,83527,83528,83529,83530,83587,83589,83597,83613,84080,84081,84107,84111,84122,84137,84139,84140,84156,84197,84198,84199,84364,84487,84489,84490,84491,84628,84630,84631,84632,84642,84780,84785,84790,84812,85101,85124,85158,85184,85185,85195,85223,85291,85296,85310,85316,85336,85339,85407,85408,85426,85476,85477,85487,85554,85570,85642,85663,85683,85686,85714,85740,85755,85756,85765,85766,85819,85891,85905,85978,85979,86071,86127,86145,86147,86192,86266,86275,86347,86382,86428,86443,86474,86517,86528,86547,86552,86564,86592,86761,86908,86962,86986,86998,87020,87085,87160,87232,87285,87327,87342,87356,87855,87881,87882,87922,87967,88036,88054,88055,88066,88122,88262,88263,88471,88661,88716,88821,88822,88823,88824,88917,88999,89012,89036,89037,89063,89083,89084,89119,89120,89121,89164,89239,89343,89414,89427,89471,89627,89633,89677,90096,90099,90142,90210,90215,90311,90371,90372,90518,90583,90593,90700,90720,90737,90796,90797,90798,90799,90834,90835,90836,90895,90896,90897,90898,90901,90955,90957,90996,91014,91015,91036,91059,91106,91190,91286,91580,91648,91675,91737,91780,91781,91782,91813,91853,91956,92147,92148,92149,92274,92422,92509,92517,92537,92538,92539,92540,92541,92824,92834,92835,92998,93017,93020,93060,93063,93086,93439,93479,93482,93494,93608,93668,93699,93712,93715,93751,93951,94040,94128,94187,94209,94312,94334,94342,94351,94352,94398,94426,94559,94982,94993,95017,95033,95034,95096,95133,95165,95197,95258,95259,95261,95344,95353,95362,95373,95374,95378,95387,95452,95526,95528,95590,95601,95602,95603,95638,95658,95677,95684,95685,95719,95776,95787,95886,95889,95897,95958,95962,95963,95978,95982,95984,96006,96072,96079,96091,97772,97793,97838,97840,97841,97851,97859,97860,97869,97889,97949,98016,98032,98039,98161,98171,98198,98201,98253,98368,98380,98432,98433,98434,98435,98436,98459,98658,98659,98719,98720,98739,98740,98741,98750,98764,98770,98774,98779,98780,98784,98809,98810,98908,98923,98924,98983,98995,98999,99026,99036,99043,99253,99272,99382,99383,99440,99445,99480,99499,99503,99935,99984,100006,100011,100026,100029,100040,100044,100062,100067,100108,100109,100541,100555,100581,100630,100642,100680,100732,100758,100778,100821,100822,100861,100898,100900,100901,101097,101118,101158,101159,101160,101198,101212,101233,101234,101317,101318,101319,101355,101369,101545,101592,101593,101602,101606,101685,101734,101736,101738,101806,101819,102044,102112,102132,102139,102192,102213,102234,102281,102282,102299,102325,102342,102365,102377,102392,102551,102552,102600,102609,102610,102611,102661,102662,102671,102727,102741,102988,102997,103059,103065,103105,103106,103135,103394,103395,103406,103418,103437,103440,103474,103481,103580,103581,103738,103739,103760,103761,103767,103772,103773,103774,103798,103807,103813,103860,103864,103871,103872,103894,104020,104182,104186,104316,104370,104453,104478,104773,104792,104793,104985,104993,105009,105075,105092,105130,105180,105276,105277,105292,105293,105300,105317,105318,105325,105326,105342,105347,105352,105355,105432,105442,105471,105578,105601,105602,105645,105755,105763,105764,105835,105838,105848,105857,105858,105859,105860,105863,105907,105934,105984,105985,106087,106120,106121,106122,106123,106143,106170,106171,106192,106243,106256,106317,106365,106370,106383,106471,106472,106473,106476,106515,106516,106517,106518,106519,106537,106559,106567,106603,106614,106616,106653,106661,106662,106663,106664,106665,106677,106683,106691,106696,106720,106756,106757,106790,106796,106846,106858,106890,106899,106900,106913,106943,106992,107001,107007,107023,107033,107035,107066,107067,107081,107082,107120,107135,107191,107197,107257,107259,107317,107400,107403,107407,107420,107441,107453,107471,107486,107522,107523,107524,107562,107946,108029,108033,108052,108068,108069,108070,108078,108079,108080,108081,108099,108100,108101,108102,108125,108126,108127,108128,108148,108157,108218,108228,108246,108251,108254,108265,108266,108267,108326,108420,108506,108529,108531,108545,108547,108658,108659,108660,108661,108662,108675,108676,108696,108705,108729,108730,108785,108786,108822,108982,109048,109057,109064,109068,109069,109090,109114,109144,109275,109285,109312,109337,109383,109395,109407,109408,109450,109502,109535,109536,109577,109578,109582,109590,109627,109630,109645,109758,109799,109858,109897,109925,109929,109970,110004,110053,110062,110103,110133,110134,110153,110154,110230,110237,110260,110261,110277,110293,110341,110342,110343,110344,110379,110429,110457,110486,110538,110544,110563,110596,110624,110628,110649,110650,110738,110750,110884,110891,110904,110913,110924,110927,110961,110976,110994,111004,111007,111078,111119,111226,111231,111261,111264,111505,111536,111757,111758,111759,111760,111761,111762,111763,111764,111765,111766,111767,111768,111769,111770,111771,111772,111773,111775,111842,112129,112130,112314,112352,112466,112500,112528,112587,112624,112627,112684,112699,112700,112701,112775,112798,112835,112858,112880,112882,112897,112912,112967,112980,112986,112987,113043,113112,113128,113170,113197,113198,113203,113218,113241,113270,113296,113318,113332,113388,113390,113408,113409,113516,113521,113526,113566,113586,113594,113607,113608,113609,113610,113628,113726,113749,113756,113769,113775,113853,113854,113875,113881,113952,114048,114094,114117,114124,114131,114171,114189,114195,114221,114272,114323,114467,114468,114483,114489,114500,114509,114531,114554,114556,114572,114608,114723,114737,114830,114860,114874,114907,114941,114960,114984,115001,115021,115023,115034,115043,115074,115113,115120,115133,115152,115212,115217,115219,115237,115238,115251,115252,115265,115283,115293,115318,115351,115424,115471,115472,115480,115483,115484,115485,115486,115487,115492,115522,115536,115537,115538,115540,115542,115558,115624,115625,115700,115719,115720,115725,115748,115762,115773,115783,115784,115794,115797,115801,115802,115808,115966,115967,115968,115969,116028,116055,116060,116079,116104,116147,116148,116156,116161,116191,116212,116213,116228,116230,116240,116250,116251,116295,116300,116301,116302,116320,116337,116340,116349,116358,116377,116467,116468,116469,116480,116491,116500,116527,116530,116533,116579,116626,116630,116637,116686,116708,116730,116731,116762,116788,116918,116950,116956,116961,116969,116970,116971,116978,116987,117047,117060,117061,117112,117125,117153,117230,117262,117276,117280,117283,117284,117293,117309,117311,117346,117356,117357,117358,117447,117475,117501,117513,117517,117557,117576,117624,117625,117648,117660,117661,117665,117714,117718,117719,117720,117778,117794,117845,117887,117888,117920,117921,117927,117932,117954,117977,117986,118063,118072,118081,118128,118129,118130,118131,118146,118149,118163,118164,118165,118211,118319,118377,118384,118422,118467,118482,118483,118494,118517,118534,118542,118570,118603,118604,118607,118612,118710,118752,118776,118780,118782,118786,118824,118851,118881,118962,118990,118991,119106,119109,119117,119121,119151,119209,119234,119239,119246,119279,119312,119313,119329,119357,119358,119360,119366,119404,119693,119905,119918,119991,119992,120039,120117,120182,120425,120436,120567,120568,120569,120588,120589,120590,120591,120592,120593,120605,120606,120619,120620,120621,120659,120660,120661,120662,120732,120733,120753,120764,120906,120997,120998,120999,121000,121001,121023,121036,121072,121073,121086,121087,121088,121109,121110,121160,121170,121171,121179,121230,121326,121327,121328,121339,121340,121341,121342,121377,121378,121389,121390,121391,121418,121458,121459,121484,121642,121650,121651,121668,121692,121718,121748,121765,121766,121803,121834,121842,121912,121955,121958,122047,122110,122135,122143,122145,122158,122189,122252,122257,122263,122329,122348,122374,122390,122391,122434,122475,122477,122478,122482,122487,122488,122615,122628,122640,122647,122682,122683,122707,122709,122711,122738,122744,122757,122774,122787,122799,122823,122828,122829,122863,122864,122879,122880,122909,123001,123052,123059,123061,123065,123067,123104,123114,123122,123322,123336,123340,123348,123356,123440,123455,123459,123629,123647,123663,123673,123680,123688,123692,123693,123694,123758,123762,123808,123815,123857,123858,123938,123951,123982,124011,124023,124064,124071,124072,124090,124111,124121,124156,124189,124239,124240,124263,124266,124287,124298,124310,124311,124318,124329,124333,124334,124343,124346,124372,124373,124374,124396,125291,125305,125325,125326,125327,125371,125374,125440,125441,125443,125445,125493,125506,125508,125509,125511,125512,125514,125519,125550,125606,125622,125624,125686,125705,125711,125718,125723,125724,125732,125739,125783,125810,125821,125834,125840,125846,125895,125925,125939,125958,125975,126010,126043,126045,126079,126081,126086,126087,126115,126116,126117,126118,126168,126172,126197,126240,126269,126272,126273,126309,126313,126314,126403,126413,126440,126447,126448,126472,126489,126521,126546,126560,126580,126634,126639,126642,126650,126659,126689,126697,126742,126752,126804,126812,126840,126880,126884,126888,126970,126974,126975,126997,127006,127037,127107,127129,127146,127151,127153,127155,127163,127164,127168,127189,127199,127200,127202,127223,127246,127252,127258,127312,127313,127346,127347,127351,127367,127442,127449,127450,127488,127530,127560,127587,127600,127601,127603,127657,127694,127703,127736,127737,127739,127740,127759,127760,127784,127795,127805,127809,127819,127824,127825,127839,127854,127855,127866,127867,127892,127914,127917,127953,127954,127962,127963,128023,128071,128088,128092,128112,128125,128160,128162,128201,128229,128249,128258,128324,128325,128341,128342,128343,128388,128445,128480,128514,128578,128579,128619,128642,128716,128740,128762,128768,128777,128793,128813,128815,128874,128900,128927,128954,129001,129029,129030,129039,129040,129045,129047,129070,129114,129122,129146,129152,129202,129215,129246,129304,129309,129392,129394,129401,129434,129435,129436,129609,129610,129670,129786,129979,130115,130117,130169,130170,130250,130299,130300,130301,130378,130379,130380,130657,130658,130660,130662,130694,130698,130701,130702,130975,130976,130978,131018,131042,131043,131045,131046,131240,131299,131322,131384,131426,131472,131473,131600,131601,131725,131736,131744,131802,131803,131804,131805,131868,131870,131874,131876,132105,132106,132191,132237,132254,132302,132303,132345,132350,132380,132405,132406,132445,132446,132447,132493,132551,132560,132601,132622,132633,132634,132692,132722,132755,132772,132791,132793,132809,132864,132882,132886,132908,132932,132933,132942,133095,133099,133118,133142,133162,133231,133248,133377,133378,133381,133497,133498,133537,133664,133696,133844,133895,133962,134102,134113,134114,134137,134144,134145,134192,134202,134538,134632,134633,134975,135005,135006,135027,135052,135064,135084,135211,135307,135408,135434,135497,135522,135554,135622,135738,135766,135892,135926,135948,136060,136106,136196,136462,136479,136480,136517,136605,136636,136653,136654,136655,136663,136679,136705,136716,136751,136928,136929,136939,136940,136942,136957,136962,136966,136971,136987,136994,137003,137005,137052,137061,137062,137080,137081,137091,137229,137230,137239,137256,137269,137314,137321,137358,137364,137365,137370,137391,137393,137394,137446,137447,137451,137454,137462,137502,137523,137536,137551,137633,137637,137651,137665,137696,137791,137828,137837,137846,137886,138011,138014,138019,138021,138022,138024,138029,138031,138065,138104,138177,138179,138183,138187,138188,138198,138202,138242,138252,138298,138299,138306,138314,138447,138568,138572,138573,138579,138580,138583,138584,138590,138594,138599,138619,138670,138676,138721,138722,138723,138724,138725,138735,138740,138741,138752,138753,138764,138765,138771,138772,138795,138952,138953,138954,138955,138956,138957,138958,138959,138960,138961,138962,138963,138964,139080,139442,139454,139512,139528,139688,139692,139704,139705,139706,139711,139720,139733,139743,139751,140232,140247,140269,140418,140423,140754,140849,140855,140893,140946,140987,141030,141043,141074,141106,141212,141222,141223,141272,141292,141296,141309,141317,141322,141333,141371,141439,141575,141668,141736,141750,141757,141781,141782,141788,141870,141881,141956,141962,142067,142068,142095,142123,142131,142146,142157,142158,142178,142183,142184,142191,142221,142226,142262,142316,142317,142332,142383,142397,142406,142466,142468,142478,142484,142500,142505,142507,142552,142570,142575,142578,142670,142744,142837,142847,142850,142904,143023,143024,143101,143259,143260,143291,143319,143335,143338,143343,143344,143377,143465,143495,143596,143617,143619,143636,143637,143640,143740,143763,143765,143766,143821,143831,143838,143841,143847,143848,143875,143915,143957,143958,143975,144014,144022,144029,144063,144086,144116,144138,144164,144165,144213,144219,144222,144228,144285,144297,144354,144535,144544,144551,144560,144610,144615,144616,144621,144622,144633,144634,144690,144702,144703,144704,144723,144737,144753,144771,144819,144842,144848,144884,144888,144909,144952,144980,144999,145002,145034,145077,145081,145082,145085,145103,145121,145167,145168,145177,145181,145188,145206,145258,145261,145262,145265,145281,145287,145288,145299,145333,145334,145365,145377,145385,145399,145404,145436,145437,145481,145489,145494,145621,145622,145636,145647,145663,145680,145701,145710,145725,145726,145747,145758,145759,145760,145761,145762,145763,145776,145777,145778,145779,145780,145796,145846,145854,145855,145858,145977,145982,145986,146001,146013,146036,146048,146119,146133,146134,146136,146141,146171,146210,146223,146234,146324,146325,146326,146327,146328,146329,146330,146385,146389,146394,146402,146403,146428,146443,146457,146477,146530,146531,146532,146670,146672,146692,146723,146733,146739,146750,146753,146762,146773,146795,146798,146805,146808,146897,146905,146906,146939,146943,146959,146982,147039,147042,147045,147097,147108,147174,147175,147219,147226,147227,147235,147262,147265,147335,147341,147356,147376,147386,147481,147488,147489,147544,147548,147596,147606,147615,147619,147625,147648,147687,147698,147706,147711,147726,147730,147738,147739,147751,147752,147787,147788,147789,147815,147826,147853,147865,147873,147874,147875,147876,147883,147884,147895,147911,147926,147932,147970,147991,148017,148067,148077,148093,148104,148106,148107,148131,148169,148183,148187,148188,148255,148261,148262,148269,148271,148297,148318,148337,148339,148377,148385,148392,148405,148433,148438,148451,148461,148484,148493,148523,148525,148545,148555,148560,148626,148661,148745,148750,148761,148764,148767,148769,148770,148775,148811,148859,148891,148906,148922,148927,148948,148958,148965,148971,148972,149052,149137,149157,149205,149220,149251,149258,149259,149320,149330,149331,149332,149341,149352,149401,149504,149512,149539,149540,149609,149610,149612,149636,149650,149701,149710,149711,149741,149761,149767,149776,149782,149815,149933,149970,149971,149982,150226,150231,150256,150320,150483,150580,150605,150608,150609,150611,150613,150703,150763,150781,150825,150912,150922,150937,150959,150992,151041,151069,151096,151105,151129,151184,151213,151237,151239,151342,151421,151687,151705,151757,151792,151818,151845,151858,151876,151879,151893,151906,151922,151925,152024,152061,152062,152091,152092,152093,152122,152142,152203,152346,152436,152544,152874,152876,152966,153069,153137,153164,153175,153180,153184,153286,153315,153344,153395,153414,153419,153423,153426,153432,153510,153531,153532,153533,153538,153558,153559,153562,153573,153612,153621,153654,153656,153773,153859,153868,153873,153874,153877,153897,153928,153947,153950,153951,153953,153960,153961,153997,154000,154007,154021,154025,154026,154059,154073,154095,154131,154219,154224,154247,154254,154257,154261,154318,154346,154354,154358,154372,154385,154508,154511,154535,154571,154572,154593,154608,154633,154635,154636,154647,154676,154682,154745,154757,154774,154776,154782,154861,155001,155002,155003,155057,155069,155070,155076,155078,155080,155084,155087,155111,155146,155147,155153,155241,155278,155421,155422,155452,155515,155522,155527,155596,155621,155633,155756,156152,156184,156201,156214,156255,156272,156273,156274,156385,156400,156478,156538,156581,156700,156751,156767,156772,156884,156900,157025,157131,157152,157169,157194,157291,157292,157293,157294,157295,157296,157297,157305,157306,157307,157308,157309,157310,157311,157312,157313,157367,157372,157373,157374,157427,157489,157502,157505,157510,157512,157596,157597,157626,157637,157638,157641,157669,157685,157689,157743,157802,157803,157830,157845,157881,157895,157953,157999,158043,158045,158046,158145,158178,158181,158195,158225,158259,158289,158316,158341,158440,158453,158459,158499,158542,158543,158558,158590,158593,158594,158653,158842,158843,158844,158849,158850,158856,158883,158897,158898,158900,158986,159008,159017,159036,159056,159058,159207,159208,159257,159375,159402,159425,159426,159482,159511,159591,159599,159623,159648,159649,159655,159874,159904,159955,160024,160032,160151,160169,160213,160247,160279,160283,160296,160354,160375,160385,160447,160480,160623,160626,160627,160628,160645,160650,160654,160833,161034,161401,161540,161808,161959,162050,162056,162076,162113,162218,162242,162266,162273,162285,162336,162358,162381,162402,162482,162510,162682,162707,162716,162738,162758,162806,162877,162899,162900,162934,162992,162993,163120,163185,163254,163327,163454,163486,163630,163667,163686,163691,163722,163757,163845,163846,163860,163877,163902,163995,164004,164068,164095,164103,164296,164331,164338,164387,164391,164488,164558,164581,164593,164622,164681,164701,164702,164715,164729,164735,164784,164835,164839,164916,164959,164962,165009,165103,165151,165205,165206,165248,165258,165259,165261,165273,165279,165309,165317,165386,165614,165625,165667,165686,165687,165721,165740,165801,165822,165823,165863,165877,165932,165949,165960,165963,165964,165965,166086,166087,166088,166089,166213,166223,166387,166395,166415,166442,166443,166459,166469,166470,166477,166478,166539,166540,166546,166555,166602,166615,166623,166660,166661,166662,166663,166690,166757,166769,166770,166771,166793,166794,166795,166821,166828,166856,166897,166901,166948,166975,166978,167038,167067,167120,167128,167159,167191,167194,167197,167203,167204,167206,167209,167242,167423,167425,167447,167491,167505,167531,167534,167552,167556,167562,167563,167630,167781,167816,167821,167833,167834,167850,167859,167922,167958,167959,168051,168058,168095,168139,168146,168160,168161,168174,168176,168250,168253,168258,168299,168307,168308,168311,168320,168329,168431,168479,168500,168505,168510,168576,168590,168594,168619,168622,168638,168640,168658,168671,168701,168710,168728,168729,168730,168743,168783,168787,168807,168817,168838,168849,168851,168888,168889,168890,168931,168985,168995,169019,169020,169021,169022,169048,169107,169119,169161,169175,169185,169193,169225,169241,169303,169306,169318,169326,169336,169344,169402,169414,169441,169470,169486,169528,169530,169542,169545,169586,169775,169850,169862,169886,169896,169960,169988,169998,170018,170112,170113,170142,170156,170224,170250,170275,170337,170338,170350,170381,170386,170396,170416,170442,170456,170495,170515,170525,170526,170551,170553,170662,170687,170688,170689,170724,170750,170751,170769,170771,170836,170837,170858,170884,170904,170906,170929,170937,170970,170985,170989,171007,171065,171081,171090,171104,171105,171136,171178,171192,171203,171216,171237,171253,171254,171260,171268,171269,171277,171326,171366,171415,171437,171452,171480,171571,171572,171669,171708,171709,171733,171751,171753,171769,171770,171771,171886,171888,171904,171906,172032,172060,172107,172114,172115,172156,172161,172164,172166,172172,172173,172184,172198,172199,172200,172201,172265,172293,172324,172346,172356,172402,172406,172407,172418,172445,172474,172533,172552,172563,172582,172584,172619,172626,172628,172648,172649,172657,172658,172680,172683,172687,172722,172725,172859,172924,172955,172974,172993,173079,173135,173140,173154,173220,173227,173244,173260,173269,173270,173301,173308,173313,173321,173348,173408,173415,173422,173464,173571,173638,173639,173640,173651,173676,173713,173727,173748,173774,173848,173882,173904,173925,173942,173950,173966,173978,173987,173990,173999,174046,174049,174123,174131,174149,174153,174154,174198,174259,174304,174353,174389,174415,174423,174442,174476,174541,174605,174755,174774,174791,174845,174848,174857,174859,174905,174982,174991,175005,175012,175028,175051,175067,175074,175080,175132,175171,175183,175231,175238,175295,175303,175305,175320,175371,175444,175447,175524,175650,175651,175660,175677,175681,175713,175728,175729,175730,175731,175813,175832,175850,175893,175895,175898,175908,175991,176004,176025,176090,176093,176095,176111,176117,176118,176119,176179,176187,176199,176221,176237,176268,176283,176291,176292,176329,176345,176353,176396,176402,176469,176478,176535,176536,176564,176587,176606,176628,176758,176773,176817,176836,176845,176888,176899,176917,176934,176994,176998,177000,177034,177036,177178,177188,177221,177229,177293,177295,177303,177313,177386,177409,177425,177453,177482,177494,177519,177565,177568,177569,177577,177623,177661,177667,177681,177697,177700,177769,177825,177833,177857,177863,177885,177902,177933,177959,177969,177970,178011,178016,178067,178094,178103,178118,178122,178125,178142,178237,178292,178349,178400,178409,178463,178466,178473,178482,178502,178534,178565,178578,178579,178612,178667,178668,178830,178842,179014,179096,179156,179159,179160,179167,179173,179210,179291,179318,179408,179418,179419,179426,179540,179554,179612,179657,179702,179726,179736,179801,179825,179869,179940,179947,179948,179978,179995,179999,180028,180051,180056,180088,180095,180141,180151,180236,180244,180260,180278,180289,180380,180531,180544,180562,180585,180693,180711,180716,180733,180734,180742,180745,180751,180752,180754,180762,180773,180785,180865,180885,180907,180921,180974,180988,181041,181054,181071,181145,181156,181163,181177,181230,181241,181312,181337,181346,181396,181417,181429,181433,181511,181586,181590,181596,181617,181643,181674,181675,181677,181688,181706,181841,181844,181848,181872,181876,181886,181917,181945,181986,182023,182027,182060,182088,182090,182146,182203,182221,182234,182256,182306,182444,182462,182531,182603,182706,182828,182921,182947,182963,182987,183037,183061,183066,183128,183148,183171,183223,183224,183238,183244,183280,183291,183319,183324,183331,183424,183454,183455,183483,183530,183647,183677,183680,183730,183731,183771,183789,183836,183848,183877,183920,183932,184030,184067,184196,184201,184221,184250,184290,184293,184336,184359,184427,184436,184498,184519,184539,184544,184608,184610,184620,184627,184661,184670,184671,184688,184702,184710,184736,184757,184758,184759,184769,184782,184787,184788,184815,184829,184831,184849,184864,184865,184867,184868,184908,184958,184988,185003,185004,185046,185051,185054,185135,185155,185247,185249,185252,185275,185312,185313,185322,185430,185434,185439,185443,185460,185532,185535,185605,185608,185623,185650,185690,185758,185770,185816,185838,185891,185932,185947,185966,185985,185986,186031,186053,186075,186140,186143,186145,186146,186235,186257,186284,186285,186288,186345,186351,186368,186385,186427,186478,186485,186503,186539,186596,186608,186732,186742,186749,186750,186768,186782,186786,186796,186900,186921,186952,186977,186978,187048,187056,187070,187072,187076,187099,187100,187124,187133,187138,187200,187279,187321,187322,187329,187334,187343,187356,187414,187424,187509,187544,187607,187608,187671,187701,187848,187868,187912,187920,187968,187974,187978,187986,188009,188023,188063,188075,188117,188121,188178,188260,188290,188292,188309,188325,188344,188347,188358,188408,188469,188472,188515,188517,188519,188567,188590,188652,188653,188657,188666,188714,188727,188737,188738,188751,188775,188793,188801,188809,188972,188984,189004,189047,189063,189082,189083,189136,189158,189278,189330,189337,189342,189428,189441,189465,189549,189608,189609,189616,189619,189629,189668,189745,189751,189922,189966,190027,190028,190101,190104,190107,190111,190154,190197,190260,190298,190306,190348,190352,190388,190716,190718,190723,190730,190819,190848,190957,190979,190981,190987,190994,190997,191007,191014,191156,191236,191317,191338,191372,191423,191461,191488,191560,191566,191578,191610,191619,191656,191673,191675,191681,191701,191729,191814,191871,191872,191943,191944,192003,192008,192026,192082,192091,192151,192156,192206,192231,192249,192274,192276,192277,192301,192330,192344,192353,192424,192436,192457,192473,192495,192502,192566,192582,192584,192632,192669,192688,192743,192744,192770,192782,192794,192851,192884,192894,192904,192913,192914,192986,193048,193053,193124,193130,193205,193216,193220,193235,193252,193349,193407,193467,193472,193522,193551,193602,193609,193652,193661,193785,193868,193874,193885,193912,193913,193918,193929,193981,193990,193992,194103,194150,194151,194256,194378,194406,194473,194474,194665,194733,194734,194735,194786,194787,194842,194938,194942,195254,195362,195368,195389,195507,195566,195570,195727,195780,195785,195845,195858,195956,195971,195979,196066,196088,196214,196235,196259,196260,196338,196372,196388,196561,196787,196818,196891,197149,197150,197174,197276,197280,197380,197783,198802,198933,199527,199597) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 77 | Creole | executeQuery(): [28.91 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 (20628,20629,20630,20631,20769,20854,20855,20952,21350,21565,22018,22019,22020,22021,22083,22162,22163,22218,22219,22271,22546,22570,22587,22588,22594,22606,22616,22707,22728,22740,22749,22770,22781,22803,22805,22828,22866,22895,22902,23033,23034,23035,23036,23044,23148,23205,23222,23301,23395,23548,23552,23553,23664,23665,23702,23834,23901,23907,24042,24049,24050,24100,24110,24158,24299,24307,24693,24860,24861,24949,24963,24978,24983,25007,25073,25092,25100,25102,25116,25121,25135,25188,25221,25247,25250,25252,25254,25316,25324,25524,25569,25576,25577,25582,25716,25788,25809,25863,25952,25954,26039,26191,26223,26295,26317,26351,26504,26523,26526,26528,26592,26774,26828,27021,27067,27348,27351,27388,27449,27665,27679,27680,27689,27741,27961,27962,27963,27964,28034,28035,28036,28198,28411,29139,29431,29443,29630,29631,29632,29837,29838,29839,29840,29841,29843,29883,29991,30004,30117,30258,30495,30501,30571,30572,30574,30934,30935,30936,30937,30938,30939,31057,31058,31059,31060,31241,31612,31613,31614,31818,31931,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32307,32390,32391,32392,32393,32394,32487,32488,32621,32803,32804,32854,32897,32898,32899,32926,32947,32960,33051,33076,33161,33162,33203,33259,33309,33310,33451,33489,33523,33525,33541,33676,33933,33934,34039,34309,34384,34446,34794,35021,35057,35059,35088,35113,35138,35256,35305,35306,35324,35415,35429,35546,35621,35622,36226,36435,36516,36517,36571,36604,36610,36866,36867,36909,36991,36992,36993,36994,36995,37046,38653,38666,38688,38693,38707,38728,38783,38804,38807,38816,38859,38860,38939,39484,39508,39522,39523,39550,39578,39581,39660,39667,39668,39683,39739,40344,41891,41901,41977,42002,42395,42416,42433,42494,42506,42625,42651,42669,43021,43088,43089,43090,43101,43102,43122,43123,43124,43192,43274,43361,43365,43366,43368,43842,43925,43926,43927,43936,43955,44005,44059,44424,44425,44754,44798,45309,45389,45390,45466,45763,46212,46235,46236,46303,46336,46426,46850,46993,46994,46995,46996,46997,47034,47101,47109,47154,47190,47598,47599,47747,47748,47884,47885,47904,47907,47936,47937,48356,48457,48461,48552,48627,48790,48823,48824,49126,49382,49528,49605,49606,49642,49662,49692,49821,49896,49897,49898,49899,50170,50204,50218,50219,50232,50233,50295,50296,50297,50298,50319,50333,50431,50432,50704,50753,50800,50801,50802,50816,50826,50837,50855,50889,51029,51030,51044,51045,51656,51657,51919,51991,52024,52039,52040,52218,52219,52436,52443,52468,52562,52595,52966,52974,52977,53112,53147,53148,53261,53267,53290,53326,53573,53656,53657,53658,53659,53660,53661,53696,53724,53739,53766,53801,53811,53993,54099,54100,54101,54102,54103,54171,54250,54251,54252,54339,54635,54739,54782,55178,55273,55325,55375,55379,55387,55450,55451,55452,55453,55817,55818,55824,55834,55849,55862,55890,55891,55897,55946,55947,55952,55953,55954,55960,55961,55962,55981,55990,55991,56118,56119,56120,56121,56122,56123,56135,56136,56137,56148,56149,56163,56180,56201,56211,56226,56313,56314,56458,56459,56460,56461,56462,56463,56464,56465,56466,56467,56468,56469,56470,56599,56600,56602,56603,56604,56605,56606,56608,56753,56754,56755,56756,56763,56780,56870,56871,56875,56876,56881,56951,57021,57022,57033,57034,57035,57045,57071,57085,57086,57087,57092,57098,57099,57100,57101,57143,57147,57150,57269,57270,57281,57305,57306,57329,57361,57362,57366,57375,57381,57393,57397,57409,57420,57422,57466,57470,57471,57478,57479,57481,57487,57488,57494,57499,57508,57546,57547,57548,57603,57635,57636,57638,57641,57642,57651,57682,57684,57735,57736,57737,57738,57746,57758,57759,57760,57763,57766,57767,57779,57808,57809,58198,58201,58202,58203,58210,58211,58212,58245,58254,58264,58286,58299,58300,58304,58345,58547,58548,58562,58576,58577,58578,58595,58596,58597,58617,58658,58727,58772,58806,58807,58826,58827,58894,58928,58935,59028,59036,59071,59089,59090,59096,59098,59110,59412,59492,59494,59495,59496,59497,59498,59499,59500,59501,59526,59548,59638,59644,59646,59982,60016,60017,60018,60090,60171,60194,60217,60218,60219,60258,60270,60276,60278,60314,60315,60316,60317,60657,60735,60751,60765,60766,60767,60768,60769,60770,60780,60797,60798,60811,60812,60813,60814,60815,60829,60840,60876,60950,60951,60952,60953,60986,61012,61020,61072,61073,61082,61087,61092,61093,61094,61095,61107,61169,61191,61358,61396,61399,61402,61407,61434,61436,61440,61466,61503,61663,61665,61666,61820,62104,62110,62116,62125,62135,62141,62179,62180,62201,62202,62203,62204,62205,62225,62226,62332,62352,62353,62405,62422,62425,62426,62429,62441,62442,62834,62841,62896,62932,62933,62955,62956,62958,62959,62960,62961,63006,63007,63017,63077,63115,63141,63171,63719,63756,63762,63794,63795,63796,63821,63822,63849,63850,63893,63894,63919,63957,63959,63972,64020,64039,64387,64406,64408,64424,64441,64466,64467,64468,64519,64520,64521,64564,64565,64649,64680,64719,64728,64732,65139,65140,65142,65143,65144,65147,65152,65189,65190,65268,65380,65384,65487,65561,65625,65709,65715,65717,65725,65726,65730,65798,65839,65840,65847,65850,66398,66400,66421,66438,66439,66454,66562,66563,66646,66655,66821,66860,66861,66976,67498,67517,67667,67670,67732,67733,67784,67785,67786,67787,67894,67906,67923,67992,68000,68020,68021,68441,68488,68631,68636,68651,68701,68745,68768,69299,69310,69317,69318,69342,69374,69375,69395,69396,69397,69398,69399,69400,69401,69402,69444,69445,69446,69449,69462,69478,69550,69556,69566,69602,69603,69632,70039,70091,70092,70109,70110,70154,70176,70182,70183,70213,70233,70234,70289,70298,70300,70309,70322,70418,70443,70448,70449,70468,70516,70986,70993,71002,71020,71049,71050,71088,71094,71116,71167,71186,71208,71209,71230,71257,71284,71297,71301,71781,71782,71785,71816,71817,71825,71826,71832,71870,71873,71894,71895,71896,71897,71927,71993,72562,72585,72653,72686,72733,72734,72735,72736,72737,72738,72884,72886,72891,72900,72933,73400,73402,73403,73417,73420,73433,73434,73443,73462,73548,73549,73550,73551,73584,73595,73674,73686,73687,74204,74211,74212,74246,74269,74270,74281,74282,74329,74368,74385,74450,74532,74533,74551,75037,75038,75039,75042,75071,75119,75120,75161,75169,75170,75276,75343,75353,75355,75819,75844,75845,75847,75850,75854,75857,75894,75896,75898,75964,75965,76027,76032,76034,76035,76109,76114,76119,76120,76162,76170,76574,76648,76691,76692,76734,76738,76739,76740,76741,76742,76743,76766,76822,76823,76829,76886,76893,76903,76906,76923,76941,76993,77004,77384,77385,77413,77414,77423,77424,77425,77426,77480,77515,77566,77567,77568,77569,77570,77571,77572,77573,77623,77633,77635,77637,77647,77654,77655,77661,77667,77700,77727,77729,78179,78185,78189,78191,78211,78283,78310,78422,78546,78547,78605,78650,78651,78809,78810,79705,79706,79707,80458,80459,80471,80934,81208,81258,81330,81340,81341,81471,81501,81852,81864,81865,81870,81881,81886,81898,81939,81940,81954,81966,81979,81980,81982,81989,82429,82440,82441,82446,82450,82475,82476,82499,82528,82943,82948,82960,82972,83003,83025,83029,83031,83078,83095,83096,83098,83116,83245,83252,83253,83285,83286,83287,83389,83429,83527,83528,83529,83530,83587,83589,83597,83613,84080,84081,84107,84111,84122,84137,84139,84140,84156,84197,84198,84199,84364,84487,84489,84490,84491,84628,84630,84631,84632,84642,84780,84785,84790,84812,85101,85124,85158,85184,85185,85195,85223,85291,85296,85310,85316,85336,85339,85407,85408,85426,85476,85477,85487,85554,85570,85642,85663,85683,85686,85714,85740,85755,85756,85765,85766,85819,85891,85905,85978,85979,86071,86127,86145,86147,86192,86266,86275,86347,86382,86428,86443,86474,86517,86528,86547,86552,86564,86592,86761,86908,86962,86986,86998,87020,87085,87160,87232,87285,87327,87342,87356,87855,87881,87882,87922,87967,88036,88054,88055,88066,88122,88262,88263,88471,88661,88716,88821,88822,88823,88824,88917,88999,89012,89036,89037,89063,89083,89084,89119,89120,89121,89164,89239,89343,89414,89427,89471,89627,89633,89677,90096,90099,90142,90210,90215,90311,90371,90372,90518,90583,90593,90700,90720,90737,90796,90797,90798,90799,90834,90835,90836,90895,90896,90897,90898,90901,90955,90957,90996,91014,91015,91036,91059,91106,91190,91286,91580,91648,91675,91737,91780,91781,91782,91813,91853,91956,92147,92148,92149,92274,92422,92509,92517,92537,92538,92539,92540,92541,92824,92834,92835,92998,93017,93020,93060,93063,93086,93439,93479,93482,93494,93608,93668,93699,93712,93715,93751,93951,94040,94128,94187,94209,94312,94334,94342,94351,94352,94398,94426,94559,94982,94993,95017,95033,95034,95096,95133,95165,95197,95258,95259,95261,95344,95353,95362,95373,95374,95378,95387,95452,95526,95528,95590,95601,95602,95603,95638,95658,95677,95684,95685,95719,95776,95787,95886,95889,95897,95958,95962,95963,95978,95982,95984,96006,96072,96079,96091,97772,97793,97838,97840,97841,97851,97859,97860,97869,97889,97949,98016,98032,98039,98161,98171,98198,98201,98253,98368,98380,98432,98433,98434,98435,98436,98459,98658,98659,98719,98720,98739,98740,98741,98750,98764,98770,98774,98779,98780,98784,98809,98810,98908,98923,98924,98983,98995,98999,99026,99036,99043,99253,99272,99382,99383,99440,99445,99480,99499,99503,99935,99984,100006,100011,100026,100029,100040,100044,100062,100067,100108,100109,100541,100555,100581,100630,100642,100680,100732,100758,100778,100821,100822,100861,100898,100900,100901,101097,101118,101158,101159,101160,101198,101212,101233,101234,101317,101318,101319,101355,101369,101545,101592,101593,101602,101606,101685,101734,101736,101738,101806,101819,102044,102112,102132,102139,102192,102213,102234,102281,102282,102299,102325,102342,102365,102377,102392,102551,102552,102600,102609,102610,102611,102661,102662,102671,102727,102741,102988,102997,103059,103065,103105,103106,103135,103394,103395,103406,103418,103437,103440,103474,103481,103580,103581,103738,103739,103760,103761,103767,103772,103773,103774,103798,103807,103813,103860,103864,103871,103872,103894,104020,104182,104186,104316,104370,104453,104478,104773,104792,104793,104985,104993,105009,105075,105092,105130,105180,105276,105277,105292,105293,105300,105317,105318,105325,105326,105342,105347,105352,105355,105432,105442,105471,105578,105601,105602,105645,105755,105763,105764,105835,105838,105848,105857,105858,105859,105860,105863,105907,105934,105984,105985,106087,106120,106121,106122,106123,106143,106170,106171,106192,106243,106256,106317,106365,106370,106383,106471,106472,106473,106476,106515,106516,106517,106518,106519,106537,106559,106567,106603,106614,106616,106653,106661,106662,106663,106664,106665,106677,106683,106691,106696,106720,106756,106757,106790,106796,106846,106858,106890,106899,106900,106913,106943,106992,107001,107007,107023,107033,107035,107066,107067,107081,107082,107120,107135,107191,107197,107257,107259,107317,107400,107403,107407,107420,107441,107453,107471,107486,107522,107523,107524,107562,107946,108029,108033,108052,108068,108069,108070,108078,108079,108080,108081,108099,108100,108101,108102,108125,108126,108127,108128,108148,108157,108218,108228,108246,108251,108254,108265,108266,108267,108326,108420,108506,108529,108531,108545,108547,108658,108659,108660,108661,108662,108675,108676,108696,108705,108729,108730,108785,108786,108822,108982,109048,109057,109064,109068,109069,109090,109114,109144,109275,109285,109312,109337,109383,109395,109407,109408,109450,109502,109535,109536,109577,109578,109582,109590,109627,109630,109645,109758,109799,109858,109897,109925,109929,109970,110004,110053,110062,110103,110133,110134,110153,110154,110230,110237,110260,110261,110277,110293,110341,110342,110343,110344,110379,110429,110457,110486,110538,110544,110563,110596,110624,110628,110649,110650,110738,110750,110884,110891,110904,110913,110924,110927,110961,110976,110994,111004,111007,111078,111119,111226,111231,111261,111264,111505,111536,111757,111758,111759,111760,111761,111762,111763,111764,111765,111766,111767,111768,111769,111770,111771,111772,111773,111775,111842,112129,112130,112314,112352,112466,112500,112528,112587,112624,112627,112684,112699,112700,112701,112775,112798,112835,112858,112880,112882,112897,112912,112967,112980,112986,112987,113043,113112,113128,113170,113197,113198,113203,113218,113241,113270,113296,113318,113332,113388,113390,113408,113409,113516,113521,113526,113566,113586,113594,113607,113608,113609,113610,113628,113726,113749,113756,113769,113775,113853,113854,113875,113881,113952,114048,114094,114117,114124,114131,114171,114189,114195,114221,114272,114323,114467,114468,114483,114489,114500,114509,114531,114554,114556,114572,114608,114723,114737,114830,114860,114874,114907,114941,114960,114984,115001,115021,115023,115034,115043,115074,115113,115120,115133,115152,115212,115217,115219,115237,115238,115251,115252,115265,115283,115293,115318,115351,115424,115471,115472,115480,115483,115484,115485,115486,115487,115492,115522,115536,115537,115538,115540,115542,115558,115624,115625,115700,115719,115720,115725,115748,115762,115773,115783,115784,115794,115797,115801,115802,115808,115966,115967,115968,115969,116028,116055,116060,116079,116104,116147,116148,116156,116161,116191,116212,116213,116228,116230,116240,116250,116251,116295,116300,116301,116302,116320,116337,116340,116349,116358,116377,116467,116468,116469,116480,116491,116500,116527,116530,116533,116579,116626,116630,116637,116686,116708,116730,116731,116762,116788,116918,116950,116956,116961,116969,116970,116971,116978,116987,117047,117060,117061,117112,117125,117153,117230,117262,117276,117280,117283,117284,117293,117309,117311,117346,117356,117357,117358,117447,117475,117501,117513,117517,117557,117576,117624,117625,117648,117660,117661,117665,117714,117718,117719,117720,117778,117794,117845,117887,117888,117920,117921,117927,117932,117954,117977,117986,118063,118072,118081,118128,118129,118130,118131,118146,118149,118163,118164,118165,118211,118319,118377,118384,118422,118467,118482,118483,118494,118517,118534,118542,118570,118603,118604,118607,118612,118710,118752,118776,118780,118782,118786,118824,118851,118881,118962,118990,118991,119106,119109,119117,119121,119151,119209,119234,119239,119246,119279,119312,119313,119329,119357,119358,119360,119366,119404,119693,119905,119918,119991,119992,120039,120117,120182,120425,120436,120567,120568,120569,120588,120589,120590,120591,120592,120593,120605,120606,120619,120620,120621,120659,120660,120661,120662,120732,120733,120753,120764,120906,120997,120998,120999,121000,121001,121023,121036,121072,121073,121086,121087,121088,121109,121110,121160,121170,121171,121179,121230,121326,121327,121328,121339,121340,121341,121342,121377,121378,121389,121390,121391,121418,121458,121459,121484,121642,121650,121651,121668,121692,121718,121748,121765,121766,121803,121834,121842,121912,121955,121958,122047,122110,122135,122143,122145,122158,122189,122252,122257,122263,122329,122348,122374,122390,122391,122434,122475,122477,122478,122482,122487,122488,122615,122628,122640,122647,122682,122683,122707,122709,122711,122738,122744,122757,122774,122787,122799,122823,122828,122829,122863,122864,122879,122880,122909,123001,123052,123059,123061,123065,123067,123104,123114,123122,123322,123336,123340,123348,123356,123440,123455,123459,123629,123647,123663,123673,123680,123688,123692,123693,123694,123758,123762,123808,123815,123857,123858,123938,123951,123982,124011,124023,124064,124071,124072,124090,124111,124121,124156,124189,124239,124240,124263,124266,124287,124298,124310,124311,124318,124329,124333,124334,124343,124346,124372,124373,124374,124396,125291,125305,125325,125326,125327,125371,125374,125440,125441,125443,125445,125493,125506,125508,125509,125511,125512,125514,125519,125550,125606,125622,125624,125686,125705,125711,125718,125723,125724,125732,125739,125783,125810,125821,125834,125840,125846,125895,125925,125939,125958,125975,126010,126043,126045,126079,126081,126086,126087,126115,126116,126117,126118,126168,126172,126197,126240,126269,126272,126273,126309,126313,126314,126403,126413,126440,126447,126448,126472,126489,126521,126546,126560,126580,126634,126639,126642,126650,126659,126689,126697,126742,126752,126804,126812,126840,126880,126884,126888,126970,126974,126975,126997,127006,127037,127107,127129,127146,127151,127153,127155,127163,127164,127168,127189,127199,127200,127202,127223,127246,127252,127258,127312,127313,127346,127347,127351,127367,127442,127449,127450,127488,127530,127560,127587,127600,127601,127603,127657,127694,127703,127736,127737,127739,127740,127759,127760,127784,127795,127805,127809,127819,127824,127825,127839,127854,127855,127866,127867,127892,127914,127917,127953,127954,127962,127963,128023,128071,128088,128092,128112,128125,128160,128162,128201,128229,128249,128258,128324,128325,128341,128342,128343,128388,128445,128480,128514,128578,128579,128619,128642,128716,128740,128762,128768,128777,128793,128813,128815,128874,128900,128927,128954,129001,129029,129030,129039,129040,129045,129047,129070,129114,129122,129146,129152,129202,129215,129246,129304,129309,129392,129394,129401,129434,129435,129436,129609,129610,129670,129786,129979,130115,130117,130169,130170,130250,130299,130300,130301,130378,130379,130380,130657,130658,130660,130662,130694,130698,130701,130702,130975,130976,130978,131018,131042,131043,131045,131046,131240,131299,131322,131384,131426,131472,131473,131600,131601,131725,131736,131744,131802,131803,131804,131805,131868,131870,131874,131876,132105,132106,132191,132237,132254,132302,132303,132345,132350,132380,132405,132406,132445,132446,132447,132493,132551,132560,132601,132622,132633,132634,132692,132722,132755,132772,132791,132793,132809,132864,132882,132886,132908,132932,132933,132942,133095,133099,133118,133142,133162,133231,133248,133377,133378,133381,133497,133498,133537,133664,133696,133844,133895,133962,134102,134113,134114,134137,134144,134145,134192,134202,134538,134632,134633,134975,135005,135006,135027,135052,135064,135084,135211,135307,135408,135434,135497,135522,135554,135622,135738,135766,135892,135926,135948,136060,136106,136196,136462,136479,136480,136517,136605,136636,136653,136654,136655,136663,136679,136705,136716,136751,136928,136929,136939,136940,136942,136957,136962,136966,136971,136987,136994,137003,137005,137052,137061,137062,137080,137081,137091,137229,137230,137239,137256,137269,137314,137321,137358,137364,137365,137370,137391,137393,137394,137446,137447,137451,137454,137462,137502,137523,137536,137551,137633,137637,137651,137665,137696,137791,137828,137837,137846,137886,138011,138014,138019,138021,138022,138024,138029,138031,138065,138104,138177,138179,138183,138187,138188,138198,138202,138242,138252,138298,138299,138306,138314,138447,138568,138572,138573,138579,138580,138583,138584,138590,138594,138599,138619,138670,138676,138721,138722,138723,138724,138725,138735,138740,138741,138752,138753,138764,138765,138771,138772,138795,138952,138953,138954,138955,138956,138957,138958,138959,138960,138961,138962,138963,138964,139080,139442,139454,139512,139528,139688,139692,139704,139705,139706,139711,139720,139733,139743,139751,140232,140247,140269,140418,140423,140754,140849,140855,140893,140946,140987,141030,141043,141074,141106,141212,141222,141223,141272,141292,141296,141309,141317,141322,141333,141371,141439,141575,141668,141736,141750,141757,141781,141782,141788,141870,141881,141956,141962,142067,142068,142095,142123,142131,142146,142157,142158,142178,142183,142184,142191,142221,142226,142262,142316,142317,142332,142383,142397,142406,142466,142468,142478,142484,142500,142505,142507,142552,142570,142575,142578,142670,142744,142837,142847,142850,142904,143023,143024,143101,143259,143260,143291,143319,143335,143338,143343,143344,143377,143465,143495,143596,143617,143619,143636,143637,143640,143740,143763,143765,143766,143821,143831,143838,143841,143847,143848,143875,143915,143957,143958,143975,144014,144022,144029,144063,144086,144116,144138,144164,144165,144213,144219,144222,144228,144285,144297,144354,144535,144544,144551,144560,144610,144615,144616,144621,144622,144633,144634,144690,144702,144703,144704,144723,144737,144753,144771,144819,144842,144848,144884,144888,144909,144952,144980,144999,145002,145034,145077,145081,145082,145085,145103,145121,145167,145168,145177,145181,145188,145206,145258,145261,145262,145265,145281,145287,145288,145299,145333,145334,145365,145377,145385,145399,145404,145436,145437,145481,145489,145494,145621,145622,145636,145647,145663,145680,145701,145710,145725,145726,145747,145758,145759,145760,145761,145762,145763,145776,145777,145778,145779,145780,145796,145846,145854,145855,145858,145977,145982,145986,146001,146013,146036,146048,146119,146133,146134,146136,146141,146171,146210,146223,146234,146324,146325,146326,146327,146328,146329,146330,146385,146389,146394,146402,146403,146428,146443,146457,146477,146530,146531,146532,146670,146672,146692,146723,146733,146739,146750,146753,146762,146773,146795,146798,146805,146808,146897,146905,146906,146939,146943,146959,146982,147039,147042,147045,147097,147108,147174,147175,147219,147226,147227,147235,147262,147265,147335,147341,147356,147376,147386,147481,147488,147489,147544,147548,147596,147606,147615,147619,147625,147648,147687,147698,147706,147711,147726,147730,147738,147739,147751,147752,147787,147788,147789,147815,147826,147853,147865,147873,147874,147875,147876,147883,147884,147895,147911,147926,147932,147970,147991,148017,148067,148077,148093,148104,148106,148107,148131,148169,148183,148187,148188,148255,148261,148262,148269,148271,148297,148318,148337,148339,148377,148385,148392,148405,148433,148438,148451,148461,148484,148493,148523,148525,148545,148555,148560,148626,148661,148745,148750,148761,148764,148767,148769,148770,148775,148811,148859,148891,148906,148922,148927,148948,148958,148965,148971,148972,149052,149137,149157,149205,149220,149251,149258,149259,149320,149330,149331,149332,149341,149352,149401,149504,149512,149539,149540,149609,149610,149612,149636,149650,149701,149710,149711,149741,149761,149767,149776,149782,149815,149933,149970,149971,149982,150226,150231,150256,150320,150483,150580,150605,150608,150609,150611,150613,150703,150763,150781,150825,150912,150922,150937,150959,150992,151041,151069,151096,151105,151129,151184,151213,151237,151239,151342,151421,151687,151705,151757,151792,151818,151845,151858,151876,151879,151893,151906,151922,151925,152024,152061,152062,152091,152092,152093,152122,152142,152203,152346,152436,152544,152874,152876,152966,153069,153137,153164,153175,153180,153184,153286,153315,153344,153395,153414,153419,153423,153426,153432,153510,153531,153532,153533,153538,153558,153559,153562,153573,153612,153621,153654,153656,153773,153859,153868,153873,153874,153877,153897,153928,153947,153950,153951,153953,153960,153961,153997,154000,154007,154021,154025,154026,154059,154073,154095,154131,154219,154224,154247,154254,154257,154261,154318,154346,154354,154358,154372,154385,154508,154511,154535,154571,154572,154593,154608,154633,154635,154636,154647,154676,154682,154745,154757,154774,154776,154782,154861,155001,155002,155003,155057,155069,155070,155076,155078,155080,155084,155087,155111,155146,155147,155153,155241,155278,155421,155422,155452,155515,155522,155527,155596,155621,155633,155756,156152,156184,156201,156214,156255,156272,156273,156274,156385,156400,156478,156538,156581,156700,156751,156767,156772,156884,156900,157025,157131,157152,157169,157194,157291,157292,157293,157294,157295,157296,157297,157305,157306,157307,157308,157309,157310,157311,157312,157313,157367,157372,157373,157374,157427,157489,157502,157505,157510,157512,157596,157597,157626,157637,157638,157641,157669,157685,157689,157743,157802,157803,157830,157845,157881,157895,157953,157999,158043,158045,158046,158145,158178,158181,158195,158225,158259,158289,158316,158341,158440,158453,158459,158499,158542,158543,158558,158590,158593,158594,158653,158842,158843,158844,158849,158850,158856,158883,158897,158898,158900,158986,159008,159017,159036,159056,159058,159207,159208,159257,159375,159402,159425,159426,159482,159511,159591,159599,159623,159648,159649,159655,159874,159904,159955,160024,160032,160151,160169,160213,160247,160279,160283,160296,160354,160375,160385,160447,160480,160623,160626,160627,160628,160645,160650,160654,160833,161034,161401,161540,161808,161959,162050,162056,162076,162113,162218,162242,162266,162273,162285,162336,162358,162381,162402,162482,162510,162682,162707,162716,162738,162758,162806,162877,162899,162900,162934,162992,162993,163120,163185,163254,163327,163454,163486,163630,163667,163686,163691,163722,163757,163845,163846,163860,163877,163902,163995,164004,164068,164095,164103,164296,164331,164338,164387,164391,164488,164558,164581,164593,164622,164681,164701,164702,164715,164729,164735,164784,164835,164839,164916,164959,164962,165009,165103,165151,165205,165206,165248,165258,165259,165261,165273,165279,165309,165317,165386,165614,165625,165667,165686,165687,165721,165740,165801,165822,165823,165863,165877,165932,165949,165960,165963,165964,165965,166086,166087,166088,166089,166213,166223,166387,166395,166415,166442,166443,166459,166469,166470,166477,166478,166539,166540,166546,166555,166602,166615,166623,166660,166661,166662,166663,166690,166757,166769,166770,166771,166793,166794,166795,166821,166828,166856,166897,166901,166948,166975,166978,167038,167067,167120,167128,167159,167191,167194,167197,167203,167204,167206,167209,167242,167423,167425,167447,167491,167505,167531,167534,167552,167556,167562,167563,167630,167781,167816,167821,167833,167834,167850,167859,167922,167958,167959,168051,168058,168095,168139,168146,168160,168161,168174,168176,168250,168253,168258,168299,168307,168308,168311,168320,168329,168431,168479,168500,168505,168510,168576,168590,168594,168619,168622,168638,168640,168658,168671,168701,168710,168728,168729,168730,168743,168783,168787,168807,168817,168838,168849,168851,168888,168889,168890,168931,168985,168995,169019,169020,169021,169022,169048,169107,169119,169161,169175,169185,169193,169225,169241,169303,169306,169318,169326,169336,169344,169402,169414,169441,169470,169486,169528,169530,169542,169545,169586,169775,169850,169862,169886,169896,169960,169988,169998,170018,170112,170113,170142,170156,170224,170250,170275,170337,170338,170350,170381,170386,170396,170416,170442,170456,170495,170515,170525,170526,170551,170553,170662,170687,170688,170689,170724,170750,170751,170769,170771,170836,170837,170858,170884,170904,170906,170929,170937,170970,170985,170989,171007,171065,171081,171090,171104,171105,171136,171178,171192,171203,171216,171237,171253,171254,171260,171268,171269,171277,171326,171366,171415,171437,171452,171480,171571,171572,171669,171708,171709,171733,171751,171753,171769,171770,171771,171886,171888,171904,171906,172032,172060,172107,172114,172115,172156,172161,172164,172166,172172,172173,172184,172198,172199,172200,172201,172265,172293,172324,172346,172356,172402,172406,172407,172418,172445,172474,172533,172552,172563,172582,172584,172619,172626,172628,172648,172649,172657,172658,172680,172683,172687,172722,172725,172859,172924,172955,172974,172993,173079,173135,173140,173154,173220,173227,173244,173260,173269,173270,173301,173308,173313,173321,173348,173408,173415,173422,173464,173571,173638,173639,173640,173651,173676,173713,173727,173748,173774,173848,173882,173904,173925,173942,173950,173966,173978,173987,173990,173999,174046,174049,174123,174131,174149,174153,174154,174198,174259,174304,174353,174389,174415,174423,174442,174476,174541,174605,174755,174774,174791,174845,174848,174857,174859,174905,174982,174991,175005,175012,175028,175051,175067,175074,175080,175132,175171,175183,175231,175238,175295,175303,175305,175320,175371,175444,175447,175524,175650,175651,175660,175677,175681,175713,175728,175729,175730,175731,175813,175832,175850,175893,175895,175898,175908,175991,176004,176025,176090,176093,176095,176111,176117,176118,176119,176179,176187,176199,176221,176237,176268,176283,176291,176292,176329,176345,176353,176396,176402,176469,176478,176535,176536,176564,176587,176606,176628,176758,176773,176817,176836,176845,176888,176899,176917,176934,176994,176998,177000,177034,177036,177178,177188,177221,177229,177293,177295,177303,177313,177386,177409,177425,177453,177482,177494,177519,177565,177568,177569,177577,177623,177661,177667,177681,177697,177700,177769,177825,177833,177857,177863,177885,177902,177933,177959,177969,177970,178011,178016,178067,178094,178103,178118,178122,178125,178142,178237,178292,178349,178400,178409,178463,178466,178473,178482,178502,178534,178565,178578,178579,178612,178667,178668,178830,178842,179014,179096,179156,179159,179160,179167,179173,179210,179291,179318,179408,179418,179419,179426,179540,179554,179612,179657,179702,179726,179736,179801,179825,179869,179940,179947,179948,179978,179995,179999,180028,180051,180056,180088,180095,180141,180151,180236,180244,180260,180278,180289,180380,180531,180544,180562,180585,180693,180711,180716,180733,180734,180742,180745,180751,180752,180754,180762,180773,180785,180865,180885,180907,180921,180974,180988,181041,181054,181071,181145,181156,181163,181177,181230,181241,181312,181337,181346,181396,181417,181429,181433,181511,181586,181590,181596,181617,181643,181674,181675,181677,181688,181706,181841,181844,181848,181872,181876,181886,181917,181945,181986,182023,182027,182060,182088,182090,182146,182203,182221,182234,182256,182306,182444,182462,182531,182603,182706,182828,182921,182947,182963,182987,183037,183061,183066,183128,183148,183171,183223,183224,183238,183244,183280,183291,183319,183324,183331,183424,183454,183455,183483,183530,183647,183677,183680,183730,183731,183771,183789,183836,183848,183877,183920,183932,184030,184067,184196,184201,184221,184250,184290,184293,184336,184359,184427,184436,184498,184519,184539,184544,184608,184610,184620,184627,184661,184670,184671,184688,184702,184710,184736,184757,184758,184759,184769,184782,184787,184788,184815,184829,184831,184849,184864,184865,184867,184868,184908,184958,184988,185003,185004,185046,185051,185054,185135,185155,185247,185249,185252,185275,185312,185313,185322,185430,185434,185439,185443,185460,185532,185535,185605,185608,185623,185650,185690,185758,185770,185816,185838,185891,185932,185947,185966,185985,185986,186031,186053,186075,186140,186143,186145,186146,186235,186257,186284,186285,186288,186345,186351,186368,186385,186427,186478,186485,186503,186539,186596,186608,186732,186742,186749,186750,186768,186782,186786,186796,186900,186921,186952,186977,186978,187048,187056,187070,187072,187076,187099,187100,187124,187133,187138,187200,187279,187321,187322,187329,187334,187343,187356,187414,187424,187509,187544,187607,187608,187671,187701,187848,187868,187912,187920,187968,187974,187978,187986,188009,188023,188063,188075,188117,188121,188178,188260,188290,188292,188309,188325,188344,188347,188358,188408,188469,188472,188515,188517,188519,188567,188590,188652,188653,188657,188666,188714,188727,188737,188738,188751,188775,188793,188801,188809,188972,188984,189004,189047,189063,189082,189083,189136,189158,189278,189330,189337,189342,189428,189441,189465,189549,189608,189609,189616,189619,189629,189668,189745,189751,189922,189966,190027,190028,190101,190104,190107,190111,190154,190197,190260,190298,190306,190348,190352,190388,190716,190718,190723,190730,190819,190848,190957,190979,190981,190987,190994,190997,191007,191014,191156,191236,191317,191338,191372,191423,191461,191488,191560,191566,191578,191610,191619,191656,191673,191675,191681,191701,191729,191814,191871,191872,191943,191944,192003,192008,192026,192082,192091,192151,192156,192206,192231,192249,192274,192276,192277,192301,192330,192344,192353,192424,192436,192457,192473,192495,192502,192566,192582,192584,192632,192669,192688,192743,192744,192770,192782,192794,192851,192884,192894,192904,192913,192914,192986,193048,193053,193124,193130,193205,193216,193220,193235,193252,193349,193407,193467,193472,193522,193551,193602,193609,193652,193661,193785,193868,193874,193885,193912,193913,193918,193929,193981,193990,193992,194103,194150,194151,194256,194378,194406,194473,194474,194665,194733,194734,194735,194786,194787,194842,194938,194942,195254,195362,195368,195389,195507,195566,195570,195727,195780,195785,195845,195858,195956,195971,195979,196066,196088,196214,196235,196259,196260,196338,196372,196388,196561,196787,196818,196891,197149,197150,197174,197276,197280,197380,197783,198802,198933,199527,199597) 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 (20628,20629,20630,20631,20769,20854,20855,20952,21350,21565,22018,22019,22020,22021,22083,22162,22163,22218,22219,22271,22546,22570,22587,22588,22594,22606,22616,22707,22728,22740,22749,22770,22781,22803,22805,22828,22866,22895,22902,23033,23034,23035,23036,23044,23148,23205,23222,23301,23395,23548,23552,23553,23664,23665,23702,23834,23901,23907,24042,24049,24050,24100,24110,24158,24299,24307,24693,24860,24861,24949,24963,24978,24983,25007,25073,25092,25100,25102,25116,25121,25135,25188,25221,25247,25250,25252,25254,25316,25324,25524,25569,25576,25577,25582,25716,25788,25809,25863,25952,25954,26039,26191,26223,26295,26317,26351,26504,26523,26526,26528,26592,26774,26828,27021,27067,27348,27351,27388,27449,27665,27679,27680,27689,27741,27961,27962,27963,27964,28034,28035,28036,28198,28411,29139,29431,29443,29630,29631,29632,29837,29838,29839,29840,29841,29843,29883,29991,30004,30117,30258,30495,30501,30571,30572,30574,30934,30935,30936,30937,30938,30939,31057,31058,31059,31060,31241,31612,31613,31614,31818,31931,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32307,32390,32391,32392,32393,32394,32487,32488,32621,32803,32804,32854,32897,32898,32899,32926,32947,32960,33051,33076,33161,33162,33203,33259,33309,33310,33451,33489,33523,33525,33541,33676,33933,33934,34039,34309,34384,34446,34794,35021,35057,35059,35088,35113,35138,35256,35305,35306,35324,35415,35429,35546,35621,35622,36226,36435,36516,36517,36571,36604,36610,36866,36867,36909,36991,36992,36993,36994,36995,37046,38653,38666,38688,38693,38707,38728,38783,38804,38807,38816,38859,38860,38939,39484,39508,39522,39523,39550,39578,39581,39660,39667,39668,39683,39739,40344,41891,41901,41977,42002,42395,42416,42433,42494,42506,42625,42651,42669,43021,43088,43089,43090,43101,43102,43122,43123,43124,43192,43274,43361,43365,43366,43368,43842,43925,43926,43927,43936,43955,44005,44059,44424,44425,44754,44798,45309,45389,45390,45466,45763,46212,46235,46236,46303,46336,46426,46850,46993,46994,46995,46996,46997,47034,47101,47109,47154,47190,47598,47599,47747,47748,47884,47885,47904,47907,47936,47937,48356,48457,48461,48552,48627,48790,48823,48824,49126,49382,49528,49605,49606,49642,49662,49692,49821,49896,49897,49898,49899,50170,50204,50218,50219,50232,50233,50295,50296,50297,50298,50319,50333,50431,50432,50704,50753,50800,50801,50802,50816,50826,50837,50855,50889,51029,51030,51044,51045,51656,51657,51919,51991,52024,52039,52040,52218,52219,52436,52443,52468,52562,52595,52966,52974,52977,53112,53147,53148,53261,53267,53290,53326,53573,53656,53657,53658,53659,53660,53661,53696,53724,53739,53766,53801,53811,53993,54099,54100,54101,54102,54103,54171,54250,54251,54252,54339,54635,54739,54782,55178,55273,55325,55375,55379,55387,55450,55451,55452,55453,55817,55818,55824,55834,55849,55862,55890,55891,55897,55946,55947,55952,55953,55954,55960,55961,55962,55981,55990,55991,56118,56119,56120,56121,56122,56123,56135,56136,56137,56148,56149,56163,56180,56201,56211,56226,56313,56314,56458,56459,56460,56461,56462,56463,56464,56465,56466,56467,56468,56469,56470,56599,56600,56602,56603,56604,56605,56606,56608,56753,56754,56755,56756,56763,56780,56870,56871,56875,56876,56881,56951,57021,57022,57033,57034,57035,57045,57071,57085,57086,57087,57092,57098,57099,57100,57101,57143,57147,57150,57269,57270,57281,57305,57306,57329,57361,57362,57366,57375,57381,57393,57397,57409,57420,57422,57466,57470,57471,57478,57479,57481,57487,57488,57494,57499,57508,57546,57547,57548,57603,57635,57636,57638,57641,57642,57651,57682,57684,57735,57736,57737,57738,57746,57758,57759,57760,57763,57766,57767,57779,57808,57809,58198,58201,58202,58203,58210,58211,58212,58245,58254,58264,58286,58299,58300,58304,58345,58547,58548,58562,58576,58577,58578,58595,58596,58597,58617,58658,58727,58772,58806,58807,58826,58827,58894,58928,58935,59028,59036,59071,59089,59090,59096,59098,59110,59412,59492,59494,59495,59496,59497,59498,59499,59500,59501,59526,59548,59638,59644,59646,59982,60016,60017,60018,60090,60171,60194,60217,60218,60219,60258,60270,60276,60278,60314,60315,60316,60317,60657,60735,60751,60765,60766,60767,60768,60769,60770,60780,60797,60798,60811,60812,60813,60814,60815,60829,60840,60876,60950,60951,60952,60953,60986,61012,61020,61072,61073,61082,61087,61092,61093,61094,61095,61107,61169,61191,61358,61396,61399,61402,61407,61434,61436,61440,61466,61503,61663,61665,61666,61820,62104,62110,62116,62125,62135,62141,62179,62180,62201,62202,62203,62204,62205,62225,62226,62332,62352,62353,62405,62422,62425,62426,62429,62441,62442,62834,62841,62896,62932,62933,62955,62956,62958,62959,62960,62961,63006,63007,63017,63077,63115,63141,63171,63719,63756,63762,63794,63795,63796,63821,63822,63849,63850,63893,63894,63919,63957,63959,63972,64020,64039,64387,64406,64408,64424,64441,64466,64467,64468,64519,64520,64521,64564,64565,64649,64680,64719,64728,64732,65139,65140,65142,65143,65144,65147,65152,65189,65190,65268,65380,65384,65487,65561,65625,65709,65715,65717,65725,65726,65730,65798,65839,65840,65847,65850,66398,66400,66421,66438,66439,66454,66562,66563,66646,66655,66821,66860,66861,66976,67498,67517,67667,67670,67732,67733,67784,67785,67786,67787,67894,67906,67923,67992,68000,68020,68021,68441,68488,68631,68636,68651,68701,68745,68768,69299,69310,69317,69318,69342,69374,69375,69395,69396,69397,69398,69399,69400,69401,69402,69444,69445,69446,69449,69462,69478,69550,69556,69566,69602,69603,69632,70039,70091,70092,70109,70110,70154,70176,70182,70183,70213,70233,70234,70289,70298,70300,70309,70322,70418,70443,70448,70449,70468,70516,70986,70993,71002,71020,71049,71050,71088,71094,71116,71167,71186,71208,71209,71230,71257,71284,71297,71301,71781,71782,71785,71816,71817,71825,71826,71832,71870,71873,71894,71895,71896,71897,71927,71993,72562,72585,72653,72686,72733,72734,72735,72736,72737,72738,72884,72886,72891,72900,72933,73400,73402,73403,73417,73420,73433,73434,73443,73462,73548,73549,73550,73551,73584,73595,73674,73686,73687,74204,74211,74212,74246,74269,74270,74281,74282,74329,74368,74385,74450,74532,74533,74551,75037,75038,75039,75042,75071,75119,75120,75161,75169,75170,75276,75343,75353,75355,75819,75844,75845,75847,75850,75854,75857,75894,75896,75898,75964,75965,76027,76032,76034,76035,76109,76114,76119,76120,76162,76170,76574,76648,76691,76692,76734,76738,76739,76740,76741,76742,76743,76766,76822,76823,76829,76886,76893,76903,76906,76923,76941,76993,77004,77384,77385,77413,77414,77423,77424,77425,77426,77480,77515,77566,77567,77568,77569,77570,77571,77572,77573,77623,77633,77635,77637,77647,77654,77655,77661,77667,77700,77727,77729,78179,78185,78189,78191,78211,78283,78310,78422,78546,78547,78605,78650,78651,78809,78810,79705,79706,79707,80458,80459,80471,80934,81208,81258,81330,81340,81341,81471,81501,81852,81864,81865,81870,81881,81886,81898,81939,81940,81954,81966,81979,81980,81982,81989,82429,82440,82441,82446,82450,82475,82476,82499,82528,82943,82948,82960,82972,83003,83025,83029,83031,83078,83095,83096,83098,83116,83245,83252,83253,83285,83286,83287,83389,83429,83527,83528,83529,83530,83587,83589,83597,83613,84080,84081,84107,84111,84122,84137,84139,84140,84156,84197,84198,84199,84364,84487,84489,84490,84491,84628,84630,84631,84632,84642,84780,84785,84790,84812,85101,85124,85158,85184,85185,85195,85223,85291,85296,85310,85316,85336,85339,85407,85408,85426,85476,85477,85487,85554,85570,85642,85663,85683,85686,85714,85740,85755,85756,85765,85766,85819,85891,85905,85978,85979,86071,86127,86145,86147,86192,86266,86275,86347,86382,86428,86443,86474,86517,86528,86547,86552,86564,86592,86761,86908,86962,86986,86998,87020,87085,87160,87232,87285,87327,87342,87356,87855,87881,87882,87922,87967,88036,88054,88055,88066,88122,88262,88263,88471,88661,88716,88821,88822,88823,88824,88917,88999,89012,89036,89037,89063,89083,89084,89119,89120,89121,89164,89239,89343,89414,89427,89471,89627,89633,89677,90096,90099,90142,90210,90215,90311,90371,90372,90518,90583,90593,90700,90720,90737,90796,90797,90798,90799,90834,90835,90836,90895,90896,90897,90898,90901,90955,90957,90996,91014,91015,91036,91059,91106,91190,91286,91580,91648,91675,91737,91780,91781,91782,91813,91853,91956,92147,92148,92149,92274,92422,92509,92517,92537,92538,92539,92540,92541,92824,92834,92835,92998,93017,93020,93060,93063,93086,93439,93479,93482,93494,93608,93668,93699,93712,93715,93751,93951,94040,94128,94187,94209,94312,94334,94342,94351,94352,94398,94426,94559,94982,94993,95017,95033,95034,95096,95133,95165,95197,95258,95259,95261,95344,95353,95362,95373,95374,95378,95387,95452,95526,95528,95590,95601,95602,95603,95638,95658,95677,95684,95685,95719,95776,95787,95886,95889,95897,95958,95962,95963,95978,95982,95984,96006,96072,96079,96091,97772,97793,97838,97840,97841,97851,97859,97860,97869,97889,97949,98016,98032,98039,98161,98171,98198,98201,98253,98368,98380,98432,98433,98434,98435,98436,98459,98658,98659,98719,98720,98739,98740,98741,98750,98764,98770,98774,98779,98780,98784,98809,98810,98908,98923,98924,98983,98995,98999,99026,99036,99043,99253,99272,99382,99383,99440,99445,99480,99499,99503,99935,99984,100006,100011,100026,100029,100040,100044,100062,100067,100108,100109,100541,100555,100581,100630,100642,100680,100732,100758,100778,100821,100822,100861,100898,100900,100901,101097,101118,101158,101159,101160,101198,101212,101233,101234,101317,101318,101319,101355,101369,101545,101592,101593,101602,101606,101685,101734,101736,101738,101806,101819,102044,102112,102132,102139,102192,102213,102234,102281,102282,102299,102325,102342,102365,102377,102392,102551,102552,102600,102609,102610,102611,102661,102662,102671,102727,102741,102988,102997,103059,103065,103105,103106,103135,103394,103395,103406,103418,103437,103440,103474,103481,103580,103581,103738,103739,103760,103761,103767,103772,103773,103774,103798,103807,103813,103860,103864,103871,103872,103894,104020,104182,104186,104316,104370,104453,104478,104773,104792,104793,104985,104993,105009,105075,105092,105130,105180,105276,105277,105292,105293,105300,105317,105318,105325,105326,105342,105347,105352,105355,105432,105442,105471,105578,105601,105602,105645,105755,105763,105764,105835,105838,105848,105857,105858,105859,105860,105863,105907,105934,105984,105985,106087,106120,106121,106122,106123,106143,106170,106171,106192,106243,106256,106317,106365,106370,106383,106471,106472,106473,106476,106515,106516,106517,106518,106519,106537,106559,106567,106603,106614,106616,106653,106661,106662,106663,106664,106665,106677,106683,106691,106696,106720,106756,106757,106790,106796,106846,106858,106890,106899,106900,106913,106943,106992,107001,107007,107023,107033,107035,107066,107067,107081,107082,107120,107135,107191,107197,107257,107259,107317,107400,107403,107407,107420,107441,107453,107471,107486,107522,107523,107524,107562,107946,108029,108033,108052,108068,108069,108070,108078,108079,108080,108081,108099,108100,108101,108102,108125,108126,108127,108128,108148,108157,108218,108228,108246,108251,108254,108265,108266,108267,108326,108420,108506,108529,108531,108545,108547,108658,108659,108660,108661,108662,108675,108676,108696,108705,108729,108730,108785,108786,108822,108982,109048,109057,109064,109068,109069,109090,109114,109144,109275,109285,109312,109337,109383,109395,109407,109408,109450,109502,109535,109536,109577,109578,109582,109590,109627,109630,109645,109758,109799,109858,109897,109925,109929,109970,110004,110053,110062,110103,110133,110134,110153,110154,110230,110237,110260,110261,110277,110293,110341,110342,110343,110344,110379,110429,110457,110486,110538,110544,110563,110596,110624,110628,110649,110650,110738,110750,110884,110891,110904,110913,110924,110927,110961,110976,110994,111004,111007,111078,111119,111226,111231,111261,111264,111505,111536,111757,111758,111759,111760,111761,111762,111763,111764,111765,111766,111767,111768,111769,111770,111771,111772,111773,111775,111842,112129,112130,112314,112352,112466,112500,112528,112587,112624,112627,112684,112699,112700,112701,112775,112798,112835,112858,112880,112882,112897,112912,112967,112980,112986,112987,113043,113112,113128,113170,113197,113198,113203,113218,113241,113270,113296,113318,113332,113388,113390,113408,113409,113516,113521,113526,113566,113586,113594,113607,113608,113609,113610,113628,113726,113749,113756,113769,113775,113853,113854,113875,113881,113952,114048,114094,114117,114124,114131,114171,114189,114195,114221,114272,114323,114467,114468,114483,114489,114500,114509,114531,114554,114556,114572,114608,114723,114737,114830,114860,114874,114907,114941,114960,114984,115001,115021,115023,115034,115043,115074,115113,115120,115133,115152,115212,115217,115219,115237,115238,115251,115252,115265,115283,115293,115318,115351,115424,115471,115472,115480,115483,115484,115485,115486,115487,115492,115522,115536,115537,115538,115540,115542,115558,115624,115625,115700,115719,115720,115725,115748,115762,115773,115783,115784,115794,115797,115801,115802,115808,115966,115967,115968,115969,116028,116055,116060,116079,116104,116147,116148,116156,116161,116191,116212,116213,116228,116230,116240,116250,116251,116295,116300,116301,116302,116320,116337,116340,116349,116358,116377,116467,116468,116469,116480,116491,116500,116527,116530,116533,116579,116626,116630,116637,116686,116708,116730,116731,116762,116788,116918,116950,116956,116961,116969,116970,116971,116978,116987,117047,117060,117061,117112,117125,117153,117230,117262,117276,117280,117283,117284,117293,117309,117311,117346,117356,117357,117358,117447,117475,117501,117513,117517,117557,117576,117624,117625,117648,117660,117661,117665,117714,117718,117719,117720,117778,117794,117845,117887,117888,117920,117921,117927,117932,117954,117977,117986,118063,118072,118081,118128,118129,118130,118131,118146,118149,118163,118164,118165,118211,118319,118377,118384,118422,118467,118482,118483,118494,118517,118534,118542,118570,118603,118604,118607,118612,118710,118752,118776,118780,118782,118786,118824,118851,118881,118962,118990,118991,119106,119109,119117,119121,119151,119209,119234,119239,119246,119279,119312,119313,119329,119357,119358,119360,119366,119404,119693,119905,119918,119991,119992,120039,120117,120182,120425,120436,120567,120568,120569,120588,120589,120590,120591,120592,120593,120605,120606,120619,120620,120621,120659,120660,120661,120662,120732,120733,120753,120764,120906,120997,120998,120999,121000,121001,121023,121036,121072,121073,121086,121087,121088,121109,121110,121160,121170,121171,121179,121230,121326,121327,121328,121339,121340,121341,121342,121377,121378,121389,121390,121391,121418,121458,121459,121484,121642,121650,121651,121668,121692,121718,121748,121765,121766,121803,121834,121842,121912,121955,121958,122047,122110,122135,122143,122145,122158,122189,122252,122257,122263,122329,122348,122374,122390,122391,122434,122475,122477,122478,122482,122487,122488,122615,122628,122640,122647,122682,122683,122707,122709,122711,122738,122744,122757,122774,122787,122799,122823,122828,122829,122863,122864,122879,122880,122909,123001,123052,123059,123061,123065,123067,123104,123114,123122,123322,123336,123340,123348,123356,123440,123455,123459,123629,123647,123663,123673,123680,123688,123692,123693,123694,123758,123762,123808,123815,123857,123858,123938,123951,123982,124011,124023,124064,124071,124072,124090,124111,124121,124156,124189,124239,124240,124263,124266,124287,124298,124310,124311,124318,124329,124333,124334,124343,124346,124372,124373,124374,124396,125291,125305,125325,125326,125327,125371,125374,125440,125441,125443,125445,125493,125506,125508,125509,125511,125512,125514,125519,125550,125606,125622,125624,125686,125705,125711,125718,125723,125724,125732,125739,125783,125810,125821,125834,125840,125846,125895,125925,125939,125958,125975,126010,126043,126045,126079,126081,126086,126087,126115,126116,126117,126118,126168,126172,126197,126240,126269,126272,126273,126309,126313,126314,126403,126413,126440,126447,126448,126472,126489,126521,126546,126560,126580,126634,126639,126642,126650,126659,126689,126697,126742,126752,126804,126812,126840,126880,126884,126888,126970,126974,126975,126997,127006,127037,127107,127129,127146,127151,127153,127155,127163,127164,127168,127189,127199,127200,127202,127223,127246,127252,127258,127312,127313,127346,127347,127351,127367,127442,127449,127450,127488,127530,127560,127587,127600,127601,127603,127657,127694,127703,127736,127737,127739,127740,127759,127760,127784,127795,127805,127809,127819,127824,127825,127839,127854,127855,127866,127867,127892,127914,127917,127953,127954,127962,127963,128023,128071,128088,128092,128112,128125,128160,128162,128201,128229,128249,128258,128324,128325,128341,128342,128343,128388,128445,128480,128514,128578,128579,128619,128642,128716,128740,128762,128768,128777,128793,128813,128815,128874,128900,128927,128954,129001,129029,129030,129039,129040,129045,129047,129070,129114,129122,129146,129152,129202,129215,129246,129304,129309,129392,129394,129401,129434,129435,129436,129609,129610,129670,129786,129979,130115,130117,130169,130170,130250,130299,130300,130301,130378,130379,130380,130657,130658,130660,130662,130694,130698,130701,130702,130975,130976,130978,131018,131042,131043,131045,131046,131240,131299,131322,131384,131426,131472,131473,131600,131601,131725,131736,131744,131802,131803,131804,131805,131868,131870,131874,131876,132105,132106,132191,132237,132254,132302,132303,132345,132350,132380,132405,132406,132445,132446,132447,132493,132551,132560,132601,132622,132633,132634,132692,132722,132755,132772,132791,132793,132809,132864,132882,132886,132908,132932,132933,132942,133095,133099,133118,133142,133162,133231,133248,133377,133378,133381,133497,133498,133537,133664,133696,133844,133895,133962,134102,134113,134114,134137,134144,134145,134192,134202,134538,134632,134633,134975,135005,135006,135027,135052,135064,135084,135211,135307,135408,135434,135497,135522,135554,135622,135738,135766,135892,135926,135948,136060,136106,136196,136462,136479,136480,136517,136605,136636,136653,136654,136655,136663,136679,136705,136716,136751,136928,136929,136939,136940,136942,136957,136962,136966,136971,136987,136994,137003,137005,137052,137061,137062,137080,137081,137091,137229,137230,137239,137256,137269,137314,137321,137358,137364,137365,137370,137391,137393,137394,137446,137447,137451,137454,137462,137502,137523,137536,137551,137633,137637,137651,137665,137696,137791,137828,137837,137846,137886,138011,138014,138019,138021,138022,138024,138029,138031,138065,138104,138177,138179,138183,138187,138188,138198,138202,138242,138252,138298,138299,138306,138314,138447,138568,138572,138573,138579,138580,138583,138584,138590,138594,138599,138619,138670,138676,138721,138722,138723,138724,138725,138735,138740,138741,138752,138753,138764,138765,138771,138772,138795,138952,138953,138954,138955,138956,138957,138958,138959,138960,138961,138962,138963,138964,139080,139442,139454,139512,139528,139688,139692,139704,139705,139706,139711,139720,139733,139743,139751,140232,140247,140269,140418,140423,140754,140849,140855,140893,140946,140987,141030,141043,141074,141106,141212,141222,141223,141272,141292,141296,141309,141317,141322,141333,141371,141439,141575,141668,141736,141750,141757,141781,141782,141788,141870,141881,141956,141962,142067,142068,142095,142123,142131,142146,142157,142158,142178,142183,142184,142191,142221,142226,142262,142316,142317,142332,142383,142397,142406,142466,142468,142478,142484,142500,142505,142507,142552,142570,142575,142578,142670,142744,142837,142847,142850,142904,143023,143024,143101,143259,143260,143291,143319,143335,143338,143343,143344,143377,143465,143495,143596,143617,143619,143636,143637,143640,143740,143763,143765,143766,143821,143831,143838,143841,143847,143848,143875,143915,143957,143958,143975,144014,144022,144029,144063,144086,144116,144138,144164,144165,144213,144219,144222,144228,144285,144297,144354,144535,144544,144551,144560,144610,144615,144616,144621,144622,144633,144634,144690,144702,144703,144704,144723,144737,144753,144771,144819,144842,144848,144884,144888,144909,144952,144980,144999,145002,145034,145077,145081,145082,145085,145103,145121,145167,145168,145177,145181,145188,145206,145258,145261,145262,145265,145281,145287,145288,145299,145333,145334,145365,145377,145385,145399,145404,145436,145437,145481,145489,145494,145621,145622,145636,145647,145663,145680,145701,145710,145725,145726,145747,145758,145759,145760,145761,145762,145763,145776,145777,145778,145779,145780,145796,145846,145854,145855,145858,145977,145982,145986,146001,146013,146036,146048,146119,146133,146134,146136,146141,146171,146210,146223,146234,146324,146325,146326,146327,146328,146329,146330,146385,146389,146394,146402,146403,146428,146443,146457,146477,146530,146531,146532,146670,146672,146692,146723,146733,146739,146750,146753,146762,146773,146795,146798,146805,146808,146897,146905,146906,146939,146943,146959,146982,147039,147042,147045,147097,147108,147174,147175,147219,147226,147227,147235,147262,147265,147335,147341,147356,147376,147386,147481,147488,147489,147544,147548,147596,147606,147615,147619,147625,147648,147687,147698,147706,147711,147726,147730,147738,147739,147751,147752,147787,147788,147789,147815,147826,147853,147865,147873,147874,147875,147876,147883,147884,147895,147911,147926,147932,147970,147991,148017,148067,148077,148093,148104,148106,148107,148131,148169,148183,148187,148188,148255,148261,148262,148269,148271,148297,148318,148337,148339,148377,148385,148392,148405,148433,148438,148451,148461,148484,148493,148523,148525,148545,148555,148560,148626,148661,148745,148750,148761,148764,148767,148769,148770,148775,148811,148859,148891,148906,148922,148927,148948,148958,148965,148971,148972,149052,149137,149157,149205,149220,149251,149258,149259,149320,149330,149331,149332,149341,149352,149401,149504,149512,149539,149540,149609,149610,149612,149636,149650,149701,149710,149711,149741,149761,149767,149776,149782,149815,149933,149970,149971,149982,150226,150231,150256,150320,150483,150580,150605,150608,150609,150611,150613,150703,150763,150781,150825,150912,150922,150937,150959,150992,151041,151069,151096,151105,151129,151184,151213,151237,151239,151342,151421,151687,151705,151757,151792,151818,151845,151858,151876,151879,151893,151906,151922,151925,152024,152061,152062,152091,152092,152093,152122,152142,152203,152346,152436,152544,152874,152876,152966,153069,153137,153164,153175,153180,153184,153286,153315,153344,153395,153414,153419,153423,153426,153432,153510,153531,153532,153533,153538,153558,153559,153562,153573,153612,153621,153654,153656,153773,153859,153868,153873,153874,153877,153897,153928,153947,153950,153951,153953,153960,153961,153997,154000,154007,154021,154025,154026,154059,154073,154095,154131,154219,154224,154247,154254,154257,154261,154318,154346,154354,154358,154372,154385,154508,154511,154535,154571,154572,154593,154608,154633,154635,154636,154647,154676,154682,154745,154757,154774,154776,154782,154861,155001,155002,155003,155057,155069,155070,155076,155078,155080,155084,155087,155111,155146,155147,155153,155241,155278,155421,155422,155452,155515,155522,155527,155596,155621,155633,155756,156152,156184,156201,156214,156255,156272,156273,156274,156385,156400,156478,156538,156581,156700,156751,156767,156772,156884,156900,157025,157131,157152,157169,157194,157291,157292,157293,157294,157295,157296,157297,157305,157306,157307,157308,157309,157310,157311,157312,157313,157367,157372,157373,157374,157427,157489,157502,157505,157510,157512,157596,157597,157626,157637,157638,157641,157669,157685,157689,157743,157802,157803,157830,157845,157881,157895,157953,157999,158043,158045,158046,158145,158178,158181,158195,158225,158259,158289,158316,158341,158440,158453,158459,158499,158542,158543,158558,158590,158593,158594,158653,158842,158843,158844,158849,158850,158856,158883,158897,158898,158900,158986,159008,159017,159036,159056,159058,159207,159208,159257,159375,159402,159425,159426,159482,159511,159591,159599,159623,159648,159649,159655,159874,159904,159955,160024,160032,160151,160169,160213,160247,160279,160283,160296,160354,160375,160385,160447,160480,160623,160626,160627,160628,160645,160650,160654,160833,161034,161401,161540,161808,161959,162050,162056,162076,162113,162218,162242,162266,162273,162285,162336,162358,162381,162402,162482,162510,162682,162707,162716,162738,162758,162806,162877,162899,162900,162934,162992,162993,163120,163185,163254,163327,163454,163486,163630,163667,163686,163691,163722,163757,163845,163846,163860,163877,163902,163995,164004,164068,164095,164103,164296,164331,164338,164387,164391,164488,164558,164581,164593,164622,164681,164701,164702,164715,164729,164735,164784,164835,164839,164916,164959,164962,165009,165103,165151,165205,165206,165248,165258,165259,165261,165273,165279,165309,165317,165386,165614,165625,165667,165686,165687,165721,165740,165801,165822,165823,165863,165877,165932,165949,165960,165963,165964,165965,166086,166087,166088,166089,166213,166223,166387,166395,166415,166442,166443,166459,166469,166470,166477,166478,166539,166540,166546,166555,166602,166615,166623,166660,166661,166662,166663,166690,166757,166769,166770,166771,166793,166794,166795,166821,166828,166856,166897,166901,166948,166975,166978,167038,167067,167120,167128,167159,167191,167194,167197,167203,167204,167206,167209,167242,167423,167425,167447,167491,167505,167531,167534,167552,167556,167562,167563,167630,167781,167816,167821,167833,167834,167850,167859,167922,167958,167959,168051,168058,168095,168139,168146,168160,168161,168174,168176,168250,168253,168258,168299,168307,168308,168311,168320,168329,168431,168479,168500,168505,168510,168576,168590,168594,168619,168622,168638,168640,168658,168671,168701,168710,168728,168729,168730,168743,168783,168787,168807,168817,168838,168849,168851,168888,168889,168890,168931,168985,168995,169019,169020,169021,169022,169048,169107,169119,169161,169175,169185,169193,169225,169241,169303,169306,169318,169326,169336,169344,169402,169414,169441,169470,169486,169528,169530,169542,169545,169586,169775,169850,169862,169886,169896,169960,169988,169998,170018,170112,170113,170142,170156,170224,170250,170275,170337,170338,170350,170381,170386,170396,170416,170442,170456,170495,170515,170525,170526,170551,170553,170662,170687,170688,170689,170724,170750,170751,170769,170771,170836,170837,170858,170884,170904,170906,170929,170937,170970,170985,170989,171007,171065,171081,171090,171104,171105,171136,171178,171192,171203,171216,171237,171253,171254,171260,171268,171269,171277,171326,171366,171415,171437,171452,171480,171571,171572,171669,171708,171709,171733,171751,171753,171769,171770,171771,171886,171888,171904,171906,172032,172060,172107,172114,172115,172156,172161,172164,172166,172172,172173,172184,172198,172199,172200,172201,172265,172293,172324,172346,172356,172402,172406,172407,172418,172445,172474,172533,172552,172563,172582,172584,172619,172626,172628,172648,172649,172657,172658,172680,172683,172687,172722,172725,172859,172924,172955,172974,172993,173079,173135,173140,173154,173220,173227,173244,173260,173269,173270,173301,173308,173313,173321,173348,173408,173415,173422,173464,173571,173638,173639,173640,173651,173676,173713,173727,173748,173774,173848,173882,173904,173925,173942,173950,173966,173978,173987,173990,173999,174046,174049,174123,174131,174149,174153,174154,174198,174259,174304,174353,174389,174415,174423,174442,174476,174541,174605,174755,174774,174791,174845,174848,174857,174859,174905,174982,174991,175005,175012,175028,175051,175067,175074,175080,175132,175171,175183,175231,175238,175295,175303,175305,175320,175371,175444,175447,175524,175650,175651,175660,175677,175681,175713,175728,175729,175730,175731,175813,175832,175850,175893,175895,175898,175908,175991,176004,176025,176090,176093,176095,176111,176117,176118,176119,176179,176187,176199,176221,176237,176268,176283,176291,176292,176329,176345,176353,176396,176402,176469,176478,176535,176536,176564,176587,176606,176628,176758,176773,176817,176836,176845,176888,176899,176917,176934,176994,176998,177000,177034,177036,177178,177188,177221,177229,177293,177295,177303,177313,177386,177409,177425,177453,177482,177494,177519,177565,177568,177569,177577,177623,177661,177667,177681,177697,177700,177769,177825,177833,177857,177863,177885,177902,177933,177959,177969,177970,178011,178016,178067,178094,178103,178118,178122,178125,178142,178237,178292,178349,178400,178409,178463,178466,178473,178482,178502,178534,178565,178578,178579,178612,178667,178668,178830,178842,179014,179096,179156,179159,179160,179167,179173,179210,179291,179318,179408,179418,179419,179426,179540,179554,179612,179657,179702,179726,179736,179801,179825,179869,179940,179947,179948,179978,179995,179999,180028,180051,180056,180088,180095,180141,180151,180236,180244,180260,180278,180289,180380,180531,180544,180562,180585,180693,180711,180716,180733,180734,180742,180745,180751,180752,180754,180762,180773,180785,180865,180885,180907,180921,180974,180988,181041,181054,181071,181145,181156,181163,181177,181230,181241,181312,181337,181346,181396,181417,181429,181433,181511,181586,181590,181596,181617,181643,181674,181675,181677,181688,181706,181841,181844,181848,181872,181876,181886,181917,181945,181986,182023,182027,182060,182088,182090,182146,182203,182221,182234,182256,182306,182444,182462,182531,182603,182706,182828,182921,182947,182963,182987,183037,183061,183066,183128,183148,183171,183223,183224,183238,183244,183280,183291,183319,183324,183331,183424,183454,183455,183483,183530,183647,183677,183680,183730,183731,183771,183789,183836,183848,183877,183920,183932,184030,184067,184196,184201,184221,184250,184290,184293,184336,184359,184427,184436,184498,184519,184539,184544,184608,184610,184620,184627,184661,184670,184671,184688,184702,184710,184736,184757,184758,184759,184769,184782,184787,184788,184815,184829,184831,184849,184864,184865,184867,184868,184908,184958,184988,185003,185004,185046,185051,185054,185135,185155,185247,185249,185252,185275,185312,185313,185322,185430,185434,185439,185443,185460,185532,185535,185605,185608,185623,185650,185690,185758,185770,185816,185838,185891,185932,185947,185966,185985,185986,186031,186053,186075,186140,186143,186145,186146,186235,186257,186284,186285,186288,186345,186351,186368,186385,186427,186478,186485,186503,186539,186596,186608,186732,186742,186749,186750,186768,186782,186786,186796,186900,186921,186952,186977,186978,187048,187056,187070,187072,187076,187099,187100,187124,187133,187138,187200,187279,187321,187322,187329,187334,187343,187356,187414,187424,187509,187544,187607,187608,187671,187701,187848,187868,187912,187920,187968,187974,187978,187986,188009,188023,188063,188075,188117,188121,188178,188260,188290,188292,188309,188325,188344,188347,188358,188408,188469,188472,188515,188517,188519,188567,188590,188652,188653,188657,188666,188714,188727,188737,188738,188751,188775,188793,188801,188809,188972,188984,189004,189047,189063,189082,189083,189136,189158,189278,189330,189337,189342,189428,189441,189465,189549,189608,189609,189616,189619,189629,189668,189745,189751,189922,189966,190027,190028,190101,190104,190107,190111,190154,190197,190260,190298,190306,190348,190352,190388,190716,190718,190723,190730,190819,190848,190957,190979,190981,190987,190994,190997,191007,191014,191156,191236,191317,191338,191372,191423,191461,191488,191560,191566,191578,191610,191619,191656,191673,191675,191681,191701,191729,191814,191871,191872,191943,191944,192003,192008,192026,192082,192091,192151,192156,192206,192231,192249,192274,192276,192277,192301,192330,192344,192353,192424,192436,192457,192473,192495,192502,192566,192582,192584,192632,192669,192688,192743,192744,192770,192782,192794,192851,192884,192894,192904,192913,192914,192986,193048,193053,193124,193130,193205,193216,193220,193235,193252,193349,193407,193467,193472,193522,193551,193602,193609,193652,193661,193785,193868,193874,193885,193912,193913,193918,193929,193981,193990,193992,194103,194150,194151,194256,194378,194406,194473,194474,194665,194733,194734,194735,194786,194787,194842,194938,194942,195254,195362,195368,195389,195507,195566,195570,195727,195780,195785,195845,195858,195956,195971,195979,196066,196088,196214,196235,196259,196260,196338,196372,196388,196561,196787,196818,196891,197149,197150,197174,197276,197280,197380,197783,198802,198933,199527,199597) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 79 | Creole | executeQuery(): [38.65 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 (20628,20629,20630,20631,20769,20854,20855,20952,21350,21565,22018,22019,22020,22021,22083,22162,22163,22218,22219,22271,22546,22570,22587,22588,22594,22606,22616,22707,22728,22740,22749,22770,22781,22803,22805,22828,22866,22895,22902,23033,23034,23035,23036,23044,23148,23205,23222,23301,23395,23548,23552,23553,23664,23665,23702,23834,23901,23907,24042,24049,24050,24100,24110,24158,24299,24307,24693,24860,24861,24949,24963,24978,24983,25007,25073,25092,25100,25102,25116,25121,25135,25188,25221,25247,25250,25252,25254,25316,25324,25524,25569,25576,25577,25582,25716,25788,25809,25863,25952,25954,26039,26191,26223,26295,26317,26351,26504,26523,26526,26528,26592,26774,26828,27021,27067,27348,27351,27388,27449,27665,27679,27680,27689,27741,27961,27962,27963,27964,28034,28035,28036,28198,28411,29139,29431,29443,29630,29631,29632,29837,29838,29839,29840,29841,29843,29883,29991,30004,30117,30258,30495,30501,30571,30572,30574,30934,30935,30936,30937,30938,30939,31057,31058,31059,31060,31241,31612,31613,31614,31818,31931,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32307,32390,32391,32392,32393,32394,32487,32488,32621,32803,32804,32854,32897,32898,32899,32926,32947,32960,33051,33076,33161,33162,33203,33259,33309,33310,33451,33489,33523,33525,33541,33676,33933,33934,34039,34309,34384,34446,34794,35021,35057,35059,35088,35113,35138,35256,35305,35306,35324,35415,35429,35546,35621,35622,36226,36435,36516,36517,36571,36604,36610,36866,36867,36909,36991,36992,36993,36994,36995,37046,38653,38666,38688,38693,38707,38728,38783,38804,38807,38816,38859,38860,38939,39484,39508,39522,39523,39550,39578,39581,39660,39667,39668,39683,39739,40344,41891,41901,41977,42002,42395,42416,42433,42494,42506,42625,42651,42669,43021,43088,43089,43090,43101,43102,43122,43123,43124,43192,43274,43361,43365,43366,43368,43842,43925,43926,43927,43936,43955,44005,44059,44424,44425,44754,44798,45309,45389,45390,45466,45763,46212,46235,46236,46303,46336,46426,46850,46993,46994,46995,46996,46997,47034,47101,47109,47154,47190,47598,47599,47747,47748,47884,47885,47904,47907,47936,47937,48356,48457,48461,48552,48627,48790,48823,48824,49126,49382,49528,49605,49606,49642,49662,49692,49821,49896,49897,49898,49899,50170,50204,50218,50219,50232,50233,50295,50296,50297,50298,50319,50333,50431,50432,50704,50753,50800,50801,50802,50816,50826,50837,50855,50889,51029,51030,51044,51045,51656,51657,51919,51991,52024,52039,52040,52218,52219,52436,52443,52468,52562,52595,52966,52974,52977,53112,53147,53148,53261,53267,53290,53326,53573,53656,53657,53658,53659,53660,53661,53696,53724,53739,53766,53801,53811,53993,54099,54100,54101,54102,54103,54171,54250,54251,54252,54339,54635,54739,54782,55178,55273,55325,55375,55379,55387,55450,55451,55452,55453,55817,55818,55824,55834,55849,55862,55890,55891,55897,55946,55947,55952,55953,55954,55960,55961,55962,55981,55990,55991,56118,56119,56120,56121,56122,56123,56135,56136,56137,56148,56149,56163,56180,56201,56211,56226,56313,56314,56458,56459,56460,56461,56462,56463,56464,56465,56466,56467,56468,56469,56470,56599,56600,56602,56603,56604,56605,56606,56608,56753,56754,56755,56756,56763,56780,56870,56871,56875,56876,56881,56951,57021,57022,57033,57034,57035,57045,57071,57085,57086,57087,57092,57098,57099,57100,57101,57143,57147,57150,57269,57270,57281,57305,57306,57329,57361,57362,57366,57375,57381,57393,57397,57409,57420,57422,57466,57470,57471,57478,57479,57481,57487,57488,57494,57499,57508,57546,57547,57548,57603,57635,57636,57638,57641,57642,57651,57682,57684,57735,57736,57737,57738,57746,57758,57759,57760,57763,57766,57767,57779,57808,57809,58198,58201,58202,58203,58210,58211,58212,58245,58254,58264,58286,58299,58300,58304,58345,58547,58548,58562,58576,58577,58578,58595,58596,58597,58617,58658,58727,58772,58806,58807,58826,58827,58894,58928,58935,59028,59036,59071,59089,59090,59096,59098,59110,59412,59492,59494,59495,59496,59497,59498,59499,59500,59501,59526,59548,59638,59644,59646,59982,60016,60017,60018,60090,60171,60194,60217,60218,60219,60258,60270,60276,60278,60314,60315,60316,60317,60657,60735,60751,60765,60766,60767,60768,60769,60770,60780,60797,60798,60811,60812,60813,60814,60815,60829,60840,60876,60950,60951,60952,60953,60986,61012,61020,61072,61073,61082,61087,61092,61093,61094,61095,61107,61169,61191,61358,61396,61399,61402,61407,61434,61436,61440,61466,61503,61663,61665,61666,61820,62104,62110,62116,62125,62135,62141,62179,62180,62201,62202,62203,62204,62205,62225,62226,62332,62352,62353,62405,62422,62425,62426,62429,62441,62442,62834,62841,62896,62932,62933,62955,62956,62958,62959,62960,62961,63006,63007,63017,63077,63115,63141,63171,63719,63756,63762,63794,63795,63796,63821,63822,63849,63850,63893,63894,63919,63957,63959,63972,64020,64039,64387,64406,64408,64424,64441,64466,64467,64468,64519,64520,64521,64564,64565,64649,64680,64719,64728,64732,65139,65140,65142,65143,65144,65147,65152,65189,65190,65268,65380,65384,65487,65561,65625,65709,65715,65717,65725,65726,65730,65798,65839,65840,65847,65850,66398,66400,66421,66438,66439,66454,66562,66563,66646,66655,66821,66860,66861,66976,67498,67517,67667,67670,67732,67733,67784,67785,67786,67787,67894,67906,67923,67992,68000,68020,68021,68441,68488,68631,68636,68651,68701,68745,68768,69299,69310,69317,69318,69342,69374,69375,69395,69396,69397,69398,69399,69400,69401,69402,69444,69445,69446,69449,69462,69478,69550,69556,69566,69602,69603,69632,70039,70091,70092,70109,70110,70154,70176,70182,70183,70213,70233,70234,70289,70298,70300,70309,70322,70418,70443,70448,70449,70468,70516,70986,70993,71002,71020,71049,71050,71088,71094,71116,71167,71186,71208,71209,71230,71257,71284,71297,71301,71781,71782,71785,71816,71817,71825,71826,71832,71870,71873,71894,71895,71896,71897,71927,71993,72562,72585,72653,72686,72733,72734,72735,72736,72737,72738,72884,72886,72891,72900,72933,73400,73402,73403,73417,73420,73433,73434,73443,73462,73548,73549,73550,73551,73584,73595,73674,73686,73687,74204,74211,74212,74246,74269,74270,74281,74282,74329,74368,74385,74450,74532,74533,74551,75037,75038,75039,75042,75071,75119,75120,75161,75169,75170,75276,75343,75353,75355,75819,75844,75845,75847,75850,75854,75857,75894,75896,75898,75964,75965,76027,76032,76034,76035,76109,76114,76119,76120,76162,76170,76574,76648,76691,76692,76734,76738,76739,76740,76741,76742,76743,76766,76822,76823,76829,76886,76893,76903,76906,76923,76941,76993,77004,77384,77385,77413,77414,77423,77424,77425,77426,77480,77515,77566,77567,77568,77569,77570,77571,77572,77573,77623,77633,77635,77637,77647,77654,77655,77661,77667,77700,77727,77729,78179,78185,78189,78191,78211,78283,78310,78422,78546,78547,78605,78650,78651,78809,78810,79705,79706,79707,80458,80459,80471,80934,81208,81258,81330,81340,81341,81471,81501,81852,81864,81865,81870,81881,81886,81898,81939,81940,81954,81966,81979,81980,81982,81989,82429,82440,82441,82446,82450,82475,82476,82499,82528,82943,82948,82960,82972,83003,83025,83029,83031,83078,83095,83096,83098,83116,83245,83252,83253,83285,83286,83287,83389,83429,83527,83528,83529,83530,83587,83589,83597,83613,84080,84081,84107,84111,84122,84137,84139,84140,84156,84197,84198,84199,84364,84487,84489,84490,84491,84628,84630,84631,84632,84642,84780,84785,84790,84812,85101,85124,85158,85184,85185,85195,85223,85291,85296,85310,85316,85336,85339,85407,85408,85426,85476,85477,85487,85554,85570,85642,85663,85683,85686,85714,85740,85755,85756,85765,85766,85819,85891,85905,85978,85979,86071,86127,86145,86147,86192,86266,86275,86347,86382,86428,86443,86474,86517,86528,86547,86552,86564,86592,86761,86908,86962,86986,86998,87020,87085,87160,87232,87285,87327,87342,87356,87855,87881,87882,87922,87967,88036,88054,88055,88066,88122,88262,88263,88471,88661,88716,88821,88822,88823,88824,88917,88999,89012,89036,89037,89063,89083,89084,89119,89120,89121,89164,89239,89343,89414,89427,89471,89627,89633,89677,90096,90099,90142,90210,90215,90311,90371,90372,90518,90583,90593,90700,90720,90737,90796,90797,90798,90799,90834,90835,90836,90895,90896,90897,90898,90901,90955,90957,90996,91014,91015,91036,91059,91106,91190,91286,91580,91648,91675,91737,91780,91781,91782,91813,91853,91956,92147,92148,92149,92274,92422,92509,92517,92537,92538,92539,92540,92541,92824,92834,92835,92998,93017,93020,93060,93063,93086,93439,93479,93482,93494,93608,93668,93699,93712,93715,93751,93951,94040,94128,94187,94209,94312,94334,94342,94351,94352,94398,94426,94559,94982,94993,95017,95033,95034,95096,95133,95165,95197,95258,95259,95261,95344,95353,95362,95373,95374,95378,95387,95452,95526,95528,95590,95601,95602,95603,95638,95658,95677,95684,95685,95719,95776,95787,95886,95889,95897,95958,95962,95963,95978,95982,95984,96006,96072,96079,96091,97772,97793,97838,97840,97841,97851,97859,97860,97869,97889,97949,98016,98032,98039,98161,98171,98198,98201,98253,98368,98380,98432,98433,98434,98435,98436,98459,98658,98659,98719,98720,98739,98740,98741,98750,98764,98770,98774,98779,98780,98784,98809,98810,98908,98923,98924,98983,98995,98999,99026,99036,99043,99253,99272,99382,99383,99440,99445,99480,99499,99503,99935,99984,100006,100011,100026,100029,100040,100044,100062,100067,100108,100109,100541,100555,100581,100630,100642,100680,100732,100758,100778,100821,100822,100861,100898,100900,100901,101097,101118,101158,101159,101160,101198,101212,101233,101234,101317,101318,101319,101355,101369,101545,101592,101593,101602,101606,101685,101734,101736,101738,101806,101819,102044,102112,102132,102139,102192,102213,102234,102281,102282,102299,102325,102342,102365,102377,102392,102551,102552,102600,102609,102610,102611,102661,102662,102671,102727,102741,102988,102997,103059,103065,103105,103106,103135,103394,103395,103406,103418,103437,103440,103474,103481,103580,103581,103738,103739,103760,103761,103767,103772,103773,103774,103798,103807,103813,103860,103864,103871,103872,103894,104020,104182,104186,104316,104370,104453,104478,104773,104792,104793,104985,104993,105009,105075,105092,105130,105180,105276,105277,105292,105293,105300,105317,105318,105325,105326,105342,105347,105352,105355,105432,105442,105471,105578,105601,105602,105645,105755,105763,105764,105835,105838,105848,105857,105858,105859,105860,105863,105907,105934,105984,105985,106087,106120,106121,106122,106123,106143,106170,106171,106192,106243,106256,106317,106365,106370,106383,106471,106472,106473,106476,106515,106516,106517,106518,106519,106537,106559,106567,106603,106614,106616,106653,106661,106662,106663,106664,106665,106677,106683,106691,106696,106720,106756,106757,106790,106796,106846,106858,106890,106899,106900,106913,106943,106992,107001,107007,107023,107033,107035,107066,107067,107081,107082,107120,107135,107191,107197,107257,107259,107317,107400,107403,107407,107420,107441,107453,107471,107486,107522,107523,107524,107562,107946,108029,108033,108052,108068,108069,108070,108078,108079,108080,108081,108099,108100,108101,108102,108125,108126,108127,108128,108148,108157,108218,108228,108246,108251,108254,108265,108266,108267,108326,108420,108506,108529,108531,108545,108547,108658,108659,108660,108661,108662,108675,108676,108696,108705,108729,108730,108785,108786,108822,108982,109048,109057,109064,109068,109069,109090,109114,109144,109275,109285,109312,109337,109383,109395,109407,109408,109450,109502,109535,109536,109577,109578,109582,109590,109627,109630,109645,109758,109799,109858,109897,109925,109929,109970,110004,110053,110062,110103,110133,110134,110153,110154,110230,110237,110260,110261,110277,110293,110341,110342,110343,110344,110379,110429,110457,110486,110538,110544,110563,110596,110624,110628,110649,110650,110738,110750,110884,110891,110904,110913,110924,110927,110961,110976,110994,111004,111007,111078,111119,111226,111231,111261,111264,111505,111536,111757,111758,111759,111760,111761,111762,111763,111764,111765,111766,111767,111768,111769,111770,111771,111772,111773,111775,111842,112129,112130,112314,112352,112466,112500,112528,112587,112624,112627,112684,112699,112700,112701,112775,112798,112835,112858,112880,112882,112897,112912,112967,112980,112986,112987,113043,113112,113128,113170,113197,113198,113203,113218,113241,113270,113296,113318,113332,113388,113390,113408,113409,113516,113521,113526,113566,113586,113594,113607,113608,113609,113610,113628,113726,113749,113756,113769,113775,113853,113854,113875,113881,113952,114048,114094,114117,114124,114131,114171,114189,114195,114221,114272,114323,114467,114468,114483,114489,114500,114509,114531,114554,114556,114572,114608,114723,114737,114830,114860,114874,114907,114941,114960,114984,115001,115021,115023,115034,115043,115074,115113,115120,115133,115152,115212,115217,115219,115237,115238,115251,115252,115265,115283,115293,115318,115351,115424,115471,115472,115480,115483,115484,115485,115486,115487,115492,115522,115536,115537,115538,115540,115542,115558,115624,115625,115700,115719,115720,115725,115748,115762,115773,115783,115784,115794,115797,115801,115802,115808,115966,115967,115968,115969,116028,116055,116060,116079,116104,116147,116148,116156,116161,116191,116212,116213,116228,116230,116240,116250,116251,116295,116300,116301,116302,116320,116337,116340,116349,116358,116377,116467,116468,116469,116480,116491,116500,116527,116530,116533,116579,116626,116630,116637,116686,116708,116730,116731,116762,116788,116918,116950,116956,116961,116969,116970,116971,116978,116987,117047,117060,117061,117112,117125,117153,117230,117262,117276,117280,117283,117284,117293,117309,117311,117346,117356,117357,117358,117447,117475,117501,117513,117517,117557,117576,117624,117625,117648,117660,117661,117665,117714,117718,117719,117720,117778,117794,117845,117887,117888,117920,117921,117927,117932,117954,117977,117986,118063,118072,118081,118128,118129,118130,118131,118146,118149,118163,118164,118165,118211,118319,118377,118384,118422,118467,118482,118483,118494,118517,118534,118542,118570,118603,118604,118607,118612,118710,118752,118776,118780,118782,118786,118824,118851,118881,118962,118990,118991,119106,119109,119117,119121,119151,119209,119234,119239,119246,119279,119312,119313,119329,119357,119358,119360,119366,119404,119693,119905,119918,119991,119992,120039,120117,120182,120425,120436,120567,120568,120569,120588,120589,120590,120591,120592,120593,120605,120606,120619,120620,120621,120659,120660,120661,120662,120732,120733,120753,120764,120906,120997,120998,120999,121000,121001,121023,121036,121072,121073,121086,121087,121088,121109,121110,121160,121170,121171,121179,121230,121326,121327,121328,121339,121340,121341,121342,121377,121378,121389,121390,121391,121418,121458,121459,121484,121642,121650,121651,121668,121692,121718,121748,121765,121766,121803,121834,121842,121912,121955,121958,122047,122110,122135,122143,122145,122158,122189,122252,122257,122263,122329,122348,122374,122390,122391,122434,122475,122477,122478,122482,122487,122488,122615,122628,122640,122647,122682,122683,122707,122709,122711,122738,122744,122757,122774,122787,122799,122823,122828,122829,122863,122864,122879,122880,122909,123001,123052,123059,123061,123065,123067,123104,123114,123122,123322,123336,123340,123348,123356,123440,123455,123459,123629,123647,123663,123673,123680,123688,123692,123693,123694,123758,123762,123808,123815,123857,123858,123938,123951,123982,124011,124023,124064,124071,124072,124090,124111,124121,124156,124189,124239,124240,124263,124266,124287,124298,124310,124311,124318,124329,124333,124334,124343,124346,124372,124373,124374,124396,125291,125305,125325,125326,125327,125371,125374,125440,125441,125443,125445,125493,125506,125508,125509,125511,125512,125514,125519,125550,125606,125622,125624,125686,125705,125711,125718,125723,125724,125732,125739,125783,125810,125821,125834,125840,125846,125895,125925,125939,125958,125975,126010,126043,126045,126079,126081,126086,126087,126115,126116,126117,126118,126168,126172,126197,126240,126269,126272,126273,126309,126313,126314,126403,126413,126440,126447,126448,126472,126489,126521,126546,126560,126580,126634,126639,126642,126650,126659,126689,126697,126742,126752,126804,126812,126840,126880,126884,126888,126970,126974,126975,126997,127006,127037,127107,127129,127146,127151,127153,127155,127163,127164,127168,127189,127199,127200,127202,127223,127246,127252,127258,127312,127313,127346,127347,127351,127367,127442,127449,127450,127488,127530,127560,127587,127600,127601,127603,127657,127694,127703,127736,127737,127739,127740,127759,127760,127784,127795,127805,127809,127819,127824,127825,127839,127854,127855,127866,127867,127892,127914,127917,127953,127954,127962,127963,128023,128071,128088,128092,128112,128125,128160,128162,128201,128229,128249,128258,128324,128325,128341,128342,128343,128388,128445,128480,128514,128578,128579,128619,128642,128716,128740,128762,128768,128777,128793,128813,128815,128874,128900,128927,128954,129001,129029,129030,129039,129040,129045,129047,129070,129114,129122,129146,129152,129202,129215,129246,129304,129309,129392,129394,129401,129434,129435,129436,129609,129610,129670,129786,129979,130115,130117,130169,130170,130250,130299,130300,130301,130378,130379,130380,130657,130658,130660,130662,130694,130698,130701,130702,130975,130976,130978,131018,131042,131043,131045,131046,131240,131299,131322,131384,131426,131472,131473,131600,131601,131725,131736,131744,131802,131803,131804,131805,131868,131870,131874,131876,132105,132106,132191,132237,132254,132302,132303,132345,132350,132380,132405,132406,132445,132446,132447,132493,132551,132560,132601,132622,132633,132634,132692,132722,132755,132772,132791,132793,132809,132864,132882,132886,132908,132932,132933,132942,133095,133099,133118,133142,133162,133231,133248,133377,133378,133381,133497,133498,133537,133664,133696,133844,133895,133962,134102,134113,134114,134137,134144,134145,134192,134202,134538,134632,134633,134975,135005,135006,135027,135052,135064,135084,135211,135307,135408,135434,135497,135522,135554,135622,135738,135766,135892,135926,135948,136060,136106,136196,136462,136479,136480,136517,136605,136636,136653,136654,136655,136663,136679,136705,136716,136751,136928,136929,136939,136940,136942,136957,136962,136966,136971,136987,136994,137003,137005,137052,137061,137062,137080,137081,137091,137229,137230,137239,137256,137269,137314,137321,137358,137364,137365,137370,137391,137393,137394,137446,137447,137451,137454,137462,137502,137523,137536,137551,137633,137637,137651,137665,137696,137791,137828,137837,137846,137886,138011,138014,138019,138021,138022,138024,138029,138031,138065,138104,138177,138179,138183,138187,138188,138198,138202,138242,138252,138298,138299,138306,138314,138447,138568,138572,138573,138579,138580,138583,138584,138590,138594,138599,138619,138670,138676,138721,138722,138723,138724,138725,138735,138740,138741,138752,138753,138764,138765,138771,138772,138795,138952,138953,138954,138955,138956,138957,138958,138959,138960,138961,138962,138963,138964,139080,139442,139454,139512,139528,139688,139692,139704,139705,139706,139711,139720,139733,139743,139751,140232,140247,140269,140418,140423,140754,140849,140855,140893,140946,140987,141030,141043,141074,141106,141212,141222,141223,141272,141292,141296,141309,141317,141322,141333,141371,141439,141575,141668,141736,141750,141757,141781,141782,141788,141870,141881,141956,141962,142067,142068,142095,142123,142131,142146,142157,142158,142178,142183,142184,142191,142221,142226,142262,142316,142317,142332,142383,142397,142406,142466,142468,142478,142484,142500,142505,142507,142552,142570,142575,142578,142670,142744,142837,142847,142850,142904,143023,143024,143101,143259,143260,143291,143319,143335,143338,143343,143344,143377,143465,143495,143596,143617,143619,143636,143637,143640,143740,143763,143765,143766,143821,143831,143838,143841,143847,143848,143875,143915,143957,143958,143975,144014,144022,144029,144063,144086,144116,144138,144164,144165,144213,144219,144222,144228,144285,144297,144354,144535,144544,144551,144560,144610,144615,144616,144621,144622,144633,144634,144690,144702,144703,144704,144723,144737,144753,144771,144819,144842,144848,144884,144888,144909,144952,144980,144999,145002,145034,145077,145081,145082,145085,145103,145121,145167,145168,145177,145181,145188,145206,145258,145261,145262,145265,145281,145287,145288,145299,145333,145334,145365,145377,145385,145399,145404,145436,145437,145481,145489,145494,145621,145622,145636,145647,145663,145680,145701,145710,145725,145726,145747,145758,145759,145760,145761,145762,145763,145776,145777,145778,145779,145780,145796,145846,145854,145855,145858,145977,145982,145986,146001,146013,146036,146048,146119,146133,146134,146136,146141,146171,146210,146223,146234,146324,146325,146326,146327,146328,146329,146330,146385,146389,146394,146402,146403,146428,146443,146457,146477,146530,146531,146532,146670,146672,146692,146723,146733,146739,146750,146753,146762,146773,146795,146798,146805,146808,146897,146905,146906,146939,146943,146959,146982,147039,147042,147045,147097,147108,147174,147175,147219,147226,147227,147235,147262,147265,147335,147341,147356,147376,147386,147481,147488,147489,147544,147548,147596,147606,147615,147619,147625,147648,147687,147698,147706,147711,147726,147730,147738,147739,147751,147752,147787,147788,147789,147815,147826,147853,147865,147873,147874,147875,147876,147883,147884,147895,147911,147926,147932,147970,147991,148017,148067,148077,148093,148104,148106,148107,148131,148169,148183,148187,148188,148255,148261,148262,148269,148271,148297,148318,148337,148339,148377,148385,148392,148405,148433,148438,148451,148461,148484,148493,148523,148525,148545,148555,148560,148626,148661,148745,148750,148761,148764,148767,148769,148770,148775,148811,148859,148891,148906,148922,148927,148948,148958,148965,148971,148972,149052,149137,149157,149205,149220,149251,149258,149259,149320,149330,149331,149332,149341,149352,149401,149504,149512,149539,149540,149609,149610,149612,149636,149650,149701,149710,149711,149741,149761,149767,149776,149782,149815,149933,149970,149971,149982,150226,150231,150256,150320,150483,150580,150605,150608,150609,150611,150613,150703,150763,150781,150825,150912,150922,150937,150959,150992,151041,151069,151096,151105,151129,151184,151213,151237,151239,151342,151421,151687,151705,151757,151792,151818,151845,151858,151876,151879,151893,151906,151922,151925,152024,152061,152062,152091,152092,152093,152122,152142,152203,152346,152436,152544,152874,152876,152966,153069,153137,153164,153175,153180,153184,153286,153315,153344,153395,153414,153419,153423,153426,153432,153510,153531,153532,153533,153538,153558,153559,153562,153573,153612,153621,153654,153656,153773,153859,153868,153873,153874,153877,153897,153928,153947,153950,153951,153953,153960,153961,153997,154000,154007,154021,154025,154026,154059,154073,154095,154131,154219,154224,154247,154254,154257,154261,154318,154346,154354,154358,154372,154385,154508,154511,154535,154571,154572,154593,154608,154633,154635,154636,154647,154676,154682,154745,154757,154774,154776,154782,154861,155001,155002,155003,155057,155069,155070,155076,155078,155080,155084,155087,155111,155146,155147,155153,155241,155278,155421,155422,155452,155515,155522,155527,155596,155621,155633,155756,156152,156184,156201,156214,156255,156272,156273,156274,156385,156400,156478,156538,156581,156700,156751,156767,156772,156884,156900,157025,157131,157152,157169,157194,157291,157292,157293,157294,157295,157296,157297,157305,157306,157307,157308,157309,157310,157311,157312,157313,157367,157372,157373,157374,157427,157489,157502,157505,157510,157512,157596,157597,157626,157637,157638,157641,157669,157685,157689,157743,157802,157803,157830,157845,157881,157895,157953,157999,158043,158045,158046,158145,158178,158181,158195,158225,158259,158289,158316,158341,158440,158453,158459,158499,158542,158543,158558,158590,158593,158594,158653,158842,158843,158844,158849,158850,158856,158883,158897,158898,158900,158986,159008,159017,159036,159056,159058,159207,159208,159257,159375,159402,159425,159426,159482,159511,159591,159599,159623,159648,159649,159655,159874,159904,159955,160024,160032,160151,160169,160213,160247,160279,160283,160296,160354,160375,160385,160447,160480,160623,160626,160627,160628,160645,160650,160654,160833,161034,161401,161540,161808,161959,162050,162056,162076,162113,162218,162242,162266,162273,162285,162336,162358,162381,162402,162482,162510,162682,162707,162716,162738,162758,162806,162877,162899,162900,162934,162992,162993,163120,163185,163254,163327,163454,163486,163630,163667,163686,163691,163722,163757,163845,163846,163860,163877,163902,163995,164004,164068,164095,164103,164296,164331,164338,164387,164391,164488,164558,164581,164593,164622,164681,164701,164702,164715,164729,164735,164784,164835,164839,164916,164959,164962,165009,165103,165151,165205,165206,165248,165258,165259,165261,165273,165279,165309,165317,165386,165614,165625,165667,165686,165687,165721,165740,165801,165822,165823,165863,165877,165932,165949,165960,165963,165964,165965,166086,166087,166088,166089,166213,166223,166387,166395,166415,166442,166443,166459,166469,166470,166477,166478,166539,166540,166546,166555,166602,166615,166623,166660,166661,166662,166663,166690,166757,166769,166770,166771,166793,166794,166795,166821,166828,166856,166897,166901,166948,166975,166978,167038,167067,167120,167128,167159,167191,167194,167197,167203,167204,167206,167209,167242,167423,167425,167447,167491,167505,167531,167534,167552,167556,167562,167563,167630,167781,167816,167821,167833,167834,167850,167859,167922,167958,167959,168051,168058,168095,168139,168146,168160,168161,168174,168176,168250,168253,168258,168299,168307,168308,168311,168320,168329,168431,168479,168500,168505,168510,168576,168590,168594,168619,168622,168638,168640,168658,168671,168701,168710,168728,168729,168730,168743,168783,168787,168807,168817,168838,168849,168851,168888,168889,168890,168931,168985,168995,169019,169020,169021,169022,169048,169107,169119,169161,169175,169185,169193,169225,169241,169303,169306,169318,169326,169336,169344,169402,169414,169441,169470,169486,169528,169530,169542,169545,169586,169775,169850,169862,169886,169896,169960,169988,169998,170018,170112,170113,170142,170156,170224,170250,170275,170337,170338,170350,170381,170386,170396,170416,170442,170456,170495,170515,170525,170526,170551,170553,170662,170687,170688,170689,170724,170750,170751,170769,170771,170836,170837,170858,170884,170904,170906,170929,170937,170970,170985,170989,171007,171065,171081,171090,171104,171105,171136,171178,171192,171203,171216,171237,171253,171254,171260,171268,171269,171277,171326,171366,171415,171437,171452,171480,171571,171572,171669,171708,171709,171733,171751,171753,171769,171770,171771,171886,171888,171904,171906,172032,172060,172107,172114,172115,172156,172161,172164,172166,172172,172173,172184,172198,172199,172200,172201,172265,172293,172324,172346,172356,172402,172406,172407,172418,172445,172474,172533,172552,172563,172582,172584,172619,172626,172628,172648,172649,172657,172658,172680,172683,172687,172722,172725,172859,172924,172955,172974,172993,173079,173135,173140,173154,173220,173227,173244,173260,173269,173270,173301,173308,173313,173321,173348,173408,173415,173422,173464,173571,173638,173639,173640,173651,173676,173713,173727,173748,173774,173848,173882,173904,173925,173942,173950,173966,173978,173987,173990,173999,174046,174049,174123,174131,174149,174153,174154,174198,174259,174304,174353,174389,174415,174423,174442,174476,174541,174605,174755,174774,174791,174845,174848,174857,174859,174905,174982,174991,175005,175012,175028,175051,175067,175074,175080,175132,175171,175183,175231,175238,175295,175303,175305,175320,175371,175444,175447,175524,175650,175651,175660,175677,175681,175713,175728,175729,175730,175731,175813,175832,175850,175893,175895,175898,175908,175991,176004,176025,176090,176093,176095,176111,176117,176118,176119,176179,176187,176199,176221,176237,176268,176283,176291,176292,176329,176345,176353,176396,176402,176469,176478,176535,176536,176564,176587,176606,176628,176758,176773,176817,176836,176845,176888,176899,176917,176934,176994,176998,177000,177034,177036,177178,177188,177221,177229,177293,177295,177303,177313,177386,177409,177425,177453,177482,177494,177519,177565,177568,177569,177577,177623,177661,177667,177681,177697,177700,177769,177825,177833,177857,177863,177885,177902,177933,177959,177969,177970,178011,178016,178067,178094,178103,178118,178122,178125,178142,178237,178292,178349,178400,178409,178463,178466,178473,178482,178502,178534,178565,178578,178579,178612,178667,178668,178830,178842,179014,179096,179156,179159,179160,179167,179173,179210,179291,179318,179408,179418,179419,179426,179540,179554,179612,179657,179702,179726,179736,179801,179825,179869,179940,179947,179948,179978,179995,179999,180028,180051,180056,180088,180095,180141,180151,180236,180244,180260,180278,180289,180380,180531,180544,180562,180585,180693,180711,180716,180733,180734,180742,180745,180751,180752,180754,180762,180773,180785,180865,180885,180907,180921,180974,180988,181041,181054,181071,181145,181156,181163,181177,181230,181241,181312,181337,181346,181396,181417,181429,181433,181511,181586,181590,181596,181617,181643,181674,181675,181677,181688,181706,181841,181844,181848,181872,181876,181886,181917,181945,181986,182023,182027,182060,182088,182090,182146,182203,182221,182234,182256,182306,182444,182462,182531,182603,182706,182828,182921,182947,182963,182987,183037,183061,183066,183128,183148,183171,183223,183224,183238,183244,183280,183291,183319,183324,183331,183424,183454,183455,183483,183530,183647,183677,183680,183730,183731,183771,183789,183836,183848,183877,183920,183932,184030,184067,184196,184201,184221,184250,184290,184293,184336,184359,184427,184436,184498,184519,184539,184544,184608,184610,184620,184627,184661,184670,184671,184688,184702,184710,184736,184757,184758,184759,184769,184782,184787,184788,184815,184829,184831,184849,184864,184865,184867,184868,184908,184958,184988,185003,185004,185046,185051,185054,185135,185155,185247,185249,185252,185275,185312,185313,185322,185430,185434,185439,185443,185460,185532,185535,185605,185608,185623,185650,185690,185758,185770,185816,185838,185891,185932,185947,185966,185985,185986,186031,186053,186075,186140,186143,186145,186146,186235,186257,186284,186285,186288,186345,186351,186368,186385,186427,186478,186485,186503,186539,186596,186608,186732,186742,186749,186750,186768,186782,186786,186796,186900,186921,186952,186977,186978,187048,187056,187070,187072,187076,187099,187100,187124,187133,187138,187200,187279,187321,187322,187329,187334,187343,187356,187414,187424,187509,187544,187607,187608,187671,187701,187848,187868,187912,187920,187968,187974,187978,187986,188009,188023,188063,188075,188117,188121,188178,188260,188290,188292,188309,188325,188344,188347,188358,188408,188469,188472,188515,188517,188519,188567,188590,188652,188653,188657,188666,188714,188727,188737,188738,188751,188775,188793,188801,188809,188972,188984,189004,189047,189063,189082,189083,189136,189158,189278,189330,189337,189342,189428,189441,189465,189549,189608,189609,189616,189619,189629,189668,189745,189751,189922,189966,190027,190028,190101,190104,190107,190111,190154,190197,190260,190298,190306,190348,190352,190388,190716,190718,190723,190730,190819,190848,190957,190979,190981,190987,190994,190997,191007,191014,191156,191236,191317,191338,191372,191423,191461,191488,191560,191566,191578,191610,191619,191656,191673,191675,191681,191701,191729,191814,191871,191872,191943,191944,192003,192008,192026,192082,192091,192151,192156,192206,192231,192249,192274,192276,192277,192301,192330,192344,192353,192424,192436,192457,192473,192495,192502,192566,192582,192584,192632,192669,192688,192743,192744,192770,192782,192794,192851,192884,192894,192904,192913,192914,192986,193048,193053,193124,193130,193205,193216,193220,193235,193252,193349,193407,193467,193472,193522,193551,193602,193609,193652,193661,193785,193868,193874,193885,193912,193913,193918,193929,193981,193990,193992,194103,194150,194151,194256,194378,194406,194473,194474,194665,194733,194734,194735,194786,194787,194842,194938,194942,195254,195362,195368,195389,195507,195566,195570,195727,195780,195785,195845,195858,195956,195971,195979,196066,196088,196214,196235,196259,196260,196338,196372,196388,196561,196787,196818,196891,197149,197150,197174,197276,197280,197380,197783,198802,198933,199527,199597) 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(): [1048.78 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(): [0.55 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199756 |
| 108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 109 | Creole | executeQuery(): [0.51 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199736 |
| 110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 111 | Creole | executeQuery(): [0.72 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199686 |
| 112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 113 | Creole | executeQuery(): [3.34 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199666 |
| 114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 115 | Creole | executeQuery(): [1.86 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199626 |
| 116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 117 | Creole | executeQuery(): [2.45 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=142946 |
| 118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 119 | Creole | executeQuery(): [3.09 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=142171 |
| 120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 121 | Creole | executeQuery(): [0.40 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=142170 |
| 122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 123 | Creole | executeQuery(): [9.21 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141809 |
| 124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 125 | Creole | executeQuery(): [3.55 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141461 |
| 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 |
vars & config
logs & msgs
39
10750.0 KB
1455 ms
