1 | SELECT `Country`.`Code2`, `Country`.`Name` FROM `db13147089-dazz2`.`countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`Name` ASC | | 239 | 239 | 1 |
2 | SELECT COUNT(*) AS `count` FROM `db13147089-dazz2`.`orders` AS `Order` LEFT JOIN `db13147089-dazz2`.`users` AS `User` ON (`Order`.`user_id` = `User`.`id`) WHERE `Order`.`reopen_status` = 1 AND `Order`.`complaint_approve` = 0 | | 1 | 1 | 230 |
3 | SELECT `Notification`.`id`, `Notification`.`notification_text`, `Notification`.`order_id`, `Notification`.`type`, `Notification`.`status`, `Notification`.`user_id`, `Notification`.`created`, `Order`.`id`, `Order`.`crplock`, `Order`.`photogifts`, `Order`.`time_zone`, `Order`.`type`, `Order`.`trackingnumber`, `Order`.`invoice_number`, `Order`.`personello_invoice`, `Order`.`taxrate`, `Order`.`sreetno`, `Order`.`postcode`, `Order`.`vat`, `Order`.`price`, `Order`.`test`, `Order`.`text`, `Order`.`size`, `Order`.`instructions`, `Order`.`isaccepted`, `Order`.`assignedto`, `Order`.`isverify`, `Order`.`curlOrderid`, `Order`.`user_id`, `Order`.`style_id`, `Order`.`voucher_id`, `Order`.`voucher_type`, `Order`.`option_id`, `Order`.`firstname`, `Order`.`lastname`, `Order`.`email`, `Order`.`contactno`, `Order`.`order_date`, `Order`.`order_status`, `Order`.`reopen_reason`, `Order`.`reopen_status`, `Order`.`support_reopen`, `Order`.`support_userid`, `Order`.`download_complete`, `Order`.`desktop_complete`, `Order`.`external_images`, `Order`.`paid`, `Order`.`request`, `Order`.`reason_id`, `Order`.`company_id`, `Order`.`customer_invoice`, `Order`.`payment_gateway_id`, `Order`.`suggested_starttime`, `Order`.`suggested_endtime`, `Order`.`time_spend`, `Order`.`delay_time`, `Order`.`order_start_time`, `Order`.`order_finish_time`, `Order`.`order_estimated_time`, `Order`.`sourcefile`, `Order`.`change_reason`, `Order`.`complaint`, `Order`.`allow_images`, `Order`.`complaint_approve`, `Order`.`client_uploaded`, `Order`.`country`, `Order`.`acknowledgedby`, `Order`.`acknowledged_date`, `Order`.`rejectreason`, `Order`.`order_type`, `Order`.`notify_emails`, `Order`.`template_id`, `Order`.`crp_no`, `Order`.`mcrp_style_on`, `Order`.`photographerid`, `Order`.`crp_created`, `Order`.`clientid`, `Order`.`campaign_id`, `Order`.`is_qa`, `Order`.`rendering`, `Order`.`is_deleted`, `Order`.`deleted_date`, `Order`.`returnkeyword`, `Order`.`created` FROM `db13147089-dazz2`.`notifications` AS `Notification` LEFT JOIN `db13147089-dazz2`.`orders` AS `Order` ON (`Notification`.`order_id` = `Order`.`id`) WHERE `Notification`.`status` = 0 ORDER BY `Order`.`id` DESC | | 0 | 0 | 9 |
4 | SELECT `Gateway`.`id`, `Gateway`.`gateway_type`, `Gateway`.`title`, `Gateway`.`mode`, `Gateway`.`stripe_test_secret`, `Gateway`.`stripe_live_secret`, `Gateway`.`live_url`, `Gateway`.`paypal_live_user`, `Gateway`.`paypal_live_pwd`, `Gateway`.`paypal_live_signature`, `Gateway`.`sandbox_url`, `Gateway`.`paypal_test_user`, `Gateway`.`paypal_test_pwd`, `Gateway`.`paypal_test_signature`, `Gateway`.`status` FROM `db13147089-dazz2`.`gateways` AS `Gateway` WHERE `Gateway`.`gateway_type` = 0 LIMIT 1 | | 1 | 1 | 1 |
5 | SELECT `Photostyle`.`id`, `Photostyle`.`ordinal`, `Photostyle`.`payment`, `Photostyle`.`spcase`, `Photostyle`.`chat_box`, `Photostyle`.`carousal`, `Photostyle`.`styleName`, `Photostyle`.`price`, `Photostyle`.`editorView`, `Photostyle`.`external`, `Photostyle`.`external_url`, `Photostyle`.`dazz_id`, `Photostyle`.`total_images`, `Photostyle`.`keywords`, `Photostyle`.`minimum_validation`, `Photostyle`.`notes`, `Photostyle`.`howto`, `Photostyle`.`visualapiurl`, `Photostyle`.`thumbnail`, `Photostyle`.`detailimage`, `Photostyle`.`afterimage`, `Photostyle`.`description`, `Photostyle`.`description_de`, `Photostyle`.`whatgets`, `Photostyle`.`optiontext`, `Photostyle`.`seo_name`, `Photostyle`.`finalimage`, `Photostyle`.`mobilepreview`, `Photostyle`.`estimated_time`, `Photostyle`.`countries`, `Photostyle`.`photogifts`, `Photostyle`.`status`, `Photostyle`.`api`, `Photostyle`.`sort`, `Photostyle`.`img_square`, `Photostyle`.`img_landscape`, `Photostyle`.`img_portrait`, `Photostyle`.`img_circle`, `Photostyle`.`img_wide`, `Photostyle`.`sticker_visualizer_id`, `Photostyle`.`square_visualizer_id`, `Photostyle`.`landscape_visualizer_id`, `Photostyle`.`portrait_visualizer_id`, `Photostyle`.`circle_visualizer_id`, `Photostyle`.`wide_visualizer_id`, `Photostyle`.`type`, `Photostyle`.`visualizer_id`, `Photostyle`.`skipcrp`, `Photostyle`.`skiptophotogift`, `Photostyle`.`wait`, `Photostyle`.`downloadstyle`, `Photostyle`.`source_validation`, `Photostyle`.`source_height`, `Photostyle`.`source_width`, `Photostyle`.`spell`, `Photostyle`.`spell_id`, `Photostyle`.`spell_autocomplete` FROM `db13147089-dazz2`.`photostyles` AS `Photostyle` WHERE `Photostyle`.`styleName` = 'Schoene Welt' LIMIT 1 | | 1 | 1 | 1 |
6 | SELECT `Option`.`id`, `Option`.`title`, `Option`.`photostyle_id`, `Option`.`country_id`, `Option`.`frame` FROM `db13147089-dazz2`.`options` AS `Option` WHERE `Option`.`photostyle_id` = (111) | | 0 | 0 | 7 |
7 | SELECT `Styleimagecaption`.`id`, `Styleimagecaption`.`photostyle_id`, `Styleimagecaption`.`caption`, `Styleimagecaption`.`captionimage` FROM `db13147089-dazz2`.`styleimagecaptions` AS `Styleimagecaption` WHERE `Styleimagecaption`.`photostyle_id` = (111) | | 0 | 0 | 3 |
8 | SELECT `Photostylefield`.`id`, `Photostylefield`.`field_label`, `Photostylefield`.`photostyle_id`, `Photostylefield`.`identifier`, `Photostylefield`.`isrequired` FROM `db13147089-dazz2`.`photostylefields` AS `Photostylefield` WHERE `Photostylefield`.`photostyle_id` = (111) | | 1 | 1 | 3 |
9 | SELECT `Photostyleproduct`.`id`, `Photostyleproduct`.`photostyle_id`, `Photostyleproduct`.`product_id`, `Photostyleproduct`.`ppImage`, `Photostyleproduct`.`pages` FROM `db13147089-dazz2`.`photostyleproducts` AS `Photostyleproduct` WHERE `Photostyleproduct`.`photostyle_id` = (111) | | 0 | 0 | 1 |
10 | SELECT `PhotostylesUtm`.`id`, `PhotostylesUtm`.`name`, `PhotostylesUtm`.`value`, `PhotostylesUtm`.`photostyle_id` FROM `db13147089-dazz2`.`photostyles_utms` AS `PhotostylesUtm` WHERE `PhotostylesUtm`.`photostyle_id` = (111) | | 0 | 0 | 1 |
11 | SELECT `Photostyle`.`id`, `Photostyle`.`ordinal`, `Photostyle`.`payment`, `Photostyle`.`spcase`, `Photostyle`.`chat_box`, `Photostyle`.`carousal`, `Photostyle`.`styleName`, `Photostyle`.`price`, `Photostyle`.`editorView`, `Photostyle`.`external`, `Photostyle`.`external_url`, `Photostyle`.`dazz_id`, `Photostyle`.`total_images`, `Photostyle`.`keywords`, `Photostyle`.`minimum_validation`, `Photostyle`.`notes`, `Photostyle`.`howto`, `Photostyle`.`visualapiurl`, `Photostyle`.`thumbnail`, `Photostyle`.`detailimage`, `Photostyle`.`afterimage`, `Photostyle`.`description`, `Photostyle`.`description_de`, `Photostyle`.`whatgets`, `Photostyle`.`optiontext`, `Photostyle`.`seo_name`, `Photostyle`.`finalimage`, `Photostyle`.`mobilepreview`, `Photostyle`.`estimated_time`, `Photostyle`.`countries`, `Photostyle`.`photogifts`, `Photostyle`.`status`, `Photostyle`.`api`, `Photostyle`.`sort`, `Photostyle`.`img_square`, `Photostyle`.`img_landscape`, `Photostyle`.`img_portrait`, `Photostyle`.`img_circle`, `Photostyle`.`img_wide`, `Photostyle`.`sticker_visualizer_id`, `Photostyle`.`square_visualizer_id`, `Photostyle`.`landscape_visualizer_id`, `Photostyle`.`portrait_visualizer_id`, `Photostyle`.`circle_visualizer_id`, `Photostyle`.`wide_visualizer_id`, `Photostyle`.`type`, `Photostyle`.`visualizer_id`, `Photostyle`.`skipcrp`, `Photostyle`.`skiptophotogift`, `Photostyle`.`wait`, `Photostyle`.`downloadstyle`, `Photostyle`.`source_validation`, `Photostyle`.`source_height`, `Photostyle`.`source_width`, `Photostyle`.`spell`, `Photostyle`.`spell_id`, `Photostyle`.`spell_autocomplete` FROM `db13147089-dazz2`.`photostyles` AS `Photostyle` WHERE `Photostyle`.`keywords` LIKE '%%' AND `Photostyle`.`status` = 1 AND `Photostyle`.`id` < 111 ORDER BY `Photostyle`.`id` DESC LIMIT 1 | | 1 | 1 | 1 |
12 | SELECT `Option`.`id`, `Option`.`title`, `Option`.`photostyle_id`, `Option`.`country_id`, `Option`.`frame` FROM `db13147089-dazz2`.`options` AS `Option` WHERE `Option`.`photostyle_id` = (100) | | 0 | 0 | 6 |
13 | SELECT `Styleimagecaption`.`id`, `Styleimagecaption`.`photostyle_id`, `Styleimagecaption`.`caption`, `Styleimagecaption`.`captionimage` FROM `db13147089-dazz2`.`styleimagecaptions` AS `Styleimagecaption` WHERE `Styleimagecaption`.`photostyle_id` = (100) | | 0 | 0 | 3 |
14 | SELECT `Photostylefield`.`id`, `Photostylefield`.`field_label`, `Photostylefield`.`photostyle_id`, `Photostylefield`.`identifier`, `Photostylefield`.`isrequired` FROM `db13147089-dazz2`.`photostylefields` AS `Photostylefield` WHERE `Photostylefield`.`photostyle_id` = (100) | | 1 | 1 | 3 |
15 | SELECT `Photostyleproduct`.`id`, `Photostyleproduct`.`photostyle_id`, `Photostyleproduct`.`product_id`, `Photostyleproduct`.`ppImage`, `Photostyleproduct`.`pages` FROM `db13147089-dazz2`.`photostyleproducts` AS `Photostyleproduct` WHERE `Photostyleproduct`.`photostyle_id` = (100) | | 0 | 0 | 0 |
16 | SELECT `PhotostylesUtm`.`id`, `PhotostylesUtm`.`name`, `PhotostylesUtm`.`value`, `PhotostylesUtm`.`photostyle_id` FROM `db13147089-dazz2`.`photostyles_utms` AS `PhotostylesUtm` WHERE `PhotostylesUtm`.`photostyle_id` = (100) | | 0 | 0 | 0 |
17 | SELECT `Photostyle`.`id`, `Photostyle`.`ordinal`, `Photostyle`.`payment`, `Photostyle`.`spcase`, `Photostyle`.`chat_box`, `Photostyle`.`carousal`, `Photostyle`.`styleName`, `Photostyle`.`price`, `Photostyle`.`editorView`, `Photostyle`.`external`, `Photostyle`.`external_url`, `Photostyle`.`dazz_id`, `Photostyle`.`total_images`, `Photostyle`.`keywords`, `Photostyle`.`minimum_validation`, `Photostyle`.`notes`, `Photostyle`.`howto`, `Photostyle`.`visualapiurl`, `Photostyle`.`thumbnail`, `Photostyle`.`detailimage`, `Photostyle`.`afterimage`, `Photostyle`.`description`, `Photostyle`.`description_de`, `Photostyle`.`whatgets`, `Photostyle`.`optiontext`, `Photostyle`.`seo_name`, `Photostyle`.`finalimage`, `Photostyle`.`mobilepreview`, `Photostyle`.`estimated_time`, `Photostyle`.`countries`, `Photostyle`.`photogifts`, `Photostyle`.`status`, `Photostyle`.`api`, `Photostyle`.`sort`, `Photostyle`.`img_square`, `Photostyle`.`img_landscape`, `Photostyle`.`img_portrait`, `Photostyle`.`img_circle`, `Photostyle`.`img_wide`, `Photostyle`.`sticker_visualizer_id`, `Photostyle`.`square_visualizer_id`, `Photostyle`.`landscape_visualizer_id`, `Photostyle`.`portrait_visualizer_id`, `Photostyle`.`circle_visualizer_id`, `Photostyle`.`wide_visualizer_id`, `Photostyle`.`type`, `Photostyle`.`visualizer_id`, `Photostyle`.`skipcrp`, `Photostyle`.`skiptophotogift`, `Photostyle`.`wait`, `Photostyle`.`downloadstyle`, `Photostyle`.`source_validation`, `Photostyle`.`source_height`, `Photostyle`.`source_width`, `Photostyle`.`spell`, `Photostyle`.`spell_id`, `Photostyle`.`spell_autocomplete` FROM `db13147089-dazz2`.`photostyles` AS `Photostyle` WHERE `Photostyle`.`keywords` LIKE '%%' AND `Photostyle`.`status` = 1 AND `Photostyle`.`id` >= 100 AND `Photostyle`.`id` != 111 ORDER BY `Photostyle`.`id` ASC LIMIT 2 | | 2 | 2 | 1 |
18 | SELECT `Option`.`id`, `Option`.`title`, `Option`.`photostyle_id`, `Option`.`country_id`, `Option`.`frame` FROM `db13147089-dazz2`.`options` AS `Option` WHERE `Option`.`photostyle_id` IN (100, 114) | | 0 | 0 | 6 |
19 | SELECT `Styleimagecaption`.`id`, `Styleimagecaption`.`photostyle_id`, `Styleimagecaption`.`caption`, `Styleimagecaption`.`captionimage` FROM `db13147089-dazz2`.`styleimagecaptions` AS `Styleimagecaption` WHERE `Styleimagecaption`.`photostyle_id` IN (100, 114) | | 0 | 0 | 2 |
20 | SELECT `Photostylefield`.`id`, `Photostylefield`.`field_label`, `Photostylefield`.`photostyle_id`, `Photostylefield`.`identifier`, `Photostylefield`.`isrequired` FROM `db13147089-dazz2`.`photostylefields` AS `Photostylefield` WHERE `Photostylefield`.`photostyle_id` IN (100, 114) | | 4 | 4 | 3 |
21 | SELECT `Photostyleproduct`.`id`, `Photostyleproduct`.`photostyle_id`, `Photostyleproduct`.`product_id`, `Photostyleproduct`.`ppImage`, `Photostyleproduct`.`pages` FROM `db13147089-dazz2`.`photostyleproducts` AS `Photostyleproduct` WHERE `Photostyleproduct`.`photostyle_id` IN (100, 114) | | 0 | 0 | 0 |
22 | SELECT `PhotostylesUtm`.`id`, `PhotostylesUtm`.`name`, `PhotostylesUtm`.`value`, `PhotostylesUtm`.`photostyle_id` FROM `db13147089-dazz2`.`photostyles_utms` AS `PhotostylesUtm` WHERE `PhotostylesUtm`.`photostyle_id` IN (100, 114) | | 0 | 0 | 0 |
23 | SELECT `Carousel`.`id`, `Carousel`.`name`, `Carousel`.`name_german`, `Carousel`.`image`, `Carousel`.`photostyle_id`, `Photostyle`.`id`, `Photostyle`.`ordinal`, `Photostyle`.`payment`, `Photostyle`.`spcase`, `Photostyle`.`chat_box`, `Photostyle`.`carousal`, `Photostyle`.`styleName`, `Photostyle`.`price`, `Photostyle`.`editorView`, `Photostyle`.`external`, `Photostyle`.`external_url`, `Photostyle`.`dazz_id`, `Photostyle`.`total_images`, `Photostyle`.`keywords`, `Photostyle`.`minimum_validation`, `Photostyle`.`notes`, `Photostyle`.`howto`, `Photostyle`.`visualapiurl`, `Photostyle`.`thumbnail`, `Photostyle`.`detailimage`, `Photostyle`.`afterimage`, `Photostyle`.`description`, `Photostyle`.`description_de`, `Photostyle`.`whatgets`, `Photostyle`.`optiontext`, `Photostyle`.`seo_name`, `Photostyle`.`finalimage`, `Photostyle`.`mobilepreview`, `Photostyle`.`estimated_time`, `Photostyle`.`countries`, `Photostyle`.`photogifts`, `Photostyle`.`status`, `Photostyle`.`api`, `Photostyle`.`sort`, `Photostyle`.`img_square`, `Photostyle`.`img_landscape`, `Photostyle`.`img_portrait`, `Photostyle`.`img_circle`, `Photostyle`.`img_wide`, `Photostyle`.`sticker_visualizer_id`, `Photostyle`.`square_visualizer_id`, `Photostyle`.`landscape_visualizer_id`, `Photostyle`.`portrait_visualizer_id`, `Photostyle`.`circle_visualizer_id`, `Photostyle`.`wide_visualizer_id`, `Photostyle`.`type`, `Photostyle`.`visualizer_id`, `Photostyle`.`skipcrp`, `Photostyle`.`skiptophotogift`, `Photostyle`.`wait`, `Photostyle`.`downloadstyle`, `Photostyle`.`source_validation`, `Photostyle`.`source_height`, `Photostyle`.`source_width`, `Photostyle`.`spell`, `Photostyle`.`spell_id`, `Photostyle`.`spell_autocomplete` FROM `db13147089-dazz2`.`carousels` AS `Carousel` LEFT JOIN `db13147089-dazz2`.`photostyles` AS `Photostyle` ON (`Carousel`.`photostyle_id` = `Photostyle`.`id`) WHERE `Carousel`.`photostyle_id` = 111 | | 9 | 9 | 12 |
24 | SELECT `Order`.`id`, `Order`.`crplock`, `Order`.`photogifts`, `Order`.`time_zone`, `Order`.`type`, `Order`.`trackingnumber`, `Order`.`invoice_number`, `Order`.`personello_invoice`, `Order`.`taxrate`, `Order`.`sreetno`, `Order`.`postcode`, `Order`.`vat`, `Order`.`price`, `Order`.`test`, `Order`.`text`, `Order`.`size`, `Order`.`instructions`, `Order`.`isaccepted`, `Order`.`assignedto`, `Order`.`isverify`, `Order`.`curlOrderid`, `Order`.`user_id`, `Order`.`style_id`, `Order`.`voucher_id`, `Order`.`voucher_type`, `Order`.`option_id`, `Order`.`firstname`, `Order`.`lastname`, `Order`.`email`, `Order`.`contactno`, `Order`.`order_date`, `Order`.`order_status`, `Order`.`reopen_reason`, `Order`.`reopen_status`, `Order`.`support_reopen`, `Order`.`support_userid`, `Order`.`download_complete`, `Order`.`desktop_complete`, `Order`.`external_images`, `Order`.`paid`, `Order`.`request`, `Order`.`reason_id`, `Order`.`company_id`, `Order`.`customer_invoice`, `Order`.`payment_gateway_id`, `Order`.`suggested_starttime`, `Order`.`suggested_endtime`, `Order`.`time_spend`, `Order`.`delay_time`, `Order`.`order_start_time`, `Order`.`order_finish_time`, `Order`.`order_estimated_time`, `Order`.`sourcefile`, `Order`.`change_reason`, `Order`.`complaint`, `Order`.`allow_images`, `Order`.`complaint_approve`, `Order`.`client_uploaded`, `Order`.`country`, `Order`.`acknowledgedby`, `Order`.`acknowledged_date`, `Order`.`rejectreason`, `Order`.`order_type`, `Order`.`notify_emails`, `Order`.`template_id`, `Order`.`crp_no`, `Order`.`mcrp_style_on`, `Order`.`photographerid`, `Order`.`crp_created`, `Order`.`clientid`, `Order`.`campaign_id`, `Order`.`is_qa`, `Order`.`rendering`, `Order`.`is_deleted`, `Order`.`deleted_date`, `Order`.`returnkeyword`, `Order`.`created` FROM `db13147089-dazz2`.`orders` AS `Order` WHERE `Order`.`order_status` NOT IN ('2', '3') AND `Order`.`isverify` = 1 ORDER BY `Order`.`id` DESC | | 60 | 60 | 702 |