/var/www/html/nox-modules/prints
/lib/action/frontend
/printsBlueprintsSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='car'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='rover' AND `class_id`='1' ORDER BY name
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE class_id = 1 AND ((vectors_count > 0) OR (blueprints_count > 0) OR (id IN (SELECT make_id FROM `prints_request_vector`))) ORDER BY name
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `make_id`='116'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('2384','2387','2388','2390','2391','2392','2393','2394','2395','9962','9963','9964','9965','9966','9967','9968','9969','9970','9971','9972','9973','9974','9975','9976','9977','9978','13155','13359','13360','13361','13362','13363','13364','14080','17718','17719','18330','25890','27535','27536','27537','27538','27539','27540','27541','27542','27543','27544','27545','27546','27547','27548','27549','27550','27551','27552','27555','27556','27557','27558','27559','27560','27561','27562','27563','27564','60636','60637','60638','60639','60640','60641','60642','60643','60644','60645','60646','60647','60648','60649','60650','60651','60652','60653','60654','60655','60656','60657','60658','60659','60660','60661','60662','60663','60664','60665','60666','60667','60668','60669','61977','61978','61979','61980') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2384','2387','2388','2390','2391','2392','2393','2394','2395','9962','9963','9964','9965','9966','9967','9968','9969','9970','9971','9972','9973','9974','9975','9976','9977','9978','13155','13359','13360','13361','13362','13363','13364','14080','17718','17719','18330','25890','27535','27536','27537','27538','27539','27540','27541','27542','27543','27544','27545','27546','27547','27548','27549','27550','27551','27552','27555','27556','27557','27558','27559','27560','27561','27562','27563','27564','60636','60637','60638','60639','60640','60641','60642','60643','60644','60645','60646','60647','60648','60649','60650','60651','60652','60653','60654','60655','60656','60657','60658','60659','60660','60661','60662','60663','60664','60665','60666','60667','60668','60669','61977','61978','61979','61980') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='116'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `name_full` LIKE "Rover%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='116'
139
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='116' ORDER BY `sort_name`, `type` LIMIT 0, 100
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','289','290','291')
SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='116'
SELECT `id`, `tag` FROM tag WHERE `id` IN('147','148')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('417','7962','9607','9608','9609','9610','9611','9612','9613','9614','9615','9616','9617','9618','9619','9620','9621','9622','9623','9624','9627','9628','9629','9630','9631','9632','9633','9634','9635','9636','31812','31813','31814','31815')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='417'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36345' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36345) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='36345'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('417','31812') ORDER BY price LIMIT 0, 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=0 AND `id` IN('7962','9607','9608','9609','9610','9611','9612','9613','9614','9615','9616','9617','9618','9619','9620','9621','9622','9623','9624','9627','9628','9629','9630','9631','9632','9633','9634','9635','9636','31812','31813','31814','31815')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31813'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31813'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1963 - 1977 rover 2000 series i glass roof sedan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31813'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31812'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36345' ORDER BY name_title
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31814'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31814'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1963 - 1977 rover 2200 series i glass roof sedan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31814'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31815'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31815'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1963 - 1977 rover 3500 series i glass roof sedan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='31815'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31812'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36345' ORDER BY name_title
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=1 AND `id` IN('7962','9607','9608','9609','9610','9611','9612','9613','9614','9615','9616','9617','9618','9619','9620','9621','9622','9623','9624','9627','9628','9629','9630','9631','9632','9633','9634','9635','9636')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9613'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9618'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9620'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9627'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9837' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9837) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9621'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9633'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9840' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9840) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9615'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9631'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9838' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9838) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9628'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9837' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9837) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9632'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9838' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9838) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9611'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='7962'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9839' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9839) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9624'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9833' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9833) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9634'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9840' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9840) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9608'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9813' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9813) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9607'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9813' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9813) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9610'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9612'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9617'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9622'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9616'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9609'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9813' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9813) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9623'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9833' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9833) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9636'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9841' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9841) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9619'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9629'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9837' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9837) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9630'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9837' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9837) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9614'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9635'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9841' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9841) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='9613'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='9832' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9832) AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='9832'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('9610','9611','9612','9613','9614','9615','9616','9617','9618','9619','9620','9621','9622') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group