Ошибка базы данных WordPress: [Table './tp2014/wp_sam_stats' is marked as crashed and should be repaired]
SELECT sp.id, sp.name, sp.description, sp.code_before, sp.code_after, sp.place_size, sp.place_custom_width, sp.place_custom_height, sp.patch_img, sp.patch_link, sp.patch_code, sp.patch_adserver, sp.patch_dfp, sp.patch_source, sp.trash, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE) AS ad_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND (sa.ad_weight > 0)) AS ad_logic_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND IF(sa.ad_weight > 0, (sa.ad_weight_hits*10/(sa.ad_weight*1000)) < 1, FALSE)) AS ad_full_count FROM wp_sam_places sp WHERE sp.id = 1 AND sp.trash IS FALSE;

10:05 / 27 Май 2019

Пространство для творчества

Пространство для творчества

В Тюмени состоялось открытие первого магазина формата Wonder Photo Shop by FUJIFILM

Ошибка базы данных WordPress: [Table './tp2014/wp_sam_stats' is marked as crashed and should be repaired]
SELECT sp.id, sp.name, sp.description, sp.code_before, sp.code_after, sp.place_size, sp.place_custom_width, sp.place_custom_height, sp.patch_img, sp.patch_link, sp.patch_code, sp.patch_adserver, sp.patch_dfp, sp.patch_source, sp.trash, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE) AS ad_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND (sa.ad_weight > 0)) AS ad_logic_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND IF(sa.ad_weight > 0, (sa.ad_weight_hits*10/(sa.ad_weight*1000)) < 1, FALSE)) AS ad_full_count FROM wp_sam_places sp WHERE sp.id = 1 AND sp.trash IS FALSE;

23 мая в Тюмени прошло открытие первого фотомагазина в концепции Wonder Photo Shop. Проект реализован в партнерстве с сетью фотостудий «Старый фотограф». Новое интересное место находится в ТРЦ «Гудвин».
 
 

На торжественное открытие магазина пришли представители городских СМИ и инфлюенсеры, для которых была организована развлекательная программа. Каждый мог протестировать знаменитые камеры моментальной печати Instax, в том числе новую линейку квадратного формата, сделать памятную монохромную фотокарточку, поучаствовать в экскурсии по магазину и самое главное – убедиться, насколько просто стало распечатывать любимые снимки в фотомагазинах концепции WPS.

Пространство для творчества

Гостям мероприятия предлагали легкие закуски и напитки, и каждый ушел с хорошим настроением и небольшим подарком от организаторов

 
 

В новом магазине представлено всё самое необходимое для создания редактирования и хранения фотографий: цифровая техника, камеры моментальной печати Instax, различные виды пленки, сумки для фотокамер, фотоальбомы, фоторамки и многое другое.

В Wonder Photo Shop все фотографии печатаются исключительно на высококачественной фотобумаге FUJIFILM. Посетители могут распечатывать фотографии через специальные фотокиоски самостоятельно или заказать фотографии, фотокниги и другие фототовары. Профессиональные консультанты магазина с радостью ответят на вопросы, помогут подобрать нужный товар или распечатать фотографии.

Первый магазин Wonder Photo Shop при поддержке японской компании FUJIFILM открылся в Токио в 2014 году. Сегодня фотомагазины нового поколения успешно работают в Барселоне, Нью-Йорке, Шанхае, Москве и других городах по всему миру. Каждый из них – это уникальное творческое пространство, где посетители смогут воплотить свои самые необычные фото-идеи в жизнь.

Пространство для творчества
 


Текст: Елена Селивёрстова
Фото предоставлены пресс-службой

 

Ошибка базы данных WordPress: [Table './tp2014/wp_sam_stats' is marked as crashed and should be repaired]
SELECT sp.id, sp.name, sp.description, sp.code_before, sp.code_after, sp.place_size, sp.place_custom_width, sp.place_custom_height, sp.patch_img, sp.patch_link, sp.patch_code, sp.patch_adserver, sp.patch_dfp, sp.patch_source, sp.trash, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE) AS ad_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND (sa.ad_weight > 0)) AS ad_logic_count, (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(56908, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("portaltyumen", sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("fujifilm", sa.view_tags) OR FIND_IN_SET("wonder-photo-shop", sa.view_tags) OR FIND_IN_SET("staryj-fotograf", sa.view_tags) OR FIND_IN_SET("stil", sa.view_tags) OR FIND_IN_SET("foto", sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET("style", sa.view_custom_tax_terms) OR FIND_IN_SET("fujifilm", sa.view_custom_tax_terms) OR FIND_IN_SET("wonder-photo-shop", sa.view_custom_tax_terms) OR FIND_IN_SET("staryj-fotograf", sa.view_custom_tax_terms) OR FIND_IN_SET("stil", sa.view_custom_tax_terms) OR FIND_IN_SET("foto", sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(56908, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET("portaltyumen", sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("fujifilm", sa.x_view_tags)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_tags)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_tags)) AND (NOT FIND_IN_SET("stil", sa.x_view_tags)) AND (NOT FIND_IN_SET("foto", sa.x_view_tags)), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET("style", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("fujifilm", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("wonder-photo-shop", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("staryj-fotograf", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("stil", sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET("foto", sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND IF(sa.ad_weight > 0, (sa.ad_weight_hits*10/(sa.ad_weight*1000)) < 1, FALSE)) AS ad_full_count FROM wp_sam_places sp WHERE sp.id = 1 AND sp.trash IS FALSE;