/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`='volkswagen' 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`='143'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1394','1395','1396','1397','1398','1399','1400','1401','1402','1403','1404','1405','1406','1407','1408','1409','1410','1411','1412','1413','1414','1415','1416','1417','1418','1419','1420','1421','1422','1423','1424','1425','1426','1427','1428','1429','1430','1431','1432','1433','1434','1435','1436','1437','1438','1439','1440','1441','1442','1443','1444','1445','1446','1447','1448','1449','1450','1451','1452','1453','1454','1455','1456','1457','1458','1459','1460','1461','1462','1463','1464','1465','1466','1467','1468','1469','1470','1471','1472','1473','1474','1475','1476','1477','1478','1479','1480','1481','1482','1483','1484','1485','1486','1487','1488','1489','1490','1491','1492','1493','1494','1495','1496','1497','1498','1499','1500','1501','1502','1503','1504','1505','1506','1507','1508','4311','6819','6820','6821','6822','6823','6824','6825','6826','6827','6828','6829','6830','6831','6832','6833','6834','6835','6836','6837','6838','6839','6840','6841','6842','6843','6844','6845','6846','6847','6848','6849','6850','6851','6852','6853','6854','6855','6856','6857','6858','6859','6860','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873','6874','6875','6876','6877','6878','6879','6880','6881','6882','6883','6884','6885','6886','6887','6888','6889','6890','6891','6892','6893','6894','6895','6896','6897','6898','6899','6900','6901','6902','6903','6904','6905','6906','6907','6908','6909','6910','6911','6912','6913','6914','6915','6916','6917','6918','6919','6920','6921','6922','6923','6924','6925','6926','6927','6928','6929','6930','6931','6932','6933','6934','6935','6936','6937','6938','6939','6940','6941','6942','6943','6944','6945','6946','6947','6948','6949','6950','6951','6952','6953','6954','6955','6956','6957','6958','6959','6960','6961','6962','6963','6964','6965','6966','6967','6968','6969','6970','6971','6972','6973','6974','6975','6976','7289','7290','7291','7292','7293','7294','7295','7296','7297','7298','7299','7300','7301','7302','7303','8943','11177','11178','12752','12753','12754','13385','13386','13387','13789','14135','14136','14137','14138','14139','14140','14141','14142','14143','14144','14145','14146','14147','14148','14149','14150','14151','14152','14153','14154','14155','14156','14157','14158','14159','14160','14161','14162','14163','14229','15369','15862','15863','15864','15865','15866','15867','15868','15869','16467','16468','16469','16470','17040','17632','17845','17846','17847','17848','17849','17850','17851','17852','17913','17914','17915','17916','18058','18059','18060','18061','18062','18063','18064','18065','18066','18067','18068','18069','18070','18071','18128','18129','18130','18131','18132','18133','18134','18135','18170','18171','18172','18173','18174','18175','18176','18188','18189','18190','18191','18192','18193','18194','18457','18532','18533','18537','18538','18539','18547','18548','18549','18578','18579','18580','18581','18582','18583','18584','18730','18731','18732','18733','18734','18735','18736','18737','18738','18739','18740','18741','18742','18766','18767','18768','18863','18864','18865','18871','18872','18956','18957','18958','18959','19069','19070','19071','19120','19247','19248','19249','19250','19261','19262','19263','19264','19265','19266','19267','19268','19290','19291','19292','19293','19294','19295','19296','19297','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','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','19389','19392','19393','19443','19444','20401','20402','20403','20404','20405','20406','20407','20408','20409','20410','20411','20412','20413','20414','20415','20416','20417','20418','20419','20420','20752','20753','20754','20755','20756','20757','20758','20759','20760','20761','20762','20763','20764','20765','20766','20767','20768','20769','20770','20771','20772','20915','20916','20917','20918','21965','21988','21989','21994','22023','22024','22032','22037','22066','22181','22796','22797','22993','22994','22999','23000','23001','23002','23003','23004','23005','23006','23866','27631','29457','29458','29459','29460','29461','29462','29463','29464','29465','29466','29467','29468','29469','29470','29471','29472','29473','29474','29475','29476','29477','29478','29479','29480','29481','29482','29483','29484','29485','29486','29487','29488','29489','29490','29491','29492','29493','29494','29495','29496','29497','29498','29499','29500','29501','29502','29503','29504','29505','29506','29507','29508','29509','29510','29511','29512','29513','29514','29515','29516','29517','29518','29519','29520','29521','29522','29523','29524','29525','29526','29527','29528','29529','29530','29531','29532','29533','29534','29535','29536','29537','29538','29539','29540','29541','29542','29543','29544','29545','29546','29547','29548','29549','29550','29551','29552','29553','29554','29555','29556','29557','29558','29559','29560','29561','29562','29563','29564','29565','29566','29567','29568','29569','29570','29571','29572','29573','29574','29575','29576','29577','29578','29579','29580','29581','29582','29583','29584','29585','29590','29591','29592','29593','29594','29595','29596','29597','29598','29599','29600','29601','29602','29603','29604','29605','29606','29607','29608','29609','29610','29611','29612','29613','29614','29615','29616','29617','29618','29619','29620','29621','29622','29623','29624','29625','29626','29627','29628','29629','29630','29631','29632','29633','29634','29635','29636','29637','29638','29639','29640','29641','29642','29681','30479','30480','30481','30482','30483','30484','30485','30486','30487','30488','30489','30490','30491','30492','30493','30494','30495','30496','45753','45774','45867','45871','45893','45922','45924','45925','45926','45927','45928','45930','45931','46044','46067','46093','46094','46127','46233','46234','46235','46236','46323','46443','46444','46445','46446','46711','46782','46820','46830','46831','46981','46982','47109','47110','47111','47112','47113','47114','47115','47120','47148','47386','47948','48017','48061','48203','48255','48266','48430','48667','48706','49851','49852','49853','49854','49855','49856','49857','49858','50561','50562','50563','50564','50565','50566','50567','50568','50569','50570','50824','50825','50826','50827','50866','50867','50868','50947','52214','52215','52216','52217','52218','52219','52220','52221','52222','61452','61453','61454','61455','61456','61457','61458','61459','61460','61461','61462','61463','61464','61465','61466','61467','61468','61469','61470','61471','61472','61473','61474','61475','61476','61477','61478','61479','61480','61481','61482','61483','61484','61485','61486','61487','61488','61489','61490','61491','61492','61493','61494','61495','61496','61497','61498','61499','61500','61501','61502','61503','61504','61505','61506','61507','61508','61509','61510','61511','61512','61513','61514','61515','61516','61517','61518','61519','61520','61521','61522','61523','61524','61525','61526','61527','61528','61529','61530','61531','61532','61533','61534','61535','61536','61537','61538','61539','61540','61541','61542','61543','61544','61545','61546','61547','61548','61549','61550','61551','61552','61553','61554','61555','61556','61557','61558','61559','61560','61561','61562','61563','61564','61565','61566','61567','61568','61569','61570','61571','61572','61573','61574','61575','61576','61577','61578','61579','61580','61581','61582','61583','61584','61585','61586','61587','61588','61589','61590','61591','61592','61593','61594','61595','61596','61597','61598','61599','61600','61601','61602','61603','61604','61605','61606','61607','61608','61609','61610','61611','61612','61613','61614','61615','61616','61617','61618','61619','61620','61621','61622','61623','61624','61625','61626','61627','61628','61629','61630','61631','61632','61633','61634','61635','61636','61637','61638','61639','61640','61641','61642','61643','61644','61645','61646','61647','61648','61649','61650','61651','61652','61653','61654','61655','61656','61657','61658','61659','61660','61661','61662','61663','61664','61665','61666','61667','61668','61669','62031','62032','62033','62034','62035','62036','62037','62038','62039','62040','62041','62042','62043','62060','62136','62137','62138','62141') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1394','1395','1396','1397','1398','1399','1400','1401','1402','1403','1404','1405','1406','1407','1408','1409','1410','1411','1412','1413','1414','1415','1416','1417','1418','1419','1420','1421','1422','1423','1424','1425','1426','1427','1428','1429','1430','1431','1432','1433','1434','1435','1436','1437','1438','1439','1440','1441','1442','1443','1444','1445','1446','1447','1448','1449','1450','1451','1452','1453','1454','1455','1456','1457','1458','1459','1460','1461','1462','1463','1464','1465','1466','1467','1468','1469','1470','1471','1472','1473','1474','1475','1476','1477','1478','1479','1480','1481','1482','1483','1484','1485','1486','1487','1488','1489','1490','1491','1492','1493','1494','1495','1496','1497','1498','1499','1500','1501','1502','1503','1504','1505','1506','1507','1508','4311','6819','6820','6821','6822','6823','6824','6825','6826','6827','6828','6829','6830','6831','6832','6833','6834','6835','6836','6837','6838','6839','6840','6841','6842','6843','6844','6845','6846','6847','6848','6849','6850','6851','6852','6853','6854','6855','6856','6857','6858','6859','6860','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873','6874','6875','6876','6877','6878','6879','6880','6881','6882','6883','6884','6885','6886','6887','6888','6889','6890','6891','6892','6893','6894','6895','6896','6897','6898','6899','6900','6901','6902','6903','6904','6905','6906','6907','6908','6909','6910','6911','6912','6913','6914','6915','6916','6917','6918','6919','6920','6921','6922','6923','6924','6925','6926','6927','6928','6929','6930','6931','6932','6933','6934','6935','6936','6937','6938','6939','6940','6941','6942','6943','6944','6945','6946','6947','6948','6949','6950','6951','6952','6953','6954','6955','6956','6957','6958','6959','6960','6961','6962','6963','6964','6965','6966','6967','6968','6969','6970','6971','6972','6973','6974','6975','6976','7289','7290','7291','7292','7293','7294','7295','7296','7297','7298','7299','7300','7301','7302','7303','8943','11177','11178','12752','12753','12754','13385','13386','13387','13789','14135','14136','14137','14138','14139','14140','14141','14142','14143','14144','14145','14146','14147','14148','14149','14150','14151','14152','14153','14154','14155','14156','14157','14158','14159','14160','14161','14162','14163','14229','15369','15862','15863','15864','15865','15866','15867','15868','15869','16467','16468','16469','16470','17040','17632','17845','17846','17847','17848','17849','17850','17851','17852','17913','17914','17915','17916','18058','18059','18060','18061','18062','18063','18064','18065','18066','18067','18068','18069','18070','18071','18128','18129','18130','18131','18132','18133','18134','18135','18170','18171','18172','18173','18174','18175','18176','18188','18189','18190','18191','18192','18193','18194','18457','18532','18533','18537','18538','18539','18547','18548','18549','18578','18579','18580','18581','18582','18583','18584','18730','18731','18732','18733','18734','18735','18736','18737','18738','18739','18740','18741','18742','18766','18767','18768','18863','18864','18865','18871','18872','18956','18957','18958','18959','19069','19070','19071','19120','19247','19248','19249','19250','19261','19262','19263','19264','19265','19266','19267','19268','19290','19291','19292','19293','19294','19295','19296','19297','19298','19299','19300','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','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','19389','19392','19393','19443','19444','20401','20402','20403','20404','20405','20406','20407','20408','20409','20410','20411','20412','20413','20414','20415','20416','20417','20418','20419','20420','20752','20753','20754','20755','20756','20757','20758','20759','20760','20761','20762','20763','20764','20765','20766','20767','20768','20769','20770','20771','20772','20915','20916','20917','20918','21965','21988','21989','21994','22023','22024','22032','22037','22066','22181','22796','22797','22993','22994','22999','23000','23001','23002','23003','23004','23005','23006','23866','27631','29457','29458','29459','29460','29461','29462','29463','29464','29465','29466','29467','29468','29469','29470','29471','29472','29473','29474','29475','29476','29477','29478','29479','29480','29481','29482','29483','29484','29485','29486','29487','29488','29489','29490','29491','29492','29493','29494','29495','29496','29497','29498','29499','29500','29501','29502','29503','29504','29505','29506','29507','29508','29509','29510','29511','29512','29513','29514','29515','29516','29517','29518','29519','29520','29521','29522','29523','29524','29525','29526','29527','29528','29529','29530','29531','29532','29533','29534','29535','29536','29537','29538','29539','29540','29541','29542','29543','29544','29545','29546','29547','29548','29549','29550','29551','29552','29553','29554','29555','29556','29557','29558','29559','29560','29561','29562','29563','29564','29565','29566','29567','29568','29569','29570','29571','29572','29573','29574','29575','29576','29577','29578','29579','29580','29581','29582','29583','29584','29585','29590','29591','29592','29593','29594','29595','29596','29597','29598','29599','29600','29601','29602','29603','29604','29605','29606','29607','29608','29609','29610','29611','29612','29613','29614','29615','29616','29617','29618','29619','29620','29621','29622','29623','29624','29625','29626','29627','29628','29629','29630','29631','29632','29633','29634','29635','29636','29637','29638','29639','29640','29641','29642','29681','30479','30480','30481','30482','30483','30484','30485','30486','30487','30488','30489','30490','30491','30492','30493','30494','30495','30496','45753','45774','45867','45871','45893','45922','45924','45925','45926','45927','45928','45930','45931','46044','46067','46093','46094','46127','46233','46234','46235','46236','46323','46443','46444','46445','46446','46711','46782','46820','46830','46831','46981','46982','47109','47110','47111','47112','47113','47114','47115','47120','47148','47386','47948','48017','48061','48203','48255','48266','48430','48667','48706','49851','49852','49853','49854','49855','49856','49857','49858','50561','50562','50563','50564','50565','50566','50567','50568','50569','50570','50824','50825','50826','50827','50866','50867','50868','50947','52214','52215','52216','52217','52218','52219','52220','52221','52222','61452','61453','61454','61455','61456','61457','61458','61459','61460','61461','61462','61463','61464','61465','61466','61467','61468','61469','61470','61471','61472','61473','61474','61475','61476','61477','61478','61479','61480','61481','61482','61483','61484','61485','61486','61487','61488','61489','61490','61491','61492','61493','61494','61495','61496','61497','61498','61499','61500','61501','61502','61503','61504','61505','61506','61507','61508','61509','61510','61511','61512','61513','61514','61515','61516','61517','61518','61519','61520','61521','61522','61523','61524','61525','61526','61527','61528','61529','61530','61531','61532','61533','61534','61535','61536','61537','61538','61539','61540','61541','61542','61543','61544','61545','61546','61547','61548','61549','61550','61551','61552','61553','61554','61555','61556','61557','61558','61559','61560','61561','61562','61563','61564','61565','61566','61567','61568','61569','61570','61571','61572','61573','61574','61575','61576','61577','61578','61579','61580','61581','61582','61583','61584','61585','61586','61587','61588','61589','61590','61591','61592','61593','61594','61595','61596','61597','61598','61599','61600','61601','61602','61603','61604','61605','61606','61607','61608','61609','61610','61611','61612','61613','61614','61615','61616','61617','61618','61619','61620','61621','61622','61623','61624','61625','61626','61627','61628','61629','61630','61631','61632','61633','61634','61635','61636','61637','61638','61639','61640','61641','61642','61643','61644','61645','61646','61647','61648','61649','61650','61651','61652','61653','61654','61655','61656','61657','61658','61659','61660','61661','61662','61663','61664','61665','61666','61667','61668','61669','62031','62032','62033','62034','62035','62036','62037','62038','62039','62040','62041','62042','62043','62060','62136','62137','62138','62141') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='143'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Volkswagen%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='143'
1424
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='143' 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`='143'
SELECT `id`, `tag` FROM tag WHERE `id` IN('164','518','525','915')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('145','146','147','148','149','150','151','152','153','154','155','156','157','158','215','216','217','218','219','220','221','222','257','258','259','260','261','262','263','275','276','277','278','279','280','281','544','619','620','625','634','635','636','665','666','667','668','669','670','671','817','818','819','820','821','822','823','824','825','826','827','828','829','853','854','855','950','951','952','958','959','1043','1044','1045','1046','1157','1158','1159','1336','1337','1338','1339','1350','1351','1352','1353','1354','1355','1356','1357','1379','1380','1381','1382','1383','1384','1385','1386','1387','1388','1389','1390','1391','1392','1393','1394','1395','1396','1397','1398','1399','1400','1401','1408','1409','1410','1411','1412','1413','1414','1415','1416','1417','1418','1419','1420','1421','1422','1423','1424','1425','1426','1427','1428','1429','1430','1431','1432','1433','1434','1435','1436','1478','1481','1482','1532','1533','2433','2434','2435','2436','2437','2438','2439','2440','2441','2442','2443','2444','2445','2446','2447','2448','2449','2450','2451','2452','2784','2785','2786','2787','2788','2789','2790','2791','2792','2793','2794','2795','2796','2797','2798','2799','2800','2801','2802','2803','2804','2947','2948','2949','2950','4013','4036','4037','4043','4076','4077','4087','4094','4124','4249','4865','4866','5062','5063','5068','5069','5070','5071','5072','5073','5074','5075','5938','9703','11529','11530','11531','11532','11533','11534','11535','11536','11537','11538','11539','11540','11541','11542','11543','11544','11545','11546','11547','11548','11549','11550','11551','11552','11553','11554','11555','11556','11557','11558','11559','11560','11561','11562','11563','11564','11565','11566','11567','11568','11569','11570','11571','11572','11573','11574','11575','11576','11577','11578','11579','11580','11581','11582','11583','11584','11585','11586','11587','11588','11589','11590','11591','11592','11593','11594','11595','11596','11597','11598','11599','11600','11601','11602','11603','11604','11605','11606','11607','11608','11609','11610','11611','11612','11613','11614','11615','11616','11617','11618','11619','11620','11621','11622','11623','11624','11625','11626','11627','11628','11629','11630','11631','11632','11633','11634','11635','11636','11637','11638','11639','11640','11641','11642','11643','11644','11645','11646','11647','11648','11649','11650','11651','11652','11653','11654','11655','11656','11657','11662','11663','11664','11665','11666','11667','11668','11669','11670','11671','11672','11673','11674','11675','11676','11677','11678','11679','11680','11681','11682','11683','11684','11685','11686','11687','11688','11689','11690','11691','11692','11693','11694','11695','11696','11697','11698','11699','11700','11701','11702','11703','11704','11705','11706','11707','11708','11709','11710','11711','11712','11713','11714','11754','12554','12555','12556','12557','12558','12559','12560','12561','12562','12563','12564','12565','12566','12567','12568','12569','12570','12571','27834','27958','27962','27984','28016','28018','28019','28020','28021','28022','28024','28025','28140','28165','28192','28193','28226','28408','28528','28529','28530','28531','28794','28865','28903','28913','28914','29062','29063','29185','29186','29187','29188','29189','29190','29191','29219','29454','29997','30057','30101','30233','30284','30295','30459','30693','30726','31381','31382','31383','31384','31423','31424','31425','31504','31866','31867','31868','31869','31870','31871','31872','31873','31874','31875','31876','31877','31878','31896','31977')
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 = 215) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33370) 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`='33370'
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('215','216','217','218','219','220','221','222','950','951','952','1422','1423','1424','1425','28192','28193','28408','28794','29185','29186','29187','29188','29997') 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 = 28019) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29293) 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`='29293'
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('1397','2439','2440','2441','2442','2443','2444','2445','11581','11582','11583','11584','11585','11586','28019','28024','28025') 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 = 1413) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 3739) 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`='3739'
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('145','146','147','148','149','150','151','152','153','154','155','156','157','158','1408','1409','1410','1411','1412','1413','1414','1415','1416','1417','1418','1419','1420','1421','1481') 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 = 1482) 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`='1482' 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 = 1355) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33577) 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`='33577'
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('1336','1337','1338','1339','1350','1351','1352','1354','1355','1356','1357','4249','11678','11679','11680','11681','11682','11683','11684','11685','11686','11687','11690','11691','11692','11693','11694','11695','11696','11697','11698','11699','11700','27962','28903') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group