/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`='honda' 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`='53'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('3525','4951','4952','4953','4954','4955','4956','4957','4958','4959','4960','4961','4962','4963','4964','4965','4966','4967','4968','4969','4970','4971','4972','4973','4974','4975','4976','4977','4978','4979','4980','4981','4982','4983','4984','4985','4986','4987','4988','4989','4990','4991','4992','4993','4994','4995','4996','4997','4998','4999','5000','5001','5002','5003','5004','5005','5006','5007','5008','5009','5010','5011','5012','5013','5014','5015','5016','5017','5018','5019','5020','5021','5022','5023','5024','5025','5026','5027','5028','5029','5030','5031','5032','5033','5034','5035','5036','5037','5038','5039','5040','5041','5042','5043','5044','5045','5046','5047','5048','5049','5050','5051','5052','5053','5054','5055','5056','5057','5058','5059','5060','5061','5062','7503','7504','7505','7506','7507','7508','7509','7510','7511','7512','7513','7514','7515','7516','7517','7518','7519','7520','7521','7522','7523','7524','7525','7526','7527','7528','7529','7530','7531','7532','7533','7534','7535','7536','7537','7538','7539','7540','7541','7542','7543','7544','7545','7546','7547','7548','7549','7550','7551','7552','7553','7554','7555','7556','7557','7558','7559','7560','7561','7562','7563','7564','7565','7567','7568','7569','7570','7571','7572','7573','7574','7575','7576','7577','7578','7579','7580','7581','7582','7583','7584','7585','7586','7587','7588','7589','7590','7591','7592','7593','7594','7595','7596','7597','7598','7599','7600','7601','7602','7603','7604','7605','7606','7607','7608','7939','7940','7941','7942','7943','7944','7945','7946','7947','7948','7949','7950','7951','7952','9070','9071','9072','9073','9074','11004','11986','12066','12374','12375','12376','12377','12378','12379','12699','12700','12701','12702','13051','13052','13053','13054','13055','13284','13285','13286','13287','13288','13766','13936','13937','13938','13939','13940','13941','13942','13943','13944','13945','13946','13947','13948','13949','15313','16209','16436','16437','16438','16439','17510','17511','17920','18167','18431','18786','18787','18788','18789','18790','18791','18792','18793','19229','19230','20005','20006','20007','20008','20009','20010','20011','20012','20013','20014','20015','20016','20017','20018','20019','20020','20021','20022','20023','20024','20025','20026','20027','20028','20029','20030','20031','20032','20033','20484','20485','20486','20487','20488','20489','20490','20491','20492','20493','20494','20495','20496','20497','20498','20499','20500','20501','20502','20503','20504','20505','20506','20507','20508','20509','20510','20809','20975','20976','20977','20978','20992','20993','22061','22108','22128','22144','22145','22146','22147','22148','22149','22150','22151','22152','22153','22154','22155','22156','22157','22158','22159','22160','22161','22164','22165','22166','22167','22168','22169','22170','22171','22172','22173','22220','22221','22222','22223','22224','22225','22226','22227','22228','22229','22230','22231','22232','23415','23416','23417','23418','23419','23420','23421','23422','23423','23424','23425','23426','23427','23428','23429','23430','23431','23432','23433','23434','23435','23436','23437','23438','23439','23440','23441','23442','23443','23444','23445','23446','23447','23450','23451','23452','23453','23454','23455','23456','23457','23458','23459','23460','23461','23462','23463','23464','23465','23466','23467','23468','23469','23470','23471','23472','23473','23474','23475','23479','23480','23483','23484','23485','23489','23491','23493','23494','23495','23496','23497','23498','23499','23500','23501','23502','23503','23504','23505','23506','23507','23508','23509','23510','23511','23513','23514','23515','23516','23517','23518','23519','23520','23521','23522','23523','23524','23525','23526','23527','23528','23529','23530','23531','23532','23533','23534','23535','24558','24580','24581','24664','24665','24666','25857','25858','25859','25860','25861','25862','25863','25864','25865','25866','25867','25868','25869','25870','25871','25872','25873','25874','25875','25876','25877','25878','25879','25880','25881','25882','25883','25884','25885','25886','25888','25889','25891','25892','25893','25894','25895','25896','25897','25898','25899','25900','25901','25902','25903','25904','25905','25906','25907','25908','25909','25910','25911','25912','25913','25914','25915','25916','25917','25918','25919','25920','25921','25922','25923','25924','25925','25926','25927','25928','25929','25930','25931','25932','25933','25934','25935','25936','25937','25938','25939','25940','25941','25942','25943','25944','25945','25946','25947','25948','25949','25950','25951','25952','25953','25954','25955','25956','25957','25958','25960','25961','26029','26030','26031','26032','26033','26034','26035','26036','26037','26038','26039','26040','26042','26043','26044','26045','26046','26047','26048','26049','26050','26051','26052','26053','33765','33766','33767','33768','33769','33770','33771','33772','33773','45997','46128','46423','46424','46425','46426','46427','46665','46666','46985','46986','46987','47294','47295','47297','48055','48237','48498','48773','49009','50088','50089','50090','50091','50092','50093','50094','50095','50096','50097','50098','50099','50100','50101','50102','50103','50104','50105','50106','50107','50108','50109','50110','50111','50112','50113','50114','50115','50116','50791','51327','51328','57736','57737','57738','57739','57740','57741','57742','57743','57744','57745','57746','57747','57748','57749','57750','57751','57752','57753','57754','57755','57756','57757','57758','57759','57760','57761','57762','57763','57764','57765','57766','57767','57768','57769','57770','57771','57772','57773','57774','57775','57776','57777','57778','57779','57780','57781','57782','57783','57784','57785','57786','57787','57788','57789','57790','57791','57792','57793','57794','57795','57796','57797','57798','57799','57800','57801','57802','57803','57804','57805','57806','57807','57808','57809','57810','57811','57812','57813','57814','57815','57816','57817','57818','57819','57820','57821','57822','57823','57824','57825','57826','57827','57828','57829','57830','57831','57832','57833','57834','57835','57836','57837','57838','57839','57840','57841','57842','57843','57844','57845','57846','57847','57848','57849','57850','57851','57852','57853','57854','57855','57856','57857','57858','57859','57860','57861','57862','57863','57864','57865','57866','57867','57868','57869','57870','57871','57872','57873','57874','57875','57876','57877','57878','57879','57880','57881','57882','57883','57884','57885','57886','57887','57888','57889','57890','57891','57892','57893','57894','57895','57896','57897','57898','57899','57900','57901','57902','57903','57904','57905','57906','57907','57908','57909','57910','57911','57912','57913','57914','57915','57916','57917','57918','57919','57920','57921','57922','57923','57924','57925','57926','57927','57928','57929','57930','57931','57932','57933','57934','57935','57936','57937','57938','57939','57940','57941','57942','57943','57944','57945','57946','57947','57948','57949','57950','57951','57952','57953','57954','57955','61982','61983','61984','61985') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('3525','4951','4952','4953','4954','4955','4956','4957','4958','4959','4960','4961','4962','4963','4964','4965','4966','4967','4968','4969','4970','4971','4972','4973','4974','4975','4976','4977','4978','4979','4980','4981','4982','4983','4984','4985','4986','4987','4988','4989','4990','4991','4992','4993','4994','4995','4996','4997','4998','4999','5000','5001','5002','5003','5004','5005','5006','5007','5008','5009','5010','5011','5012','5013','5014','5015','5016','5017','5018','5019','5020','5021','5022','5023','5024','5025','5026','5027','5028','5029','5030','5031','5032','5033','5034','5035','5036','5037','5038','5039','5040','5041','5042','5043','5044','5045','5046','5047','5048','5049','5050','5051','5052','5053','5054','5055','5056','5057','5058','5059','5060','5061','5062','7503','7504','7505','7506','7507','7508','7509','7510','7511','7512','7513','7514','7515','7516','7517','7518','7519','7520','7521','7522','7523','7524','7525','7526','7527','7528','7529','7530','7531','7532','7533','7534','7535','7536','7537','7538','7539','7540','7541','7542','7543','7544','7545','7546','7547','7548','7549','7550','7551','7552','7553','7554','7555','7556','7557','7558','7559','7560','7561','7562','7563','7564','7565','7567','7568','7569','7570','7571','7572','7573','7574','7575','7576','7577','7578','7579','7580','7581','7582','7583','7584','7585','7586','7587','7588','7589','7590','7591','7592','7593','7594','7595','7596','7597','7598','7599','7600','7601','7602','7603','7604','7605','7606','7607','7608','7939','7940','7941','7942','7943','7944','7945','7946','7947','7948','7949','7950','7951','7952','9070','9071','9072','9073','9074','11004','11986','12066','12374','12375','12376','12377','12378','12379','12699','12700','12701','12702','13051','13052','13053','13054','13055','13284','13285','13286','13287','13288','13766','13936','13937','13938','13939','13940','13941','13942','13943','13944','13945','13946','13947','13948','13949','15313','16209','16436','16437','16438','16439','17510','17511','17920','18167','18431','18786','18787','18788','18789','18790','18791','18792','18793','19229','19230','20005','20006','20007','20008','20009','20010','20011','20012','20013','20014','20015','20016','20017','20018','20019','20020','20021','20022','20023','20024','20025','20026','20027','20028','20029','20030','20031','20032','20033','20484','20485','20486','20487','20488','20489','20490','20491','20492','20493','20494','20495','20496','20497','20498','20499','20500','20501','20502','20503','20504','20505','20506','20507','20508','20509','20510','20809','20975','20976','20977','20978','20992','20993','22061','22108','22128','22144','22145','22146','22147','22148','22149','22150','22151','22152','22153','22154','22155','22156','22157','22158','22159','22160','22161','22164','22165','22166','22167','22168','22169','22170','22171','22172','22173','22220','22221','22222','22223','22224','22225','22226','22227','22228','22229','22230','22231','22232','23415','23416','23417','23418','23419','23420','23421','23422','23423','23424','23425','23426','23427','23428','23429','23430','23431','23432','23433','23434','23435','23436','23437','23438','23439','23440','23441','23442','23443','23444','23445','23446','23447','23450','23451','23452','23453','23454','23455','23456','23457','23458','23459','23460','23461','23462','23463','23464','23465','23466','23467','23468','23469','23470','23471','23472','23473','23474','23475','23479','23480','23483','23484','23485','23489','23491','23493','23494','23495','23496','23497','23498','23499','23500','23501','23502','23503','23504','23505','23506','23507','23508','23509','23510','23511','23513','23514','23515','23516','23517','23518','23519','23520','23521','23522','23523','23524','23525','23526','23527','23528','23529','23530','23531','23532','23533','23534','23535','24558','24580','24581','24664','24665','24666','25857','25858','25859','25860','25861','25862','25863','25864','25865','25866','25867','25868','25869','25870','25871','25872','25873','25874','25875','25876','25877','25878','25879','25880','25881','25882','25883','25884','25885','25886','25888','25889','25891','25892','25893','25894','25895','25896','25897','25898','25899','25900','25901','25902','25903','25904','25905','25906','25907','25908','25909','25910','25911','25912','25913','25914','25915','25916','25917','25918','25919','25920','25921','25922','25923','25924','25925','25926','25927','25928','25929','25930','25931','25932','25933','25934','25935','25936','25937','25938','25939','25940','25941','25942','25943','25944','25945','25946','25947','25948','25949','25950','25951','25952','25953','25954','25955','25956','25957','25958','25960','25961','26029','26030','26031','26032','26033','26034','26035','26036','26037','26038','26039','26040','26042','26043','26044','26045','26046','26047','26048','26049','26050','26051','26052','26053','33765','33766','33767','33768','33769','33770','33771','33772','33773','45997','46128','46423','46424','46425','46426','46427','46665','46666','46985','46986','46987','47294','47295','47297','48055','48237','48498','48773','49009','50088','50089','50090','50091','50092','50093','50094','50095','50096','50097','50098','50099','50100','50101','50102','50103','50104','50105','50106','50107','50108','50109','50110','50111','50112','50113','50114','50115','50116','50791','51327','51328','57736','57737','57738','57739','57740','57741','57742','57743','57744','57745','57746','57747','57748','57749','57750','57751','57752','57753','57754','57755','57756','57757','57758','57759','57760','57761','57762','57763','57764','57765','57766','57767','57768','57769','57770','57771','57772','57773','57774','57775','57776','57777','57778','57779','57780','57781','57782','57783','57784','57785','57786','57787','57788','57789','57790','57791','57792','57793','57794','57795','57796','57797','57798','57799','57800','57801','57802','57803','57804','57805','57806','57807','57808','57809','57810','57811','57812','57813','57814','57815','57816','57817','57818','57819','57820','57821','57822','57823','57824','57825','57826','57827','57828','57829','57830','57831','57832','57833','57834','57835','57836','57837','57838','57839','57840','57841','57842','57843','57844','57845','57846','57847','57848','57849','57850','57851','57852','57853','57854','57855','57856','57857','57858','57859','57860','57861','57862','57863','57864','57865','57866','57867','57868','57869','57870','57871','57872','57873','57874','57875','57876','57877','57878','57879','57880','57881','57882','57883','57884','57885','57886','57887','57888','57889','57890','57891','57892','57893','57894','57895','57896','57897','57898','57899','57900','57901','57902','57903','57904','57905','57906','57907','57908','57909','57910','57911','57912','57913','57914','57915','57916','57917','57918','57919','57920','57921','57922','57923','57924','57925','57926','57927','57928','57929','57930','57931','57932','57933','57934','57935','57936','57937','57938','57939','57940','57941','57942','57943','57944','57945','57946','57947','57948','57949','57950','57951','57952','57953','57954','57955','61982','61983','61984','61985') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='53'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Honda%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='53'
1226
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='53' ORDER BY `sort_name`, `type` LIMIT 1200, 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`='53'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','885','886')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('254','518','873','874','875','876','877','878','879','880','1318','1319','2037','2038','2039','2040','2041','2042','2043','2044','2045','2046','2047','2048','2049','2050','2051','2052','2053','2054','2055','2056','2057','2058','2059','2060','2061','2062','2063','2064','2065','2516','2517','2518','2519','2520','2521','2522','2523','2524','2525','2526','2527','2528','2529','2530','2531','2532','2533','2534','2535','2536','2537','2538','2539','2540','2541','2542','2841','3007','3008','3009','3010','3024','3025','4119','4169','4191','4210','4211','4212','4213','4214','4215','4216','4217','4218','4219','4220','4221','4222','4223','4224','4225','4226','4227','4230','4231','4232','4233','4234','4235','4236','4237','4238','4239','4289','4290','4291','4292','4293','4294','4295','4296','4297','4298','4299','4300','4301','5487','5488','5489','5490','5491','5492','5493','5494','5495','5496','5497','5498','5499','5500','5501','5502','5503','5504','5505','5506','5507','5508','5509','5510','5511','5512','5513','5514','5515','5516','5517','5518','5519','5522','5523','5524','5525','5526','5527','5528','5529','5530','5531','5532','5533','5534','5535','5536','5537','5538','5539','5540','5541','5542','5543','5544','5545','5546','5547','5551','5552','5555','5556','5557','5561','5563','5565','5566','5567','5568','5569','5570','5571','5572','5573','5574','5575','5576','5577','5578','5579','5580','5581','5582','5583','5585','5586','5587','5588','5589','5590','5591','5592','5593','5594','5595','5596','5597','5598','5599','5600','5601','5602','5603','5604','5605','5606','5607','6630','6652','6653','6736','6737','6738','7929','7930','7931','7932','7933','7934','7935','7936','7937','7938','7939','7940','7941','7942','7943','7944','7945','7946','7947','7948','7949','7950','7951','7952','7953','7954','7955','7956','7957','7958','7960','7961','7963','7964','7965','7966','7967','7968','7969','7970','7971','7972','7973','7974','7975','7976','7977','7978','7979','7980','7981','7982','7983','7984','7985','7986','7987','7988','7989','7990','7991','7992','7993','7994','7995','7996','7997','7998','7999','8000','8001','8002','8003','8004','8005','8006','8007','8008','8009','8010','8011','8012','8013','8014','8015','8016','8017','8018','8019','8020','8021','8022','8023','8024','8025','8026','8027','8028','8029','8030','8032','8033','8101','8102','8103','8104','8105','8106','8107','8108','8109','8110','8111','8112','8114','8115','8116','8117','8118','8119','8120','8121','8122','8123','8124','8125','15843','15844','15845','15846','15847','15848','15849','15850','15851','28091','28227','28508','28509','28510','28511','28512','28748','28749','29066','29067','29068','29362','29363','29365','30095','30266','30527','30793','31028','31353','31817','31818','31819','31820')
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 = 4294) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34658) 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`='34658'
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('4290','4292','4294','4297','4298','4299','4300','8109','8110','8114','8117','8118','8119','8120','8121') 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 = 880) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33873) 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`='33873'
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('873','874','875','876','877','878','879','880','1318','1319','2037','2038','2039','2040','2041','2042','2043','2044','2045','2046','2047','2048','2049','2050','2051','2052','2053','2054','2055','2056','2057','2058','2059','2060','2061','2062','4169','7989','7990','7991','7992','7993','7994','7995','7996','7997','7998','7999','8000','8001','8002','8003','8004','8005','8006','8007','8008','8009','8010','8011','8012','8013','8022','8023','8024','8025','8026','8027','8028','8029','28748','28749','29362','29363') 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 = 15849) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16626) 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 = 8012) 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 = 4212) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 30301) 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`='30301'
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('4210','4211','4212') 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 = 2048) 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 = 8114) 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 = 4239) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29053) 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`='29053'
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('4231','4232','4233','4234','4235','4236','4237','4238','4239','31819') 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 = 1318) 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 = 4236) 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 = 5526) 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`='5526' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group