/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.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`='seat' 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 (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`='121'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2558','2559','2560','2561','2562','2563','2564','2565','2566','2567','2568','2569','2570','2571','2572','2573','2574','2575','11045','11046','11047','11048','11049','11050','11051','11052','11053','11054','11055','11056','11057','11058','13366','13367','13368','13369','14081','14082','14083','14084','14085','14086','14087','14088','14089','14090','14228','15360','16348','17773','17774','17775','17776','17777','17778','17779','17780','18873','18874','18875','21966','21967','21968','22995','22996','22997','22998','27605','27606','27607','27608','27609','27610','27611','27612','27613','27614','27615','27616','27617','27618','27619','27620','27621','27622','27623','27624','27625','27626','27627','27628','27629','27630','27632','27633','27634','27635','27636','27637','27638','27639','27640','27641','27642','27643','27644','27645','27646','27647','27648','27649','27650','27651','27652','27653','27654','27655','27656','27657','27658','27659','27660','27662','27663','27664','30293','30294','30295','30296','30297','30304','30305','30306','30307','60725','60726','60727','60728','60729','60730','60731','60732','60733','60734','60735','60736','60737','60738','60739','60740','60741','60742','60743','60744','60745','60746','60747','60748','60749','60750','60751','60752','60753','60754','60755','60756','60757') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='121' AND `type` IN('0','1','2')
132
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='121' AND `type` IN('0','1','2') 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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('960','961','962','4014','4015','4016','5064','5065','5066','5067','9677','9678','9679','9680','9681','9682','9683','9684','9685','9686','9687','9688','9689','9690','9691','9692','9693','9694','9695','9696','9697','9698','9699','9700','9701','9702','9704','9705','9706','9707','9708','9709','9710','9711','9712','9713','9714','9715','9716','9717','9718','9719','9720','9721','9722','9723','9724','9725','9726','9727','9728','9729','9730','9731','9732','9734','9735','9736','12367','12368','12369','12370','12371','12378','12379','12380','12381')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 961)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2736) 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`='2736'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('960','961','962') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12371)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12532) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9678)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29643) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9730)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28879) 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`='28879'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('9727','9728','9729','9730') 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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=0 AND `id` IN('960','962','4014','4015','4016','5064','5065','5066','5067','9677','9679','9680','9681','9682','9683','9684','9685','9686','9687','9688','9689','9690','9691','9692','9693','9694','9695','9696','9697','9698','9699','9700','9701','9702','9704','9705','9706','9707','9708','9709','9710','9711','9712','9713','9714','9715','9716','9717','9718','9719','9720','9721','9722','9723','9724','9725','9726','9727','9728','9729','9731','9732','9734','9735','9736','12367','12368','12369','12370','12378','12379','12380','12381')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 962)
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 5067)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29224) 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`='29224'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('5064','5065','5066','5067') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 960)
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=1 AND `id` IN('4014','4015','4016','5064','5065','5066','9677','9679','9680','9681','9682','9683','9684','9685','9686','9687','9688','9689','9690','9691','9692','9693','9694','9695','9696','9697','9698','9699','9700','9701','9702','9704','9705','9706','9707','9708','9709','9710','9711','9712','9713','9714','9715','9716','9717','9718','9719','9720','9721','9722','9723','9724','9725','9726','9727','9728','9729','9731','9732','9734','9735','9736','12367','12368','12369','12370','12378','12379','12380','12381')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9697)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9705)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12367)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33994) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9713)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9731)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9927) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9702)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9721)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31344) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9688)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9883) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9683)
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='9683'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 4014)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9735)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9927) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12368)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33994) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9699)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9718)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31344) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9680)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9877) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9677)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29643) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9732)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9927) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9704)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9715)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9700)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12370)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12532) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9729)
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9722)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31344) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9694)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9885) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9681)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9877) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 5066)
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12379)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12532) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 4016)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9706)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12380)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12533) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9720)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31344) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12381)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12533) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9690)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9883) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9728)
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9726)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9679)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29643) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 4015)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9692)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9884) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9687)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9883) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9712)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9708)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9725)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9736)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9927) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9707)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9684)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9883) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12378)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12532) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9698)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9716)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9723)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34213) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9711)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 5065)
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9701)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 9709)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29607) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 12369)
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='12369'
SELECT `id`, `name`, `type` FROM nox_group