| # |
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' => 'porsche', 'model' => '911', 'id' => '61147', '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(): [0.99 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_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=61147 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.91 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 (705) |
| 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(): [0.74 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=61147 |
| 38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
| 39 | Creole | executeQuery(): [0.88 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=61147 |
| 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(): [12.74 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=61147 |
| 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(): [0.82 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 (705) |
| 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(): [1.55 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=61147 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.46 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 (61147) ORDER BY carimg.ORD ASC |
| 49 | Creole | executeQuery(): [0.98 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 (61147) 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.70 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 (705) |
| 52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
| 53 | Creole | executeQuery(): [0.64 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=705 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(): [1.35 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=139 AND model.ID=1587 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) ) AS count |
| 58 | Creole | executeQuery(): [11.14 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) ) 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 60 | Creole | executeQuery(): [24.57 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 != 61147 AND car.ID_MODEL = '1587' ) 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 != 61147 AND car.ID_MODEL = '1587' ) 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 (199768,199661,199659,199615,199573) ORDER BY carimg.ORD ASC |
| 62 | Creole | executeQuery(): [0.98 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 (199768,199661,199659,199615,199573) 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) ) AS count |
| 65 | Creole | executeQuery(): [1.38 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 67 | Creole | executeQuery(): [1.29 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 != '61147' AND car.ID_NETTI_USER = '705' ) 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 (65620,64723,61149,61148,61146) ORDER BY carimg.ORD ASC |
| 69 | Creole | executeQuery(): [0.74 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (65620,64723,61149,61148,61146) 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(): [6.83 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=139 AND car.ID_MODEL=1587 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(): [51.86 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=139 AND sold_car.ID_MODEL=1587 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 (23233,27698,27699,28267,28268,28936,29367,29467,29469,29473,29474,30599,31435,35372,35375,37106,38924,39594,42613,45626,46458,48155,48156,49723,52596,59614,61147,66744,66905,75256,75858,84652,85633,90916,91185,91186,96059,100851,101170,102166,105027,106149,114095,114430,116734,116744,117406,117781,118715,120035,120078,122319,122695,126754,129449,129462,129589,129637,129642,129646,129702,129823,129827,129955,130004,130048,130049,130177,130206,130585,130602,130802,131161,131189,131244,131547,131584,131608,131769,131777,131861,131863,131926,132172,132578,132918,133313,133924,134795,134797,134798,134799,134800,134801,134953,134954,135121,135216,135428,135429,135601,135746,135821,135897,136086,136321,136495,136499,136522,136695,136801,136835,137159,137165,137538,137539,137567,138392,139106,140342,140824,140898,140909,141144,141169,141656,141810,141862,142273,142283,142426,142607,142608,142719,142829,142879,143059,144517,145114,145147,147536,150189,150190,150385,150457,152111,152382,153011,153013,153019,153738,155231,156042,156047,156053,156740,157056,157156,158378,158538,159397,159529,161985,163618,165468,165469,168075,171855,172573,172734,175495,176085,176099,177237,177496,178174,178695,179832,180409,180614,180616,180624,180628,180630,185659,186644,187397,187404,188958,189326,191655,192834,193364,193606,193731,194433,194479,194924,194947,194979,195042,195624,195661,195781,195808,195883,196047,196143,196315,196704,196907,197102,197417,197507,197754,198205,198545,198546,198549,198550,198551,198552,198702,198717,198851,199014,199133,199225,199246,199363,199572,199573,199615,199659,199661,199768) GROUP BY cmonth ORDER BY date_create |
| 75 | Creole | executeQuery(): [4.42 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 (23233,27698,27699,28267,28268,28936,29367,29467,29469,29473,29474,30599,31435,35372,35375,37106,38924,39594,42613,45626,46458,48155,48156,49723,52596,59614,61147,66744,66905,75256,75858,84652,85633,90916,91185,91186,96059,100851,101170,102166,105027,106149,114095,114430,116734,116744,117406,117781,118715,120035,120078,122319,122695,126754,129449,129462,129589,129637,129642,129646,129702,129823,129827,129955,130004,130048,130049,130177,130206,130585,130602,130802,131161,131189,131244,131547,131584,131608,131769,131777,131861,131863,131926,132172,132578,132918,133313,133924,134795,134797,134798,134799,134800,134801,134953,134954,135121,135216,135428,135429,135601,135746,135821,135897,136086,136321,136495,136499,136522,136695,136801,136835,137159,137165,137538,137539,137567,138392,139106,140342,140824,140898,140909,141144,141169,141656,141810,141862,142273,142283,142426,142607,142608,142719,142829,142879,143059,144517,145114,145147,147536,150189,150190,150385,150457,152111,152382,153011,153013,153019,153738,155231,156042,156047,156053,156740,157056,157156,158378,158538,159397,159529,161985,163618,165468,165469,168075,171855,172573,172734,175495,176085,176099,177237,177496,178174,178695,179832,180409,180614,180616,180624,180628,180630,185659,186644,187397,187404,188958,189326,191655,192834,193364,193606,193731,194433,194479,194924,194947,194979,195042,195624,195661,195781,195808,195883,196047,196143,196315,196704,196907,197102,197417,197507,197754,198205,198545,198546,198549,198550,198551,198552,198702,198717,198851,199014,199133,199225,199246,199363,199572,199573,199615,199659,199661,199768) 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 (20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20714,20715,20716,20718,20719,20721,20776,20819,20820,20821,20869,20870,20919,20920,20921,20961,20962,20963,21026,21072,21073,21116,21175,21176,21178,21295,21364,21426,21462,21510,21647,21648,21649,21747,21748,21749,21750,21751,21752,21804,21805,21806,21807,21808,21809,21868,21869,21870,21929,21930,21931,21932,21979,21980,21981,21982,21983,21984,22031,22033,22034,22088,22125,22126,22127,22128,22178,22180,22232,22233,22234,22237,22238,22239,22277,22278,22279,22280,22281,22337,22338,22339,22340,22373,22374,22477,22479,22652,22653,23061,23290,23365,23367,23370,23431,23432,23433,23518,23519,23532,23586,23587,23588,23589,23590,23659,23660,23661,23710,23824,23825,23826,23852,23887,23888,23889,23890,23989,23990,23991,23992,24038,24132,24184,24406,24407,24416,24417,24421,24422,24423,24424,24425,24643,24644,24645,24646,24647,24648,24649,24650,24651,24652,24653,24654,24655,24656,24657,24658,24659,24660,24829,24913,24914,24915,24916,24917,24918,24942,24943,24944,24957,24964,24968,24969,24971,24982,24984,24988,24991,24992,25004,25018,25024,25029,25036,25122,25197,25199,25200,25201,25217,25218,25294,25295,25296,25297,25330,25331,25407,25408,25409,25425,25426,25427,25440,25441,25464,25487,25488,25489,25490,25505,25536,25561,25564,25565,25647,25648,25649,25708,25709,25779,25785,25786,25854,25855,25871,25890,25934,25935,25936,25950,25988,26017,26018,26105,26106,26107,26130,26138,26184,26185,26186,26202,26296,26428,26440,26446,26449,26454,26515,26516,26517,26518,26519,26520,26697,26698,26766,26871,26872,26919,26953,27010,27011,27012,27081,27098,27336,27337,27338,27339,27366,27440,27441,27442,27455,27456,27498,27567,27568,27569,27570,27571,27673,27674,27675,27683,27701,27884,27885,27886,27887,27888,27889,27905,27931,28016,28052,28053,28072,28073,28074,28205,28343,28432,28433,28434,28503,28530,28592,28805,28806,28807,28808,28878,28933,28934,28935,29017,29018,29019,29020,29171,29270,29348,29349,29353,29354,29355,29356,29357,29358,29359,29360,29361,29362,29363,29364,29366,29418,29419,29435,29457,29468,29470,29475,29476,29477,29478,29603,29614,29617,29633,29644,29645,29646,29647,29648,29670,29671,29672,29685,29686,29691,29692,29713,29714,29715,29716,29730,29732,29774,29775,29791,29792,29793,29795,29826,29827,29828,29829,29830,29831,29832,29833,29923,29935,29961,29962,29963,29964,29965,30010,30011,30014,30015,30018,30040,30041,30095,30242,30243,30244,30245,30246,30252,30253,30283,30319,30320,30321,30369,30373,30486,30487,30498,30523,30560,30561,30584,30588,30614,30615,30616,30617,30618,30619,30620,30645,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31564,31565,31720,31721,31722,31761,31762,31840,31842,31843,31844,31845,31846,31896,31897,31898,31998,32043,32044,32152,32361,32418,32420,32520,32749,32750,32821,32834,32843,32844,32858,32859,32874,32901,32940,32941,32942,32943,32966,32967,32983,32984,33031,33094,33104,33116,33117,33119,33120,33121,33149,33218,33248,33249,33250,33317,33408,33462,33464,33465,33466,33467,33468,33492,33493,33534,33544,33553,33556,33576,33577,33605,33608,33609,33611,33613,33620,33634,33765,33841,33978,33979,33980,33981,33982,33983,33984,34045,34046,34047,34048,34049,34050,34176,34179,34205,34315,34316,34317,34389,34415,34430,34481,34564,34588,34589,34810,34811,34812,34813,34962,35093,35118,35139,35154,35213,35226,35227,35277,35278,35279,35293,35312,35325,35326,35328,35333,35334,35338,35339,35371,35373,35374,35406,35410,35438,35439,35440,35583,35586,35587,35589,35590,35591,35592,35593,35594,35626,35672,35757,35768,35786,35787,35803,35808,35813,36111,36112,36132,36140,36141,36143,36203,36204,36205,36206,36233,36234,36242,36255,36256,36269,36325,36470,36472,36473,36474,36475,36476,36574,36605,36633,36642,36652,36697,36733,36753,36754,36755,36770,36771,36785,36789,36801,36809,36852,36853,36854,36855,36870,36871,36877,36971,37001,37002,37053,37068,37079,37081,37103,38699,38721,38767,38768,38790,38791,38800,38826,38842,38843,38853,38861,38862,38863,38892,38893,38901,38907,38954,39301,39397,39476,39517,39528,39530,39582,39597,39606,39607,39608,39617,39648,39656,39706,39726,39727,39728,40346,41903,41904,41919,41930,41931,41940,41971,41972,41996,41997,42003,42006,42018,42029,42352,42353,42354,42355,42376,42399,42403,42419,42420,42435,42436,42501,42532,42533,42534,42548,42549,42565,42576,42587,42600,42601,42603,42612,42615,42616,42634,42635,42676,42677,43027,43028,43029,43030,43104,43105,43126,43127,43128,43251,43281,43298,43308,43309,43310,43317,43318,43319,43333,43344,43348,43374,43786,43787,43788,43884,43939,44024,44025,44026,44027,44046,44053,44077,44078,44083,44095,44102,44109,44114,44145,44146,44147,44156,44492,44493,44521,44527,44629,44638,44639,44662,44663,44664,44665,44698,44699,44700,44702,44729,44748,44828,45080,45313,45399,45400,45542,45554,45555,45556,45565,45624,45649,45674,45708,45720,45721,45747,45753,45776,45792,45793,45794,45795,45796,46143,46144,46168,46202,46203,46209,46229,46239,46368,46397,46418,46428,46437,46438,46442,46445,46447,46459,46491,46495,46498,46753,46768,46771,46796,46901,46902,46903,46909,46910,46911,46912,46914,46915,46916,46917,46919,46920,46921,46922,46923,46924,46925,46926,46927,46928,46935,46936,46937,46938,46939,46940,46941,46942,46943,47003,47009,47010,47011,47064,47071,47072,47092,47123,47131,47143,47168,47176,47177,47178,47179,47184,47437,47454,47522,47523,47524,47525,47526,47527,47528,47529,47772,47783,47862,47891,47898,47912,47913,47914,47935,47962,47978,48213,48307,48342,48364,48365,48368,48369,48371,48389,48390,48391,48392,48393,48394,48395,48459,48473,48515,48524,48526,48557,48559,48561,48564,48567,48590,48612,48613,48622,48623,48807,48850,48853,48895,48896,48897,48984,49018,49079,49080,49082,49098,49110,49143,49144,49321,49322,49471,49487,49543,49544,49545,49546,49612,49769,49799,49815,49829,49832,49917,49930,49968,49973,49989,49990,50154,50155,50173,50207,50247,50249,50250,50251,50252,50304,50305,50343,50346,50401,50415,50427,50428,50439,50440,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50482,50483,50484,50497,50512,50515,50519,50674,50675,50762,50766,50767,50782,50810,50811,50840,50867,50876,50896,50898,50899,50921,50930,50934,50965,50970,51015,51024,51028,51055,51056,51057,51074,51080,51081,51101,51109,51119,51132,51134,51153,51154,51618,51619,51620,51621,51622,51663,51664,51928,51934,51938,51966,51994,51997,52022,52037,52044,52122,52130,52131,52132,52420,52421,52422,52423,52426,52437,52474,52483,52484,52485,52509,52524,52528,52530,52539,52550,52560,52561,52564,52582,52583,52587,52593,52612,52613,52634,52635,52636,53120,53123,53124,53125,53126,53127,53128,53166,53167,53168,53169,53170,53171,53183,53184,53285,53286,53296,53307,53308,53309,53310,53325,53329,53349,53353,53515,53516,53517,53553,53611,53612,53613,53614,53615,53616,53671,53719,53745,53753,53756,53802,53803,53804,53826,53842,53844,53861,54015,54052,54053,54054,54055,54056,54057,54058,54059,54060,54061,54109,54175,54240,54254,54255,54322,54323,54341,54389,54395,54589,54776,54810,54818,54821,54836,54838,54843,54853,55127,55148,55180,55277,55309,55319,55381,55382,55385,55390,55436,55904,56320,56321,56629,56657,57137,57149,57152,57204,57212,57213,57214,57238,57537,57538,57559,57594,57595,57805,57816,58002,58003,58045,58720,58794,58795,58832,58941,58950,58953,58978,58991,59017,59018,59037,59038,59042,59066,59378,59399,59410,59455,59456,59457,59458,59459,59528,59529,59557,59559,59569,59608,59671,59678,59679,59680,59681,59938,60030,60031,60032,60033,60034,60035,60036,60037,60038,60098,60099,60174,60175,60176,60180,60181,60189,60190,60191,60209,60233,60239,60242,60352,60353,60355,60356,60358,60359,60361,60363,60888,60890,60891,60892,60893,60894,60895,60955,60957,60962,61037,61038,61062,61069,61117,61118,61134,61136,61137,61177,61178,61179,61414,61474,61475,61476,61477,61478,61488,61489,61491,61505,61506,61571,61622,61623,61629,61654,61655,61756,61757,61758,61759,61761,61762,61815,61834,61838,61843,61846,61847,62189,62192,62229,62230,62231,62241,62260,62267,62273,62318,62325,62329,62331,62349,62354,62368,62371,62372,62380,62677,62792,62911,62912,62913,62914,62915,62916,62917,62918,62919,62920,62921,62922,62936,62969,62971,62972,62973,62981,62986,63038,63085,63087,63113,63136,63144,63157,63158,63165,63175,63212,63213,63214,63226,63732,63758,63759,63806,63808,63809,63810,63811,63812,63813,63814,63858,63876,63904,63905,63917,63945,63990,64045,64435,64487,64488,64489,64490,64492,64493,64494,64527,64528,64529,64530,64582,64586,64631,64644,64645,64650,64693,64694,64695,64696,64721,64745,65093,65198,65199,65200,65201,65202,65203,65204,65205,65272,65273,65274,65275,65276,65277,65278,65336,65337,65338,65398,65479,65550,65551,65565,65610,65614,65616,65619,65672,65673,66468,66469,66470,66472,66473,66474,66475,66476,66477,66478,66671,66701,66745,66754,66847,66848,66871,66891,66954,66955,66973,67518,67640,67742,67744,67745,67746,67747,67748,67749,67750,67751,67752,67753,67794,67795,67796,67797,67798,67799,67845,67846,67886,67891,67896,67911,67959,67960,67961,67962,67963,67964,67965,67966,67967,67981,67990,68011,68437,68463,68464,68465,68466,68467,68468,68578,68585,68586,68587,68594,68597,68598,68617,68618,68619,68625,68626,68627,68628,68644,68655,68657,68658,68659,68663,68673,68674,68683,68686,68688,68689,68753,69308,69357,69358,69359,69360,69361,69364,69365,69366,69367,69368,69369,69370,69371,69408,69409,69410,69411,69412,69437,69466,69467,69474,69483,69500,69503,69508,69521,69524,69528,69529,69586,69613,69641,70048,70082,70198,70200,70201,70202,70203,70204,70205,70206,70207,70242,70243,70244,70317,70318,70323,70367,70407,70408,70409,70474,70484,70491,70502,70510,70543,70921,70922,71032,71033,71034,71115,71121,71122,71210,71213,71217,71227,71235,71236,71237,71238,71239,71261,71267,71268,71269,71270,71861,71862,71863,71864,71865,71866,71867,71901,71902,71903,71904,71948,71953,71956,71979,71980,71981,72003,72008,72017,72029,72047,72084,72085,72086,72571,72572,72635,72636,72700,72702,72703,72705,72706,72707,72708,72727,72794,72816,72902,72903,72918,72922,72946,72956,72982,72983,73520,73523,73526,73527,73528,73529,73530,73572,73573,73574,73599,73625,73631,73641,73642,73665,73666,73690,73711,74232,74295,74296,74298,74342,74343,74356,74411,74427,74428,74444,74456,74480,74528,75055,75084,75085,75142,75216,75217,75248,75249,75250,75254,75255,75257,75258,75295,75296,75297,75298,75299,75304,75306,75321,75922,75923,75924,75942,75943,76029,76052,76067,76076,76124,76131,76147,76153,76164,76165,76638,76707,76708,76748,76749,76750,76849,76899,76934,76935,76946,76947,76949,76950,76963,76986,77436,77437,77438,77509,77510,77512,77579,77580,77581,77674,77675,77691,78346,78560,78561,78782,79703,81973,82486,82521,83011,83012,83013,83014,83015,83016,83018,83032,83048,83062,83230,83231,83233,83234,83236,83237,83238,83240,83241,83282,83296,83301,83302,83305,83306,83307,83308,83309,83310,83311,83312,83313,83314,83315,83316,83317,83318,83319,83320,83321,83322,83329,83356,83357,83358,83368,83387,83391,83436,83445,83446,83449,83458,83470,83471,83489,83549,83562,83571,83572,83573,83574,83579,83581,83582,83583,83584,83585,83600,83733,83734,83735,83736,84181,84202,84338,84340,84341,84343,84369,84513,84514,84515,84653,84654,84655,84656,84791,84834,84869,84947,84950,84989,84990,84991,84992,85045,85113,85114,85115,85116,85117,85121,85131,85132,85180,85191,85192,85207,85208,85212,85215,85216,85217,85314,85373,85374,85377,85378,85379,85380,85381,85382,85383,85384,85385,85386,85387,85388,85423,85524,85528,85541,85543,85544,85573,85574,85575,85576,85577,85578,85579,85580,85581,85582,85583,85584,85585,85586,85587,85588,85589,85591,85592,85593,85594,85595,85597,85598,85599,85600,85601,85602,85603,85604,85605,85607,85608,85609,85612,85613,85614,85615,85616,85617,85618,85619,85620,85621,85622,85623,85624,85625,85626,85627,85631,85632,85648,85794,85796,85797,85822,85833,85834,85835,85838,85931,85984,85995,85998,85999,86000,86002,86003,86004,86027,86073,86236,86237,86248,86269,86271,86272,86277,86315,86330,86376,86433,86434,86436,86630,86631,86633,86634,86635,86637,86638,86639,86640,86641,86652,86680,86681,86690,86748,86749,86794,86795,86810,86811,86812,86813,86842,86846,86847,86853,86866,86873,86876,86879,87061,87062,87064,87065,87066,87067,87068,87069,87070,87071,87101,87185,87220,87228,87268,87277,87292,87297,87316,87317,87318,87330,87382,88131,88132,88133,88134,88154,88266,88363,88364,88527,88614,88776,88777,88788,88797,88877,88912,88913,88943,88947,89098,89099,89100,89123,89124,89125,89160,89161,89162,89247,89292,89299,89300,89446,89511,89512,89528,89534,89535,89536,89609,89638,90378,90382,90383,90384,90385,90386,90387,90388,90389,90390,90391,90392,90393,90394,90395,90396,90397,90398,90399,90400,90401,90402,90426,90579,90580,90763,90774,90855,90904,90905,90906,90907,90908,90909,90910,90911,90912,90913,90945,90990,91017,91018,91053,91069,91072,91073,91083,91126,91131,91132,91143,91144,91145,91180,91182,91193,91221,91222,91223,91226,91234,91249,91253,91264,91265,91278,91290,91485,91537,91538,91539,91540,91596,91598,91609,91610,91612,91613,91614,91890,91891,91892,91894,91912,91913,91996,91997,92025,92026,92042,92043,92047,92049,92094,92096,92170,92258,92260,92309,92316,92317,92318,92410,92513,92514,92569,92570,92615,92631,92656,92657,92658,92746,92754,92839,92860,92957,92965,92988,93603,93625,93692,93694,93695,93760,93762,93763,93765,93788,93937,93956,94029,94030,94031,94167,94255,94260,94265,94279,94310,94433,94455,94522,94523,94850,95047,95048,95139,95140,95141,95142,95143,95144,95145,95146,95157,95178,95198,95199,95311,95320,95326,95335,95337,95438,95463,95488,95493,95516,95517,95530,95533,95551,95558,95578,95620,95621,95670,95782,95783,95784,95794,95815,95820,95821,95834,95961,96025,96042,96043,96044,96045,96046,96047,96048,96050,96051,96052,96053,96054,96056,96057,96135,96139,97846,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97935,97936,97937,97938,98019,98020,98042,98044,98127,98174,98175,98176,98307,98308,98309,98310,98311,98312,98313,98314,98315,98334,98335,98352,98396,98456,98690,98736,98737,98746,98747,98821,98823,98824,98905,98915,98916,98917,99009,99011,99040,99049,99140,99173,99181,99182,99183,99184,99185,99186,99187,99188,99189,99190,99191,99201,99202,99243,99310,99311,99335,99340,99431,99500,100174,100318,100354,100369,100449,100579,100686,100691,100707,100835,100836,100837,100846,100855,100866,100894,100895,101039,101060,101101,101165,101168,101284,101289,101290,101294,101296,101300,101302,101303,101304,101306,101307,101308,101311,101312,101313,101325,101362,101363,101532,101612,101614,101615,101616,101617,101618,101620,101621,101624,101625,101628,101633,101634,101702,101755,101782,101793,101803,101847,102021,102031,102242,102243,102244,102245,102246,102247,102248,102249,102250,102251,102252,102253,102275,102302,102354,102418,102442,102490,102535,102560,102561,102620,102675,102676,102690,102724,102739,102765,102948,103034,103035,103036,103037,103038,103039,103040,103074,103077,103148,103149,103196,103209,103212,103226,103229,103330,103336,103350,103460,103476,103477,103507,103508,103644,103645,103646,103647,103648,103649,103652,103653,103784,103897,103898,104108,104323,104376,104390,104393,104440,104466,104495,104934,104935,104936,104937,104938,104940,104941,104942,104943,104944,104945,104990,105022,105023,105032,105128,105146,105148,105149,105186,105210,105211,105212,105213,105214,105337,105365,105389,105390,105396,105485,105499,105537,105539,105540,105541,105555,105580,105644,105649,105656,105710,105711,105713,105719,105722,105781,105807,105880,105881,105882,105938,105939,105940,105941,105942,105943,105944,105945,105957,105958,105960,105967,105971,105987,105988,105989,105994,105997,106080,106083,106084,106085,106086,106132,106180,106197,106208,106209,106252,106253,106280,106331,106332,106335,106368,106369,106422,106464,106521,106542,106543,106545,106590,106605,106643,106645,106671,106821,106822,106823,106856,106960,106961,106962,106971,107020,107021,107022,107026,107060,107061,107070,107088,107103,107286,107287,107355,107439,107444,107462,107463,107464,107473,107495,107520,107529,107530,107547,107548,107573,107574,108194,108236,108280,108281,108282,108300,108318,108330,108354,108417,108460,108564,108592,108628,108686,108741,108784,108807,108808,108849,108869,108877,108894,108914,108915,108916,108917,108918,108919,108920,108930,108940,108946,108977,108984,108985,109072,109233,109235,109236,109237,109238,109299,109338,109339,109412,109413,109417,109422,109427,109428,109440,109441,109501,109515,109551,109556,109612,109654,109656,109867,109880,109899,110003,110025,110035,110144,110145,110157,110414,110447,110471,110473,110475,110476,110539,110547,110605,110614,110620,110633,110635,110636,110659,110675,110759,110940,110941,110942,110973,110990,111116,111117,111828,111829,111831,111833,111855,111956,112002,112252,112256,112325,112341,112342,112343,112369,112383,112412,112675,112713,112714,112750,112764,112826,112892,112899,112922,112941,113008,113020,113066,113096,113097,113098,113100,113187,113192,113232,113284,113337,113382,113435,113468,113469,113496,113625,113754,113811,113901,113923,113927,114144,114915,114956,115093,115099,115128,115130,115271,115555,115581,115582,115583,115584,115661,115676,115753,115789,115914,115915,115972,116047,116094,116113,116436,116578,116704,116763,116795,116852,116868,117238,117505,117623,117780,117792,117799,117835,117869,117940,117958,117996,118017,118018,118271,118343,118346,118541,118553,118559,118621,118675,118677,118678,118679,118680,118681,118682,118683,118684,118736,118943,119065,119076,119091,119094,119141,119186,119249,119827,119871,119998,120115,121166,121202,121558,121776,121809,121813,121826,121880,121896,121897,122006,122007,122301,122302,122468,122530,122532,122535,122552,122619,122642,122677,122696,122759,122881,122996,122997,122998,123006,123073,123102,123341,123462,123612,123650,123676,123929,124096,124248,124255,124295,125307,125398,125399,125405,125416,125417,125418,125558,125571,125576,125698,125756,125822,125940,126137,126139,126268,126728,126787,126982,127051,127150,127326,127327,127573,127713,128182,128240,128275,128348,128349,128450,128451,128452,128593,128672,128785,129463,129497,129499,129537,129624,129635,129636,129638,129643,129651,129652,129690,129756,129805,129898,129917,129936,130005,130007,130073,130187,130203,130205,130321,130336,130350,130459,130530,130584,130586,130587,130588,130680,130682,130855,130944,130945,130951,130952,130999,131001,131003,131004,131110,131211,131312,131460,131462,131507,131508,131509,131510,131511,131513,131530,131533,131583,131585,131586,131587,131703,131775,131845,131864,131941,131944,132073,132161,132200,132215,132312,132435,132451,132458,132509,132521,132631,132728,132729,132853,132872,133014,133015,133063,133064,133126,133187,133202,133322,133355,133403,133452,133477,133505,133544,133557,133581,133627,133640,133724,133748,133807,133819,133979,133983,133995,134004,134005,134098,134151,134200,134528,134794,134796,135089,135111,135115,135119,135129,135130,135143,135290,135392,135592,135636,135725,135726,135761,135762,135829,135874,135904,135955,136069,136097,136345,136346,136347,136363,136459,136708,136759,137158,137517,137518,137540,138375,138376,138789,139164,139376,139377,139475,139523,140265,140343,140480,140825,140900,141194,141250,141265,141379,141565,141566,141652,141727,141763,141916,141947,142070,142071,142086,142118,142249,142268,142349,142413,142452,142664,142696,142857,142862,143403,143406,144004,144147,144174,144340,144341,145141,145323,145378,146063,146064,146268,146270,146271,146646,146781,146868,146869,146870,147417,147683,147838,147897,148215,148584,148827,149596,149657,150242,150288,150332,150333,150365,150376,150601,150628,150815,150871,150941,150942,151032,151118,151224,151333,151391,151441,152369,152377,152506,152645,152652,152947,153023,153024,153025,153026,153042,153047,153050,153051,153052,153056,153580,154176,154485,154594,155055,155334,155605,155772,155797,155974,155976,155979,155986,155994,156038,156048,156072,156079,156085,156240,156366,156471,156532,156533,156542,156625,156626,156676,156996,156997,157015,157535,157601,157632,157806,157809,157831,157876,157896,157944,158020,158082,158089,158129,158217,158222,158233,158245,158336,158343,158522,158553,158775,158965,159136,159382,159523,159613,159635,159643,159713,159768,159830,160131,160136,160287,160343,160353,160565,160891,161174,161593,162042,162082,162093,162097,162180,162318,162382,162465,162536,162726,162826,162903,162936,163067,163090,163208,163310,163431,163499,163543,163644,163771,163947,163960,163974,164035,164056,164312,164528,164623,164689,164816,164881,164886,164888,165018,165030,165078,165127,165241,165332,165346,165511,165707,165755,165756,165760,165772,165798,165811,165852,165891,165937,165978,166102,166414,166513,166729,166842,166989,166990,167566,167810,168123,168127,168293,168518,168599,168668,168857,168867,169073,169082,169156,169183,169448,169455,169550,169579,169675,169680,169685,169833,169940,169955,169978,170161,170209,170215,170245,170309,170493,170507,170545,170683,170766,170938,170954,171166,171267,171404,171428,171469,171549,171552,171594,171598,171599,171622,172142,172179,172395,172581,172717,172719,172749,173011,173024,173359,173396,173400,173401,173416,173508,173560,173786,173791,173807,173837,173922,173937,173948,174018,174594,174718,174904,174915,175165,175179,175357,175378,175469,175586,175601,175602,175611,175826,175846,175876,175962,176091,176103,176138,176263,176366,176456,176569,176572,176698,176897,176911,176912,176922,176975,176989,176995,177094,177193,177194,177195,177232,177258,177342,177485,177767,177932,177966,178082,178189,178194,178318,178432,178558,178646,178659,178780,178912,178926,178954,178955,179125,179193,179324,179422,179849,179853,180045,180053,180060,180198,180234,180336,180514,180515,180852,181713,181925,182002,182342,182917,183378,183398,183404,183748,183751,183752,183908,183962,183963,183964,183965,183966,184020,184170,184275,184417,184501,184642,184656,184667,184803,184936,185087,185113,185160,185168,185207,185519,185571,185572,185654,185720,185833,186036,186348,186411,186412,186468,186592,186599,186679,186759,186760,186761,186762,186912,186964,187400,187401,187409,187841,187973,188043,188099,188183,188261,188307,188399,188449,188529,188700,188885,188910,189134,189260,189437,189438,189643,189681,189682,189848,189967,190323,190589,190590,190976,191053,191056,191170,191237,191240,191503,191769,192145,192392,192488,192534,192552,192567,193218,193329,193330,193698,193826,193927,193973,194064,194290,194948,195039,195040,195041,195044,195130,195249,195363,195478,195528,195662,195851,195880,195987,196098,196275,196355,196361,196538,196808,197342,197348,197353,197412,197721,197836,198548,199186) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 77 | Creole | executeQuery(): [21.02 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 (20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20714,20715,20716,20718,20719,20721,20776,20819,20820,20821,20869,20870,20919,20920,20921,20961,20962,20963,21026,21072,21073,21116,21175,21176,21178,21295,21364,21426,21462,21510,21647,21648,21649,21747,21748,21749,21750,21751,21752,21804,21805,21806,21807,21808,21809,21868,21869,21870,21929,21930,21931,21932,21979,21980,21981,21982,21983,21984,22031,22033,22034,22088,22125,22126,22127,22128,22178,22180,22232,22233,22234,22237,22238,22239,22277,22278,22279,22280,22281,22337,22338,22339,22340,22373,22374,22477,22479,22652,22653,23061,23290,23365,23367,23370,23431,23432,23433,23518,23519,23532,23586,23587,23588,23589,23590,23659,23660,23661,23710,23824,23825,23826,23852,23887,23888,23889,23890,23989,23990,23991,23992,24038,24132,24184,24406,24407,24416,24417,24421,24422,24423,24424,24425,24643,24644,24645,24646,24647,24648,24649,24650,24651,24652,24653,24654,24655,24656,24657,24658,24659,24660,24829,24913,24914,24915,24916,24917,24918,24942,24943,24944,24957,24964,24968,24969,24971,24982,24984,24988,24991,24992,25004,25018,25024,25029,25036,25122,25197,25199,25200,25201,25217,25218,25294,25295,25296,25297,25330,25331,25407,25408,25409,25425,25426,25427,25440,25441,25464,25487,25488,25489,25490,25505,25536,25561,25564,25565,25647,25648,25649,25708,25709,25779,25785,25786,25854,25855,25871,25890,25934,25935,25936,25950,25988,26017,26018,26105,26106,26107,26130,26138,26184,26185,26186,26202,26296,26428,26440,26446,26449,26454,26515,26516,26517,26518,26519,26520,26697,26698,26766,26871,26872,26919,26953,27010,27011,27012,27081,27098,27336,27337,27338,27339,27366,27440,27441,27442,27455,27456,27498,27567,27568,27569,27570,27571,27673,27674,27675,27683,27701,27884,27885,27886,27887,27888,27889,27905,27931,28016,28052,28053,28072,28073,28074,28205,28343,28432,28433,28434,28503,28530,28592,28805,28806,28807,28808,28878,28933,28934,28935,29017,29018,29019,29020,29171,29270,29348,29349,29353,29354,29355,29356,29357,29358,29359,29360,29361,29362,29363,29364,29366,29418,29419,29435,29457,29468,29470,29475,29476,29477,29478,29603,29614,29617,29633,29644,29645,29646,29647,29648,29670,29671,29672,29685,29686,29691,29692,29713,29714,29715,29716,29730,29732,29774,29775,29791,29792,29793,29795,29826,29827,29828,29829,29830,29831,29832,29833,29923,29935,29961,29962,29963,29964,29965,30010,30011,30014,30015,30018,30040,30041,30095,30242,30243,30244,30245,30246,30252,30253,30283,30319,30320,30321,30369,30373,30486,30487,30498,30523,30560,30561,30584,30588,30614,30615,30616,30617,30618,30619,30620,30645,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31564,31565,31720,31721,31722,31761,31762,31840,31842,31843,31844,31845,31846,31896,31897,31898,31998,32043,32044,32152,32361,32418,32420,32520,32749,32750,32821,32834,32843,32844,32858,32859,32874,32901,32940,32941,32942,32943,32966,32967,32983,32984,33031,33094,33104,33116,33117,33119,33120,33121,33149,33218,33248,33249,33250,33317,33408,33462,33464,33465,33466,33467,33468,33492,33493,33534,33544,33553,33556,33576,33577,33605,33608,33609,33611,33613,33620,33634,33765,33841,33978,33979,33980,33981,33982,33983,33984,34045,34046,34047,34048,34049,34050,34176,34179,34205,34315,34316,34317,34389,34415,34430,34481,34564,34588,34589,34810,34811,34812,34813,34962,35093,35118,35139,35154,35213,35226,35227,35277,35278,35279,35293,35312,35325,35326,35328,35333,35334,35338,35339,35371,35373,35374,35406,35410,35438,35439,35440,35583,35586,35587,35589,35590,35591,35592,35593,35594,35626,35672,35757,35768,35786,35787,35803,35808,35813,36111,36112,36132,36140,36141,36143,36203,36204,36205,36206,36233,36234,36242,36255,36256,36269,36325,36470,36472,36473,36474,36475,36476,36574,36605,36633,36642,36652,36697,36733,36753,36754,36755,36770,36771,36785,36789,36801,36809,36852,36853,36854,36855,36870,36871,36877,36971,37001,37002,37053,37068,37079,37081,37103,38699,38721,38767,38768,38790,38791,38800,38826,38842,38843,38853,38861,38862,38863,38892,38893,38901,38907,38954,39301,39397,39476,39517,39528,39530,39582,39597,39606,39607,39608,39617,39648,39656,39706,39726,39727,39728,40346,41903,41904,41919,41930,41931,41940,41971,41972,41996,41997,42003,42006,42018,42029,42352,42353,42354,42355,42376,42399,42403,42419,42420,42435,42436,42501,42532,42533,42534,42548,42549,42565,42576,42587,42600,42601,42603,42612,42615,42616,42634,42635,42676,42677,43027,43028,43029,43030,43104,43105,43126,43127,43128,43251,43281,43298,43308,43309,43310,43317,43318,43319,43333,43344,43348,43374,43786,43787,43788,43884,43939,44024,44025,44026,44027,44046,44053,44077,44078,44083,44095,44102,44109,44114,44145,44146,44147,44156,44492,44493,44521,44527,44629,44638,44639,44662,44663,44664,44665,44698,44699,44700,44702,44729,44748,44828,45080,45313,45399,45400,45542,45554,45555,45556,45565,45624,45649,45674,45708,45720,45721,45747,45753,45776,45792,45793,45794,45795,45796,46143,46144,46168,46202,46203,46209,46229,46239,46368,46397,46418,46428,46437,46438,46442,46445,46447,46459,46491,46495,46498,46753,46768,46771,46796,46901,46902,46903,46909,46910,46911,46912,46914,46915,46916,46917,46919,46920,46921,46922,46923,46924,46925,46926,46927,46928,46935,46936,46937,46938,46939,46940,46941,46942,46943,47003,47009,47010,47011,47064,47071,47072,47092,47123,47131,47143,47168,47176,47177,47178,47179,47184,47437,47454,47522,47523,47524,47525,47526,47527,47528,47529,47772,47783,47862,47891,47898,47912,47913,47914,47935,47962,47978,48213,48307,48342,48364,48365,48368,48369,48371,48389,48390,48391,48392,48393,48394,48395,48459,48473,48515,48524,48526,48557,48559,48561,48564,48567,48590,48612,48613,48622,48623,48807,48850,48853,48895,48896,48897,48984,49018,49079,49080,49082,49098,49110,49143,49144,49321,49322,49471,49487,49543,49544,49545,49546,49612,49769,49799,49815,49829,49832,49917,49930,49968,49973,49989,49990,50154,50155,50173,50207,50247,50249,50250,50251,50252,50304,50305,50343,50346,50401,50415,50427,50428,50439,50440,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50482,50483,50484,50497,50512,50515,50519,50674,50675,50762,50766,50767,50782,50810,50811,50840,50867,50876,50896,50898,50899,50921,50930,50934,50965,50970,51015,51024,51028,51055,51056,51057,51074,51080,51081,51101,51109,51119,51132,51134,51153,51154,51618,51619,51620,51621,51622,51663,51664,51928,51934,51938,51966,51994,51997,52022,52037,52044,52122,52130,52131,52132,52420,52421,52422,52423,52426,52437,52474,52483,52484,52485,52509,52524,52528,52530,52539,52550,52560,52561,52564,52582,52583,52587,52593,52612,52613,52634,52635,52636,53120,53123,53124,53125,53126,53127,53128,53166,53167,53168,53169,53170,53171,53183,53184,53285,53286,53296,53307,53308,53309,53310,53325,53329,53349,53353,53515,53516,53517,53553,53611,53612,53613,53614,53615,53616,53671,53719,53745,53753,53756,53802,53803,53804,53826,53842,53844,53861,54015,54052,54053,54054,54055,54056,54057,54058,54059,54060,54061,54109,54175,54240,54254,54255,54322,54323,54341,54389,54395,54589,54776,54810,54818,54821,54836,54838,54843,54853,55127,55148,55180,55277,55309,55319,55381,55382,55385,55390,55436,55904,56320,56321,56629,56657,57137,57149,57152,57204,57212,57213,57214,57238,57537,57538,57559,57594,57595,57805,57816,58002,58003,58045,58720,58794,58795,58832,58941,58950,58953,58978,58991,59017,59018,59037,59038,59042,59066,59378,59399,59410,59455,59456,59457,59458,59459,59528,59529,59557,59559,59569,59608,59671,59678,59679,59680,59681,59938,60030,60031,60032,60033,60034,60035,60036,60037,60038,60098,60099,60174,60175,60176,60180,60181,60189,60190,60191,60209,60233,60239,60242,60352,60353,60355,60356,60358,60359,60361,60363,60888,60890,60891,60892,60893,60894,60895,60955,60957,60962,61037,61038,61062,61069,61117,61118,61134,61136,61137,61177,61178,61179,61414,61474,61475,61476,61477,61478,61488,61489,61491,61505,61506,61571,61622,61623,61629,61654,61655,61756,61757,61758,61759,61761,61762,61815,61834,61838,61843,61846,61847,62189,62192,62229,62230,62231,62241,62260,62267,62273,62318,62325,62329,62331,62349,62354,62368,62371,62372,62380,62677,62792,62911,62912,62913,62914,62915,62916,62917,62918,62919,62920,62921,62922,62936,62969,62971,62972,62973,62981,62986,63038,63085,63087,63113,63136,63144,63157,63158,63165,63175,63212,63213,63214,63226,63732,63758,63759,63806,63808,63809,63810,63811,63812,63813,63814,63858,63876,63904,63905,63917,63945,63990,64045,64435,64487,64488,64489,64490,64492,64493,64494,64527,64528,64529,64530,64582,64586,64631,64644,64645,64650,64693,64694,64695,64696,64721,64745,65093,65198,65199,65200,65201,65202,65203,65204,65205,65272,65273,65274,65275,65276,65277,65278,65336,65337,65338,65398,65479,65550,65551,65565,65610,65614,65616,65619,65672,65673,66468,66469,66470,66472,66473,66474,66475,66476,66477,66478,66671,66701,66745,66754,66847,66848,66871,66891,66954,66955,66973,67518,67640,67742,67744,67745,67746,67747,67748,67749,67750,67751,67752,67753,67794,67795,67796,67797,67798,67799,67845,67846,67886,67891,67896,67911,67959,67960,67961,67962,67963,67964,67965,67966,67967,67981,67990,68011,68437,68463,68464,68465,68466,68467,68468,68578,68585,68586,68587,68594,68597,68598,68617,68618,68619,68625,68626,68627,68628,68644,68655,68657,68658,68659,68663,68673,68674,68683,68686,68688,68689,68753,69308,69357,69358,69359,69360,69361,69364,69365,69366,69367,69368,69369,69370,69371,69408,69409,69410,69411,69412,69437,69466,69467,69474,69483,69500,69503,69508,69521,69524,69528,69529,69586,69613,69641,70048,70082,70198,70200,70201,70202,70203,70204,70205,70206,70207,70242,70243,70244,70317,70318,70323,70367,70407,70408,70409,70474,70484,70491,70502,70510,70543,70921,70922,71032,71033,71034,71115,71121,71122,71210,71213,71217,71227,71235,71236,71237,71238,71239,71261,71267,71268,71269,71270,71861,71862,71863,71864,71865,71866,71867,71901,71902,71903,71904,71948,71953,71956,71979,71980,71981,72003,72008,72017,72029,72047,72084,72085,72086,72571,72572,72635,72636,72700,72702,72703,72705,72706,72707,72708,72727,72794,72816,72902,72903,72918,72922,72946,72956,72982,72983,73520,73523,73526,73527,73528,73529,73530,73572,73573,73574,73599,73625,73631,73641,73642,73665,73666,73690,73711,74232,74295,74296,74298,74342,74343,74356,74411,74427,74428,74444,74456,74480,74528,75055,75084,75085,75142,75216,75217,75248,75249,75250,75254,75255,75257,75258,75295,75296,75297,75298,75299,75304,75306,75321,75922,75923,75924,75942,75943,76029,76052,76067,76076,76124,76131,76147,76153,76164,76165,76638,76707,76708,76748,76749,76750,76849,76899,76934,76935,76946,76947,76949,76950,76963,76986,77436,77437,77438,77509,77510,77512,77579,77580,77581,77674,77675,77691,78346,78560,78561,78782,79703,81973,82486,82521,83011,83012,83013,83014,83015,83016,83018,83032,83048,83062,83230,83231,83233,83234,83236,83237,83238,83240,83241,83282,83296,83301,83302,83305,83306,83307,83308,83309,83310,83311,83312,83313,83314,83315,83316,83317,83318,83319,83320,83321,83322,83329,83356,83357,83358,83368,83387,83391,83436,83445,83446,83449,83458,83470,83471,83489,83549,83562,83571,83572,83573,83574,83579,83581,83582,83583,83584,83585,83600,83733,83734,83735,83736,84181,84202,84338,84340,84341,84343,84369,84513,84514,84515,84653,84654,84655,84656,84791,84834,84869,84947,84950,84989,84990,84991,84992,85045,85113,85114,85115,85116,85117,85121,85131,85132,85180,85191,85192,85207,85208,85212,85215,85216,85217,85314,85373,85374,85377,85378,85379,85380,85381,85382,85383,85384,85385,85386,85387,85388,85423,85524,85528,85541,85543,85544,85573,85574,85575,85576,85577,85578,85579,85580,85581,85582,85583,85584,85585,85586,85587,85588,85589,85591,85592,85593,85594,85595,85597,85598,85599,85600,85601,85602,85603,85604,85605,85607,85608,85609,85612,85613,85614,85615,85616,85617,85618,85619,85620,85621,85622,85623,85624,85625,85626,85627,85631,85632,85648,85794,85796,85797,85822,85833,85834,85835,85838,85931,85984,85995,85998,85999,86000,86002,86003,86004,86027,86073,86236,86237,86248,86269,86271,86272,86277,86315,86330,86376,86433,86434,86436,86630,86631,86633,86634,86635,86637,86638,86639,86640,86641,86652,86680,86681,86690,86748,86749,86794,86795,86810,86811,86812,86813,86842,86846,86847,86853,86866,86873,86876,86879,87061,87062,87064,87065,87066,87067,87068,87069,87070,87071,87101,87185,87220,87228,87268,87277,87292,87297,87316,87317,87318,87330,87382,88131,88132,88133,88134,88154,88266,88363,88364,88527,88614,88776,88777,88788,88797,88877,88912,88913,88943,88947,89098,89099,89100,89123,89124,89125,89160,89161,89162,89247,89292,89299,89300,89446,89511,89512,89528,89534,89535,89536,89609,89638,90378,90382,90383,90384,90385,90386,90387,90388,90389,90390,90391,90392,90393,90394,90395,90396,90397,90398,90399,90400,90401,90402,90426,90579,90580,90763,90774,90855,90904,90905,90906,90907,90908,90909,90910,90911,90912,90913,90945,90990,91017,91018,91053,91069,91072,91073,91083,91126,91131,91132,91143,91144,91145,91180,91182,91193,91221,91222,91223,91226,91234,91249,91253,91264,91265,91278,91290,91485,91537,91538,91539,91540,91596,91598,91609,91610,91612,91613,91614,91890,91891,91892,91894,91912,91913,91996,91997,92025,92026,92042,92043,92047,92049,92094,92096,92170,92258,92260,92309,92316,92317,92318,92410,92513,92514,92569,92570,92615,92631,92656,92657,92658,92746,92754,92839,92860,92957,92965,92988,93603,93625,93692,93694,93695,93760,93762,93763,93765,93788,93937,93956,94029,94030,94031,94167,94255,94260,94265,94279,94310,94433,94455,94522,94523,94850,95047,95048,95139,95140,95141,95142,95143,95144,95145,95146,95157,95178,95198,95199,95311,95320,95326,95335,95337,95438,95463,95488,95493,95516,95517,95530,95533,95551,95558,95578,95620,95621,95670,95782,95783,95784,95794,95815,95820,95821,95834,95961,96025,96042,96043,96044,96045,96046,96047,96048,96050,96051,96052,96053,96054,96056,96057,96135,96139,97846,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97935,97936,97937,97938,98019,98020,98042,98044,98127,98174,98175,98176,98307,98308,98309,98310,98311,98312,98313,98314,98315,98334,98335,98352,98396,98456,98690,98736,98737,98746,98747,98821,98823,98824,98905,98915,98916,98917,99009,99011,99040,99049,99140,99173,99181,99182,99183,99184,99185,99186,99187,99188,99189,99190,99191,99201,99202,99243,99310,99311,99335,99340,99431,99500,100174,100318,100354,100369,100449,100579,100686,100691,100707,100835,100836,100837,100846,100855,100866,100894,100895,101039,101060,101101,101165,101168,101284,101289,101290,101294,101296,101300,101302,101303,101304,101306,101307,101308,101311,101312,101313,101325,101362,101363,101532,101612,101614,101615,101616,101617,101618,101620,101621,101624,101625,101628,101633,101634,101702,101755,101782,101793,101803,101847,102021,102031,102242,102243,102244,102245,102246,102247,102248,102249,102250,102251,102252,102253,102275,102302,102354,102418,102442,102490,102535,102560,102561,102620,102675,102676,102690,102724,102739,102765,102948,103034,103035,103036,103037,103038,103039,103040,103074,103077,103148,103149,103196,103209,103212,103226,103229,103330,103336,103350,103460,103476,103477,103507,103508,103644,103645,103646,103647,103648,103649,103652,103653,103784,103897,103898,104108,104323,104376,104390,104393,104440,104466,104495,104934,104935,104936,104937,104938,104940,104941,104942,104943,104944,104945,104990,105022,105023,105032,105128,105146,105148,105149,105186,105210,105211,105212,105213,105214,105337,105365,105389,105390,105396,105485,105499,105537,105539,105540,105541,105555,105580,105644,105649,105656,105710,105711,105713,105719,105722,105781,105807,105880,105881,105882,105938,105939,105940,105941,105942,105943,105944,105945,105957,105958,105960,105967,105971,105987,105988,105989,105994,105997,106080,106083,106084,106085,106086,106132,106180,106197,106208,106209,106252,106253,106280,106331,106332,106335,106368,106369,106422,106464,106521,106542,106543,106545,106590,106605,106643,106645,106671,106821,106822,106823,106856,106960,106961,106962,106971,107020,107021,107022,107026,107060,107061,107070,107088,107103,107286,107287,107355,107439,107444,107462,107463,107464,107473,107495,107520,107529,107530,107547,107548,107573,107574,108194,108236,108280,108281,108282,108300,108318,108330,108354,108417,108460,108564,108592,108628,108686,108741,108784,108807,108808,108849,108869,108877,108894,108914,108915,108916,108917,108918,108919,108920,108930,108940,108946,108977,108984,108985,109072,109233,109235,109236,109237,109238,109299,109338,109339,109412,109413,109417,109422,109427,109428,109440,109441,109501,109515,109551,109556,109612,109654,109656,109867,109880,109899,110003,110025,110035,110144,110145,110157,110414,110447,110471,110473,110475,110476,110539,110547,110605,110614,110620,110633,110635,110636,110659,110675,110759,110940,110941,110942,110973,110990,111116,111117,111828,111829,111831,111833,111855,111956,112002,112252,112256,112325,112341,112342,112343,112369,112383,112412,112675,112713,112714,112750,112764,112826,112892,112899,112922,112941,113008,113020,113066,113096,113097,113098,113100,113187,113192,113232,113284,113337,113382,113435,113468,113469,113496,113625,113754,113811,113901,113923,113927,114144,114915,114956,115093,115099,115128,115130,115271,115555,115581,115582,115583,115584,115661,115676,115753,115789,115914,115915,115972,116047,116094,116113,116436,116578,116704,116763,116795,116852,116868,117238,117505,117623,117780,117792,117799,117835,117869,117940,117958,117996,118017,118018,118271,118343,118346,118541,118553,118559,118621,118675,118677,118678,118679,118680,118681,118682,118683,118684,118736,118943,119065,119076,119091,119094,119141,119186,119249,119827,119871,119998,120115,121166,121202,121558,121776,121809,121813,121826,121880,121896,121897,122006,122007,122301,122302,122468,122530,122532,122535,122552,122619,122642,122677,122696,122759,122881,122996,122997,122998,123006,123073,123102,123341,123462,123612,123650,123676,123929,124096,124248,124255,124295,125307,125398,125399,125405,125416,125417,125418,125558,125571,125576,125698,125756,125822,125940,126137,126139,126268,126728,126787,126982,127051,127150,127326,127327,127573,127713,128182,128240,128275,128348,128349,128450,128451,128452,128593,128672,128785,129463,129497,129499,129537,129624,129635,129636,129638,129643,129651,129652,129690,129756,129805,129898,129917,129936,130005,130007,130073,130187,130203,130205,130321,130336,130350,130459,130530,130584,130586,130587,130588,130680,130682,130855,130944,130945,130951,130952,130999,131001,131003,131004,131110,131211,131312,131460,131462,131507,131508,131509,131510,131511,131513,131530,131533,131583,131585,131586,131587,131703,131775,131845,131864,131941,131944,132073,132161,132200,132215,132312,132435,132451,132458,132509,132521,132631,132728,132729,132853,132872,133014,133015,133063,133064,133126,133187,133202,133322,133355,133403,133452,133477,133505,133544,133557,133581,133627,133640,133724,133748,133807,133819,133979,133983,133995,134004,134005,134098,134151,134200,134528,134794,134796,135089,135111,135115,135119,135129,135130,135143,135290,135392,135592,135636,135725,135726,135761,135762,135829,135874,135904,135955,136069,136097,136345,136346,136347,136363,136459,136708,136759,137158,137517,137518,137540,138375,138376,138789,139164,139376,139377,139475,139523,140265,140343,140480,140825,140900,141194,141250,141265,141379,141565,141566,141652,141727,141763,141916,141947,142070,142071,142086,142118,142249,142268,142349,142413,142452,142664,142696,142857,142862,143403,143406,144004,144147,144174,144340,144341,145141,145323,145378,146063,146064,146268,146270,146271,146646,146781,146868,146869,146870,147417,147683,147838,147897,148215,148584,148827,149596,149657,150242,150288,150332,150333,150365,150376,150601,150628,150815,150871,150941,150942,151032,151118,151224,151333,151391,151441,152369,152377,152506,152645,152652,152947,153023,153024,153025,153026,153042,153047,153050,153051,153052,153056,153580,154176,154485,154594,155055,155334,155605,155772,155797,155974,155976,155979,155986,155994,156038,156048,156072,156079,156085,156240,156366,156471,156532,156533,156542,156625,156626,156676,156996,156997,157015,157535,157601,157632,157806,157809,157831,157876,157896,157944,158020,158082,158089,158129,158217,158222,158233,158245,158336,158343,158522,158553,158775,158965,159136,159382,159523,159613,159635,159643,159713,159768,159830,160131,160136,160287,160343,160353,160565,160891,161174,161593,162042,162082,162093,162097,162180,162318,162382,162465,162536,162726,162826,162903,162936,163067,163090,163208,163310,163431,163499,163543,163644,163771,163947,163960,163974,164035,164056,164312,164528,164623,164689,164816,164881,164886,164888,165018,165030,165078,165127,165241,165332,165346,165511,165707,165755,165756,165760,165772,165798,165811,165852,165891,165937,165978,166102,166414,166513,166729,166842,166989,166990,167566,167810,168123,168127,168293,168518,168599,168668,168857,168867,169073,169082,169156,169183,169448,169455,169550,169579,169675,169680,169685,169833,169940,169955,169978,170161,170209,170215,170245,170309,170493,170507,170545,170683,170766,170938,170954,171166,171267,171404,171428,171469,171549,171552,171594,171598,171599,171622,172142,172179,172395,172581,172717,172719,172749,173011,173024,173359,173396,173400,173401,173416,173508,173560,173786,173791,173807,173837,173922,173937,173948,174018,174594,174718,174904,174915,175165,175179,175357,175378,175469,175586,175601,175602,175611,175826,175846,175876,175962,176091,176103,176138,176263,176366,176456,176569,176572,176698,176897,176911,176912,176922,176975,176989,176995,177094,177193,177194,177195,177232,177258,177342,177485,177767,177932,177966,178082,178189,178194,178318,178432,178558,178646,178659,178780,178912,178926,178954,178955,179125,179193,179324,179422,179849,179853,180045,180053,180060,180198,180234,180336,180514,180515,180852,181713,181925,182002,182342,182917,183378,183398,183404,183748,183751,183752,183908,183962,183963,183964,183965,183966,184020,184170,184275,184417,184501,184642,184656,184667,184803,184936,185087,185113,185160,185168,185207,185519,185571,185572,185654,185720,185833,186036,186348,186411,186412,186468,186592,186599,186679,186759,186760,186761,186762,186912,186964,187400,187401,187409,187841,187973,188043,188099,188183,188261,188307,188399,188449,188529,188700,188885,188910,189134,189260,189437,189438,189643,189681,189682,189848,189967,190323,190589,190590,190976,191053,191056,191170,191237,191240,191503,191769,192145,192392,192488,192534,192552,192567,193218,193329,193330,193698,193826,193927,193973,194064,194290,194948,195039,195040,195041,195044,195130,195249,195363,195478,195528,195662,195851,195880,195987,196098,196275,196355,196361,196538,196808,197342,197348,197353,197412,197721,197836,198548,199186) 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 (20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20714,20715,20716,20718,20719,20721,20776,20819,20820,20821,20869,20870,20919,20920,20921,20961,20962,20963,21026,21072,21073,21116,21175,21176,21178,21295,21364,21426,21462,21510,21647,21648,21649,21747,21748,21749,21750,21751,21752,21804,21805,21806,21807,21808,21809,21868,21869,21870,21929,21930,21931,21932,21979,21980,21981,21982,21983,21984,22031,22033,22034,22088,22125,22126,22127,22128,22178,22180,22232,22233,22234,22237,22238,22239,22277,22278,22279,22280,22281,22337,22338,22339,22340,22373,22374,22477,22479,22652,22653,23061,23290,23365,23367,23370,23431,23432,23433,23518,23519,23532,23586,23587,23588,23589,23590,23659,23660,23661,23710,23824,23825,23826,23852,23887,23888,23889,23890,23989,23990,23991,23992,24038,24132,24184,24406,24407,24416,24417,24421,24422,24423,24424,24425,24643,24644,24645,24646,24647,24648,24649,24650,24651,24652,24653,24654,24655,24656,24657,24658,24659,24660,24829,24913,24914,24915,24916,24917,24918,24942,24943,24944,24957,24964,24968,24969,24971,24982,24984,24988,24991,24992,25004,25018,25024,25029,25036,25122,25197,25199,25200,25201,25217,25218,25294,25295,25296,25297,25330,25331,25407,25408,25409,25425,25426,25427,25440,25441,25464,25487,25488,25489,25490,25505,25536,25561,25564,25565,25647,25648,25649,25708,25709,25779,25785,25786,25854,25855,25871,25890,25934,25935,25936,25950,25988,26017,26018,26105,26106,26107,26130,26138,26184,26185,26186,26202,26296,26428,26440,26446,26449,26454,26515,26516,26517,26518,26519,26520,26697,26698,26766,26871,26872,26919,26953,27010,27011,27012,27081,27098,27336,27337,27338,27339,27366,27440,27441,27442,27455,27456,27498,27567,27568,27569,27570,27571,27673,27674,27675,27683,27701,27884,27885,27886,27887,27888,27889,27905,27931,28016,28052,28053,28072,28073,28074,28205,28343,28432,28433,28434,28503,28530,28592,28805,28806,28807,28808,28878,28933,28934,28935,29017,29018,29019,29020,29171,29270,29348,29349,29353,29354,29355,29356,29357,29358,29359,29360,29361,29362,29363,29364,29366,29418,29419,29435,29457,29468,29470,29475,29476,29477,29478,29603,29614,29617,29633,29644,29645,29646,29647,29648,29670,29671,29672,29685,29686,29691,29692,29713,29714,29715,29716,29730,29732,29774,29775,29791,29792,29793,29795,29826,29827,29828,29829,29830,29831,29832,29833,29923,29935,29961,29962,29963,29964,29965,30010,30011,30014,30015,30018,30040,30041,30095,30242,30243,30244,30245,30246,30252,30253,30283,30319,30320,30321,30369,30373,30486,30487,30498,30523,30560,30561,30584,30588,30614,30615,30616,30617,30618,30619,30620,30645,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31564,31565,31720,31721,31722,31761,31762,31840,31842,31843,31844,31845,31846,31896,31897,31898,31998,32043,32044,32152,32361,32418,32420,32520,32749,32750,32821,32834,32843,32844,32858,32859,32874,32901,32940,32941,32942,32943,32966,32967,32983,32984,33031,33094,33104,33116,33117,33119,33120,33121,33149,33218,33248,33249,33250,33317,33408,33462,33464,33465,33466,33467,33468,33492,33493,33534,33544,33553,33556,33576,33577,33605,33608,33609,33611,33613,33620,33634,33765,33841,33978,33979,33980,33981,33982,33983,33984,34045,34046,34047,34048,34049,34050,34176,34179,34205,34315,34316,34317,34389,34415,34430,34481,34564,34588,34589,34810,34811,34812,34813,34962,35093,35118,35139,35154,35213,35226,35227,35277,35278,35279,35293,35312,35325,35326,35328,35333,35334,35338,35339,35371,35373,35374,35406,35410,35438,35439,35440,35583,35586,35587,35589,35590,35591,35592,35593,35594,35626,35672,35757,35768,35786,35787,35803,35808,35813,36111,36112,36132,36140,36141,36143,36203,36204,36205,36206,36233,36234,36242,36255,36256,36269,36325,36470,36472,36473,36474,36475,36476,36574,36605,36633,36642,36652,36697,36733,36753,36754,36755,36770,36771,36785,36789,36801,36809,36852,36853,36854,36855,36870,36871,36877,36971,37001,37002,37053,37068,37079,37081,37103,38699,38721,38767,38768,38790,38791,38800,38826,38842,38843,38853,38861,38862,38863,38892,38893,38901,38907,38954,39301,39397,39476,39517,39528,39530,39582,39597,39606,39607,39608,39617,39648,39656,39706,39726,39727,39728,40346,41903,41904,41919,41930,41931,41940,41971,41972,41996,41997,42003,42006,42018,42029,42352,42353,42354,42355,42376,42399,42403,42419,42420,42435,42436,42501,42532,42533,42534,42548,42549,42565,42576,42587,42600,42601,42603,42612,42615,42616,42634,42635,42676,42677,43027,43028,43029,43030,43104,43105,43126,43127,43128,43251,43281,43298,43308,43309,43310,43317,43318,43319,43333,43344,43348,43374,43786,43787,43788,43884,43939,44024,44025,44026,44027,44046,44053,44077,44078,44083,44095,44102,44109,44114,44145,44146,44147,44156,44492,44493,44521,44527,44629,44638,44639,44662,44663,44664,44665,44698,44699,44700,44702,44729,44748,44828,45080,45313,45399,45400,45542,45554,45555,45556,45565,45624,45649,45674,45708,45720,45721,45747,45753,45776,45792,45793,45794,45795,45796,46143,46144,46168,46202,46203,46209,46229,46239,46368,46397,46418,46428,46437,46438,46442,46445,46447,46459,46491,46495,46498,46753,46768,46771,46796,46901,46902,46903,46909,46910,46911,46912,46914,46915,46916,46917,46919,46920,46921,46922,46923,46924,46925,46926,46927,46928,46935,46936,46937,46938,46939,46940,46941,46942,46943,47003,47009,47010,47011,47064,47071,47072,47092,47123,47131,47143,47168,47176,47177,47178,47179,47184,47437,47454,47522,47523,47524,47525,47526,47527,47528,47529,47772,47783,47862,47891,47898,47912,47913,47914,47935,47962,47978,48213,48307,48342,48364,48365,48368,48369,48371,48389,48390,48391,48392,48393,48394,48395,48459,48473,48515,48524,48526,48557,48559,48561,48564,48567,48590,48612,48613,48622,48623,48807,48850,48853,48895,48896,48897,48984,49018,49079,49080,49082,49098,49110,49143,49144,49321,49322,49471,49487,49543,49544,49545,49546,49612,49769,49799,49815,49829,49832,49917,49930,49968,49973,49989,49990,50154,50155,50173,50207,50247,50249,50250,50251,50252,50304,50305,50343,50346,50401,50415,50427,50428,50439,50440,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50482,50483,50484,50497,50512,50515,50519,50674,50675,50762,50766,50767,50782,50810,50811,50840,50867,50876,50896,50898,50899,50921,50930,50934,50965,50970,51015,51024,51028,51055,51056,51057,51074,51080,51081,51101,51109,51119,51132,51134,51153,51154,51618,51619,51620,51621,51622,51663,51664,51928,51934,51938,51966,51994,51997,52022,52037,52044,52122,52130,52131,52132,52420,52421,52422,52423,52426,52437,52474,52483,52484,52485,52509,52524,52528,52530,52539,52550,52560,52561,52564,52582,52583,52587,52593,52612,52613,52634,52635,52636,53120,53123,53124,53125,53126,53127,53128,53166,53167,53168,53169,53170,53171,53183,53184,53285,53286,53296,53307,53308,53309,53310,53325,53329,53349,53353,53515,53516,53517,53553,53611,53612,53613,53614,53615,53616,53671,53719,53745,53753,53756,53802,53803,53804,53826,53842,53844,53861,54015,54052,54053,54054,54055,54056,54057,54058,54059,54060,54061,54109,54175,54240,54254,54255,54322,54323,54341,54389,54395,54589,54776,54810,54818,54821,54836,54838,54843,54853,55127,55148,55180,55277,55309,55319,55381,55382,55385,55390,55436,55904,56320,56321,56629,56657,57137,57149,57152,57204,57212,57213,57214,57238,57537,57538,57559,57594,57595,57805,57816,58002,58003,58045,58720,58794,58795,58832,58941,58950,58953,58978,58991,59017,59018,59037,59038,59042,59066,59378,59399,59410,59455,59456,59457,59458,59459,59528,59529,59557,59559,59569,59608,59671,59678,59679,59680,59681,59938,60030,60031,60032,60033,60034,60035,60036,60037,60038,60098,60099,60174,60175,60176,60180,60181,60189,60190,60191,60209,60233,60239,60242,60352,60353,60355,60356,60358,60359,60361,60363,60888,60890,60891,60892,60893,60894,60895,60955,60957,60962,61037,61038,61062,61069,61117,61118,61134,61136,61137,61177,61178,61179,61414,61474,61475,61476,61477,61478,61488,61489,61491,61505,61506,61571,61622,61623,61629,61654,61655,61756,61757,61758,61759,61761,61762,61815,61834,61838,61843,61846,61847,62189,62192,62229,62230,62231,62241,62260,62267,62273,62318,62325,62329,62331,62349,62354,62368,62371,62372,62380,62677,62792,62911,62912,62913,62914,62915,62916,62917,62918,62919,62920,62921,62922,62936,62969,62971,62972,62973,62981,62986,63038,63085,63087,63113,63136,63144,63157,63158,63165,63175,63212,63213,63214,63226,63732,63758,63759,63806,63808,63809,63810,63811,63812,63813,63814,63858,63876,63904,63905,63917,63945,63990,64045,64435,64487,64488,64489,64490,64492,64493,64494,64527,64528,64529,64530,64582,64586,64631,64644,64645,64650,64693,64694,64695,64696,64721,64745,65093,65198,65199,65200,65201,65202,65203,65204,65205,65272,65273,65274,65275,65276,65277,65278,65336,65337,65338,65398,65479,65550,65551,65565,65610,65614,65616,65619,65672,65673,66468,66469,66470,66472,66473,66474,66475,66476,66477,66478,66671,66701,66745,66754,66847,66848,66871,66891,66954,66955,66973,67518,67640,67742,67744,67745,67746,67747,67748,67749,67750,67751,67752,67753,67794,67795,67796,67797,67798,67799,67845,67846,67886,67891,67896,67911,67959,67960,67961,67962,67963,67964,67965,67966,67967,67981,67990,68011,68437,68463,68464,68465,68466,68467,68468,68578,68585,68586,68587,68594,68597,68598,68617,68618,68619,68625,68626,68627,68628,68644,68655,68657,68658,68659,68663,68673,68674,68683,68686,68688,68689,68753,69308,69357,69358,69359,69360,69361,69364,69365,69366,69367,69368,69369,69370,69371,69408,69409,69410,69411,69412,69437,69466,69467,69474,69483,69500,69503,69508,69521,69524,69528,69529,69586,69613,69641,70048,70082,70198,70200,70201,70202,70203,70204,70205,70206,70207,70242,70243,70244,70317,70318,70323,70367,70407,70408,70409,70474,70484,70491,70502,70510,70543,70921,70922,71032,71033,71034,71115,71121,71122,71210,71213,71217,71227,71235,71236,71237,71238,71239,71261,71267,71268,71269,71270,71861,71862,71863,71864,71865,71866,71867,71901,71902,71903,71904,71948,71953,71956,71979,71980,71981,72003,72008,72017,72029,72047,72084,72085,72086,72571,72572,72635,72636,72700,72702,72703,72705,72706,72707,72708,72727,72794,72816,72902,72903,72918,72922,72946,72956,72982,72983,73520,73523,73526,73527,73528,73529,73530,73572,73573,73574,73599,73625,73631,73641,73642,73665,73666,73690,73711,74232,74295,74296,74298,74342,74343,74356,74411,74427,74428,74444,74456,74480,74528,75055,75084,75085,75142,75216,75217,75248,75249,75250,75254,75255,75257,75258,75295,75296,75297,75298,75299,75304,75306,75321,75922,75923,75924,75942,75943,76029,76052,76067,76076,76124,76131,76147,76153,76164,76165,76638,76707,76708,76748,76749,76750,76849,76899,76934,76935,76946,76947,76949,76950,76963,76986,77436,77437,77438,77509,77510,77512,77579,77580,77581,77674,77675,77691,78346,78560,78561,78782,79703,81973,82486,82521,83011,83012,83013,83014,83015,83016,83018,83032,83048,83062,83230,83231,83233,83234,83236,83237,83238,83240,83241,83282,83296,83301,83302,83305,83306,83307,83308,83309,83310,83311,83312,83313,83314,83315,83316,83317,83318,83319,83320,83321,83322,83329,83356,83357,83358,83368,83387,83391,83436,83445,83446,83449,83458,83470,83471,83489,83549,83562,83571,83572,83573,83574,83579,83581,83582,83583,83584,83585,83600,83733,83734,83735,83736,84181,84202,84338,84340,84341,84343,84369,84513,84514,84515,84653,84654,84655,84656,84791,84834,84869,84947,84950,84989,84990,84991,84992,85045,85113,85114,85115,85116,85117,85121,85131,85132,85180,85191,85192,85207,85208,85212,85215,85216,85217,85314,85373,85374,85377,85378,85379,85380,85381,85382,85383,85384,85385,85386,85387,85388,85423,85524,85528,85541,85543,85544,85573,85574,85575,85576,85577,85578,85579,85580,85581,85582,85583,85584,85585,85586,85587,85588,85589,85591,85592,85593,85594,85595,85597,85598,85599,85600,85601,85602,85603,85604,85605,85607,85608,85609,85612,85613,85614,85615,85616,85617,85618,85619,85620,85621,85622,85623,85624,85625,85626,85627,85631,85632,85648,85794,85796,85797,85822,85833,85834,85835,85838,85931,85984,85995,85998,85999,86000,86002,86003,86004,86027,86073,86236,86237,86248,86269,86271,86272,86277,86315,86330,86376,86433,86434,86436,86630,86631,86633,86634,86635,86637,86638,86639,86640,86641,86652,86680,86681,86690,86748,86749,86794,86795,86810,86811,86812,86813,86842,86846,86847,86853,86866,86873,86876,86879,87061,87062,87064,87065,87066,87067,87068,87069,87070,87071,87101,87185,87220,87228,87268,87277,87292,87297,87316,87317,87318,87330,87382,88131,88132,88133,88134,88154,88266,88363,88364,88527,88614,88776,88777,88788,88797,88877,88912,88913,88943,88947,89098,89099,89100,89123,89124,89125,89160,89161,89162,89247,89292,89299,89300,89446,89511,89512,89528,89534,89535,89536,89609,89638,90378,90382,90383,90384,90385,90386,90387,90388,90389,90390,90391,90392,90393,90394,90395,90396,90397,90398,90399,90400,90401,90402,90426,90579,90580,90763,90774,90855,90904,90905,90906,90907,90908,90909,90910,90911,90912,90913,90945,90990,91017,91018,91053,91069,91072,91073,91083,91126,91131,91132,91143,91144,91145,91180,91182,91193,91221,91222,91223,91226,91234,91249,91253,91264,91265,91278,91290,91485,91537,91538,91539,91540,91596,91598,91609,91610,91612,91613,91614,91890,91891,91892,91894,91912,91913,91996,91997,92025,92026,92042,92043,92047,92049,92094,92096,92170,92258,92260,92309,92316,92317,92318,92410,92513,92514,92569,92570,92615,92631,92656,92657,92658,92746,92754,92839,92860,92957,92965,92988,93603,93625,93692,93694,93695,93760,93762,93763,93765,93788,93937,93956,94029,94030,94031,94167,94255,94260,94265,94279,94310,94433,94455,94522,94523,94850,95047,95048,95139,95140,95141,95142,95143,95144,95145,95146,95157,95178,95198,95199,95311,95320,95326,95335,95337,95438,95463,95488,95493,95516,95517,95530,95533,95551,95558,95578,95620,95621,95670,95782,95783,95784,95794,95815,95820,95821,95834,95961,96025,96042,96043,96044,96045,96046,96047,96048,96050,96051,96052,96053,96054,96056,96057,96135,96139,97846,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97935,97936,97937,97938,98019,98020,98042,98044,98127,98174,98175,98176,98307,98308,98309,98310,98311,98312,98313,98314,98315,98334,98335,98352,98396,98456,98690,98736,98737,98746,98747,98821,98823,98824,98905,98915,98916,98917,99009,99011,99040,99049,99140,99173,99181,99182,99183,99184,99185,99186,99187,99188,99189,99190,99191,99201,99202,99243,99310,99311,99335,99340,99431,99500,100174,100318,100354,100369,100449,100579,100686,100691,100707,100835,100836,100837,100846,100855,100866,100894,100895,101039,101060,101101,101165,101168,101284,101289,101290,101294,101296,101300,101302,101303,101304,101306,101307,101308,101311,101312,101313,101325,101362,101363,101532,101612,101614,101615,101616,101617,101618,101620,101621,101624,101625,101628,101633,101634,101702,101755,101782,101793,101803,101847,102021,102031,102242,102243,102244,102245,102246,102247,102248,102249,102250,102251,102252,102253,102275,102302,102354,102418,102442,102490,102535,102560,102561,102620,102675,102676,102690,102724,102739,102765,102948,103034,103035,103036,103037,103038,103039,103040,103074,103077,103148,103149,103196,103209,103212,103226,103229,103330,103336,103350,103460,103476,103477,103507,103508,103644,103645,103646,103647,103648,103649,103652,103653,103784,103897,103898,104108,104323,104376,104390,104393,104440,104466,104495,104934,104935,104936,104937,104938,104940,104941,104942,104943,104944,104945,104990,105022,105023,105032,105128,105146,105148,105149,105186,105210,105211,105212,105213,105214,105337,105365,105389,105390,105396,105485,105499,105537,105539,105540,105541,105555,105580,105644,105649,105656,105710,105711,105713,105719,105722,105781,105807,105880,105881,105882,105938,105939,105940,105941,105942,105943,105944,105945,105957,105958,105960,105967,105971,105987,105988,105989,105994,105997,106080,106083,106084,106085,106086,106132,106180,106197,106208,106209,106252,106253,106280,106331,106332,106335,106368,106369,106422,106464,106521,106542,106543,106545,106590,106605,106643,106645,106671,106821,106822,106823,106856,106960,106961,106962,106971,107020,107021,107022,107026,107060,107061,107070,107088,107103,107286,107287,107355,107439,107444,107462,107463,107464,107473,107495,107520,107529,107530,107547,107548,107573,107574,108194,108236,108280,108281,108282,108300,108318,108330,108354,108417,108460,108564,108592,108628,108686,108741,108784,108807,108808,108849,108869,108877,108894,108914,108915,108916,108917,108918,108919,108920,108930,108940,108946,108977,108984,108985,109072,109233,109235,109236,109237,109238,109299,109338,109339,109412,109413,109417,109422,109427,109428,109440,109441,109501,109515,109551,109556,109612,109654,109656,109867,109880,109899,110003,110025,110035,110144,110145,110157,110414,110447,110471,110473,110475,110476,110539,110547,110605,110614,110620,110633,110635,110636,110659,110675,110759,110940,110941,110942,110973,110990,111116,111117,111828,111829,111831,111833,111855,111956,112002,112252,112256,112325,112341,112342,112343,112369,112383,112412,112675,112713,112714,112750,112764,112826,112892,112899,112922,112941,113008,113020,113066,113096,113097,113098,113100,113187,113192,113232,113284,113337,113382,113435,113468,113469,113496,113625,113754,113811,113901,113923,113927,114144,114915,114956,115093,115099,115128,115130,115271,115555,115581,115582,115583,115584,115661,115676,115753,115789,115914,115915,115972,116047,116094,116113,116436,116578,116704,116763,116795,116852,116868,117238,117505,117623,117780,117792,117799,117835,117869,117940,117958,117996,118017,118018,118271,118343,118346,118541,118553,118559,118621,118675,118677,118678,118679,118680,118681,118682,118683,118684,118736,118943,119065,119076,119091,119094,119141,119186,119249,119827,119871,119998,120115,121166,121202,121558,121776,121809,121813,121826,121880,121896,121897,122006,122007,122301,122302,122468,122530,122532,122535,122552,122619,122642,122677,122696,122759,122881,122996,122997,122998,123006,123073,123102,123341,123462,123612,123650,123676,123929,124096,124248,124255,124295,125307,125398,125399,125405,125416,125417,125418,125558,125571,125576,125698,125756,125822,125940,126137,126139,126268,126728,126787,126982,127051,127150,127326,127327,127573,127713,128182,128240,128275,128348,128349,128450,128451,128452,128593,128672,128785,129463,129497,129499,129537,129624,129635,129636,129638,129643,129651,129652,129690,129756,129805,129898,129917,129936,130005,130007,130073,130187,130203,130205,130321,130336,130350,130459,130530,130584,130586,130587,130588,130680,130682,130855,130944,130945,130951,130952,130999,131001,131003,131004,131110,131211,131312,131460,131462,131507,131508,131509,131510,131511,131513,131530,131533,131583,131585,131586,131587,131703,131775,131845,131864,131941,131944,132073,132161,132200,132215,132312,132435,132451,132458,132509,132521,132631,132728,132729,132853,132872,133014,133015,133063,133064,133126,133187,133202,133322,133355,133403,133452,133477,133505,133544,133557,133581,133627,133640,133724,133748,133807,133819,133979,133983,133995,134004,134005,134098,134151,134200,134528,134794,134796,135089,135111,135115,135119,135129,135130,135143,135290,135392,135592,135636,135725,135726,135761,135762,135829,135874,135904,135955,136069,136097,136345,136346,136347,136363,136459,136708,136759,137158,137517,137518,137540,138375,138376,138789,139164,139376,139377,139475,139523,140265,140343,140480,140825,140900,141194,141250,141265,141379,141565,141566,141652,141727,141763,141916,141947,142070,142071,142086,142118,142249,142268,142349,142413,142452,142664,142696,142857,142862,143403,143406,144004,144147,144174,144340,144341,145141,145323,145378,146063,146064,146268,146270,146271,146646,146781,146868,146869,146870,147417,147683,147838,147897,148215,148584,148827,149596,149657,150242,150288,150332,150333,150365,150376,150601,150628,150815,150871,150941,150942,151032,151118,151224,151333,151391,151441,152369,152377,152506,152645,152652,152947,153023,153024,153025,153026,153042,153047,153050,153051,153052,153056,153580,154176,154485,154594,155055,155334,155605,155772,155797,155974,155976,155979,155986,155994,156038,156048,156072,156079,156085,156240,156366,156471,156532,156533,156542,156625,156626,156676,156996,156997,157015,157535,157601,157632,157806,157809,157831,157876,157896,157944,158020,158082,158089,158129,158217,158222,158233,158245,158336,158343,158522,158553,158775,158965,159136,159382,159523,159613,159635,159643,159713,159768,159830,160131,160136,160287,160343,160353,160565,160891,161174,161593,162042,162082,162093,162097,162180,162318,162382,162465,162536,162726,162826,162903,162936,163067,163090,163208,163310,163431,163499,163543,163644,163771,163947,163960,163974,164035,164056,164312,164528,164623,164689,164816,164881,164886,164888,165018,165030,165078,165127,165241,165332,165346,165511,165707,165755,165756,165760,165772,165798,165811,165852,165891,165937,165978,166102,166414,166513,166729,166842,166989,166990,167566,167810,168123,168127,168293,168518,168599,168668,168857,168867,169073,169082,169156,169183,169448,169455,169550,169579,169675,169680,169685,169833,169940,169955,169978,170161,170209,170215,170245,170309,170493,170507,170545,170683,170766,170938,170954,171166,171267,171404,171428,171469,171549,171552,171594,171598,171599,171622,172142,172179,172395,172581,172717,172719,172749,173011,173024,173359,173396,173400,173401,173416,173508,173560,173786,173791,173807,173837,173922,173937,173948,174018,174594,174718,174904,174915,175165,175179,175357,175378,175469,175586,175601,175602,175611,175826,175846,175876,175962,176091,176103,176138,176263,176366,176456,176569,176572,176698,176897,176911,176912,176922,176975,176989,176995,177094,177193,177194,177195,177232,177258,177342,177485,177767,177932,177966,178082,178189,178194,178318,178432,178558,178646,178659,178780,178912,178926,178954,178955,179125,179193,179324,179422,179849,179853,180045,180053,180060,180198,180234,180336,180514,180515,180852,181713,181925,182002,182342,182917,183378,183398,183404,183748,183751,183752,183908,183962,183963,183964,183965,183966,184020,184170,184275,184417,184501,184642,184656,184667,184803,184936,185087,185113,185160,185168,185207,185519,185571,185572,185654,185720,185833,186036,186348,186411,186412,186468,186592,186599,186679,186759,186760,186761,186762,186912,186964,187400,187401,187409,187841,187973,188043,188099,188183,188261,188307,188399,188449,188529,188700,188885,188910,189134,189260,189437,189438,189643,189681,189682,189848,189967,190323,190589,190590,190976,191053,191056,191170,191237,191240,191503,191769,192145,192392,192488,192534,192552,192567,193218,193329,193330,193698,193826,193927,193973,194064,194290,194948,195039,195040,195041,195044,195130,195249,195363,195478,195528,195662,195851,195880,195987,196098,196275,196355,196361,196538,196808,197342,197348,197353,197412,197721,197836,198548,199186) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 79 | Creole | executeQuery(): [32.56 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 (20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20714,20715,20716,20718,20719,20721,20776,20819,20820,20821,20869,20870,20919,20920,20921,20961,20962,20963,21026,21072,21073,21116,21175,21176,21178,21295,21364,21426,21462,21510,21647,21648,21649,21747,21748,21749,21750,21751,21752,21804,21805,21806,21807,21808,21809,21868,21869,21870,21929,21930,21931,21932,21979,21980,21981,21982,21983,21984,22031,22033,22034,22088,22125,22126,22127,22128,22178,22180,22232,22233,22234,22237,22238,22239,22277,22278,22279,22280,22281,22337,22338,22339,22340,22373,22374,22477,22479,22652,22653,23061,23290,23365,23367,23370,23431,23432,23433,23518,23519,23532,23586,23587,23588,23589,23590,23659,23660,23661,23710,23824,23825,23826,23852,23887,23888,23889,23890,23989,23990,23991,23992,24038,24132,24184,24406,24407,24416,24417,24421,24422,24423,24424,24425,24643,24644,24645,24646,24647,24648,24649,24650,24651,24652,24653,24654,24655,24656,24657,24658,24659,24660,24829,24913,24914,24915,24916,24917,24918,24942,24943,24944,24957,24964,24968,24969,24971,24982,24984,24988,24991,24992,25004,25018,25024,25029,25036,25122,25197,25199,25200,25201,25217,25218,25294,25295,25296,25297,25330,25331,25407,25408,25409,25425,25426,25427,25440,25441,25464,25487,25488,25489,25490,25505,25536,25561,25564,25565,25647,25648,25649,25708,25709,25779,25785,25786,25854,25855,25871,25890,25934,25935,25936,25950,25988,26017,26018,26105,26106,26107,26130,26138,26184,26185,26186,26202,26296,26428,26440,26446,26449,26454,26515,26516,26517,26518,26519,26520,26697,26698,26766,26871,26872,26919,26953,27010,27011,27012,27081,27098,27336,27337,27338,27339,27366,27440,27441,27442,27455,27456,27498,27567,27568,27569,27570,27571,27673,27674,27675,27683,27701,27884,27885,27886,27887,27888,27889,27905,27931,28016,28052,28053,28072,28073,28074,28205,28343,28432,28433,28434,28503,28530,28592,28805,28806,28807,28808,28878,28933,28934,28935,29017,29018,29019,29020,29171,29270,29348,29349,29353,29354,29355,29356,29357,29358,29359,29360,29361,29362,29363,29364,29366,29418,29419,29435,29457,29468,29470,29475,29476,29477,29478,29603,29614,29617,29633,29644,29645,29646,29647,29648,29670,29671,29672,29685,29686,29691,29692,29713,29714,29715,29716,29730,29732,29774,29775,29791,29792,29793,29795,29826,29827,29828,29829,29830,29831,29832,29833,29923,29935,29961,29962,29963,29964,29965,30010,30011,30014,30015,30018,30040,30041,30095,30242,30243,30244,30245,30246,30252,30253,30283,30319,30320,30321,30369,30373,30486,30487,30498,30523,30560,30561,30584,30588,30614,30615,30616,30617,30618,30619,30620,30645,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31564,31565,31720,31721,31722,31761,31762,31840,31842,31843,31844,31845,31846,31896,31897,31898,31998,32043,32044,32152,32361,32418,32420,32520,32749,32750,32821,32834,32843,32844,32858,32859,32874,32901,32940,32941,32942,32943,32966,32967,32983,32984,33031,33094,33104,33116,33117,33119,33120,33121,33149,33218,33248,33249,33250,33317,33408,33462,33464,33465,33466,33467,33468,33492,33493,33534,33544,33553,33556,33576,33577,33605,33608,33609,33611,33613,33620,33634,33765,33841,33978,33979,33980,33981,33982,33983,33984,34045,34046,34047,34048,34049,34050,34176,34179,34205,34315,34316,34317,34389,34415,34430,34481,34564,34588,34589,34810,34811,34812,34813,34962,35093,35118,35139,35154,35213,35226,35227,35277,35278,35279,35293,35312,35325,35326,35328,35333,35334,35338,35339,35371,35373,35374,35406,35410,35438,35439,35440,35583,35586,35587,35589,35590,35591,35592,35593,35594,35626,35672,35757,35768,35786,35787,35803,35808,35813,36111,36112,36132,36140,36141,36143,36203,36204,36205,36206,36233,36234,36242,36255,36256,36269,36325,36470,36472,36473,36474,36475,36476,36574,36605,36633,36642,36652,36697,36733,36753,36754,36755,36770,36771,36785,36789,36801,36809,36852,36853,36854,36855,36870,36871,36877,36971,37001,37002,37053,37068,37079,37081,37103,38699,38721,38767,38768,38790,38791,38800,38826,38842,38843,38853,38861,38862,38863,38892,38893,38901,38907,38954,39301,39397,39476,39517,39528,39530,39582,39597,39606,39607,39608,39617,39648,39656,39706,39726,39727,39728,40346,41903,41904,41919,41930,41931,41940,41971,41972,41996,41997,42003,42006,42018,42029,42352,42353,42354,42355,42376,42399,42403,42419,42420,42435,42436,42501,42532,42533,42534,42548,42549,42565,42576,42587,42600,42601,42603,42612,42615,42616,42634,42635,42676,42677,43027,43028,43029,43030,43104,43105,43126,43127,43128,43251,43281,43298,43308,43309,43310,43317,43318,43319,43333,43344,43348,43374,43786,43787,43788,43884,43939,44024,44025,44026,44027,44046,44053,44077,44078,44083,44095,44102,44109,44114,44145,44146,44147,44156,44492,44493,44521,44527,44629,44638,44639,44662,44663,44664,44665,44698,44699,44700,44702,44729,44748,44828,45080,45313,45399,45400,45542,45554,45555,45556,45565,45624,45649,45674,45708,45720,45721,45747,45753,45776,45792,45793,45794,45795,45796,46143,46144,46168,46202,46203,46209,46229,46239,46368,46397,46418,46428,46437,46438,46442,46445,46447,46459,46491,46495,46498,46753,46768,46771,46796,46901,46902,46903,46909,46910,46911,46912,46914,46915,46916,46917,46919,46920,46921,46922,46923,46924,46925,46926,46927,46928,46935,46936,46937,46938,46939,46940,46941,46942,46943,47003,47009,47010,47011,47064,47071,47072,47092,47123,47131,47143,47168,47176,47177,47178,47179,47184,47437,47454,47522,47523,47524,47525,47526,47527,47528,47529,47772,47783,47862,47891,47898,47912,47913,47914,47935,47962,47978,48213,48307,48342,48364,48365,48368,48369,48371,48389,48390,48391,48392,48393,48394,48395,48459,48473,48515,48524,48526,48557,48559,48561,48564,48567,48590,48612,48613,48622,48623,48807,48850,48853,48895,48896,48897,48984,49018,49079,49080,49082,49098,49110,49143,49144,49321,49322,49471,49487,49543,49544,49545,49546,49612,49769,49799,49815,49829,49832,49917,49930,49968,49973,49989,49990,50154,50155,50173,50207,50247,50249,50250,50251,50252,50304,50305,50343,50346,50401,50415,50427,50428,50439,50440,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50482,50483,50484,50497,50512,50515,50519,50674,50675,50762,50766,50767,50782,50810,50811,50840,50867,50876,50896,50898,50899,50921,50930,50934,50965,50970,51015,51024,51028,51055,51056,51057,51074,51080,51081,51101,51109,51119,51132,51134,51153,51154,51618,51619,51620,51621,51622,51663,51664,51928,51934,51938,51966,51994,51997,52022,52037,52044,52122,52130,52131,52132,52420,52421,52422,52423,52426,52437,52474,52483,52484,52485,52509,52524,52528,52530,52539,52550,52560,52561,52564,52582,52583,52587,52593,52612,52613,52634,52635,52636,53120,53123,53124,53125,53126,53127,53128,53166,53167,53168,53169,53170,53171,53183,53184,53285,53286,53296,53307,53308,53309,53310,53325,53329,53349,53353,53515,53516,53517,53553,53611,53612,53613,53614,53615,53616,53671,53719,53745,53753,53756,53802,53803,53804,53826,53842,53844,53861,54015,54052,54053,54054,54055,54056,54057,54058,54059,54060,54061,54109,54175,54240,54254,54255,54322,54323,54341,54389,54395,54589,54776,54810,54818,54821,54836,54838,54843,54853,55127,55148,55180,55277,55309,55319,55381,55382,55385,55390,55436,55904,56320,56321,56629,56657,57137,57149,57152,57204,57212,57213,57214,57238,57537,57538,57559,57594,57595,57805,57816,58002,58003,58045,58720,58794,58795,58832,58941,58950,58953,58978,58991,59017,59018,59037,59038,59042,59066,59378,59399,59410,59455,59456,59457,59458,59459,59528,59529,59557,59559,59569,59608,59671,59678,59679,59680,59681,59938,60030,60031,60032,60033,60034,60035,60036,60037,60038,60098,60099,60174,60175,60176,60180,60181,60189,60190,60191,60209,60233,60239,60242,60352,60353,60355,60356,60358,60359,60361,60363,60888,60890,60891,60892,60893,60894,60895,60955,60957,60962,61037,61038,61062,61069,61117,61118,61134,61136,61137,61177,61178,61179,61414,61474,61475,61476,61477,61478,61488,61489,61491,61505,61506,61571,61622,61623,61629,61654,61655,61756,61757,61758,61759,61761,61762,61815,61834,61838,61843,61846,61847,62189,62192,62229,62230,62231,62241,62260,62267,62273,62318,62325,62329,62331,62349,62354,62368,62371,62372,62380,62677,62792,62911,62912,62913,62914,62915,62916,62917,62918,62919,62920,62921,62922,62936,62969,62971,62972,62973,62981,62986,63038,63085,63087,63113,63136,63144,63157,63158,63165,63175,63212,63213,63214,63226,63732,63758,63759,63806,63808,63809,63810,63811,63812,63813,63814,63858,63876,63904,63905,63917,63945,63990,64045,64435,64487,64488,64489,64490,64492,64493,64494,64527,64528,64529,64530,64582,64586,64631,64644,64645,64650,64693,64694,64695,64696,64721,64745,65093,65198,65199,65200,65201,65202,65203,65204,65205,65272,65273,65274,65275,65276,65277,65278,65336,65337,65338,65398,65479,65550,65551,65565,65610,65614,65616,65619,65672,65673,66468,66469,66470,66472,66473,66474,66475,66476,66477,66478,66671,66701,66745,66754,66847,66848,66871,66891,66954,66955,66973,67518,67640,67742,67744,67745,67746,67747,67748,67749,67750,67751,67752,67753,67794,67795,67796,67797,67798,67799,67845,67846,67886,67891,67896,67911,67959,67960,67961,67962,67963,67964,67965,67966,67967,67981,67990,68011,68437,68463,68464,68465,68466,68467,68468,68578,68585,68586,68587,68594,68597,68598,68617,68618,68619,68625,68626,68627,68628,68644,68655,68657,68658,68659,68663,68673,68674,68683,68686,68688,68689,68753,69308,69357,69358,69359,69360,69361,69364,69365,69366,69367,69368,69369,69370,69371,69408,69409,69410,69411,69412,69437,69466,69467,69474,69483,69500,69503,69508,69521,69524,69528,69529,69586,69613,69641,70048,70082,70198,70200,70201,70202,70203,70204,70205,70206,70207,70242,70243,70244,70317,70318,70323,70367,70407,70408,70409,70474,70484,70491,70502,70510,70543,70921,70922,71032,71033,71034,71115,71121,71122,71210,71213,71217,71227,71235,71236,71237,71238,71239,71261,71267,71268,71269,71270,71861,71862,71863,71864,71865,71866,71867,71901,71902,71903,71904,71948,71953,71956,71979,71980,71981,72003,72008,72017,72029,72047,72084,72085,72086,72571,72572,72635,72636,72700,72702,72703,72705,72706,72707,72708,72727,72794,72816,72902,72903,72918,72922,72946,72956,72982,72983,73520,73523,73526,73527,73528,73529,73530,73572,73573,73574,73599,73625,73631,73641,73642,73665,73666,73690,73711,74232,74295,74296,74298,74342,74343,74356,74411,74427,74428,74444,74456,74480,74528,75055,75084,75085,75142,75216,75217,75248,75249,75250,75254,75255,75257,75258,75295,75296,75297,75298,75299,75304,75306,75321,75922,75923,75924,75942,75943,76029,76052,76067,76076,76124,76131,76147,76153,76164,76165,76638,76707,76708,76748,76749,76750,76849,76899,76934,76935,76946,76947,76949,76950,76963,76986,77436,77437,77438,77509,77510,77512,77579,77580,77581,77674,77675,77691,78346,78560,78561,78782,79703,81973,82486,82521,83011,83012,83013,83014,83015,83016,83018,83032,83048,83062,83230,83231,83233,83234,83236,83237,83238,83240,83241,83282,83296,83301,83302,83305,83306,83307,83308,83309,83310,83311,83312,83313,83314,83315,83316,83317,83318,83319,83320,83321,83322,83329,83356,83357,83358,83368,83387,83391,83436,83445,83446,83449,83458,83470,83471,83489,83549,83562,83571,83572,83573,83574,83579,83581,83582,83583,83584,83585,83600,83733,83734,83735,83736,84181,84202,84338,84340,84341,84343,84369,84513,84514,84515,84653,84654,84655,84656,84791,84834,84869,84947,84950,84989,84990,84991,84992,85045,85113,85114,85115,85116,85117,85121,85131,85132,85180,85191,85192,85207,85208,85212,85215,85216,85217,85314,85373,85374,85377,85378,85379,85380,85381,85382,85383,85384,85385,85386,85387,85388,85423,85524,85528,85541,85543,85544,85573,85574,85575,85576,85577,85578,85579,85580,85581,85582,85583,85584,85585,85586,85587,85588,85589,85591,85592,85593,85594,85595,85597,85598,85599,85600,85601,85602,85603,85604,85605,85607,85608,85609,85612,85613,85614,85615,85616,85617,85618,85619,85620,85621,85622,85623,85624,85625,85626,85627,85631,85632,85648,85794,85796,85797,85822,85833,85834,85835,85838,85931,85984,85995,85998,85999,86000,86002,86003,86004,86027,86073,86236,86237,86248,86269,86271,86272,86277,86315,86330,86376,86433,86434,86436,86630,86631,86633,86634,86635,86637,86638,86639,86640,86641,86652,86680,86681,86690,86748,86749,86794,86795,86810,86811,86812,86813,86842,86846,86847,86853,86866,86873,86876,86879,87061,87062,87064,87065,87066,87067,87068,87069,87070,87071,87101,87185,87220,87228,87268,87277,87292,87297,87316,87317,87318,87330,87382,88131,88132,88133,88134,88154,88266,88363,88364,88527,88614,88776,88777,88788,88797,88877,88912,88913,88943,88947,89098,89099,89100,89123,89124,89125,89160,89161,89162,89247,89292,89299,89300,89446,89511,89512,89528,89534,89535,89536,89609,89638,90378,90382,90383,90384,90385,90386,90387,90388,90389,90390,90391,90392,90393,90394,90395,90396,90397,90398,90399,90400,90401,90402,90426,90579,90580,90763,90774,90855,90904,90905,90906,90907,90908,90909,90910,90911,90912,90913,90945,90990,91017,91018,91053,91069,91072,91073,91083,91126,91131,91132,91143,91144,91145,91180,91182,91193,91221,91222,91223,91226,91234,91249,91253,91264,91265,91278,91290,91485,91537,91538,91539,91540,91596,91598,91609,91610,91612,91613,91614,91890,91891,91892,91894,91912,91913,91996,91997,92025,92026,92042,92043,92047,92049,92094,92096,92170,92258,92260,92309,92316,92317,92318,92410,92513,92514,92569,92570,92615,92631,92656,92657,92658,92746,92754,92839,92860,92957,92965,92988,93603,93625,93692,93694,93695,93760,93762,93763,93765,93788,93937,93956,94029,94030,94031,94167,94255,94260,94265,94279,94310,94433,94455,94522,94523,94850,95047,95048,95139,95140,95141,95142,95143,95144,95145,95146,95157,95178,95198,95199,95311,95320,95326,95335,95337,95438,95463,95488,95493,95516,95517,95530,95533,95551,95558,95578,95620,95621,95670,95782,95783,95784,95794,95815,95820,95821,95834,95961,96025,96042,96043,96044,96045,96046,96047,96048,96050,96051,96052,96053,96054,96056,96057,96135,96139,97846,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97935,97936,97937,97938,98019,98020,98042,98044,98127,98174,98175,98176,98307,98308,98309,98310,98311,98312,98313,98314,98315,98334,98335,98352,98396,98456,98690,98736,98737,98746,98747,98821,98823,98824,98905,98915,98916,98917,99009,99011,99040,99049,99140,99173,99181,99182,99183,99184,99185,99186,99187,99188,99189,99190,99191,99201,99202,99243,99310,99311,99335,99340,99431,99500,100174,100318,100354,100369,100449,100579,100686,100691,100707,100835,100836,100837,100846,100855,100866,100894,100895,101039,101060,101101,101165,101168,101284,101289,101290,101294,101296,101300,101302,101303,101304,101306,101307,101308,101311,101312,101313,101325,101362,101363,101532,101612,101614,101615,101616,101617,101618,101620,101621,101624,101625,101628,101633,101634,101702,101755,101782,101793,101803,101847,102021,102031,102242,102243,102244,102245,102246,102247,102248,102249,102250,102251,102252,102253,102275,102302,102354,102418,102442,102490,102535,102560,102561,102620,102675,102676,102690,102724,102739,102765,102948,103034,103035,103036,103037,103038,103039,103040,103074,103077,103148,103149,103196,103209,103212,103226,103229,103330,103336,103350,103460,103476,103477,103507,103508,103644,103645,103646,103647,103648,103649,103652,103653,103784,103897,103898,104108,104323,104376,104390,104393,104440,104466,104495,104934,104935,104936,104937,104938,104940,104941,104942,104943,104944,104945,104990,105022,105023,105032,105128,105146,105148,105149,105186,105210,105211,105212,105213,105214,105337,105365,105389,105390,105396,105485,105499,105537,105539,105540,105541,105555,105580,105644,105649,105656,105710,105711,105713,105719,105722,105781,105807,105880,105881,105882,105938,105939,105940,105941,105942,105943,105944,105945,105957,105958,105960,105967,105971,105987,105988,105989,105994,105997,106080,106083,106084,106085,106086,106132,106180,106197,106208,106209,106252,106253,106280,106331,106332,106335,106368,106369,106422,106464,106521,106542,106543,106545,106590,106605,106643,106645,106671,106821,106822,106823,106856,106960,106961,106962,106971,107020,107021,107022,107026,107060,107061,107070,107088,107103,107286,107287,107355,107439,107444,107462,107463,107464,107473,107495,107520,107529,107530,107547,107548,107573,107574,108194,108236,108280,108281,108282,108300,108318,108330,108354,108417,108460,108564,108592,108628,108686,108741,108784,108807,108808,108849,108869,108877,108894,108914,108915,108916,108917,108918,108919,108920,108930,108940,108946,108977,108984,108985,109072,109233,109235,109236,109237,109238,109299,109338,109339,109412,109413,109417,109422,109427,109428,109440,109441,109501,109515,109551,109556,109612,109654,109656,109867,109880,109899,110003,110025,110035,110144,110145,110157,110414,110447,110471,110473,110475,110476,110539,110547,110605,110614,110620,110633,110635,110636,110659,110675,110759,110940,110941,110942,110973,110990,111116,111117,111828,111829,111831,111833,111855,111956,112002,112252,112256,112325,112341,112342,112343,112369,112383,112412,112675,112713,112714,112750,112764,112826,112892,112899,112922,112941,113008,113020,113066,113096,113097,113098,113100,113187,113192,113232,113284,113337,113382,113435,113468,113469,113496,113625,113754,113811,113901,113923,113927,114144,114915,114956,115093,115099,115128,115130,115271,115555,115581,115582,115583,115584,115661,115676,115753,115789,115914,115915,115972,116047,116094,116113,116436,116578,116704,116763,116795,116852,116868,117238,117505,117623,117780,117792,117799,117835,117869,117940,117958,117996,118017,118018,118271,118343,118346,118541,118553,118559,118621,118675,118677,118678,118679,118680,118681,118682,118683,118684,118736,118943,119065,119076,119091,119094,119141,119186,119249,119827,119871,119998,120115,121166,121202,121558,121776,121809,121813,121826,121880,121896,121897,122006,122007,122301,122302,122468,122530,122532,122535,122552,122619,122642,122677,122696,122759,122881,122996,122997,122998,123006,123073,123102,123341,123462,123612,123650,123676,123929,124096,124248,124255,124295,125307,125398,125399,125405,125416,125417,125418,125558,125571,125576,125698,125756,125822,125940,126137,126139,126268,126728,126787,126982,127051,127150,127326,127327,127573,127713,128182,128240,128275,128348,128349,128450,128451,128452,128593,128672,128785,129463,129497,129499,129537,129624,129635,129636,129638,129643,129651,129652,129690,129756,129805,129898,129917,129936,130005,130007,130073,130187,130203,130205,130321,130336,130350,130459,130530,130584,130586,130587,130588,130680,130682,130855,130944,130945,130951,130952,130999,131001,131003,131004,131110,131211,131312,131460,131462,131507,131508,131509,131510,131511,131513,131530,131533,131583,131585,131586,131587,131703,131775,131845,131864,131941,131944,132073,132161,132200,132215,132312,132435,132451,132458,132509,132521,132631,132728,132729,132853,132872,133014,133015,133063,133064,133126,133187,133202,133322,133355,133403,133452,133477,133505,133544,133557,133581,133627,133640,133724,133748,133807,133819,133979,133983,133995,134004,134005,134098,134151,134200,134528,134794,134796,135089,135111,135115,135119,135129,135130,135143,135290,135392,135592,135636,135725,135726,135761,135762,135829,135874,135904,135955,136069,136097,136345,136346,136347,136363,136459,136708,136759,137158,137517,137518,137540,138375,138376,138789,139164,139376,139377,139475,139523,140265,140343,140480,140825,140900,141194,141250,141265,141379,141565,141566,141652,141727,141763,141916,141947,142070,142071,142086,142118,142249,142268,142349,142413,142452,142664,142696,142857,142862,143403,143406,144004,144147,144174,144340,144341,145141,145323,145378,146063,146064,146268,146270,146271,146646,146781,146868,146869,146870,147417,147683,147838,147897,148215,148584,148827,149596,149657,150242,150288,150332,150333,150365,150376,150601,150628,150815,150871,150941,150942,151032,151118,151224,151333,151391,151441,152369,152377,152506,152645,152652,152947,153023,153024,153025,153026,153042,153047,153050,153051,153052,153056,153580,154176,154485,154594,155055,155334,155605,155772,155797,155974,155976,155979,155986,155994,156038,156048,156072,156079,156085,156240,156366,156471,156532,156533,156542,156625,156626,156676,156996,156997,157015,157535,157601,157632,157806,157809,157831,157876,157896,157944,158020,158082,158089,158129,158217,158222,158233,158245,158336,158343,158522,158553,158775,158965,159136,159382,159523,159613,159635,159643,159713,159768,159830,160131,160136,160287,160343,160353,160565,160891,161174,161593,162042,162082,162093,162097,162180,162318,162382,162465,162536,162726,162826,162903,162936,163067,163090,163208,163310,163431,163499,163543,163644,163771,163947,163960,163974,164035,164056,164312,164528,164623,164689,164816,164881,164886,164888,165018,165030,165078,165127,165241,165332,165346,165511,165707,165755,165756,165760,165772,165798,165811,165852,165891,165937,165978,166102,166414,166513,166729,166842,166989,166990,167566,167810,168123,168127,168293,168518,168599,168668,168857,168867,169073,169082,169156,169183,169448,169455,169550,169579,169675,169680,169685,169833,169940,169955,169978,170161,170209,170215,170245,170309,170493,170507,170545,170683,170766,170938,170954,171166,171267,171404,171428,171469,171549,171552,171594,171598,171599,171622,172142,172179,172395,172581,172717,172719,172749,173011,173024,173359,173396,173400,173401,173416,173508,173560,173786,173791,173807,173837,173922,173937,173948,174018,174594,174718,174904,174915,175165,175179,175357,175378,175469,175586,175601,175602,175611,175826,175846,175876,175962,176091,176103,176138,176263,176366,176456,176569,176572,176698,176897,176911,176912,176922,176975,176989,176995,177094,177193,177194,177195,177232,177258,177342,177485,177767,177932,177966,178082,178189,178194,178318,178432,178558,178646,178659,178780,178912,178926,178954,178955,179125,179193,179324,179422,179849,179853,180045,180053,180060,180198,180234,180336,180514,180515,180852,181713,181925,182002,182342,182917,183378,183398,183404,183748,183751,183752,183908,183962,183963,183964,183965,183966,184020,184170,184275,184417,184501,184642,184656,184667,184803,184936,185087,185113,185160,185168,185207,185519,185571,185572,185654,185720,185833,186036,186348,186411,186412,186468,186592,186599,186679,186759,186760,186761,186762,186912,186964,187400,187401,187409,187841,187973,188043,188099,188183,188261,188307,188399,188449,188529,188700,188885,188910,189134,189260,189437,189438,189643,189681,189682,189848,189967,190323,190589,190590,190976,191053,191056,191170,191237,191240,191503,191769,192145,192392,192488,192534,192552,192567,193218,193329,193330,193698,193826,193927,193973,194064,194290,194948,195039,195040,195041,195044,195130,195249,195363,195478,195528,195662,195851,195880,195987,196098,196275,196355,196361,196538,196808,197342,197348,197353,197412,197721,197836,198548,199186) 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(): [1182.34 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.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199768 |
| 108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 109 | Creole | executeQuery(): [0.84 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199661 |
| 110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 111 | Creole | executeQuery(): [1.31 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199659 |
| 112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 113 | Creole | executeQuery(): [1.17 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199615 |
| 114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 115 | Creole | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199573 |
| 116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 117 | Creole | executeQuery(): [0.49 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=65620 |
| 118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 119 | Creole | executeQuery(): [0.66 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=64723 |
| 120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 121 | Creole | executeQuery(): [0.83 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=61149 |
| 122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 123 | Creole | executeQuery(): [0.96 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=61148 |
| 124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 125 | Creole | executeQuery(): [0.38 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=61146 |
| 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
10682.8 KB
1525 ms
