/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`='nissan' 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`='99'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('7','3877','3878','3879','3880','3881','3882','3883','3884','3885','3886','3887','3888','3889','3890','3891','3892','3893','3894','3895','3896','3897','3898','3899','3900','3901','3902','3903','3904','3905','3906','3907','3908','3909','3910','3911','3912','3913','3914','3915','3916','3917','3918','3919','3920','3921','3922','3923','3924','3925','3926','3927','3928','3929','3930','3931','3932','3933','3934','3935','3936','3937','3938','3939','3940','3941','3942','3943','3944','3945','3946','3947','3948','3949','3950','3951','3952','3953','3954','3955','3956','3957','3958','3959','3960','3961','3962','3963','3964','3965','3966','3967','3968','3969','3970','3971','3972','3973','3974','3975','3976','3977','3978','3979','3980','3981','3982','3983','3984','3985','3986','3987','3988','3989','3990','3991','3992','3993','3994','3995','3996','3997','3998','3999','4000','4001','4002','4003','4004','4005','4006','4007','4008','4009','4010','4011','4012','4013','4014','4015','4016','4017','4018','4019','4020','4021','4022','4023','4024','4025','4026','4027','4028','4029','4030','4031','4032','4033','4034','4035','4036','4037','4038','4039','4040','4041','4042','4043','4044','4045','4046','4047','4048','4049','4050','4051','4052','4053','4054','4055','4056','4057','4271','7127','7128','7129','7130','7131','7132','7133','7134','7135','7136','7137','7138','7139','7140','7141','7142','7143','7144','7145','7146','7147','7148','7149','7150','7151','7152','7153','7154','7155','7156','7157','7158','7159','7160','7161','7162','7163','7164','7165','7166','7167','7168','7169','7170','7171','7172','7173','7174','7175','7176','7177','7178','7179','7180','7181','7182','7183','7184','7185','7186','7187','7188','7189','7190','7191','7192','7193','7195','7196','7197','7198','7199','7200','7201','7202','7203','7204','7205','7206','7207','7208','7209','7210','7211','7212','7213','7214','7215','7216','7217','7218','7219','7220','7221','7222','7223','7224','7225','7226','7227','7228','7229','7230','7231','7232','7233','7234','7235','7236','7237','7238','7239','7240','7241','7242','7243','7244','7245','7246','7247','7248','7249','7250','7251','7252','7253','7254','7255','7256','7257','7258','7259','7260','7261','7262','7263','7264','7265','7266','7267','7268','7269','7270','7271','7272','7273','7274','7275','7276','7277','7278','7279','7280','7281','7282','8941','8942','9078','9079','9080','11136','11137','11138','11139','11140','11141','11142','11143','11144','11145','11146','11147','11148','11149','11150','12018','12019','12722','12723','12724','12725','12879','12916','13140','13141','13340','13341','13342','13343','14024','14025','14026','14027','14028','14029','14030','14031','14032','14033','14034','14035','14036','14037','14038','14039','14040','14041','14042','14043','14044','14045','14046','14374','14375','14376','14377','14378','14379','14380','14381','14382','15342','15343','15344','15466','15467','15468','16307','16308','16309','16455','16456','16457','16963','16964','16965','17647','17648','17650','17651','17652','17653','17654','17655','17656','17657','17658','17659','17660','17661','17662','17663','18213','18214','18215','18216','18217','18218','18219','18220','18345','18346','18347','18348','18349','18542','18588','18656','18657','18658','18659','18660','18661','18717','18718','18719','18720','18721','18722','18765','18816','18817','18852','19045','19060','19061','19062','19083','19084','19085','19313','19524','19525','20151','20152','20153','20154','20155','20156','20157','20158','20159','20160','20161','20162','20163','20164','20165','20166','20167','20168','20169','20170','20171','20172','20173','20174','20175','20176','20177','20178','20574','20575','20576','20577','20578','20579','20580','20581','20582','20583','20584','20585','20586','20587','20588','20589','20590','20591','20592','20593','20594','20595','20596','20597','20598','20599','20600','20904','20905','20906','20907','20908','20909','20910','20911','20912','20913','20914','20942','20943','20944','20945','20946','20947','20948','20949','20950','20951','20979','20980','20981','20982','20983','20984','20985','20986','20987','20988','20989','20990','20991','21900','21901','21902','21903','21904','21905','21906','21907','21908','21909','21910','21911','21912','21913','21914','21915','21916','21917','21918','21919','21920','21921','21922','21923','21924','21925','21926','21927','21928','21929','21930','21931','21932','21933','21934','21935','21936','21937','21990','22003','22030','22043','22044','22095','22121','22186','22187','22188','22189','22190','22191','22192','22193','22194','22195','22196','22197','22198','22199','22200','22201','22202','22203','22204','22205','22206','22207','22208','22209','22210','22211','22212','22213','22214','22215','22216','23654','25748','25749','25758','25759','25768','25769','25840','25841','25845','25855','25856','26054','26055','26056','26057','26058','26059','26060','26061','26062','26063','26064','26065','26066','26067','26068','26069','26070','26071','26072','26073','26074','26079','26080','26081','26082','26085','26086','26091','26092','26093','26094','26095','26096','26097','26098','26099','26100','26101','26102','26103','26104','26105','26106','26107','26108','26109','26110','26111','26112','26113','26114','26115','26116','26119','26120','26121','26122','26123','26124','26129','26130','26131','26132','26133','26134','26135','26136','26137','26138','26139','26140','26141','26142','26143','26144','26145','26146','26147','26148','26149','26150','26151','26182','26183','26184','26185','26186','26187','26188','26189','26194','26195','26196','26197','26198','26199','26200','26201','26202','26203','26204','26205','26214','26215','26216','26217','26218','26219','26220','26221','26222','26223','26227','26228','26229','26230','26231','26232','26233','26234','26235','26236','26237','26238','26239','26240','26241','26242','26243','26244','26245','26246','26247','26248','26249','26250','26251','26252','26253','26254','26255','26256','26257','26258','26259','26260','26261','26262','26263','26264','26265','26267','26269','26271','26272','26273','26274','26275','26276','26277','26278','26279','26280','26281','26282','26285','26286','26287','26288','26289','26290','26291','26292','26293','26294','26295','26296','26297','26298','26299','26300','26301','26302','26303','26304','26305','26306','26307','26308','26309','26310','26311','26312','26313','26314','26315','26316','26317','26318','26319','26323','26325','26326','26327','26328','26329','26330','26331','26332','26333','26340','26341','26346','26347','26348','26354','26355','26356','26357','26358','26359','26360','26361','26362','26363','26364','26365','26366','26367','26368','26369','26370','26371','26372','26373','26378','26379','26380','26381','26382','26383','26384','26385','26386','26387','26388','26389','26390','26391','26392','26393','26394','26395','26396','26397','26398','26399','26404','26406','26407','26408','26409','26410','26411','26412','26413','26414','26415','26416','26417','26418','26419','26420','26421','26422','26423','26424','26425','26426','26430','26431','26432','26433','26434','26435','26436','26437','26438','26439','26440','26441','26442','26443','26444','26445','26446','26447','26448','26449','26450','26451','26452','26453','26454','26455','26456','26457','26458','26459','26460','26461','26462','26463','26464','26465','26466','26467','26468','26469','26470','26471','26472','26473','26474','26475','26476','26477','26502','26503','26504','26505','26506','26507','26508','26509','26510','26511','26512','26513','26514','26518','26519','26520','26521','26522','26523','26524','26525','26526','26529','26530','26531','26532','26533','26534','26535','26536','26537','26538','26539','26540','26541','26542','26543','26544','26545','26546','26547','26548','26549','26550','26551','26552','26553','26554','26555','26556','26557','26558','26559','26560','26561','26562','26563','26564','26565','26566','26567','26568','26569','26570','26571','26572','26573','26574','26575','26576','26577','26578','26581','26582','26583','26584','26585','26586','26587','26588','26589','26590','26591','26592','26593','26594','26595','26596','26597','26598','26599','26600','26601','26602','26603','26604','26605','26606','26607','26608','26609','26610','26611','26612','26613','26614','26615','26616','26617','26618','26619','26620','26621','26622','26623','26624','26625','26626','26627','26628','26629','26630','26631','26632','26633','26634','26635','26636','26637','26638','26639','26640','26641','26642','26643','26649','26651','26654','26655','26656','26657','26658','26667','26668','26669','26670','26671','26672','26673','26674','26675','26676','26677','26678','26679','26680','26681','26682','26683','26684','26685','26686','26687','26688','26689','26690','26691','26692','26693','26694','26695','26696','26697','26702','26703','26704','26705','26706','26712','26713','26714','26715','26716','26717','26718','26731','26732','26733','26734','26735','26736','26737','26749','26750','26751','26752','26753','26754','26767','26768','26769','26770','26775','26776','26779','26780','26781','26782','26783','26784','26785','26786','26787','26788','26789','26790','26791','26792','26793','26794','26795','26796','26797','26798','26799','26800','26801','26806','26807','26808','26809','26810','26811','26812','26813','26814','26815','26816','26817','26818','26820','26821','27114','27115','27116','27117','27118','27119','27135','27136','27137','27138','27139','27140','27141','27148','27149','27150','27166','27167','27168','27173','27174','27175','27176','27177','27178','27179','27180','27181','27182','27183','27184','27185','27186','27187','27188','27189','27190','27191','27192','27208','27209','27210','27211','27212','27213','27214','27215','27216','27217','27228','27229','27230','27231','27232','27233','27234','27235','27236','27237','27253','27254','27255','27256','27257','27258','27259','27882','29586','29587','29588','29589','45716','45784','45785','45833','45836','45837','45839','45898','45996','46065','46087','46100','46136','46166','46252','46253','46254','46255','46416','46506','46510','46648','46649','46676','46684','46685','46686','46687','46692','46706','46707','46708','46715','46750','46751','46752','46769','46811','46829','46846','46905','46906','46907','46977','47009','47010','47079','47080','47081','47082','47083','47084','47085','47086','47087','47088','47089','47090','47091','47092','47093','47094','47095','47096','47097','47098','47099','47100','47178','47280','47282','47293','47308','47309','47310','47311','47369','47472','47490','47491','47492','47493','47494','47495','47497','48024','48206','48242','48344','48356','48357','48361','48366','48394','48395','48397','48406','48407','48507','48550','48551','48552','48582','48583','48694','49095','49096','49097','49098','49099','49100','49101','49102','49106','49806','49807','49808','49809','49810','49811','49812','50232','50233','50234','50235','50236','50237','50238','50239','50240','50241','50242','50243','50244','50245','50246','50247','50248','50249','50250','50251','50252','50253','50254','50255','50256','50257','50258','50259','50260','50675','50805','50806','50814','50817','50818','50819','50820','50852','50853','50854','50855','50911','50928','50930','50931','50932','50991','50992','50993','50994','50995','50996','50997','50998','50999','51000','51001','51002','51003','51004','51005','51010','51953','51954','51955','51956','51957','51958','51959','51960','51961','51962','51963','51964','51965','51966','51967','51968','51969','51970','51971','51972','52253','52254','52255','52256','52257','52258','52259','52260','52261','52262','52268','59280','59281','59282','59283','59284','59285','59286','59287','59288','59289','59290','59291','59292','59293','59294','59295','59296','59297','59298','59299','59300','59301','59302','59303','59304','59305','59306','59307','59308','59309','59310','59311','59312','59313','59314','59315','59316','59317','59318','59319','59320','59321','59322','59323','59324','59325','59326','59327','59328','59329','59330','59331','59332','59333','59334','59335','59336','59337','59338','59339','59340','59341','59342','59343','59344','59345','59346','59347','59348','59349','59350','59351','59352','59353','59354','59355','59356','59357','59358','59359','59360','59361','59362','59363','59364','59365','59366','59367','59368','59369','59370','59371','59372','59373','59374','59375','59376','59377','59378','59379','62121') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='99' AND `type` IN('0','1','2')
1496
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='99' 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('300','301','302','303','304','305','306','307','432','433','434','435','436','629','675','743','744','745','746','747','748','804','805','806','807','808','809','852','903','904','939','1133','1148','1149','1150','1171','1172','1173','1402','1576','1577','2183','2184','2185','2186','2187','2188','2189','2190','2191','2192','2193','2194','2195','2196','2197','2198','2199','2200','2201','2202','2203','2204','2205','2206','2207','2208','2209','2210','2606','2607','2608','2609','2610','2611','2612','2613','2614','2615','2616','2617','2618','2619','2620','2621','2622','2623','2624','2625','2626','2627','2628','2629','2630','2631','2632','2936','2937','2938','2939','2940','2941','2942','2943','2944','2945','2946','2974','2975','2976','2977','2978','2979','2980','2981','2982','2983','3011','3012','3013','3014','3015','3016','3017','3018','3019','3020','3021','3022','3023','3940','3941','3942','3943','3944','3945','3946','3947','3948','3949','3950','3951','3952','3953','3954','3955','3956','3957','3958','3959','3960','3961','3962','3963','3964','3965','3966','3967','3968','3969','3970','3971','3972','3973','3974','3975','3976','3977','4038','4052','4085','4100','4101','4154','4182','4255','4256','4257','4258','4259','4260','4261','4262','4263','4264','4265','4266','4267','4268','4269','4270','4271','4272','4273','4274','4275','4276','4277','4278','4279','4280','4281','4282','4283','4284','4285','5726','7820','7821','7830','7831','7840','7841','7912','7913','7917','7927','7928','8126','8127','8128','8129','8130','8131','8132','8133','8134','8135','8136','8137','8138','8139','8140','8141','8142','8143','8144','8145','8146','8151','8152','8153','8154','8157','8158','8163','8164','8165','8166','8167','8168','8169','8170','8171','8172','8173','8174','8175','8176','8177','8178','8179','8180','8181','8182','8183','8184','8185','8186','8187','8188','8191','8192','8193','8194','8195','8196','8201','8202','8203','8204','8205','8206','8207','8208','8209','8210','8211','8212','8213','8214','8215','8216','8217','8218','8219','8220','8221','8222','8223','8254','8255','8256','8257','8258','8259','8260','8261','8266','8267','8268','8269','8270','8271','8272','8273','8274','8275','8276','8277','8286','8287','8288','8289','8290','8291','8292','8293','8294','8295','8299','8300','8301','8302','8303','8304','8305','8306','8307','8308','8309','8310','8311','8312','8313','8314','8315','8316','8317','8318','8319','8320','8321','8322','8323','8324','8325','8326','8327','8328','8329','8330','8331','8332','8333','8334','8335','8336','8337','8339','8341','8343','8344','8345','8346','8347','8348','8349','8350','8351','8352','8353','8354','8357','8358','8359','8360','8361','8362','8363','8364','8365','8366','8367','8368','8369','8370','8371','8372','8373','8374','8375','8376','8377','8378','8379','8380','8381','8382','8383','8384','8385','8386','8387','8388','8389','8390','8391','8395','8397','8398','8399','8400','8401','8402','8403','8404','8405','8412','8413','8418','8419','8420','8426','8427','8428','8429','8430','8431','8432','8433','8434','8435','8436','8437','8438','8439','8440','8441','8442','8443','8444','8445','8450','8451','8452','8453','8454','8455','8456','8457','8458','8459','8460','8461','8462','8463','8464','8465','8466','8467','8468','8469','8470','8471','8476','8478','8479','8480','8481','8482','8483','8484','8485','8486','8487','8488','8489','8490','8491','8492','8493','8494','8495','8496','8497','8498','8502','8503','8504','8505','8506','8507','8508','8509','8510','8511','8512','8513','8514','8515','8516','8517','8518','8519','8520','8521','8522','8523','8524','8525','8526','8527','8528','8529','8530','8531','8532','8533','8534','8535','8536','8537','8538','8539','8540','8541','8542','8543','8544','8545','8546','8547','8548','8549','8574','8575','8576','8577','8578','8579','8580','8581','8582','8583','8584','8585','8586','8590','8591','8592','8593','8594','8595','8596','8597','8598','8601','8602','8603','8606','8607','8608','8609','8610','8611','8612','8613','8614','8615','8616','8617','8618','8619','8620','8621','8622','8623','8624','8625','8626','8627','8628','8629','8630','8631','8632','8633','8634','8635','8636','8637','8638','8639','8640','8641','8642','8643','8644','8645','8646','8647','8648','8649','8650','8653','8654','8655','8656','8657','8658','8659','8660','8661','8662','8663','8664','8665','8666','8667','8668','8669','8670','8671','8672','8673','8674','8675','8676','8677','8678','8679','8680','8681','8682','8683','8684','8685','8686','8687','8688','8689','8690','8691','8692','8693','8694','8695','8696','8697','8698','8699','8700','8701','8702','8703','8704','8705','8706','8707','8708','8709','8710','8711','8712','8713','8714','8715','8721','8723','8726','8727','8728','8729','8730','8739','8740','8741','8742','8743','8744','8745','8746','8747','8748','8749','8750','8751','8752','8753','8754','8755','8756','8757','8758','8759','8760','8761','8762','8763','8764','8765','8766','8767','8768','8769','8774','8775','8776','8777','8778','8784','8785','8786','8787','8788','8789','8790','8803','8804','8805','8806','8807','8808','8809','8821','8822','8823','8824','8825','8826','8839','8840','8841','8842','8847','8848','8851','8852','8853','8854','8855','8856','8857','8858','8859','8860','8861','8862','8863','8864','8865','8866','8867','8868','8869','8870','8871','8872','8873','8878','8879','8880','8881','8882','8883','8884','8885','8886','8887','8888','8889','8890','8892','8893','9186','9187','9188','9189','9190','9191','9207','9208','9209','9210','9211','9212','9213','9220','9221','9222','9238','9239','9240','9245','9246','9247','9248','9249','9250','9251','9252','9253','9254','9255','9256','9257','9258','9259','9260','9261','9262','9263','9264','9280','9281','9282','9283','9284','9285','9286','9287','9288','9289','9300','9301','9302','9303','9304','9305','9306','9307','9308','9309','9325','9326','9327','9328','9329','9330','9331','9954','11658','11659','11660','11661','27794','27868','27869','27921','27925','27926','27929','27991','28090','28163','28186','28199','28233','28263','28343','28344','28345','28346','28501','28591','28594','28731','28732','28759','28767','28768','28769','28770','28775','28789','28790','28791','28798','28833','28834','28835','28852','28894','28912','28929','28987','28988','28989','29058','29086','29087','29155','29156','29157','29158','29159','29160','29161','29162','29163','29164','29165','29166','29167','29168','29169','29170','29171','29172','29173','29174','29175','29176','29247','29348','29350','29361','29376','29377','29378','29379','29437','29540','29558','29559','29560','29561','29562','29563','29565','30064','30236','30271','30373','30385','30386','30390','30395','30423','30424','30426','30435','30436','30536','30579','30580','30581','30608','30609','30714','31111','31112','31113','31114','31115','31116','31117','31118','31122','31239','31362','31363','31371','31374','31375','31376','31377','31409','31410','31411','31412','31468','31485','31487','31488','31489','31540','31541','31542','31543','31544','31545','31546','31547','31548','31549','31550','31551','31552','31553','31554','31559','31580','31581','31582','31583','31584','31585','31586','31587','31588','31589','31595','31958')
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 = 8347)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 8696) 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 = 8666)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36243) 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`='36243'
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('8653','8654','8655','8656','8657','8658','8659','8660','8661','8662','8663','8664','8665','8666','31239','31595') 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 = 8347)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 8696) 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 = 8350)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29004) 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`='29004'
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('8348','8349','8350','27929') 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 = 8348)
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 = 2194)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31822) 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`='31822'
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('743','744','745','804','805','2193','2194','2195','2196','2197','28731','28732','29155','29156','29157','29158','29159','29160','29161','29162','29163','29164','29165') 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 = 436)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31692) 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`='31692'
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('432','433','434','435','436','28759','28912','29086','29087') 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 = 904)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36238) 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`='36238'
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('904','2198','2199','2200','2201','2202','27868','27869','27925','27926') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group