| # |
type |
message |
| 1 |  Routing | connect "/captcha" |
| 2 | Context | initialization |
| 3 | Controller | initialization |
| 4 | Routing | match route [na_vif] "/:make/:model/:id" |
| 5 | Request | request parameters array ( 'make' => 'chevrolet', 'model' => 'camaro', 'id' => '199755', '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(): [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_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=199755 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.72 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 (907) |
| 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.97 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=199755 |
| 38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
| 39 | Creole | executeQuery(): [0.71 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199755 |
| 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(): [15.61 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=199755 |
| 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.70 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 (907) |
| 44 | Creole | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
| 45 | Creole | executeQuery(): [0.72 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199755 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.57 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 (199755) ORDER BY carimg.ORD ASC |
| 49 | Creole | executeQuery(): [0.82 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 (199755) 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.61 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 (907) |
| 52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
| 53 | Creole | executeQuery(): [0.70 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=907 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.07 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=35 AND model.ID=377 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) ) AS count |
| 58 | Creole | executeQuery(): [16.01 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) ) 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 60 | Creole | executeQuery(): [21.46 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 != 199755 AND car.ID_MODEL = '377' ) 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 != 199755 AND car.ID_MODEL = '377' ) 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 (200014,199998,199968,199727,199580) ORDER BY carimg.ORD ASC |
| 62 | Creole | executeQuery(): [1.26 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 (200014,199998,199968,199727,199580) 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) ) AS count |
| 65 | Creole | executeQuery(): [11.40 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 67 | Creole | executeQuery(): [17.72 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 != '199755' AND car.ID_NETTI_USER = '907' ) 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 (200020,200012,199997,199980,199967) ORDER BY carimg.ORD ASC |
| 69 | Creole | executeQuery(): [1.21 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 (200020,200012,199997,199980,199967) 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(): [9.46 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=35 AND car.ID_MODEL=377 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(): [62.29 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=35 AND sold_car.ID_MODEL=377 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 (50746,61857,65754,65772,65781,65789,65801,65809,65820,84521,112535,117455,129177,130037,132298,132390,136265,136755,139467,139701,140985,141269,141458,141639,141730,142048,142170,142583,144557,146458,153199,153239,153240,153251,154795,154818,155463,155506,155832,156403,157076,163238,165245,166028,166321,166449,166464,166787,166789,167122,167152,167499,168654,168892,169885,170065,170404,170524,170816,171239,171241,171565,171568,171755,171933,171938,172443,172545,172586,172587,172595,172770,172907,173002,173005,173064,173381,173392,173491,173492,175299,176113,176261,177005,178181,178447,179320,179885,180677,181492,182974,182975,183151,183473,184083,185107,185686,185895,187075,187770,188426,188483,188711,188749,188767,188892,188977,189547,190430,191266,191807,191952,192280,192425,192479,192503,192885,192906,193120,193267,193375,193627,193637,193640,193642,193977,194062,194261,194283,194302,194342,194369,194373,194380,194517,194648,194663,194678,194798,194813,194891,195325,195364,195596,195635,195676,195678,195706,195723,195726,195728,195772,195777,195786,195853,195947,195950,195966,195972,195985,196095,196201,196329,196352,196392,196535,196542,196611,196655,196698,196822,196939,196965,196988,196997,197038,197078,197115,197170,197236,197251,197313,197315,197358,197420,197436,197439,197464,197533,197626,197702,197798,197948,197954,197959,198181,198239,198293,198498,198521,198609,198652,198688,198776,198810,198900,198901,198909,198945,198949,199035,199047,199051,199056,199057,199094,199145,199170,199193,199230,199282,199300,199316,199367,199577,199580,199727,199755,199968,199998,200014) GROUP BY cmonth ORDER BY date_create |
| 75 | Creole | executeQuery(): [20.32 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 (50746,61857,65754,65772,65781,65789,65801,65809,65820,84521,112535,117455,129177,130037,132298,132390,136265,136755,139467,139701,140985,141269,141458,141639,141730,142048,142170,142583,144557,146458,153199,153239,153240,153251,154795,154818,155463,155506,155832,156403,157076,163238,165245,166028,166321,166449,166464,166787,166789,167122,167152,167499,168654,168892,169885,170065,170404,170524,170816,171239,171241,171565,171568,171755,171933,171938,172443,172545,172586,172587,172595,172770,172907,173002,173005,173064,173381,173392,173491,173492,175299,176113,176261,177005,178181,178447,179320,179885,180677,181492,182974,182975,183151,183473,184083,185107,185686,185895,187075,187770,188426,188483,188711,188749,188767,188892,188977,189547,190430,191266,191807,191952,192280,192425,192479,192503,192885,192906,193120,193267,193375,193627,193637,193640,193642,193977,194062,194261,194283,194302,194342,194369,194373,194380,194517,194648,194663,194678,194798,194813,194891,195325,195364,195596,195635,195676,195678,195706,195723,195726,195728,195772,195777,195786,195853,195947,195950,195966,195972,195985,196095,196201,196329,196352,196392,196535,196542,196611,196655,196698,196822,196939,196965,196988,196997,197038,197078,197115,197170,197236,197251,197313,197315,197358,197420,197436,197439,197464,197533,197626,197702,197798,197948,197954,197959,198181,198239,198293,198498,198521,198609,198652,198688,198776,198810,198900,198901,198909,198945,198949,199035,199047,199051,199056,199057,199094,199145,199170,199193,199230,199282,199300,199316,199367,199577,199580,199727,199755,199968,199998,200014) 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 (20435,22555,22556,22565,22579,22580,22617,22670,22688,22701,22705,22724,22734,22735,22835,22849,22854,22877,22885,22896,22974,22975,22979,22980,22981,22982,23078,23200,23223,23229,23314,23387,23393,23444,23445,23446,23452,23523,23539,23549,23557,23601,23831,23842,23858,23916,24098,24099,24102,24106,24160,24191,24518,24936,25016,25134,25154,25494,25571,25804,25891,26023,26192,26283,26371,26445,26591,26782,27020,28332,29619,29966,30553,30592,31921,32015,32113,33153,33154,34024,34025,34382,34491,34492,35086,35303,35447,35736,36988,36990,37107,38995,39688,39709,41934,41999,42590,43117,43321,43920,43921,44062,44423,44480,44557,45497,45678,46323,46987,47125,47593,48384,48462,48883,48884,49493,49895,50790,50791,50812,51136,51651,51652,52045,52059,52433,53140,53141,53643,53644,53645,53683,53807,54245,55368,55826,55831,55835,55836,55845,55856,55859,55870,55892,55896,55899,55958,55964,55965,55966,55967,55975,55976,56142,56143,56159,56169,56170,56171,56172,56173,56174,56190,56191,56192,56193,56194,56222,56223,56251,56252,56377,56378,56379,56380,56381,56576,56577,56578,56579,56580,56759,56767,56768,56804,56810,56817,56885,56898,56901,56902,56933,56948,57037,57038,57039,57040,57052,57053,57054,57055,57056,57057,57058,57059,57061,57062,57063,57064,57065,57078,57079,57080,57103,57114,57115,57135,57283,57284,57285,57286,57287,57288,57304,57309,57367,57382,57486,57501,57502,57639,57646,57647,57657,57681,57743,57754,57762,57765,57770,57775,57790,57806,57812,57814,58228,58229,58230,58231,58232,58233,58250,58288,58306,58307,58349,58366,58397,58398,58564,58565,58566,58567,58586,58587,58588,58589,58601,58602,58603,58604,58605,58606,58626,58638,58653,58661,58662,58681,58689,58699,58700,58713,58742,58771,58817,59040,59411,59432,59440,59462,59546,59994,59995,59996,60081,60192,60262,60263,60665,60666,60758,60783,60784,60785,60786,60824,60828,60834,60990,60994,61016,61017,61074,61408,61483,61502,61548,61552,61659,61856,62111,62162,62235,62258,62428,62872,62928,62945,63013,63138,63193,63196,63198,63202,63713,63718,63737,63768,63779,63886,64442,64446,64510,64730,65057,65064,65149,65150,65161,65266,65502,65707,65733,65748,65792,65838,66376,66387,66402,66929,66984,67763,67825,67931,67950,67994,68647,68739,69541,69547,69621,70093,70111,70112,70420,70425,70426,70453,70540,70998,71280,71296,71818,72061,72068,72606,72710,72771,72867,72869,72972,73415,73440,73716,73718,74374,74377,74388,74537,74539,74540,74541,75000,75052,75264,75273,75346,75828,75851,75895,76113,76668,76920,76996,76997,77009,77021,77022,77023,77386,77636,77660,77682,77687,77689,77690,78221,78223,78225,78226,78236,78286,78288,78289,78290,78294,78309,78345,78383,78384,78385,78387,78388,78600,78601,78602,78604,78606,78617,78691,78692,78707,78710,78794,78811,80470,80913,81244,81255,81257,81263,81335,81494,81853,81858,81871,81893,81900,81986,82427,82449,82492,82509,82516,82952,82959,82975,83026,83035,83042,83084,83123,83125,83250,83251,83266,83591,84109,84114,84301,84594,84782,84786,85150,85295,85333,85342,85393,85394,85481,85482,85673,85725,85730,85763,85885,85964,85970,86047,86143,86296,86442,86546,86551,86582,86593,86834,87022,87155,87162,87166,87270,87839,87841,87846,87924,88053,88067,88081,88442,88472,88473,88479,88748,88937,89017,89018,89019,89060,89065,89066,89067,89114,89460,89472,89519,89632,90139,90175,90314,90704,90736,90793,91056,91108,91735,91755,91814,91849,92186,92202,92220,92874,93008,93010,93525,93530,93721,93946,94166,94995,95004,95015,95018,95019,95086,95244,95365,95370,95585,95636,95681,95701,95734,95735,95785,95879,95892,95894,96037,96169,96178,97812,97816,97855,98067,98187,98353,98409,98706,98713,98714,98768,98769,98771,98984,99381,100007,100008,100041,100063,100440,100553,100574,100575,100576,100776,100793,100816,100879,101136,101357,101358,101502,101721,101729,102211,102232,102329,102376,102400,102412,102420,102670,102743,102760,102999,103103,103107,103108,103253,103411,103413,103763,103764,103804,103866,103870,103873,104183,104444,104473,104477,104777,104919,105004,105006,105220,105222,105296,105303,105306,105307,105308,105309,105310,105320,105341,105353,105366,105425,105519,105521,105528,105606,105774,105836,105849,105892,105909,105911,106010,106127,106128,106258,106259,106260,106386,106388,106389,106475,106481,106569,106571,106582,106584,106596,106680,106681,106701,106780,106844,106853,106854,106855,107043,107110,107123,107124,107128,107174,107176,107177,107201,107249,107260,107322,107337,107404,107411,108058,108059,108060,108061,108076,108077,108085,108086,108087,108088,108089,108090,108091,108092,108093,108094,108095,108112,108141,108223,108257,108261,108262,108263,108358,108362,108518,108538,108539,108542,108543,108549,108550,108637,108709,108710,109053,109065,109209,109393,109584,109588,109592,109609,109610,109613,109678,109685,109729,109894,109931,109935,109947,109949,109951,109953,109955,109958,109961,110114,110115,110116,110117,110222,110229,110241,110250,110257,110263,110265,110272,110294,110307,110308,110309,110310,110311,110312,110378,110455,110564,110658,110731,110740,110832,110886,110888,110889,110897,110925,110964,111006,111009,111012,111017,111106,111233,111260,111317,111618,111730,112140,112507,112519,112525,112765,112784,112785,112806,112834,112954,113082,113290,113295,113299,113391,113393,113492,113575,113592,113615,113653,113663,113680,113857,113858,113859,113870,113953,113954,113957,114018,114126,114130,114172,114224,114255,114258,114474,114481,114493,114507,114508,114529,114530,114551,114573,114814,114821,114825,114828,114872,114878,114903,114937,114938,114939,114965,114989,114990,114991,114995,115013,115022,115166,115167,115168,115175,115180,115214,115218,115223,115231,115338,115345,115494,115503,115518,115694,115710,115721,115724,115732,115804,115832,116033,116061,116064,116067,116073,116088,116124,116135,116151,116152,116154,116158,116163,116164,116234,116385,116393,116404,116413,116444,116458,116512,116516,116586,116628,116640,116768,116777,116778,116780,116848,116946,116951,116952,116960,116985,117214,117216,117301,117317,117368,117450,117451,117456,117564,117572,117617,117667,117756,117842,117856,117902,117916,117926,117981,118056,118287,118381,118382,118390,118425,118433,118440,118441,118465,118518,118522,118530,118775,118779,118781,118789,118794,118873,118884,119019,119102,119111,119118,119120,119194,119237,119238,119288,119314,119319,119932,119967,120123,120173,120176,120429,120430,120600,120601,120602,120615,120616,120626,120627,120628,120629,120630,120631,120632,120633,120634,120635,120681,120717,120751,120832,120886,120902,121013,121014,121030,121031,121032,121033,121034,121045,121046,121047,121048,121049,121080,121098,121106,121107,121133,121134,121152,121349,121350,121360,121361,121362,121369,121370,121371,121372,121409,121430,121439,121445,121455,121471,121555,121556,121654,121665,121666,121667,121672,121673,121674,121675,121676,121677,121688,121716,121753,121851,122050,122060,122141,122142,122277,122327,122350,122359,122373,122426,122438,122439,122620,122710,122776,122779,122810,122839,122842,122858,122878,122905,122910,123046,123051,123130,123134,123136,123186,123191,123369,123383,123398,123399,123594,123643,123644,123755,123760,123832,123840,123841,123843,123872,123875,123914,123941,123974,124059,124082,124092,124093,124094,124114,124154,124192,124204,124226,124231,124276,124277,124387,125290,125294,125339,125341,125347,125370,125372,125429,125439,125507,125539,125556,125567,125580,125602,125619,125620,125680,125681,125682,125725,125745,125763,125806,125811,125921,125954,125955,125981,125997,125998,126024,126044,126075,126083,126113,126152,126162,126189,126198,126209,126258,126263,126316,126319,126408,126437,126438,126450,126506,126508,126525,126561,126630,126637,126660,126741,126802,126909,126957,126968,126988,126995,127022,127047,127139,127145,127157,127160,127190,127233,127359,127381,127394,127438,127474,127475,127476,127477,127478,127479,127556,127557,127622,127662,127680,127683,127686,127817,127827,127909,127928,127964,127966,128028,128030,128058,128059,128090,128131,128194,128200,128259,128263,128269,128419,128485,128491,128535,128580,128581,128601,128629,128630,128645,128699,128741,128763,128895,128924,128998,129005,129006,129034,129035,129052,129053,129108,129130,129153,129197,129306,129315,129321,129344,130019,130026,130033,130275,130276,130381,130671,130703,130705,130878,131216,131595,131875,131957,131958,132000,132099,132100,132135,132178,132260,132462,132593,132595,132603,132616,132626,132658,132783,132790,132819,132832,133093,133094,133304,133370,133395,133509,133683,133847,134039,134197,134516,135657,136101,136102,136114,136318,136381,136447,136473,136524,136618,136630,136631,136632,136633,136634,136738,136795,136945,136949,136952,136954,136956,136982,137063,137064,137065,137066,137073,137077,137078,137087,137101,137241,137243,137257,137258,137277,137296,137327,137328,137361,137380,137399,137459,137460,137466,137638,137645,137647,137648,137649,137678,137687,137705,137769,137773,137780,137787,137790,137799,137805,137806,137825,137826,137841,137844,137847,137862,138026,138027,138028,138034,138036,138040,138043,138047,138066,138067,138085,138089,138095,138097,138107,138112,138185,138190,138246,138309,138310,138311,138312,138313,138316,138317,138360,138470,138472,138473,138478,138589,138595,138602,138606,138607,138609,138612,138683,138746,138747,138748,138749,138759,138760,138767,138786,138875,138876,138877,139119,139125,139126,139338,139348,139362,139667,139690,139699,139703,139726,139729,139735,139740,139780,140261,140402,140411,140472,140495,140850,140930,140947,141078,141080,141081,141086,141094,141211,141224,141225,141227,141665,141773,141789,141927,141999,142000,142193,142227,142263,142319,142326,142375,142488,142491,142492,142493,142495,142499,142518,142553,142560,142577,142591,142616,142619,142671,142840,142911,142921,143249,143331,143423,143430,143468,143469,143485,143489,143582,143608,143642,143724,143734,143735,143741,143764,143806,143840,143843,143860,143878,143881,143892,143895,143962,143963,143964,143965,143979,144043,144052,144056,144092,144095,144096,144107,144129,144155,144196,144247,144270,144286,144296,144362,144489,144513,144516,144562,144618,144619,144620,144627,144628,144629,144644,144658,144659,144679,144693,144694,144695,144696,144697,144698,144699,144700,144713,144714,144715,144716,144717,144754,144773,144774,144779,144780,144802,144844,144864,144875,144878,144902,144903,144914,144919,144925,144942,144957,145000,145005,145030,145058,145180,145269,145270,145271,145277,145282,145283,145300,145327,145344,145358,145479,145480,145577,145640,145646,145656,145657,145658,145711,145748,145749,145750,145765,145766,145767,145768,145769,145770,145783,145784,145785,145786,145787,145788,145803,145843,145849,145852,145862,145981,146025,146029,146046,146124,146140,146228,146436,146439,146444,146489,146514,146586,146593,146596,146697,146758,146802,146877,146928,146931,146932,146935,147014,147027,147030,147044,147068,147075,147184,147185,147260,147261,147264,147349,147396,147436,147553,147554,147566,147570,147634,147672,147734,147735,147796,147840,147844,147852,147886,148002,148009,148024,148028,148047,148057,148124,148163,148305,148326,148373,148396,148432,148439,148486,148514,148524,148546,148547,148583,148621,148629,148658,148664,148665,148666,148711,148754,148755,148759,148791,148805,148806,148814,148823,148824,148830,148860,148893,148904,148905,148973,149005,149025,149043,149044,149146,149155,149202,149243,149287,149333,149346,149428,149444,149492,149559,149560,149580,149590,149615,149644,149654,149703,149716,149814,149818,149820,149854,149855,149900,149949,150005,150006,150105,150223,150248,150262,150440,150442,150499,150530,150666,150669,150757,150851,151064,151065,151122,151166,151197,151234,151262,151275,151312,151354,151442,151546,151587,151673,151706,151874,151924,152140,152534,152535,152755,153068,153162,153294,153341,153384,153385,153387,153537,153569,153570,153576,153860,153866,153878,153879,153881,153882,153884,153921,153923,153936,153957,153987,153989,154014,154017,154054,154057,154058,154112,154121,154126,154134,154154,154227,154260,154317,154333,154344,154347,154376,154423,154427,154507,154509,154510,154574,154598,154610,154618,154659,154677,154739,154740,154741,154742,154743,154875,154902,154964,155047,155063,155079,155081,155155,155158,155247,155256,155282,155325,155390,155405,155413,155455,155627,155807,155820,156232,156248,156258,156343,156345,156346,156348,156351,156393,156481,156695,156750,156754,156758,156790,156814,156832,156880,156901,157030,157190,157287,157300,157301,157314,157315,157316,157344,157366,157396,157397,157438,157494,157573,157766,157882,157923,157951,157955,157974,157976,158027,158029,158102,158104,158174,158284,158303,158306,158592,158821,158841,158980,158981,159003,159021,159065,159167,159280,159415,159427,159478,159493,159494,159495,159526,159536,159572,159592,159704,159745,159870,159956,160017,160035,160117,160142,160157,160170,160280,160551,161037,161038,161393,161807,161814,162009,162039,162099,162199,162208,162330,162467,162478,162651,162883,162954,162955,163061,163162,163259,163267,163365,163447,163536,163683,164058,164061,164289,164541,164753,164768,164915,165055,165097,165165,165172,165184,165532,165541,165563,165580,165644,165658,165665,165666,165682,165683,165831,165879,165928,165982,166322,166323,166455,166456,166462,166463,166465,166466,166487,166548,166558,166585,166586,166587,166596,166598,166666,166679,166680,166683,166684,166685,166695,166703,166710,166776,166785,166786,166788,166790,166797,166871,166898,166903,166923,166935,166973,167037,167132,167141,167172,167175,167207,167240,167368,167492,167693,167835,167858,167861,167862,167894,167941,167942,167956,167957,168086,168088,168173,168232,168330,168334,168410,168423,168428,168429,168430,168480,168539,168564,168611,168633,168697,168805,168933,168934,168996,168998,169056,169059,169063,169194,169298,169324,169328,169337,169357,169375,169529,169631,169809,169892,169907,169920,169924,169927,169931,169932,170015,170017,170096,170170,170171,170310,170353,170503,170596,170628,170629,170720,170820,170905,171062,171137,171186,171204,171205,171223,171225,171240,171247,171419,171422,171478,171479,171537,171711,171775,171932,171934,171935,171936,171937,171939,171940,172050,172116,172117,172266,172285,172305,172338,172388,172466,172534,172629,172682,172773,172808,172824,172835,172845,172873,172891,172925,172926,172931,172933,172934,172935,172957,173104,173113,173221,173240,173242,173252,173288,173290,173297,173298,173302,173323,173369,173469,173478,173519,173523,173603,173617,173751,173753,173763,173846,173881,174045,174096,174288,174321,174474,174495,174501,174505,174527,174529,174556,174603,174604,174608,174635,174637,175002,175217,175297,175430,175437,175506,175529,175537,175619,175656,175665,175673,175740,175741,175749,175759,175911,175949,175990,176018,176197,176253,176294,176315,176391,176394,176408,176468,176472,176491,176506,176512,176514,176661,176688,176775,176868,176964,177046,177054,177099,177119,177140,177180,177181,177297,177304,177305,177385,177393,177394,177454,177563,177589,177591,177592,177600,177657,177669,177831,177836,177911,178260,178327,178332,178347,178375,178398,178481,178556,178569,178570,178601,178604,178742,178823,179012,179212,179214,179313,179332,179410,179458,179523,179530,179542,179559,179694,179734,179915,179921,179977,179997,180027,180129,180139,180152,180355,180485,180488,180542,180560,180584,180726,180760,180761,180884,180954,181004,181021,181022,181126,181274,181303,181306,181328,181329,181365,181378,181380,181486,181534,181545,181649,181789,181797,181821,181849,181850,181852,181919,181950,182019,182022,182089,182144,182223,182244,182258,182441,182460,182688,182689,182696,182707,182852,182853,183057,183070,183100,183101,183103,183107,183185,183204,183250,183256,183307,183308,183429,183434,183474,183648,183653,183682,183684,183685,183686,183694,183761,183769,184043,184130,184280,184283,184342,184386,184514,184535,184560,184637,184660,184755,184819,184822,184843,184915,184927,184951,184952,184970,185117,185121,185127,185181,185352,185358,185359,185427,185429,185438,185459,185480,185540,185626,185710,185711,185731,185752,185754,185776,185780,185782,185790,185835,185842,185864,185958,185965,185968,186055,186183,186197,186199,186209,186287,186337,186339,186363,186413,186541,186544,186591,186594,186630,186680,186729,186772,186797,186842,186860,186861,186862,186919,186928,186984,187012,187063,187085,187127,187135,187192,187202,187320,187350,187507,187523,187590,187636,187683,187731,187800,187833,187852,187988,188006,188064,188073,188124,188255,188400,188417,188467,188477,188516,188541,188604,188605,188642,188655,188730,188779,188831,188855,188914,188934,188981,188982,189137,189218,189276,189277,189328,189382,189383,189392,189429,189463,189514,189639,189717,189719,189760,189763,189766,189775,189784,189873,190162,190199,190201,190248,190249,190253,190300,190429,190578,190989,190993,191002,191012,191015,191128,191185,191189,191194,191197,191198,191207,191212,191263,191412,191451,191507,191540,191562,191565,191580,191676,191726,191808,191812,191813,191865,191938,192084,192176,192278,192359,192507,192583,192644,192650,192780,192787,192847,192978,193014,193027,193040,193204,193207,193266,193270,193393,193401,193457,193583,193710,193711,193823,193979,193996,194004,194054,194057,194074,194093,194100,194160,194242,194409,194696,194754,194789,194840,194841,194847,194894,194901,194987,195445,195787,195952,195965,196091,196113,196236,196284,196337,196374,196544,196724,196752) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 77 | Creole | executeQuery(): [27.01 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 (20435,22555,22556,22565,22579,22580,22617,22670,22688,22701,22705,22724,22734,22735,22835,22849,22854,22877,22885,22896,22974,22975,22979,22980,22981,22982,23078,23200,23223,23229,23314,23387,23393,23444,23445,23446,23452,23523,23539,23549,23557,23601,23831,23842,23858,23916,24098,24099,24102,24106,24160,24191,24518,24936,25016,25134,25154,25494,25571,25804,25891,26023,26192,26283,26371,26445,26591,26782,27020,28332,29619,29966,30553,30592,31921,32015,32113,33153,33154,34024,34025,34382,34491,34492,35086,35303,35447,35736,36988,36990,37107,38995,39688,39709,41934,41999,42590,43117,43321,43920,43921,44062,44423,44480,44557,45497,45678,46323,46987,47125,47593,48384,48462,48883,48884,49493,49895,50790,50791,50812,51136,51651,51652,52045,52059,52433,53140,53141,53643,53644,53645,53683,53807,54245,55368,55826,55831,55835,55836,55845,55856,55859,55870,55892,55896,55899,55958,55964,55965,55966,55967,55975,55976,56142,56143,56159,56169,56170,56171,56172,56173,56174,56190,56191,56192,56193,56194,56222,56223,56251,56252,56377,56378,56379,56380,56381,56576,56577,56578,56579,56580,56759,56767,56768,56804,56810,56817,56885,56898,56901,56902,56933,56948,57037,57038,57039,57040,57052,57053,57054,57055,57056,57057,57058,57059,57061,57062,57063,57064,57065,57078,57079,57080,57103,57114,57115,57135,57283,57284,57285,57286,57287,57288,57304,57309,57367,57382,57486,57501,57502,57639,57646,57647,57657,57681,57743,57754,57762,57765,57770,57775,57790,57806,57812,57814,58228,58229,58230,58231,58232,58233,58250,58288,58306,58307,58349,58366,58397,58398,58564,58565,58566,58567,58586,58587,58588,58589,58601,58602,58603,58604,58605,58606,58626,58638,58653,58661,58662,58681,58689,58699,58700,58713,58742,58771,58817,59040,59411,59432,59440,59462,59546,59994,59995,59996,60081,60192,60262,60263,60665,60666,60758,60783,60784,60785,60786,60824,60828,60834,60990,60994,61016,61017,61074,61408,61483,61502,61548,61552,61659,61856,62111,62162,62235,62258,62428,62872,62928,62945,63013,63138,63193,63196,63198,63202,63713,63718,63737,63768,63779,63886,64442,64446,64510,64730,65057,65064,65149,65150,65161,65266,65502,65707,65733,65748,65792,65838,66376,66387,66402,66929,66984,67763,67825,67931,67950,67994,68647,68739,69541,69547,69621,70093,70111,70112,70420,70425,70426,70453,70540,70998,71280,71296,71818,72061,72068,72606,72710,72771,72867,72869,72972,73415,73440,73716,73718,74374,74377,74388,74537,74539,74540,74541,75000,75052,75264,75273,75346,75828,75851,75895,76113,76668,76920,76996,76997,77009,77021,77022,77023,77386,77636,77660,77682,77687,77689,77690,78221,78223,78225,78226,78236,78286,78288,78289,78290,78294,78309,78345,78383,78384,78385,78387,78388,78600,78601,78602,78604,78606,78617,78691,78692,78707,78710,78794,78811,80470,80913,81244,81255,81257,81263,81335,81494,81853,81858,81871,81893,81900,81986,82427,82449,82492,82509,82516,82952,82959,82975,83026,83035,83042,83084,83123,83125,83250,83251,83266,83591,84109,84114,84301,84594,84782,84786,85150,85295,85333,85342,85393,85394,85481,85482,85673,85725,85730,85763,85885,85964,85970,86047,86143,86296,86442,86546,86551,86582,86593,86834,87022,87155,87162,87166,87270,87839,87841,87846,87924,88053,88067,88081,88442,88472,88473,88479,88748,88937,89017,89018,89019,89060,89065,89066,89067,89114,89460,89472,89519,89632,90139,90175,90314,90704,90736,90793,91056,91108,91735,91755,91814,91849,92186,92202,92220,92874,93008,93010,93525,93530,93721,93946,94166,94995,95004,95015,95018,95019,95086,95244,95365,95370,95585,95636,95681,95701,95734,95735,95785,95879,95892,95894,96037,96169,96178,97812,97816,97855,98067,98187,98353,98409,98706,98713,98714,98768,98769,98771,98984,99381,100007,100008,100041,100063,100440,100553,100574,100575,100576,100776,100793,100816,100879,101136,101357,101358,101502,101721,101729,102211,102232,102329,102376,102400,102412,102420,102670,102743,102760,102999,103103,103107,103108,103253,103411,103413,103763,103764,103804,103866,103870,103873,104183,104444,104473,104477,104777,104919,105004,105006,105220,105222,105296,105303,105306,105307,105308,105309,105310,105320,105341,105353,105366,105425,105519,105521,105528,105606,105774,105836,105849,105892,105909,105911,106010,106127,106128,106258,106259,106260,106386,106388,106389,106475,106481,106569,106571,106582,106584,106596,106680,106681,106701,106780,106844,106853,106854,106855,107043,107110,107123,107124,107128,107174,107176,107177,107201,107249,107260,107322,107337,107404,107411,108058,108059,108060,108061,108076,108077,108085,108086,108087,108088,108089,108090,108091,108092,108093,108094,108095,108112,108141,108223,108257,108261,108262,108263,108358,108362,108518,108538,108539,108542,108543,108549,108550,108637,108709,108710,109053,109065,109209,109393,109584,109588,109592,109609,109610,109613,109678,109685,109729,109894,109931,109935,109947,109949,109951,109953,109955,109958,109961,110114,110115,110116,110117,110222,110229,110241,110250,110257,110263,110265,110272,110294,110307,110308,110309,110310,110311,110312,110378,110455,110564,110658,110731,110740,110832,110886,110888,110889,110897,110925,110964,111006,111009,111012,111017,111106,111233,111260,111317,111618,111730,112140,112507,112519,112525,112765,112784,112785,112806,112834,112954,113082,113290,113295,113299,113391,113393,113492,113575,113592,113615,113653,113663,113680,113857,113858,113859,113870,113953,113954,113957,114018,114126,114130,114172,114224,114255,114258,114474,114481,114493,114507,114508,114529,114530,114551,114573,114814,114821,114825,114828,114872,114878,114903,114937,114938,114939,114965,114989,114990,114991,114995,115013,115022,115166,115167,115168,115175,115180,115214,115218,115223,115231,115338,115345,115494,115503,115518,115694,115710,115721,115724,115732,115804,115832,116033,116061,116064,116067,116073,116088,116124,116135,116151,116152,116154,116158,116163,116164,116234,116385,116393,116404,116413,116444,116458,116512,116516,116586,116628,116640,116768,116777,116778,116780,116848,116946,116951,116952,116960,116985,117214,117216,117301,117317,117368,117450,117451,117456,117564,117572,117617,117667,117756,117842,117856,117902,117916,117926,117981,118056,118287,118381,118382,118390,118425,118433,118440,118441,118465,118518,118522,118530,118775,118779,118781,118789,118794,118873,118884,119019,119102,119111,119118,119120,119194,119237,119238,119288,119314,119319,119932,119967,120123,120173,120176,120429,120430,120600,120601,120602,120615,120616,120626,120627,120628,120629,120630,120631,120632,120633,120634,120635,120681,120717,120751,120832,120886,120902,121013,121014,121030,121031,121032,121033,121034,121045,121046,121047,121048,121049,121080,121098,121106,121107,121133,121134,121152,121349,121350,121360,121361,121362,121369,121370,121371,121372,121409,121430,121439,121445,121455,121471,121555,121556,121654,121665,121666,121667,121672,121673,121674,121675,121676,121677,121688,121716,121753,121851,122050,122060,122141,122142,122277,122327,122350,122359,122373,122426,122438,122439,122620,122710,122776,122779,122810,122839,122842,122858,122878,122905,122910,123046,123051,123130,123134,123136,123186,123191,123369,123383,123398,123399,123594,123643,123644,123755,123760,123832,123840,123841,123843,123872,123875,123914,123941,123974,124059,124082,124092,124093,124094,124114,124154,124192,124204,124226,124231,124276,124277,124387,125290,125294,125339,125341,125347,125370,125372,125429,125439,125507,125539,125556,125567,125580,125602,125619,125620,125680,125681,125682,125725,125745,125763,125806,125811,125921,125954,125955,125981,125997,125998,126024,126044,126075,126083,126113,126152,126162,126189,126198,126209,126258,126263,126316,126319,126408,126437,126438,126450,126506,126508,126525,126561,126630,126637,126660,126741,126802,126909,126957,126968,126988,126995,127022,127047,127139,127145,127157,127160,127190,127233,127359,127381,127394,127438,127474,127475,127476,127477,127478,127479,127556,127557,127622,127662,127680,127683,127686,127817,127827,127909,127928,127964,127966,128028,128030,128058,128059,128090,128131,128194,128200,128259,128263,128269,128419,128485,128491,128535,128580,128581,128601,128629,128630,128645,128699,128741,128763,128895,128924,128998,129005,129006,129034,129035,129052,129053,129108,129130,129153,129197,129306,129315,129321,129344,130019,130026,130033,130275,130276,130381,130671,130703,130705,130878,131216,131595,131875,131957,131958,132000,132099,132100,132135,132178,132260,132462,132593,132595,132603,132616,132626,132658,132783,132790,132819,132832,133093,133094,133304,133370,133395,133509,133683,133847,134039,134197,134516,135657,136101,136102,136114,136318,136381,136447,136473,136524,136618,136630,136631,136632,136633,136634,136738,136795,136945,136949,136952,136954,136956,136982,137063,137064,137065,137066,137073,137077,137078,137087,137101,137241,137243,137257,137258,137277,137296,137327,137328,137361,137380,137399,137459,137460,137466,137638,137645,137647,137648,137649,137678,137687,137705,137769,137773,137780,137787,137790,137799,137805,137806,137825,137826,137841,137844,137847,137862,138026,138027,138028,138034,138036,138040,138043,138047,138066,138067,138085,138089,138095,138097,138107,138112,138185,138190,138246,138309,138310,138311,138312,138313,138316,138317,138360,138470,138472,138473,138478,138589,138595,138602,138606,138607,138609,138612,138683,138746,138747,138748,138749,138759,138760,138767,138786,138875,138876,138877,139119,139125,139126,139338,139348,139362,139667,139690,139699,139703,139726,139729,139735,139740,139780,140261,140402,140411,140472,140495,140850,140930,140947,141078,141080,141081,141086,141094,141211,141224,141225,141227,141665,141773,141789,141927,141999,142000,142193,142227,142263,142319,142326,142375,142488,142491,142492,142493,142495,142499,142518,142553,142560,142577,142591,142616,142619,142671,142840,142911,142921,143249,143331,143423,143430,143468,143469,143485,143489,143582,143608,143642,143724,143734,143735,143741,143764,143806,143840,143843,143860,143878,143881,143892,143895,143962,143963,143964,143965,143979,144043,144052,144056,144092,144095,144096,144107,144129,144155,144196,144247,144270,144286,144296,144362,144489,144513,144516,144562,144618,144619,144620,144627,144628,144629,144644,144658,144659,144679,144693,144694,144695,144696,144697,144698,144699,144700,144713,144714,144715,144716,144717,144754,144773,144774,144779,144780,144802,144844,144864,144875,144878,144902,144903,144914,144919,144925,144942,144957,145000,145005,145030,145058,145180,145269,145270,145271,145277,145282,145283,145300,145327,145344,145358,145479,145480,145577,145640,145646,145656,145657,145658,145711,145748,145749,145750,145765,145766,145767,145768,145769,145770,145783,145784,145785,145786,145787,145788,145803,145843,145849,145852,145862,145981,146025,146029,146046,146124,146140,146228,146436,146439,146444,146489,146514,146586,146593,146596,146697,146758,146802,146877,146928,146931,146932,146935,147014,147027,147030,147044,147068,147075,147184,147185,147260,147261,147264,147349,147396,147436,147553,147554,147566,147570,147634,147672,147734,147735,147796,147840,147844,147852,147886,148002,148009,148024,148028,148047,148057,148124,148163,148305,148326,148373,148396,148432,148439,148486,148514,148524,148546,148547,148583,148621,148629,148658,148664,148665,148666,148711,148754,148755,148759,148791,148805,148806,148814,148823,148824,148830,148860,148893,148904,148905,148973,149005,149025,149043,149044,149146,149155,149202,149243,149287,149333,149346,149428,149444,149492,149559,149560,149580,149590,149615,149644,149654,149703,149716,149814,149818,149820,149854,149855,149900,149949,150005,150006,150105,150223,150248,150262,150440,150442,150499,150530,150666,150669,150757,150851,151064,151065,151122,151166,151197,151234,151262,151275,151312,151354,151442,151546,151587,151673,151706,151874,151924,152140,152534,152535,152755,153068,153162,153294,153341,153384,153385,153387,153537,153569,153570,153576,153860,153866,153878,153879,153881,153882,153884,153921,153923,153936,153957,153987,153989,154014,154017,154054,154057,154058,154112,154121,154126,154134,154154,154227,154260,154317,154333,154344,154347,154376,154423,154427,154507,154509,154510,154574,154598,154610,154618,154659,154677,154739,154740,154741,154742,154743,154875,154902,154964,155047,155063,155079,155081,155155,155158,155247,155256,155282,155325,155390,155405,155413,155455,155627,155807,155820,156232,156248,156258,156343,156345,156346,156348,156351,156393,156481,156695,156750,156754,156758,156790,156814,156832,156880,156901,157030,157190,157287,157300,157301,157314,157315,157316,157344,157366,157396,157397,157438,157494,157573,157766,157882,157923,157951,157955,157974,157976,158027,158029,158102,158104,158174,158284,158303,158306,158592,158821,158841,158980,158981,159003,159021,159065,159167,159280,159415,159427,159478,159493,159494,159495,159526,159536,159572,159592,159704,159745,159870,159956,160017,160035,160117,160142,160157,160170,160280,160551,161037,161038,161393,161807,161814,162009,162039,162099,162199,162208,162330,162467,162478,162651,162883,162954,162955,163061,163162,163259,163267,163365,163447,163536,163683,164058,164061,164289,164541,164753,164768,164915,165055,165097,165165,165172,165184,165532,165541,165563,165580,165644,165658,165665,165666,165682,165683,165831,165879,165928,165982,166322,166323,166455,166456,166462,166463,166465,166466,166487,166548,166558,166585,166586,166587,166596,166598,166666,166679,166680,166683,166684,166685,166695,166703,166710,166776,166785,166786,166788,166790,166797,166871,166898,166903,166923,166935,166973,167037,167132,167141,167172,167175,167207,167240,167368,167492,167693,167835,167858,167861,167862,167894,167941,167942,167956,167957,168086,168088,168173,168232,168330,168334,168410,168423,168428,168429,168430,168480,168539,168564,168611,168633,168697,168805,168933,168934,168996,168998,169056,169059,169063,169194,169298,169324,169328,169337,169357,169375,169529,169631,169809,169892,169907,169920,169924,169927,169931,169932,170015,170017,170096,170170,170171,170310,170353,170503,170596,170628,170629,170720,170820,170905,171062,171137,171186,171204,171205,171223,171225,171240,171247,171419,171422,171478,171479,171537,171711,171775,171932,171934,171935,171936,171937,171939,171940,172050,172116,172117,172266,172285,172305,172338,172388,172466,172534,172629,172682,172773,172808,172824,172835,172845,172873,172891,172925,172926,172931,172933,172934,172935,172957,173104,173113,173221,173240,173242,173252,173288,173290,173297,173298,173302,173323,173369,173469,173478,173519,173523,173603,173617,173751,173753,173763,173846,173881,174045,174096,174288,174321,174474,174495,174501,174505,174527,174529,174556,174603,174604,174608,174635,174637,175002,175217,175297,175430,175437,175506,175529,175537,175619,175656,175665,175673,175740,175741,175749,175759,175911,175949,175990,176018,176197,176253,176294,176315,176391,176394,176408,176468,176472,176491,176506,176512,176514,176661,176688,176775,176868,176964,177046,177054,177099,177119,177140,177180,177181,177297,177304,177305,177385,177393,177394,177454,177563,177589,177591,177592,177600,177657,177669,177831,177836,177911,178260,178327,178332,178347,178375,178398,178481,178556,178569,178570,178601,178604,178742,178823,179012,179212,179214,179313,179332,179410,179458,179523,179530,179542,179559,179694,179734,179915,179921,179977,179997,180027,180129,180139,180152,180355,180485,180488,180542,180560,180584,180726,180760,180761,180884,180954,181004,181021,181022,181126,181274,181303,181306,181328,181329,181365,181378,181380,181486,181534,181545,181649,181789,181797,181821,181849,181850,181852,181919,181950,182019,182022,182089,182144,182223,182244,182258,182441,182460,182688,182689,182696,182707,182852,182853,183057,183070,183100,183101,183103,183107,183185,183204,183250,183256,183307,183308,183429,183434,183474,183648,183653,183682,183684,183685,183686,183694,183761,183769,184043,184130,184280,184283,184342,184386,184514,184535,184560,184637,184660,184755,184819,184822,184843,184915,184927,184951,184952,184970,185117,185121,185127,185181,185352,185358,185359,185427,185429,185438,185459,185480,185540,185626,185710,185711,185731,185752,185754,185776,185780,185782,185790,185835,185842,185864,185958,185965,185968,186055,186183,186197,186199,186209,186287,186337,186339,186363,186413,186541,186544,186591,186594,186630,186680,186729,186772,186797,186842,186860,186861,186862,186919,186928,186984,187012,187063,187085,187127,187135,187192,187202,187320,187350,187507,187523,187590,187636,187683,187731,187800,187833,187852,187988,188006,188064,188073,188124,188255,188400,188417,188467,188477,188516,188541,188604,188605,188642,188655,188730,188779,188831,188855,188914,188934,188981,188982,189137,189218,189276,189277,189328,189382,189383,189392,189429,189463,189514,189639,189717,189719,189760,189763,189766,189775,189784,189873,190162,190199,190201,190248,190249,190253,190300,190429,190578,190989,190993,191002,191012,191015,191128,191185,191189,191194,191197,191198,191207,191212,191263,191412,191451,191507,191540,191562,191565,191580,191676,191726,191808,191812,191813,191865,191938,192084,192176,192278,192359,192507,192583,192644,192650,192780,192787,192847,192978,193014,193027,193040,193204,193207,193266,193270,193393,193401,193457,193583,193710,193711,193823,193979,193996,194004,194054,194057,194074,194093,194100,194160,194242,194409,194696,194754,194789,194840,194841,194847,194894,194901,194987,195445,195787,195952,195965,196091,196113,196236,196284,196337,196374,196544,196724,196752) 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 (20435,22555,22556,22565,22579,22580,22617,22670,22688,22701,22705,22724,22734,22735,22835,22849,22854,22877,22885,22896,22974,22975,22979,22980,22981,22982,23078,23200,23223,23229,23314,23387,23393,23444,23445,23446,23452,23523,23539,23549,23557,23601,23831,23842,23858,23916,24098,24099,24102,24106,24160,24191,24518,24936,25016,25134,25154,25494,25571,25804,25891,26023,26192,26283,26371,26445,26591,26782,27020,28332,29619,29966,30553,30592,31921,32015,32113,33153,33154,34024,34025,34382,34491,34492,35086,35303,35447,35736,36988,36990,37107,38995,39688,39709,41934,41999,42590,43117,43321,43920,43921,44062,44423,44480,44557,45497,45678,46323,46987,47125,47593,48384,48462,48883,48884,49493,49895,50790,50791,50812,51136,51651,51652,52045,52059,52433,53140,53141,53643,53644,53645,53683,53807,54245,55368,55826,55831,55835,55836,55845,55856,55859,55870,55892,55896,55899,55958,55964,55965,55966,55967,55975,55976,56142,56143,56159,56169,56170,56171,56172,56173,56174,56190,56191,56192,56193,56194,56222,56223,56251,56252,56377,56378,56379,56380,56381,56576,56577,56578,56579,56580,56759,56767,56768,56804,56810,56817,56885,56898,56901,56902,56933,56948,57037,57038,57039,57040,57052,57053,57054,57055,57056,57057,57058,57059,57061,57062,57063,57064,57065,57078,57079,57080,57103,57114,57115,57135,57283,57284,57285,57286,57287,57288,57304,57309,57367,57382,57486,57501,57502,57639,57646,57647,57657,57681,57743,57754,57762,57765,57770,57775,57790,57806,57812,57814,58228,58229,58230,58231,58232,58233,58250,58288,58306,58307,58349,58366,58397,58398,58564,58565,58566,58567,58586,58587,58588,58589,58601,58602,58603,58604,58605,58606,58626,58638,58653,58661,58662,58681,58689,58699,58700,58713,58742,58771,58817,59040,59411,59432,59440,59462,59546,59994,59995,59996,60081,60192,60262,60263,60665,60666,60758,60783,60784,60785,60786,60824,60828,60834,60990,60994,61016,61017,61074,61408,61483,61502,61548,61552,61659,61856,62111,62162,62235,62258,62428,62872,62928,62945,63013,63138,63193,63196,63198,63202,63713,63718,63737,63768,63779,63886,64442,64446,64510,64730,65057,65064,65149,65150,65161,65266,65502,65707,65733,65748,65792,65838,66376,66387,66402,66929,66984,67763,67825,67931,67950,67994,68647,68739,69541,69547,69621,70093,70111,70112,70420,70425,70426,70453,70540,70998,71280,71296,71818,72061,72068,72606,72710,72771,72867,72869,72972,73415,73440,73716,73718,74374,74377,74388,74537,74539,74540,74541,75000,75052,75264,75273,75346,75828,75851,75895,76113,76668,76920,76996,76997,77009,77021,77022,77023,77386,77636,77660,77682,77687,77689,77690,78221,78223,78225,78226,78236,78286,78288,78289,78290,78294,78309,78345,78383,78384,78385,78387,78388,78600,78601,78602,78604,78606,78617,78691,78692,78707,78710,78794,78811,80470,80913,81244,81255,81257,81263,81335,81494,81853,81858,81871,81893,81900,81986,82427,82449,82492,82509,82516,82952,82959,82975,83026,83035,83042,83084,83123,83125,83250,83251,83266,83591,84109,84114,84301,84594,84782,84786,85150,85295,85333,85342,85393,85394,85481,85482,85673,85725,85730,85763,85885,85964,85970,86047,86143,86296,86442,86546,86551,86582,86593,86834,87022,87155,87162,87166,87270,87839,87841,87846,87924,88053,88067,88081,88442,88472,88473,88479,88748,88937,89017,89018,89019,89060,89065,89066,89067,89114,89460,89472,89519,89632,90139,90175,90314,90704,90736,90793,91056,91108,91735,91755,91814,91849,92186,92202,92220,92874,93008,93010,93525,93530,93721,93946,94166,94995,95004,95015,95018,95019,95086,95244,95365,95370,95585,95636,95681,95701,95734,95735,95785,95879,95892,95894,96037,96169,96178,97812,97816,97855,98067,98187,98353,98409,98706,98713,98714,98768,98769,98771,98984,99381,100007,100008,100041,100063,100440,100553,100574,100575,100576,100776,100793,100816,100879,101136,101357,101358,101502,101721,101729,102211,102232,102329,102376,102400,102412,102420,102670,102743,102760,102999,103103,103107,103108,103253,103411,103413,103763,103764,103804,103866,103870,103873,104183,104444,104473,104477,104777,104919,105004,105006,105220,105222,105296,105303,105306,105307,105308,105309,105310,105320,105341,105353,105366,105425,105519,105521,105528,105606,105774,105836,105849,105892,105909,105911,106010,106127,106128,106258,106259,106260,106386,106388,106389,106475,106481,106569,106571,106582,106584,106596,106680,106681,106701,106780,106844,106853,106854,106855,107043,107110,107123,107124,107128,107174,107176,107177,107201,107249,107260,107322,107337,107404,107411,108058,108059,108060,108061,108076,108077,108085,108086,108087,108088,108089,108090,108091,108092,108093,108094,108095,108112,108141,108223,108257,108261,108262,108263,108358,108362,108518,108538,108539,108542,108543,108549,108550,108637,108709,108710,109053,109065,109209,109393,109584,109588,109592,109609,109610,109613,109678,109685,109729,109894,109931,109935,109947,109949,109951,109953,109955,109958,109961,110114,110115,110116,110117,110222,110229,110241,110250,110257,110263,110265,110272,110294,110307,110308,110309,110310,110311,110312,110378,110455,110564,110658,110731,110740,110832,110886,110888,110889,110897,110925,110964,111006,111009,111012,111017,111106,111233,111260,111317,111618,111730,112140,112507,112519,112525,112765,112784,112785,112806,112834,112954,113082,113290,113295,113299,113391,113393,113492,113575,113592,113615,113653,113663,113680,113857,113858,113859,113870,113953,113954,113957,114018,114126,114130,114172,114224,114255,114258,114474,114481,114493,114507,114508,114529,114530,114551,114573,114814,114821,114825,114828,114872,114878,114903,114937,114938,114939,114965,114989,114990,114991,114995,115013,115022,115166,115167,115168,115175,115180,115214,115218,115223,115231,115338,115345,115494,115503,115518,115694,115710,115721,115724,115732,115804,115832,116033,116061,116064,116067,116073,116088,116124,116135,116151,116152,116154,116158,116163,116164,116234,116385,116393,116404,116413,116444,116458,116512,116516,116586,116628,116640,116768,116777,116778,116780,116848,116946,116951,116952,116960,116985,117214,117216,117301,117317,117368,117450,117451,117456,117564,117572,117617,117667,117756,117842,117856,117902,117916,117926,117981,118056,118287,118381,118382,118390,118425,118433,118440,118441,118465,118518,118522,118530,118775,118779,118781,118789,118794,118873,118884,119019,119102,119111,119118,119120,119194,119237,119238,119288,119314,119319,119932,119967,120123,120173,120176,120429,120430,120600,120601,120602,120615,120616,120626,120627,120628,120629,120630,120631,120632,120633,120634,120635,120681,120717,120751,120832,120886,120902,121013,121014,121030,121031,121032,121033,121034,121045,121046,121047,121048,121049,121080,121098,121106,121107,121133,121134,121152,121349,121350,121360,121361,121362,121369,121370,121371,121372,121409,121430,121439,121445,121455,121471,121555,121556,121654,121665,121666,121667,121672,121673,121674,121675,121676,121677,121688,121716,121753,121851,122050,122060,122141,122142,122277,122327,122350,122359,122373,122426,122438,122439,122620,122710,122776,122779,122810,122839,122842,122858,122878,122905,122910,123046,123051,123130,123134,123136,123186,123191,123369,123383,123398,123399,123594,123643,123644,123755,123760,123832,123840,123841,123843,123872,123875,123914,123941,123974,124059,124082,124092,124093,124094,124114,124154,124192,124204,124226,124231,124276,124277,124387,125290,125294,125339,125341,125347,125370,125372,125429,125439,125507,125539,125556,125567,125580,125602,125619,125620,125680,125681,125682,125725,125745,125763,125806,125811,125921,125954,125955,125981,125997,125998,126024,126044,126075,126083,126113,126152,126162,126189,126198,126209,126258,126263,126316,126319,126408,126437,126438,126450,126506,126508,126525,126561,126630,126637,126660,126741,126802,126909,126957,126968,126988,126995,127022,127047,127139,127145,127157,127160,127190,127233,127359,127381,127394,127438,127474,127475,127476,127477,127478,127479,127556,127557,127622,127662,127680,127683,127686,127817,127827,127909,127928,127964,127966,128028,128030,128058,128059,128090,128131,128194,128200,128259,128263,128269,128419,128485,128491,128535,128580,128581,128601,128629,128630,128645,128699,128741,128763,128895,128924,128998,129005,129006,129034,129035,129052,129053,129108,129130,129153,129197,129306,129315,129321,129344,130019,130026,130033,130275,130276,130381,130671,130703,130705,130878,131216,131595,131875,131957,131958,132000,132099,132100,132135,132178,132260,132462,132593,132595,132603,132616,132626,132658,132783,132790,132819,132832,133093,133094,133304,133370,133395,133509,133683,133847,134039,134197,134516,135657,136101,136102,136114,136318,136381,136447,136473,136524,136618,136630,136631,136632,136633,136634,136738,136795,136945,136949,136952,136954,136956,136982,137063,137064,137065,137066,137073,137077,137078,137087,137101,137241,137243,137257,137258,137277,137296,137327,137328,137361,137380,137399,137459,137460,137466,137638,137645,137647,137648,137649,137678,137687,137705,137769,137773,137780,137787,137790,137799,137805,137806,137825,137826,137841,137844,137847,137862,138026,138027,138028,138034,138036,138040,138043,138047,138066,138067,138085,138089,138095,138097,138107,138112,138185,138190,138246,138309,138310,138311,138312,138313,138316,138317,138360,138470,138472,138473,138478,138589,138595,138602,138606,138607,138609,138612,138683,138746,138747,138748,138749,138759,138760,138767,138786,138875,138876,138877,139119,139125,139126,139338,139348,139362,139667,139690,139699,139703,139726,139729,139735,139740,139780,140261,140402,140411,140472,140495,140850,140930,140947,141078,141080,141081,141086,141094,141211,141224,141225,141227,141665,141773,141789,141927,141999,142000,142193,142227,142263,142319,142326,142375,142488,142491,142492,142493,142495,142499,142518,142553,142560,142577,142591,142616,142619,142671,142840,142911,142921,143249,143331,143423,143430,143468,143469,143485,143489,143582,143608,143642,143724,143734,143735,143741,143764,143806,143840,143843,143860,143878,143881,143892,143895,143962,143963,143964,143965,143979,144043,144052,144056,144092,144095,144096,144107,144129,144155,144196,144247,144270,144286,144296,144362,144489,144513,144516,144562,144618,144619,144620,144627,144628,144629,144644,144658,144659,144679,144693,144694,144695,144696,144697,144698,144699,144700,144713,144714,144715,144716,144717,144754,144773,144774,144779,144780,144802,144844,144864,144875,144878,144902,144903,144914,144919,144925,144942,144957,145000,145005,145030,145058,145180,145269,145270,145271,145277,145282,145283,145300,145327,145344,145358,145479,145480,145577,145640,145646,145656,145657,145658,145711,145748,145749,145750,145765,145766,145767,145768,145769,145770,145783,145784,145785,145786,145787,145788,145803,145843,145849,145852,145862,145981,146025,146029,146046,146124,146140,146228,146436,146439,146444,146489,146514,146586,146593,146596,146697,146758,146802,146877,146928,146931,146932,146935,147014,147027,147030,147044,147068,147075,147184,147185,147260,147261,147264,147349,147396,147436,147553,147554,147566,147570,147634,147672,147734,147735,147796,147840,147844,147852,147886,148002,148009,148024,148028,148047,148057,148124,148163,148305,148326,148373,148396,148432,148439,148486,148514,148524,148546,148547,148583,148621,148629,148658,148664,148665,148666,148711,148754,148755,148759,148791,148805,148806,148814,148823,148824,148830,148860,148893,148904,148905,148973,149005,149025,149043,149044,149146,149155,149202,149243,149287,149333,149346,149428,149444,149492,149559,149560,149580,149590,149615,149644,149654,149703,149716,149814,149818,149820,149854,149855,149900,149949,150005,150006,150105,150223,150248,150262,150440,150442,150499,150530,150666,150669,150757,150851,151064,151065,151122,151166,151197,151234,151262,151275,151312,151354,151442,151546,151587,151673,151706,151874,151924,152140,152534,152535,152755,153068,153162,153294,153341,153384,153385,153387,153537,153569,153570,153576,153860,153866,153878,153879,153881,153882,153884,153921,153923,153936,153957,153987,153989,154014,154017,154054,154057,154058,154112,154121,154126,154134,154154,154227,154260,154317,154333,154344,154347,154376,154423,154427,154507,154509,154510,154574,154598,154610,154618,154659,154677,154739,154740,154741,154742,154743,154875,154902,154964,155047,155063,155079,155081,155155,155158,155247,155256,155282,155325,155390,155405,155413,155455,155627,155807,155820,156232,156248,156258,156343,156345,156346,156348,156351,156393,156481,156695,156750,156754,156758,156790,156814,156832,156880,156901,157030,157190,157287,157300,157301,157314,157315,157316,157344,157366,157396,157397,157438,157494,157573,157766,157882,157923,157951,157955,157974,157976,158027,158029,158102,158104,158174,158284,158303,158306,158592,158821,158841,158980,158981,159003,159021,159065,159167,159280,159415,159427,159478,159493,159494,159495,159526,159536,159572,159592,159704,159745,159870,159956,160017,160035,160117,160142,160157,160170,160280,160551,161037,161038,161393,161807,161814,162009,162039,162099,162199,162208,162330,162467,162478,162651,162883,162954,162955,163061,163162,163259,163267,163365,163447,163536,163683,164058,164061,164289,164541,164753,164768,164915,165055,165097,165165,165172,165184,165532,165541,165563,165580,165644,165658,165665,165666,165682,165683,165831,165879,165928,165982,166322,166323,166455,166456,166462,166463,166465,166466,166487,166548,166558,166585,166586,166587,166596,166598,166666,166679,166680,166683,166684,166685,166695,166703,166710,166776,166785,166786,166788,166790,166797,166871,166898,166903,166923,166935,166973,167037,167132,167141,167172,167175,167207,167240,167368,167492,167693,167835,167858,167861,167862,167894,167941,167942,167956,167957,168086,168088,168173,168232,168330,168334,168410,168423,168428,168429,168430,168480,168539,168564,168611,168633,168697,168805,168933,168934,168996,168998,169056,169059,169063,169194,169298,169324,169328,169337,169357,169375,169529,169631,169809,169892,169907,169920,169924,169927,169931,169932,170015,170017,170096,170170,170171,170310,170353,170503,170596,170628,170629,170720,170820,170905,171062,171137,171186,171204,171205,171223,171225,171240,171247,171419,171422,171478,171479,171537,171711,171775,171932,171934,171935,171936,171937,171939,171940,172050,172116,172117,172266,172285,172305,172338,172388,172466,172534,172629,172682,172773,172808,172824,172835,172845,172873,172891,172925,172926,172931,172933,172934,172935,172957,173104,173113,173221,173240,173242,173252,173288,173290,173297,173298,173302,173323,173369,173469,173478,173519,173523,173603,173617,173751,173753,173763,173846,173881,174045,174096,174288,174321,174474,174495,174501,174505,174527,174529,174556,174603,174604,174608,174635,174637,175002,175217,175297,175430,175437,175506,175529,175537,175619,175656,175665,175673,175740,175741,175749,175759,175911,175949,175990,176018,176197,176253,176294,176315,176391,176394,176408,176468,176472,176491,176506,176512,176514,176661,176688,176775,176868,176964,177046,177054,177099,177119,177140,177180,177181,177297,177304,177305,177385,177393,177394,177454,177563,177589,177591,177592,177600,177657,177669,177831,177836,177911,178260,178327,178332,178347,178375,178398,178481,178556,178569,178570,178601,178604,178742,178823,179012,179212,179214,179313,179332,179410,179458,179523,179530,179542,179559,179694,179734,179915,179921,179977,179997,180027,180129,180139,180152,180355,180485,180488,180542,180560,180584,180726,180760,180761,180884,180954,181004,181021,181022,181126,181274,181303,181306,181328,181329,181365,181378,181380,181486,181534,181545,181649,181789,181797,181821,181849,181850,181852,181919,181950,182019,182022,182089,182144,182223,182244,182258,182441,182460,182688,182689,182696,182707,182852,182853,183057,183070,183100,183101,183103,183107,183185,183204,183250,183256,183307,183308,183429,183434,183474,183648,183653,183682,183684,183685,183686,183694,183761,183769,184043,184130,184280,184283,184342,184386,184514,184535,184560,184637,184660,184755,184819,184822,184843,184915,184927,184951,184952,184970,185117,185121,185127,185181,185352,185358,185359,185427,185429,185438,185459,185480,185540,185626,185710,185711,185731,185752,185754,185776,185780,185782,185790,185835,185842,185864,185958,185965,185968,186055,186183,186197,186199,186209,186287,186337,186339,186363,186413,186541,186544,186591,186594,186630,186680,186729,186772,186797,186842,186860,186861,186862,186919,186928,186984,187012,187063,187085,187127,187135,187192,187202,187320,187350,187507,187523,187590,187636,187683,187731,187800,187833,187852,187988,188006,188064,188073,188124,188255,188400,188417,188467,188477,188516,188541,188604,188605,188642,188655,188730,188779,188831,188855,188914,188934,188981,188982,189137,189218,189276,189277,189328,189382,189383,189392,189429,189463,189514,189639,189717,189719,189760,189763,189766,189775,189784,189873,190162,190199,190201,190248,190249,190253,190300,190429,190578,190989,190993,191002,191012,191015,191128,191185,191189,191194,191197,191198,191207,191212,191263,191412,191451,191507,191540,191562,191565,191580,191676,191726,191808,191812,191813,191865,191938,192084,192176,192278,192359,192507,192583,192644,192650,192780,192787,192847,192978,193014,193027,193040,193204,193207,193266,193270,193393,193401,193457,193583,193710,193711,193823,193979,193996,194004,194054,194057,194074,194093,194100,194160,194242,194409,194696,194754,194789,194840,194841,194847,194894,194901,194987,195445,195787,195952,195965,196091,196113,196236,196284,196337,196374,196544,196724,196752) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 79 | Creole | executeQuery(): [36.57 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 (20435,22555,22556,22565,22579,22580,22617,22670,22688,22701,22705,22724,22734,22735,22835,22849,22854,22877,22885,22896,22974,22975,22979,22980,22981,22982,23078,23200,23223,23229,23314,23387,23393,23444,23445,23446,23452,23523,23539,23549,23557,23601,23831,23842,23858,23916,24098,24099,24102,24106,24160,24191,24518,24936,25016,25134,25154,25494,25571,25804,25891,26023,26192,26283,26371,26445,26591,26782,27020,28332,29619,29966,30553,30592,31921,32015,32113,33153,33154,34024,34025,34382,34491,34492,35086,35303,35447,35736,36988,36990,37107,38995,39688,39709,41934,41999,42590,43117,43321,43920,43921,44062,44423,44480,44557,45497,45678,46323,46987,47125,47593,48384,48462,48883,48884,49493,49895,50790,50791,50812,51136,51651,51652,52045,52059,52433,53140,53141,53643,53644,53645,53683,53807,54245,55368,55826,55831,55835,55836,55845,55856,55859,55870,55892,55896,55899,55958,55964,55965,55966,55967,55975,55976,56142,56143,56159,56169,56170,56171,56172,56173,56174,56190,56191,56192,56193,56194,56222,56223,56251,56252,56377,56378,56379,56380,56381,56576,56577,56578,56579,56580,56759,56767,56768,56804,56810,56817,56885,56898,56901,56902,56933,56948,57037,57038,57039,57040,57052,57053,57054,57055,57056,57057,57058,57059,57061,57062,57063,57064,57065,57078,57079,57080,57103,57114,57115,57135,57283,57284,57285,57286,57287,57288,57304,57309,57367,57382,57486,57501,57502,57639,57646,57647,57657,57681,57743,57754,57762,57765,57770,57775,57790,57806,57812,57814,58228,58229,58230,58231,58232,58233,58250,58288,58306,58307,58349,58366,58397,58398,58564,58565,58566,58567,58586,58587,58588,58589,58601,58602,58603,58604,58605,58606,58626,58638,58653,58661,58662,58681,58689,58699,58700,58713,58742,58771,58817,59040,59411,59432,59440,59462,59546,59994,59995,59996,60081,60192,60262,60263,60665,60666,60758,60783,60784,60785,60786,60824,60828,60834,60990,60994,61016,61017,61074,61408,61483,61502,61548,61552,61659,61856,62111,62162,62235,62258,62428,62872,62928,62945,63013,63138,63193,63196,63198,63202,63713,63718,63737,63768,63779,63886,64442,64446,64510,64730,65057,65064,65149,65150,65161,65266,65502,65707,65733,65748,65792,65838,66376,66387,66402,66929,66984,67763,67825,67931,67950,67994,68647,68739,69541,69547,69621,70093,70111,70112,70420,70425,70426,70453,70540,70998,71280,71296,71818,72061,72068,72606,72710,72771,72867,72869,72972,73415,73440,73716,73718,74374,74377,74388,74537,74539,74540,74541,75000,75052,75264,75273,75346,75828,75851,75895,76113,76668,76920,76996,76997,77009,77021,77022,77023,77386,77636,77660,77682,77687,77689,77690,78221,78223,78225,78226,78236,78286,78288,78289,78290,78294,78309,78345,78383,78384,78385,78387,78388,78600,78601,78602,78604,78606,78617,78691,78692,78707,78710,78794,78811,80470,80913,81244,81255,81257,81263,81335,81494,81853,81858,81871,81893,81900,81986,82427,82449,82492,82509,82516,82952,82959,82975,83026,83035,83042,83084,83123,83125,83250,83251,83266,83591,84109,84114,84301,84594,84782,84786,85150,85295,85333,85342,85393,85394,85481,85482,85673,85725,85730,85763,85885,85964,85970,86047,86143,86296,86442,86546,86551,86582,86593,86834,87022,87155,87162,87166,87270,87839,87841,87846,87924,88053,88067,88081,88442,88472,88473,88479,88748,88937,89017,89018,89019,89060,89065,89066,89067,89114,89460,89472,89519,89632,90139,90175,90314,90704,90736,90793,91056,91108,91735,91755,91814,91849,92186,92202,92220,92874,93008,93010,93525,93530,93721,93946,94166,94995,95004,95015,95018,95019,95086,95244,95365,95370,95585,95636,95681,95701,95734,95735,95785,95879,95892,95894,96037,96169,96178,97812,97816,97855,98067,98187,98353,98409,98706,98713,98714,98768,98769,98771,98984,99381,100007,100008,100041,100063,100440,100553,100574,100575,100576,100776,100793,100816,100879,101136,101357,101358,101502,101721,101729,102211,102232,102329,102376,102400,102412,102420,102670,102743,102760,102999,103103,103107,103108,103253,103411,103413,103763,103764,103804,103866,103870,103873,104183,104444,104473,104477,104777,104919,105004,105006,105220,105222,105296,105303,105306,105307,105308,105309,105310,105320,105341,105353,105366,105425,105519,105521,105528,105606,105774,105836,105849,105892,105909,105911,106010,106127,106128,106258,106259,106260,106386,106388,106389,106475,106481,106569,106571,106582,106584,106596,106680,106681,106701,106780,106844,106853,106854,106855,107043,107110,107123,107124,107128,107174,107176,107177,107201,107249,107260,107322,107337,107404,107411,108058,108059,108060,108061,108076,108077,108085,108086,108087,108088,108089,108090,108091,108092,108093,108094,108095,108112,108141,108223,108257,108261,108262,108263,108358,108362,108518,108538,108539,108542,108543,108549,108550,108637,108709,108710,109053,109065,109209,109393,109584,109588,109592,109609,109610,109613,109678,109685,109729,109894,109931,109935,109947,109949,109951,109953,109955,109958,109961,110114,110115,110116,110117,110222,110229,110241,110250,110257,110263,110265,110272,110294,110307,110308,110309,110310,110311,110312,110378,110455,110564,110658,110731,110740,110832,110886,110888,110889,110897,110925,110964,111006,111009,111012,111017,111106,111233,111260,111317,111618,111730,112140,112507,112519,112525,112765,112784,112785,112806,112834,112954,113082,113290,113295,113299,113391,113393,113492,113575,113592,113615,113653,113663,113680,113857,113858,113859,113870,113953,113954,113957,114018,114126,114130,114172,114224,114255,114258,114474,114481,114493,114507,114508,114529,114530,114551,114573,114814,114821,114825,114828,114872,114878,114903,114937,114938,114939,114965,114989,114990,114991,114995,115013,115022,115166,115167,115168,115175,115180,115214,115218,115223,115231,115338,115345,115494,115503,115518,115694,115710,115721,115724,115732,115804,115832,116033,116061,116064,116067,116073,116088,116124,116135,116151,116152,116154,116158,116163,116164,116234,116385,116393,116404,116413,116444,116458,116512,116516,116586,116628,116640,116768,116777,116778,116780,116848,116946,116951,116952,116960,116985,117214,117216,117301,117317,117368,117450,117451,117456,117564,117572,117617,117667,117756,117842,117856,117902,117916,117926,117981,118056,118287,118381,118382,118390,118425,118433,118440,118441,118465,118518,118522,118530,118775,118779,118781,118789,118794,118873,118884,119019,119102,119111,119118,119120,119194,119237,119238,119288,119314,119319,119932,119967,120123,120173,120176,120429,120430,120600,120601,120602,120615,120616,120626,120627,120628,120629,120630,120631,120632,120633,120634,120635,120681,120717,120751,120832,120886,120902,121013,121014,121030,121031,121032,121033,121034,121045,121046,121047,121048,121049,121080,121098,121106,121107,121133,121134,121152,121349,121350,121360,121361,121362,121369,121370,121371,121372,121409,121430,121439,121445,121455,121471,121555,121556,121654,121665,121666,121667,121672,121673,121674,121675,121676,121677,121688,121716,121753,121851,122050,122060,122141,122142,122277,122327,122350,122359,122373,122426,122438,122439,122620,122710,122776,122779,122810,122839,122842,122858,122878,122905,122910,123046,123051,123130,123134,123136,123186,123191,123369,123383,123398,123399,123594,123643,123644,123755,123760,123832,123840,123841,123843,123872,123875,123914,123941,123974,124059,124082,124092,124093,124094,124114,124154,124192,124204,124226,124231,124276,124277,124387,125290,125294,125339,125341,125347,125370,125372,125429,125439,125507,125539,125556,125567,125580,125602,125619,125620,125680,125681,125682,125725,125745,125763,125806,125811,125921,125954,125955,125981,125997,125998,126024,126044,126075,126083,126113,126152,126162,126189,126198,126209,126258,126263,126316,126319,126408,126437,126438,126450,126506,126508,126525,126561,126630,126637,126660,126741,126802,126909,126957,126968,126988,126995,127022,127047,127139,127145,127157,127160,127190,127233,127359,127381,127394,127438,127474,127475,127476,127477,127478,127479,127556,127557,127622,127662,127680,127683,127686,127817,127827,127909,127928,127964,127966,128028,128030,128058,128059,128090,128131,128194,128200,128259,128263,128269,128419,128485,128491,128535,128580,128581,128601,128629,128630,128645,128699,128741,128763,128895,128924,128998,129005,129006,129034,129035,129052,129053,129108,129130,129153,129197,129306,129315,129321,129344,130019,130026,130033,130275,130276,130381,130671,130703,130705,130878,131216,131595,131875,131957,131958,132000,132099,132100,132135,132178,132260,132462,132593,132595,132603,132616,132626,132658,132783,132790,132819,132832,133093,133094,133304,133370,133395,133509,133683,133847,134039,134197,134516,135657,136101,136102,136114,136318,136381,136447,136473,136524,136618,136630,136631,136632,136633,136634,136738,136795,136945,136949,136952,136954,136956,136982,137063,137064,137065,137066,137073,137077,137078,137087,137101,137241,137243,137257,137258,137277,137296,137327,137328,137361,137380,137399,137459,137460,137466,137638,137645,137647,137648,137649,137678,137687,137705,137769,137773,137780,137787,137790,137799,137805,137806,137825,137826,137841,137844,137847,137862,138026,138027,138028,138034,138036,138040,138043,138047,138066,138067,138085,138089,138095,138097,138107,138112,138185,138190,138246,138309,138310,138311,138312,138313,138316,138317,138360,138470,138472,138473,138478,138589,138595,138602,138606,138607,138609,138612,138683,138746,138747,138748,138749,138759,138760,138767,138786,138875,138876,138877,139119,139125,139126,139338,139348,139362,139667,139690,139699,139703,139726,139729,139735,139740,139780,140261,140402,140411,140472,140495,140850,140930,140947,141078,141080,141081,141086,141094,141211,141224,141225,141227,141665,141773,141789,141927,141999,142000,142193,142227,142263,142319,142326,142375,142488,142491,142492,142493,142495,142499,142518,142553,142560,142577,142591,142616,142619,142671,142840,142911,142921,143249,143331,143423,143430,143468,143469,143485,143489,143582,143608,143642,143724,143734,143735,143741,143764,143806,143840,143843,143860,143878,143881,143892,143895,143962,143963,143964,143965,143979,144043,144052,144056,144092,144095,144096,144107,144129,144155,144196,144247,144270,144286,144296,144362,144489,144513,144516,144562,144618,144619,144620,144627,144628,144629,144644,144658,144659,144679,144693,144694,144695,144696,144697,144698,144699,144700,144713,144714,144715,144716,144717,144754,144773,144774,144779,144780,144802,144844,144864,144875,144878,144902,144903,144914,144919,144925,144942,144957,145000,145005,145030,145058,145180,145269,145270,145271,145277,145282,145283,145300,145327,145344,145358,145479,145480,145577,145640,145646,145656,145657,145658,145711,145748,145749,145750,145765,145766,145767,145768,145769,145770,145783,145784,145785,145786,145787,145788,145803,145843,145849,145852,145862,145981,146025,146029,146046,146124,146140,146228,146436,146439,146444,146489,146514,146586,146593,146596,146697,146758,146802,146877,146928,146931,146932,146935,147014,147027,147030,147044,147068,147075,147184,147185,147260,147261,147264,147349,147396,147436,147553,147554,147566,147570,147634,147672,147734,147735,147796,147840,147844,147852,147886,148002,148009,148024,148028,148047,148057,148124,148163,148305,148326,148373,148396,148432,148439,148486,148514,148524,148546,148547,148583,148621,148629,148658,148664,148665,148666,148711,148754,148755,148759,148791,148805,148806,148814,148823,148824,148830,148860,148893,148904,148905,148973,149005,149025,149043,149044,149146,149155,149202,149243,149287,149333,149346,149428,149444,149492,149559,149560,149580,149590,149615,149644,149654,149703,149716,149814,149818,149820,149854,149855,149900,149949,150005,150006,150105,150223,150248,150262,150440,150442,150499,150530,150666,150669,150757,150851,151064,151065,151122,151166,151197,151234,151262,151275,151312,151354,151442,151546,151587,151673,151706,151874,151924,152140,152534,152535,152755,153068,153162,153294,153341,153384,153385,153387,153537,153569,153570,153576,153860,153866,153878,153879,153881,153882,153884,153921,153923,153936,153957,153987,153989,154014,154017,154054,154057,154058,154112,154121,154126,154134,154154,154227,154260,154317,154333,154344,154347,154376,154423,154427,154507,154509,154510,154574,154598,154610,154618,154659,154677,154739,154740,154741,154742,154743,154875,154902,154964,155047,155063,155079,155081,155155,155158,155247,155256,155282,155325,155390,155405,155413,155455,155627,155807,155820,156232,156248,156258,156343,156345,156346,156348,156351,156393,156481,156695,156750,156754,156758,156790,156814,156832,156880,156901,157030,157190,157287,157300,157301,157314,157315,157316,157344,157366,157396,157397,157438,157494,157573,157766,157882,157923,157951,157955,157974,157976,158027,158029,158102,158104,158174,158284,158303,158306,158592,158821,158841,158980,158981,159003,159021,159065,159167,159280,159415,159427,159478,159493,159494,159495,159526,159536,159572,159592,159704,159745,159870,159956,160017,160035,160117,160142,160157,160170,160280,160551,161037,161038,161393,161807,161814,162009,162039,162099,162199,162208,162330,162467,162478,162651,162883,162954,162955,163061,163162,163259,163267,163365,163447,163536,163683,164058,164061,164289,164541,164753,164768,164915,165055,165097,165165,165172,165184,165532,165541,165563,165580,165644,165658,165665,165666,165682,165683,165831,165879,165928,165982,166322,166323,166455,166456,166462,166463,166465,166466,166487,166548,166558,166585,166586,166587,166596,166598,166666,166679,166680,166683,166684,166685,166695,166703,166710,166776,166785,166786,166788,166790,166797,166871,166898,166903,166923,166935,166973,167037,167132,167141,167172,167175,167207,167240,167368,167492,167693,167835,167858,167861,167862,167894,167941,167942,167956,167957,168086,168088,168173,168232,168330,168334,168410,168423,168428,168429,168430,168480,168539,168564,168611,168633,168697,168805,168933,168934,168996,168998,169056,169059,169063,169194,169298,169324,169328,169337,169357,169375,169529,169631,169809,169892,169907,169920,169924,169927,169931,169932,170015,170017,170096,170170,170171,170310,170353,170503,170596,170628,170629,170720,170820,170905,171062,171137,171186,171204,171205,171223,171225,171240,171247,171419,171422,171478,171479,171537,171711,171775,171932,171934,171935,171936,171937,171939,171940,172050,172116,172117,172266,172285,172305,172338,172388,172466,172534,172629,172682,172773,172808,172824,172835,172845,172873,172891,172925,172926,172931,172933,172934,172935,172957,173104,173113,173221,173240,173242,173252,173288,173290,173297,173298,173302,173323,173369,173469,173478,173519,173523,173603,173617,173751,173753,173763,173846,173881,174045,174096,174288,174321,174474,174495,174501,174505,174527,174529,174556,174603,174604,174608,174635,174637,175002,175217,175297,175430,175437,175506,175529,175537,175619,175656,175665,175673,175740,175741,175749,175759,175911,175949,175990,176018,176197,176253,176294,176315,176391,176394,176408,176468,176472,176491,176506,176512,176514,176661,176688,176775,176868,176964,177046,177054,177099,177119,177140,177180,177181,177297,177304,177305,177385,177393,177394,177454,177563,177589,177591,177592,177600,177657,177669,177831,177836,177911,178260,178327,178332,178347,178375,178398,178481,178556,178569,178570,178601,178604,178742,178823,179012,179212,179214,179313,179332,179410,179458,179523,179530,179542,179559,179694,179734,179915,179921,179977,179997,180027,180129,180139,180152,180355,180485,180488,180542,180560,180584,180726,180760,180761,180884,180954,181004,181021,181022,181126,181274,181303,181306,181328,181329,181365,181378,181380,181486,181534,181545,181649,181789,181797,181821,181849,181850,181852,181919,181950,182019,182022,182089,182144,182223,182244,182258,182441,182460,182688,182689,182696,182707,182852,182853,183057,183070,183100,183101,183103,183107,183185,183204,183250,183256,183307,183308,183429,183434,183474,183648,183653,183682,183684,183685,183686,183694,183761,183769,184043,184130,184280,184283,184342,184386,184514,184535,184560,184637,184660,184755,184819,184822,184843,184915,184927,184951,184952,184970,185117,185121,185127,185181,185352,185358,185359,185427,185429,185438,185459,185480,185540,185626,185710,185711,185731,185752,185754,185776,185780,185782,185790,185835,185842,185864,185958,185965,185968,186055,186183,186197,186199,186209,186287,186337,186339,186363,186413,186541,186544,186591,186594,186630,186680,186729,186772,186797,186842,186860,186861,186862,186919,186928,186984,187012,187063,187085,187127,187135,187192,187202,187320,187350,187507,187523,187590,187636,187683,187731,187800,187833,187852,187988,188006,188064,188073,188124,188255,188400,188417,188467,188477,188516,188541,188604,188605,188642,188655,188730,188779,188831,188855,188914,188934,188981,188982,189137,189218,189276,189277,189328,189382,189383,189392,189429,189463,189514,189639,189717,189719,189760,189763,189766,189775,189784,189873,190162,190199,190201,190248,190249,190253,190300,190429,190578,190989,190993,191002,191012,191015,191128,191185,191189,191194,191197,191198,191207,191212,191263,191412,191451,191507,191540,191562,191565,191580,191676,191726,191808,191812,191813,191865,191938,192084,192176,192278,192359,192507,192583,192644,192650,192780,192787,192847,192978,193014,193027,193040,193204,193207,193266,193270,193393,193401,193457,193583,193710,193711,193823,193979,193996,194004,194054,194057,194074,194093,194100,194160,194242,194409,194696,194754,194789,194840,194841,194847,194894,194901,194987,195445,195787,195952,195965,196091,196113,196236,196284,196337,196374,196544,196724,196752) 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(): [3045.69 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(): [7.44 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=200014 |
| 108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 109 | Creole | executeQuery(): [6.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199998 |
| 110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 111 | Creole | executeQuery(): [5.87 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199968 |
| 112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 113 | Creole | executeQuery(): [7.79 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199727 |
| 114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 115 | Creole | executeQuery(): [16.88 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199580 |
| 116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 117 | Creole | executeQuery(): [16.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=200020 |
| 118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 119 | Creole | executeQuery(): [9.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=200012 |
| 120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 121 | Creole | executeQuery(): [4.04 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199997 |
| 122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 123 | Creole | executeQuery(): [11.64 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199980 |
| 124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 125 | Creole | executeQuery(): [11.40 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199967 |
| 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
10593.6 KB
3564 ms
