/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`='freightliner' 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`='261'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('14721','14722','14723','14724','14725','14726','14727','14728','14729','14730','14731','14732','14733','14734','14735','14736','15768','15769','17230','19371','19372','19373','19374','19375','37220','37221','37222','37223','37224','37225','37226','37227','37228','37229','37230','37231','37232','37233','37234','37235','37236','37237','37238','37239','37240','37241','37242','37243','37244','37245','37246','37247','37248','37249','37250','37251','37252','37253','37254','37255','37256','37257','37258','37259','37260','37261','37262','37263','37264','37265','37266','37267','37268','37269','37270','37271','37272','37273','37274','37275','37276','37277','37278','37279','37280','37281','37282','37283','37284','37285','37286','37287','37288','37289','37290','37291','37292','37293','37294','37295','37296','37297','37298','37299','37300','37301','37302','37303','37304','37305','37306','37307','37308','37309','37310','37311','37312','37313','37314','37315','37316','37317','37318','37319','37320','37321','37322','37323','37324','37325','37326','37327','37328','37329','37330','37331','37332','37333','37334','37335','37336','37337','37338','37339','37340','37341','37342','37343','37344','37345','37346','37347','37348','37349','37350','37351','37352','37353','37354','37355','37356','37357','37358','37359','37360','37361','37362','37363','37364','37365','37366','37367','37368','37369','37370','37371','37372','37373','37374','37375','37376','37377','37378','37379','37380','37381','37382','37383','37384','37385','37386','37387','37388','37389','37390','38662','38663','38664','38665','38666','38667','38668','38669','38670','38671','38672','38673','38674','38675','38676','38677','38678','38679','38680','38681','38682','38683','38684','38685','38686','38687','38688','38689','38690','38691','38692','38693','38694','38695','38696','38697','38698','38699','38700','38701','38702','38703','38704','38705','38706','38707','38708','38709','38710','38711','38712','38713','38714','38715','38716','38717','38718','38719','38720','38721','38722','38723','38724','38725','38726','38727','38728','38729','38730','38731','38732','38733','38734','38735','38736','38737','38738','38739','38740','38741','38742','38743','38744','38745','38746','38747','38748','38749','38750','38751','38752','38753','38754','38755','38756','38757','38758','38759','38760','38761','38762','38763','38764','38765','38766','38767','38768','38769','38770','38771','38772','38773','38774','38775','38776','38777','38778','38779','38780','38781','38782','38783','38784','38785','38786','38787','38788','38789','38790','38791','38792','38793','38794','38795','38796','38797','38798','38799','38800','38801','38802','38803','38804','38805','38806','38807','38808','38809','38810','38811','38812','38813','38814','38815','38816','38817','38818','38819','38820','38821','38822','38823','38824','38825','38826','38827','38828','38829','38830','38831','38832','38833','38834','38835','38836','38837','38838','38839','38840','38841','38842','38843','38844','38845','38846','38847','38848','38849','38850','38851','38852','38853','38854','38855','38856','38857','38858','38859','38860','38861','38862','38863','38864','38865','38866','38867','38868','38869','38870','38871','38872','38873','38874','38875','38876','38877','38878','38879','38880','38881','38882','38883','38884','38885','38886','38887','38888','38889','38890','38891','38892','38893','38894','38895','38896','38897','38898','38899','38900','38901','38902','38903','38904','38905','38906','38907','38908','38909','38910','38911','38912','38913','38914','38915','38916','38917','38918','38919','38920','38921','38922','38923','38924','38925','38926','38927','38928','38929','38930','38931','38932','38933','38934','38935','38936','38937','38938','38939','38940','38941','38942','38943','38944','38945','38946','38947','38948','38949','38950','38951','38952','38953','38954','38955','38956','38957','38958','38959','38960','38961','38962','38963','38964','38965','38966','38967','38968','38969','38970','38971','38972','38973','38974','38975','38976','38977','38978','38979','38980','38981','38982','38983','38984','38985','38986','38987','38988','38989','38990','38991','38992','38993','38994','38995','38996','38997','38998','38999','39000','39001','39002','39003','39004','39005','39006','39007','39008','39009','39010','39011','39012','39013','39014','39015','39016','39017','39018','39019','39020','39021','39022','39023','39024','39025','39026','39027','39028','39029','39030','39031','39032','39033','39034','39035','39036','39037','39038','39039','39040','39041','39042','39043','39044','39045','39046','39047','39048','39049','39050','39051','39052','39053','39054','39055','39056','39057','46198','46241','46659','46690','46792','46828','46833','47161','47162','47163','47167','47168','47169','47170','47171','47172','47173','47298','47460','47476','47922','47923','47924','47925','47926','48181','48182','48345','48445','48446','48477','48478','48479','48480','48535','48536','48554','48555','48917','48918','48919','48920','48921','49015','49142','49143','49145','49150','49563','49564','49565','49566','49567','49568','49569','49570','49571','49572','49573','49574','49575','49576','49577','49578','49579','49580','49581','49582','50729','50730','50731','50732','50746','61833','61834','61835','61836','61837','61838','61839','61840','61841','61842','61843','61844','61845','61921','61922','61923','61924','61925','61926','61927','61928','61929','61930','61931','61956','61957','61958','61959','61960','61961','61962') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('14721','14722','14723','14724','14725','14726','14727','14728','14729','14730','14731','14732','14733','14734','14735','14736','15768','15769','17230','19371','19372','19373','19374','19375','37220','37221','37222','37223','37224','37225','37226','37227','37228','37229','37230','37231','37232','37233','37234','37235','37236','37237','37238','37239','37240','37241','37242','37243','37244','37245','37246','37247','37248','37249','37250','37251','37252','37253','37254','37255','37256','37257','37258','37259','37260','37261','37262','37263','37264','37265','37266','37267','37268','37269','37270','37271','37272','37273','37274','37275','37276','37277','37278','37279','37280','37281','37282','37283','37284','37285','37286','37287','37288','37289','37290','37291','37292','37293','37294','37295','37296','37297','37298','37299','37300','37301','37302','37303','37304','37305','37306','37307','37308','37309','37310','37311','37312','37313','37314','37315','37316','37317','37318','37319','37320','37321','37322','37323','37324','37325','37326','37327','37328','37329','37330','37331','37332','37333','37334','37335','37336','37337','37338','37339','37340','37341','37342','37343','37344','37345','37346','37347','37348','37349','37350','37351','37352','37353','37354','37355','37356','37357','37358','37359','37360','37361','37362','37363','37364','37365','37366','37367','37368','37369','37370','37371','37372','37373','37374','37375','37376','37377','37378','37379','37380','37381','37382','37383','37384','37385','37386','37387','37388','37389','37390','38662','38663','38664','38665','38666','38667','38668','38669','38670','38671','38672','38673','38674','38675','38676','38677','38678','38679','38680','38681','38682','38683','38684','38685','38686','38687','38688','38689','38690','38691','38692','38693','38694','38695','38696','38697','38698','38699','38700','38701','38702','38703','38704','38705','38706','38707','38708','38709','38710','38711','38712','38713','38714','38715','38716','38717','38718','38719','38720','38721','38722','38723','38724','38725','38726','38727','38728','38729','38730','38731','38732','38733','38734','38735','38736','38737','38738','38739','38740','38741','38742','38743','38744','38745','38746','38747','38748','38749','38750','38751','38752','38753','38754','38755','38756','38757','38758','38759','38760','38761','38762','38763','38764','38765','38766','38767','38768','38769','38770','38771','38772','38773','38774','38775','38776','38777','38778','38779','38780','38781','38782','38783','38784','38785','38786','38787','38788','38789','38790','38791','38792','38793','38794','38795','38796','38797','38798','38799','38800','38801','38802','38803','38804','38805','38806','38807','38808','38809','38810','38811','38812','38813','38814','38815','38816','38817','38818','38819','38820','38821','38822','38823','38824','38825','38826','38827','38828','38829','38830','38831','38832','38833','38834','38835','38836','38837','38838','38839','38840','38841','38842','38843','38844','38845','38846','38847','38848','38849','38850','38851','38852','38853','38854','38855','38856','38857','38858','38859','38860','38861','38862','38863','38864','38865','38866','38867','38868','38869','38870','38871','38872','38873','38874','38875','38876','38877','38878','38879','38880','38881','38882','38883','38884','38885','38886','38887','38888','38889','38890','38891','38892','38893','38894','38895','38896','38897','38898','38899','38900','38901','38902','38903','38904','38905','38906','38907','38908','38909','38910','38911','38912','38913','38914','38915','38916','38917','38918','38919','38920','38921','38922','38923','38924','38925','38926','38927','38928','38929','38930','38931','38932','38933','38934','38935','38936','38937','38938','38939','38940','38941','38942','38943','38944','38945','38946','38947','38948','38949','38950','38951','38952','38953','38954','38955','38956','38957','38958','38959','38960','38961','38962','38963','38964','38965','38966','38967','38968','38969','38970','38971','38972','38973','38974','38975','38976','38977','38978','38979','38980','38981','38982','38983','38984','38985','38986','38987','38988','38989','38990','38991','38992','38993','38994','38995','38996','38997','38998','38999','39000','39001','39002','39003','39004','39005','39006','39007','39008','39009','39010','39011','39012','39013','39014','39015','39016','39017','39018','39019','39020','39021','39022','39023','39024','39025','39026','39027','39028','39029','39030','39031','39032','39033','39034','39035','39036','39037','39038','39039','39040','39041','39042','39043','39044','39045','39046','39047','39048','39049','39050','39051','39052','39053','39054','39055','39056','39057','46198','46241','46659','46690','46792','46828','46833','47161','47162','47163','47167','47168','47169','47170','47171','47172','47173','47298','47460','47476','47922','47923','47924','47925','47926','48181','48182','48345','48445','48446','48477','48478','48479','48480','48535','48536','48554','48555','48917','48918','48919','48920','48921','49015','49142','49143','49145','49150','49563','49564','49565','49566','49567','49568','49569','49570','49571','49572','49573','49574','49575','49576','49577','49578','49579','49580','49581','49582','50729','50730','50731','50732','50746','61833','61834','61835','61836','61837','61838','61839','61840','61841','61842','61843','61844','61845','61921','61922','61923','61924','61925','61926','61927','61928','61929','61930','61931','61956','61957','61958','61959','61960','61961','61962') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='261'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Freightliner%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='261'
724
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='261' 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`='261'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','882','1082','1083')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1460','1461','1462','1463','1464','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19318','19319','19320','19321','19322','19323','19324','19325','19326','19327','19328','19329','19330','19331','19332','19333','19334','19335','19336','19337','19338','19339','19340','19341','19342','19343','19344','19345','19346','19347','19348','19349','19350','19351','19352','19353','19354','19355','19356','19357','19358','19359','19360','19361','19362','19363','19364','19365','19366','19367','19368','19369','19370','19371','19372','19373','19374','19375','19376','19377','19378','19379','19380','19381','19382','19383','19384','19385','19386','19387','19388','19389','19390','19391','19392','19393','19394','19395','19396','19397','19398','19399','19400','19401','19402','19403','19404','19405','19406','19407','19408','19409','19410','19411','19412','19413','19414','19415','19416','19417','19418','19419','19420','19421','19422','19423','19424','19425','19426','19427','19428','19429','19430','19431','19432','19433','19434','19435','19436','19437','19438','19439','19440','19441','19442','19443','19444','19445','19446','19447','19448','19449','19450','19451','19452','19453','19454','19455','19456','19457','19458','19459','19460','19461','19462','19463','19464','19465','19466','19467','19468','20740','20741','20742','20743','20744','20745','20746','20747','20748','20749','20750','20751','20752','20753','20754','20755','20756','20757','20758','20759','20760','20761','20762','20763','20764','20765','20766','20767','20768','20769','20770','20771','20772','20773','20774','20775','20776','20777','20778','20779','20780','20781','20782','20783','20784','20785','20786','20787','20788','20789','20790','20791','20792','20793','20794','20795','20796','20797','20798','20799','20800','20801','20802','20803','20804','20805','20806','20807','20808','20809','20810','20811','20812','20813','20814','20815','20816','20817','20818','20819','20820','20821','20822','20823','20824','20825','20826','20827','20828','20829','20830','20831','20832','20833','20834','20835','20836','20837','20838','20839','20840','20841','20842','20843','20844','20845','20846','20847','20848','20849','20850','20851','20852','20853','20854','20855','20856','20857','20858','20859','20860','20861','20862','20863','20864','20865','20866','20867','20868','20869','20870','20871','20872','20873','20874','20875','20876','20877','20878','20879','20880','20881','20882','20883','20884','20885','20886','20887','20888','20889','20890','20891','20892','20893','20894','20895','20896','20897','20898','20899','20900','20901','20902','20903','20904','20905','20906','20907','20908','20909','20910','20911','20912','20913','20914','20915','20916','20917','20918','20919','20920','20921','20922','20923','20924','20925','20926','20927','20928','20929','20930','20931','20932','20933','20934','20935','20936','20937','20938','20939','20940','20941','20942','20943','20944','20945','20946','20947','20948','20949','20950','20951','20952','20953','20954','20955','20956','20957','20958','20959','20960','20961','20962','20963','20964','20965','20966','20967','20968','20969','20970','20971','20972','20973','20974','20975','20976','20977','20978','20979','20980','20981','20982','20983','20984','20985','20986','20987','20988','20989','20990','20991','20992','20993','20994','20995','20996','20997','20998','20999','21000','21001','21002','21003','21004','21005','21006','21007','21008','21009','21010','21011','21012','21013','21014','21015','21016','21017','21018','21019','21020','21021','21022','21023','21024','21025','21026','21027','21028','21029','21030','21031','21032','21033','21034','21035','21036','21037','21038','21039','21040','21041','21042','21043','21044','21045','21046','21047','21048','21049','21050','21051','21052','21053','21054','21055','21056','21057','21058','21059','21060','21061','21062','21063','21064','21065','21066','21067','21068','21069','21070','21071','21072','21073','21074','21075','21076','21077','21078','21079','21080','21081','21082','21083','21084','21085','21086','21087','21088','21089','21090','21091','21092','21093','21094','21095','21096','21097','21098','21099','21100','21101','21102','21103','21104','21105','21106','21107','21108','21109','21110','21111','21112','21113','21114','21115','21116','21117','21118','21119','21120','21121','21122','21123','21124','21125','21126','21127','21128','21129','21130','21131','21132','21133','21134','21135','28295','28332','28742','28773','28875','28911','28916','29232','29233','29234','29238','29239','29240','29241','29242','29243','29244','29366','29528','29544','29972','29973','29974','29975','30211','30212','30374','30474','30475','30506','30507','30508','30509','30564','30565','30583','30584','30938','30939','30940','31034','31155','31156','31158','31163','31294','31295','31296','31310','31667','31668','31669','31670','31671','31672','31673','31674','31675','31676','31677','31678','31679','31757','31758','31759','31760','31761','31762','31763','31764','31765','31766','31767','31791','31792','31793','31794','31795','31796','31797')
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 = 29244) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35747) 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`='35747'
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('28916','29238','29239','29240','29241','29242','29243','29244','29366','29975','30475','30508','30509','30565','30584','30939','30940','31156','31163','31296','31669','31672','31675','31677','31678','31679') 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 = 21117) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31301) 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`='31301'
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('21103','21104','21105','21106','21107','21108','21109','21110','21111','21112','21113','21114','21115','21116','21117','21118','21119','21120','21121','21122','21123','21135','31757','31758','31759','31760','31761','31762','31763','31764','31765','31766','31767','31791','31792','31793','31794','31795','31796','31797') 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 = 29232) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35738) 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`='35738'
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('28332','28911','29232','29233','29234','29544','29972','29974','30211','30212','30474','30507','30564','30583','30938','31034','31155','31294','31668','31670','31671','31673','31674','31676') 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 = 29366) 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 = 29975) 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 = 21135) 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 = 28773) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34301) 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`='34301'
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('28742','28773','29528') 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 = 20801) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 21788) 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 = 28916) 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 = 28911) 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 = 29972) 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 = 29233) 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 = 28332) 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 = 29528) 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 = 28742) 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 = 29242) 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 `prepay`=0 AND `id` IN('1460','1461','1462','1463','1464','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19318','19319','19320','19321','19322','19323','19324','19325','19326','19327','19328','19329','19330','19331','19332','19333','19334','19335','19336','19337','19338','19339','19340','19341','19342','19343','19344','19345','19346','19347','19348','19349','19350','19351','19352','19353','19354','19355','19356','19357','19358','19359','19360','19361','19362','19363','19364','19365','19366','19367','19368','19369','19370','19371','19372','19373','19374','19375','19376','19377','19378','19379','19380','19381','19382','19383','19384','19385','19386','19387','19388','19389','19390','19391','19392','19393','19394','19395','19396','19397','19398','19399','19400','19401','19402','19403','19404','19405','19406','19407','19408','19409','19410','19411','19412','19413','19414','19415','19416','19417','19418','19419','19420','19421','19422','19423','19424','19425','19426','19427','19428','19429','19430','19431','19432','19433','19434','19435','19436','19437','19438','19439','19440','19441','19442','19443','19444','19445','19446','19447','19448','19449','19450','19451','19452','19453','19454','19455','19456','19457','19458','19459','19460','19461','19462','19463','19464','19465','19466','19467','19468','20740','20741','20742','20743','20744','20745','20746','20747','20748','20749','20750','20751','20752','20753','20754','20755','20756','20757','20758','20759','20760','20761','20762','20763','20764','20765','20766','20767','20768','20769','20770','20771','20772','20773','20774','20775','20776','20777','20778','20779','20780','20781','20782','20783','20784','20785','20786','20787','20788','20789','20790','20791','20792','20793','20794','20795','20796','20797','20798','20799','20800','20802','20803','20804','20805','20806','20807','20808','20809','20810','20811','20812','20813','20814','20815','20816','20817','20818','20819','20820','20821','20822','20823','20824','20825','20826','20827','20828','20829','20830','20831','20832','20833','20834','20835','20836','20837','20838','20839','20840','20841','20842','20843','20844','20845','20846','20847','20848','20849','20850','20851','20852','20853','20854','20855','20856','20857','20858','20859','20860','20861','20862','20863','20864','20865','20866','20867','20868','20869','20870','20871','20872','20873','20874','20875','20876','20877','20878','20879','20880','20881','20882','20883','20884','20885','20886','20887','20888','20889','20890','20891','20892','20893','20894','20895','20896','20897','20898','20899','20900','20901','20902','20903','20904','20905','20906','20907','20908','20909','20910','20911','20912','20913','20914','20915','20916','20917','20918','20919','20920','20921','20922','20923','20924','20925','20926','20927','20928','20929','20930','20931','20932','20933','20934','20935','20936','20937','20938','20939','20940','20941','20942','20943','20944','20945','20946','20947','20948','20949','20950','20951','20952','20953','20954','20955','20956','20957','20958','20959','20960','20961','20962','20963','20964','20965','20966','20967','20968','20969','20970','20971','20972','20973','20974','20975','20976','20977','20978','20979','20980','20981','20982','20983','20984','20985','20986','20987','20988','20989','20990','20991','20992','20993','20994','20995','20996','20997','20998','20999','21000','21001','21002','21003','21004','21005','21006','21007','21008','21009','21010','21011','21012','21013','21014','21015','21016','21017','21018','21019','21020','21021','21022','21023','21024','21025','21026','21027','21028','21029','21030','21031','21032','21033','21034','21035','21036','21037','21038','21039','21040','21041','21042','21043','21044','21045','21046','21047','21048','21049','21050','21051','21052','21053','21054','21055','21056','21057','21058','21059','21060','21061','21062','21063','21064','21065','21066','21067','21068','21069','21070','21071','21072','21073','21074','21075','21076','21077','21078','21079','21080','21081','21082','21083','21084','21085','21086','21087','21088','21089','21090','21091','21092','21093','21094','21095','21096','21097','21098','21099','21100','21101','21102','21103','21104','21105','21106','21107','21108','21109','21110','21111','21112','21113','21114','21115','21116','21118','21119','21120','21121','21122','21123','21124','21125','21126','21127','21128','21129','21130','21131','21132','21133','21134','28295','28875','29234','29238','29239','29240','29241','29243','29544','29973','29974','30211','30212','30374','30474','30475','30506','30507','30508','30509','30564','30565','30583','30584','30938','30939','30940','31034','31155','31156','31158','31163','31294','31295','31296','31310','31667','31668','31669','31670','31671','31672','31673','31674','31675','31676','31677','31678','31679','31757','31758','31759','31760','31761','31762','31763','31764','31765','31766','31767','31791','31792','31793','31794','31795','31796','31797')
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 = 31765) 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 = 31764) 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 = 1461) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 3145) 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`='3145'
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('1460','1461','1462','1463','1464') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group