/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`='pontiac' 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`='110'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1803','1804','1805','1806','1807','1808','1809','1810','1811','1812','1813','1814','1815','1816','1817','1818','1819','1820','1821','1822','1823','1824','1825','1826','1827','1828','1829','1830','1831','1832','1833','1834','1835','1836','1837','1838','1839','1840','1841','1842','1843','1844','1845','1846','1847','1848','1849','10084','10085','10086','10087','10088','10089','10090','10091','10092','10093','10094','10095','10096','10097','10098','10099','10100','10101','10102','10103','10104','10105','10106','10107','10108','10109','10110','10111','10112','10113','10114','10115','10116','10117','10118','10119','10120','10121','10122','10123','10124','10125','10126','10127','10128','10129','10130','10131','10132','10133','10134','10135','10136','10137','10138','10139','10140','10141','10142','10143','10144','10145','10146','10147','10148','10149','10150','10151','10152','10153','10154','10155','10156','10157','10158','10159','10160','10161','10162','10163','10164','10165','10166','10167','10168','12730','12731','12732','12733','12734','15352','15353','16322','17049','17543','18999','19000','19001','19002','19003','20200','20201','20202','20203','22017','22033','22177','26000','26001','26002','26003','27260','27261','27262','27263','27264','27265','27266','27267','27268','27269','27270','27271','27272','27273','27274','27275','27276','27277','27278','27279','27280','27281','27282','27283','27284','27285','27286','27287','27288','27289','27290','27291','27292','27293','27294','27295','27296','27297','27298','27299','27300','27301','27302','27303','27304','27305','27306','27307','27308','27309','27310','27311','27312','27313','27314','27315','27316','27317','27318','27319','27320','27321','27322','27323','27324','27325','27326','27327','27328','27329','27330','27331','27332','27333','27334','27335','27336','27337','27338','27339','27340','27341','27342','27343','27344','27345','27348','27349','27350','27351','27352','27353','27354','27355','27356','27357','27358','27359','27360','27361','27362','27363','27365','27916','27917','27929','27930','27931','27932','27933','27934','27935','27936','28013','28014','28015','28016','28017','28018','31314','31882','31883','31884','31885','31888','33265','33266','33267','33268','33269','33270','33271','33272','33273','33274','33275','33276','33277','33278','33279','33280','33281','33282','33283','33284','33285','33286','33287','33288','33289','33290','33291','33292','33293','33294','33295','33296','33297','33298','33299','33300','33301','33302','33303','33304','33305','33306','33307','33308','33309','33310','33311','33312','33313','33314','33315','33316','33317','33318','33319','33320','33321','33322','33323','33324','33325','33326','33327','33328','33329','33330','33331','33332','33333','33334','33335','33336','33337','33338','33339','33340','33341','33342','33343','33344','33345','33346','33347','33348','33349','33350','33351','33352','33353','33354','33355','33356','33357','33358','33359','33360','33361','33362','33363','33364','33365','33366','33367','33368','33369','33370','33371','33372','33373','33374','33375','33376','33377','33378','33379','33380','33381','33382','33383','33384','33385','33386','33387','33388','33389','33390','33391','33392','33393','33394','33395','33396','33397','33398','33399','33400','33401','33402','33403','33404','33405','33406','33407','33408','33409','33410','33411','33412','33413','33414','33415','33416','33417','33418','33419','33420','33421','33422','33423','33424','33425','33426','33427','33428','33429','33430','33431','33432','33433','33434','33435','33436','33437','33438','33439','33440','33441','33442','33443','33444','33445','33446','33447','33448','33449','33450','33451','33452','33453','33454','33455','33456','33457','33458','33459','33460','33461','33462','33463','33464','33465','33466','33467','33468','33469','33470','33471','33472','33473','33474','33475','33476','33477','33478','33479','33480','33481','33482','33483','33484','33485','33486','33487','33488','33489','33490','33491','33492','33493','33494','33531','33532','33533','33534','33535','33536','33537','33538','33539','33540','33541','33542','33543','33544','33545','33546','33547','33548','33549','33550','33551','33552','33553','33554','33555','33556','33557','33558','33559','33560','33561','33562','33563','33564','33565','33566','33567','33568','33569','33570','33571','33572','33573','33574','33575','33576','33577','33578','33579','33580','33581','33582','33583','33584','33585','33586','33587','33588','33589','33590','33591','33592','33593','33594','33595','33596','33597','33609','33610','45783','46117','46946','46947','46951','47262','47263','47938','47939','48025','48026','50289','59952','59953','59954','59955','59956','59957','59958','59959','59960','59961','59962','59963','59964','59965','59966','59967','59968','59969','59970','59971','59972','59973','59974','59975','59976','59977','59978','59979','59980','59981','59982','59983','59984','59985','59986','59987','59988','59989','59990','59991','59995','59996','59997','59998','59999','60000','60001','60002','60003','60004','60005','60006','60007','60008','60009','60010','60011','60012','60013','60014','60015','60016','60017','60018','60019','60020','60021','60022','60023','60024','60025','60026','60027','60028','60029','60030','60031','60032','60033','60034','60035','60036','60037','60038','60039','60040','60041','60042','60043','60044','60045','60046','60047','60048','60049','60050','60051','60052','60053','60054','60055','60056','60057','60058','60059','60060','60061','60062','60063','60064','60065','60066','60067','60068','60069','60070','60071','60072','60073','60074','60075','60076','60077','60078','60079','60080','60081','60082','60083','60084','60085','60086','60087','60088','60089','60090','60091','60092','60093','60094','60095','60096','60097','60098','60099','60100','60101') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1803','1804','1805','1806','1807','1808','1809','1810','1811','1812','1813','1814','1815','1816','1817','1818','1819','1820','1821','1822','1823','1824','1825','1826','1827','1828','1829','1830','1831','1832','1833','1834','1835','1836','1837','1838','1839','1840','1841','1842','1843','1844','1845','1846','1847','1848','1849','10084','10085','10086','10087','10088','10089','10090','10091','10092','10093','10094','10095','10096','10097','10098','10099','10100','10101','10102','10103','10104','10105','10106','10107','10108','10109','10110','10111','10112','10113','10114','10115','10116','10117','10118','10119','10120','10121','10122','10123','10124','10125','10126','10127','10128','10129','10130','10131','10132','10133','10134','10135','10136','10137','10138','10139','10140','10141','10142','10143','10144','10145','10146','10147','10148','10149','10150','10151','10152','10153','10154','10155','10156','10157','10158','10159','10160','10161','10162','10163','10164','10165','10166','10167','10168','12730','12731','12732','12733','12734','15352','15353','16322','17049','17543','18999','19000','19001','19002','19003','20200','20201','20202','20203','22017','22033','22177','26000','26001','26002','26003','27260','27261','27262','27263','27264','27265','27266','27267','27268','27269','27270','27271','27272','27273','27274','27275','27276','27277','27278','27279','27280','27281','27282','27283','27284','27285','27286','27287','27288','27289','27290','27291','27292','27293','27294','27295','27296','27297','27298','27299','27300','27301','27302','27303','27304','27305','27306','27307','27308','27309','27310','27311','27312','27313','27314','27315','27316','27317','27318','27319','27320','27321','27322','27323','27324','27325','27326','27327','27328','27329','27330','27331','27332','27333','27334','27335','27336','27337','27338','27339','27340','27341','27342','27343','27344','27345','27348','27349','27350','27351','27352','27353','27354','27355','27356','27357','27358','27359','27360','27361','27362','27363','27365','27916','27917','27929','27930','27931','27932','27933','27934','27935','27936','28013','28014','28015','28016','28017','28018','31314','31882','31883','31884','31885','31888','33265','33266','33267','33268','33269','33270','33271','33272','33273','33274','33275','33276','33277','33278','33279','33280','33281','33282','33283','33284','33285','33286','33287','33288','33289','33290','33291','33292','33293','33294','33295','33296','33297','33298','33299','33300','33301','33302','33303','33304','33305','33306','33307','33308','33309','33310','33311','33312','33313','33314','33315','33316','33317','33318','33319','33320','33321','33322','33323','33324','33325','33326','33327','33328','33329','33330','33331','33332','33333','33334','33335','33336','33337','33338','33339','33340','33341','33342','33343','33344','33345','33346','33347','33348','33349','33350','33351','33352','33353','33354','33355','33356','33357','33358','33359','33360','33361','33362','33363','33364','33365','33366','33367','33368','33369','33370','33371','33372','33373','33374','33375','33376','33377','33378','33379','33380','33381','33382','33383','33384','33385','33386','33387','33388','33389','33390','33391','33392','33393','33394','33395','33396','33397','33398','33399','33400','33401','33402','33403','33404','33405','33406','33407','33408','33409','33410','33411','33412','33413','33414','33415','33416','33417','33418','33419','33420','33421','33422','33423','33424','33425','33426','33427','33428','33429','33430','33431','33432','33433','33434','33435','33436','33437','33438','33439','33440','33441','33442','33443','33444','33445','33446','33447','33448','33449','33450','33451','33452','33453','33454','33455','33456','33457','33458','33459','33460','33461','33462','33463','33464','33465','33466','33467','33468','33469','33470','33471','33472','33473','33474','33475','33476','33477','33478','33479','33480','33481','33482','33483','33484','33485','33486','33487','33488','33489','33490','33491','33492','33493','33494','33531','33532','33533','33534','33535','33536','33537','33538','33539','33540','33541','33542','33543','33544','33545','33546','33547','33548','33549','33550','33551','33552','33553','33554','33555','33556','33557','33558','33559','33560','33561','33562','33563','33564','33565','33566','33567','33568','33569','33570','33571','33572','33573','33574','33575','33576','33577','33578','33579','33580','33581','33582','33583','33584','33585','33586','33587','33588','33589','33590','33591','33592','33593','33594','33595','33596','33597','33609','33610','45783','46117','46946','46947','46951','47262','47263','47938','47939','48025','48026','50289','59952','59953','59954','59955','59956','59957','59958','59959','59960','59961','59962','59963','59964','59965','59966','59967','59968','59969','59970','59971','59972','59973','59974','59975','59976','59977','59978','59979','59980','59981','59982','59983','59984','59985','59986','59987','59988','59989','59990','59991','59995','59996','59997','59998','59999','60000','60001','60002','60003','60004','60005','60006','60007','60008','60009','60010','60011','60012','60013','60014','60015','60016','60017','60018','60019','60020','60021','60022','60023','60024','60025','60026','60027','60028','60029','60030','60031','60032','60033','60034','60035','60036','60037','60038','60039','60040','60041','60042','60043','60044','60045','60046','60047','60048','60049','60050','60051','60052','60053','60054','60055','60056','60057','60058','60059','60060','60061','60062','60063','60064','60065','60066','60067','60068','60069','60070','60071','60072','60073','60074','60075','60076','60077','60078','60079','60080','60081','60082','60083','60084','60085','60086','60087','60088','60089','60090','60091','60092','60093','60094','60095','60096','60097','60098','60099','60100','60101') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='110'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Pontiac%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='110'
874
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='110' ORDER BY `sort_name`, `type` LIMIT 200, 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`='110'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1086','1087','1088','1089','1090','2232','2233','2234','2235','4066','4089','4245','8072','8073','8074','8075','9332','9333','9334','9335','9336','9337','9338','9339','9340','9341','9342','9343','9344','9345','9346','9347','9348','9349','9350','9351','9352','9353','9354','9355','9356','9357','9358','9359','9360','9361','9362','9363','9364','9365','9366','9367','9368','9369','9370','9371','9372','9373','9374','9375','9376','9377','9378','9379','9380','9381','9382','9383','9384','9385','9386','9387','9388','9389','9390','9391','9392','9393','9394','9395','9396','9397','9398','9399','9400','9401','9402','9403','9404','9405','9406','9407','9408','9409','9410','9411','9412','9413','9414','9415','9416','9417','9420','9421','9422','9423','9424','9425','9426','9427','9428','9429','9430','9431','9432','9433','9434','9435','9437','9988','9989','10001','10002','10003','10004','10005','10006','10007','10008','10085','10086','10087','10088','10089','10090','13390','13958','13959','13960','13961','13964','15341','15342','15343','15344','15345','15346','15347','15348','15349','15350','15351','15352','15353','15354','15355','15356','15357','15358','15359','15360','15361','15362','15363','15364','15365','15366','15367','15368','15369','15370','15371','15372','15373','15374','15375','15376','15377','15378','15379','15380','15381','15382','15383','15384','15385','15386','15387','15388','15389','15390','15391','15392','15393','15394','15395','15396','15397','15398','15399','15400','15401','15402','15403','15404','15405','15406','15407','15408','15409','15410','15411','15412','15413','15414','15415','15416','15417','15418','15419','15420','15421','15422','15423','15424','15425','15426','15427','15428','15429','15430','15431','15432','15433','15434','15435','15436','15437','15438','15439','15440','15441','15442','15443','15444','15445','15446','15447','15448','15449','15450','15451','15452','15453','15454','15455','15456','15457','15458','15459','15460','15461','15462','15463','15464','15465','15466','15467','15468','15469','15470','15471','15472','15473','15474','15475','15476','15477','15478','15479','15480','15481','15482','15483','15484','15485','15486','15487','15488','15489','15490','15491','15492','15493','15494','15495','15496','15497','15498','15499','15500','15501','15502','15503','15504','15505','15506','15507','15508','15509','15510','15511','15512','15513','15514','15515','15516','15517','15518','15519','15520','15521','15522','15523','15524','15525','15526','15527','15528','15529','15530','15531','15532','15533','15534','15535','15536','15537','15538','15539','15540','15541','15542','15543','15544','15545','15546','15547','15548','15549','15550','15551','15552','15553','15554','15555','15556','15557','15558','15559','15560','15561','15562','15563','15564','15565','15566','15567','15568','15569','15570','15607','15608','15609','15610','15611','15612','15613','15614','15615','15616','15617','15618','15619','15620','15621','15622','15623','15624','15625','15626','15627','15628','15629','15630','15631','15632','15633','15634','15635','15636','15637','15638','15639','15640','15641','15642','15643','15644','15645','15646','15647','15648','15649','15650','15651','15652','15653','15654','15655','15656','15657','15658','15659','15660','15661','15662','15663','15664','15665','15666','15667','15668','15669','15670','15671','15672','15673','15685','15686','27867','28216','29027','29028','29032','29330','29331','29987','29988','30065','30066')
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 = 1087) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2616) 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`='2616'
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('1086','1087') 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 = 15491) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29566) 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`='29566'
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('4089','9356','9357','9358','9359','9360','9361','9362','9363','9364','9365','9366','9367','9368','9369','9370','9371','9372','15396','15397','15398','15399','15485','15486','15487','15488','15489','15490','15491','15492','15493','15494','15495','15496','15497','15498','15499','15500','15501','15502','15503','15504','15505','15506','15507','15508','15509','15510','15511','15512','27867') 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 = 28216) 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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='28216' 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 = 15468) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32056) 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`='32056'
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('15453','15454','15455','15456','15457','15458','15459','15460','15461','15462','15463','15464','15465','15466','15467','15468','15469','15470','15471','15472','15473','15474','15475','15476','15477','15478','15479','15480','15481','15482','15483','15484','29330','29331') 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 = 15497) ORDER BY name_title
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 = 15432) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16235) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC 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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=0 AND `id` IN('1086','1088','1089','1090','2232','2233','2234','2235','4066','4089','4245','8072','8073','8074','8075','9332','9333','9334','9335','9336','9337','9338','9339','9340','9341','9342','9343','9344','9345','9346','9347','9348','9349','9350','9351','9352','9353','9354','9355','9356','9357','9358','9359','9360','9361','9362','9363','9364','9365','9366','9367','9368','9369','9370','9371','9372','9373','9374','9375','9376','9377','9378','9379','9380','9381','9382','9383','9384','9385','9386','9387','9388','9389','9390','9391','9392','9393','9394','9395','9396','9397','9398','9399','9400','9401','9402','9403','9404','9405','9406','9407','9408','9409','9410','9411','9412','9413','9414','9415','9416','9417','9420','9421','9422','9423','9424','9425','9426','9427','9428','9429','9430','9431','9432','9433','9434','9435','9437','9988','9989','10001','10002','10003','10004','10005','10006','10007','10008','10085','10086','10087','10088','10089','10090','13390','13958','13959','13960','13961','13964','15341','15342','15343','15344','15345','15346','15347','15348','15349','15350','15351','15352','15353','15354','15355','15356','15357','15358','15359','15360','15361','15362','15363','15364','15365','15366','15367','15368','15369','15370','15371','15372','15373','15374','15375','15376','15377','15378','15379','15380','15381','15382','15383','15384','15385','15386','15387','15388','15389','15390','15391','15392','15393','15394','15395','15396','15397','15398','15399','15400','15401','15402','15403','15404','15405','15406','15407','15408','15409','15410','15411','15412','15413','15414','15415','15416','15417','15418','15419','15420','15421','15422','15423','15424','15425','15426','15427','15428','15429','15430','15431','15433','15434','15435','15436','15437','15438','15439','15440','15441','15442','15443','15444','15445','15446','15447','15448','15449','15450','15451','15452','15453','15454','15455','15456','15457','15458','15459','15460','15461','15462','15463','15464','15465','15466','15467','15469','15470','15471','15472','15473','15474','15475','15476','15477','15478','15479','15480','15481','15482','15483','15484','15485','15486','15487','15488','15489','15490','15492','15493','15494','15495','15496','15498','15499','15500','15501','15502','15503','15504','15505','15506','15507','15508','15509','15510','15511','15512','15513','15514','15515','15516','15517','15518','15519','15520','15521','15522','15523','15524','15525','15526','15527','15528','15529','15530','15531','15532','15533','15534','15535','15536','15537','15538','15539','15540','15541','15542','15543','15544','15545','15546','15547','15548','15549','15550','15551','15552','15553','15554','15555','15556','15557','15558','15559','15560','15561','15562','15563','15564','15565','15566','15567','15568','15569','15570','15607','15608','15609','15610','15611','15612','15613','15614','15615','15616','15617','15618','15619','15620','15621','15622','15623','15624','15625','15626','15627','15628','15629','15630','15631','15632','15633','15634','15635','15636','15637','15638','15639','15640','15641','15642','15643','15644','15645','15646','15647','15648','15649','15650','15651','15652','15653','15654','15655','15656','15657','15658','15659','15660','15661','15662','15663','15664','15665','15666','15667','15668','15669','15670','15671','15672','15673','15685','15686','27867','29027','29028','29032','29330','29331','29987','29988','30065','30066')
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 = 1088) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 13728) 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`='13728'
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('1088','1089','1090','2232','2233','2234','2235','13390') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group