/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`='citroen' 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`='29'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1023','1024','1025','1026','1027','1028','1029','1030','1031','1032','1033','1034','1035','1036','1037','1038','1039','1040','1041','1042','1043','1044','1045','1046','1047','1048','1049','1050','1051','1052','1053','1054','1055','1056','1057','1058','1059','1060','1061','1062','1063','1064','1065','1066','1067','1068','1069','1070','1071','1072','1073','1074','1075','1076','1077','1078','1079','1080','1081','1082','1083','1084','1085','1086','1087','1088','1089','1090','1091','1092','1093','1094','1095','1096','1097','1098','1099','1100','1101','1102','1103','1104','1105','1106','1107','1108','1109','1110','1111','1112','1113','1114','1115','1116','1117','1118','1119','1120','1121','1122','1123','1124','1125','1126','1127','1128','1129','1130','1131','1132','1133','1134','1135','1136','1137','1138','1139','1140','1141','1142','1143','1144','1145','1146','1147','1148','1149','1150','1151','1152','1153','1154','1155','1156','1157','1158','1159','1160','1161','1162','1163','1164','1165','1166','1167','1168','1169','1170','1171','1172','1173','1174','1175','1176','1177','1178','1179','1180','1181','1182','1183','1184','1185','1186','1187','1188','1189','1190','1191','1192','1193','1194','1195','1196','1197','1198','1199','1200','1201','1202','1203','1204','1205','1206','1207','1208','1209','1210','1211','1212','1213','1214','1215','1216','1217','1218','1219','1220','1221','1222','1223','1224','1225','1226','1227','1228','1229','1230','1231','1232','1233','1234','1235','1236','1237','1238','1239','1240','1241','1242','1243','5203','5209','5210','8072','8073','8218','8219','8220','8221','8222','8223','8224','8225','8226','8227','8228','8229','8230','8231','8232','8233','8234','8235','8236','8237','8238','8239','8240','8241','8242','8243','8244','8245','8246','8247','8248','8249','8250','8251','8252','8253','8254','8255','8256','8257','8258','8259','8260','8261','8262','8263','8264','8265','8266','8267','8268','8269','8270','8271','8272','8273','8274','8275','8276','8277','8278','8279','8280','8281','8282','8283','8284','8285','8286','8287','8288','8289','8290','8291','8292','8293','8294','8295','8296','8297','8298','10948','10949','10950','10951','12947','12948','12949','12950','13271','13272','13273','13274','13863','13864','13865','13866','13867','13868','13869','15307','15751','15752','15753','15754','15755','15756','15757','15758','15759','16137','16138','16139','16140','16141','16413','16414','16415','16416','16417','16418','16419','16420','16421','17397','17398','17399','17400','17401','17402','17403','17404','17973','17974','17975','17976','17977','17978','18081','18082','18111','18112','18113','18114','18115','18124','18125','18126','18127','18221','18222','18289','18290','18291','18292','18293','18294','18295','18296','18297','18298','18299','18300','18301','18302','18303','18304','18305','18306','18307','18308','18309','18310','18311','18312','18313','18314','18315','18316','18317','18318','18319','18320','18321','18322','18323','18324','18325','18326','18327','18328','18419','18420','18421','18422','18423','18424','18425','18426','18427','18428','18429','18430','18435','18436','18437','18463','18464','18465','18466','18467','18468','18469','18470','18471','18472','18473','18474','18475','18476','18477','18478','18479','18703','18704','18705','18807','18808','18809','18810','18811','18812','19124','19125','19126','19127','19128','19129','19130','19131','19132','19133','19134','19135','19136','19137','19138','19139','19140','19141','19142','19143','19144','19145','19146','19147','19148','19149','19150','19151','19152','19153','19154','19155','19156','19157','19158','19159','19160','19161','19162','19163','19164','19165','19166','19167','19168','19169','19170','19171','19172','19173','19174','19175','19176','19177','19178','19179','19180','19181','19182','19183','19191','19192','19193','19194','19900','19903','19904','19905','19906','19907','19908','19909','19910','19911','19912','19913','19914','19915','19979','20894','20895','20896','20897','20898','20899','20900','20901','20902','20903','21348','21810','21811','21812','21813','21814','21815','21816','21817','21818','21819','21820','21821','21822','21823','21824','21825','21826','21827','21828','21829','21830','21831','21832','21833','21834','21835','21836','21837','21838','21839','21840','21841','21842','21843','21844','21845','21846','21847','21848','21849','21850','21851','21852','21853','21854','21855','22052','22182','23363','23364','23365','23366','23367','23368','23369','23370','23371','23372','23373','23374','23375','23376','23377','23378','23379','23380','23381','23382','23383','23384','23385','33745','33746','33747','33748','33749','33750','33751','33752','33753','33754','33755','33756','33757','33758','33759','33760','33761','33762','33763','45797','45798','45799','45815','45816','45817','45834','46081','46220','46221','46226','46232','46717','46718','46784','46818','46895','46971','46972','46973','47327','47467','47544','47545','47552','47558','48038','48229','49180','49181','50677','51162','51163','52460','52461','52462','52463','52464','52465','52466','52467','52468','52469','52470','52471','52472','52473','52474','52475','52476','55805','55806','55807','55808','55809','55810','55811','55812','55813','55814','55815','55816','55817','55818','55819','55820','55821','55822','55823','55824','55825','55826','55827','55828','55829','55830','55831','55832','55833','55834','55835','55836','55837','55838','55839','55840','55841','55842','55843','55844','55845','55846','55847','55848','55849','55850','55851','55852','55853','55854','55855','55856','55857','55858','55859','55860','55861','55862','55863','55864','55865','55866','55867','55868','55869','55870','55871','55872','55873','55874','55875','55876','55877','55878','55879','55880','55881','55882','55883','55884','55885','55886','55887','55888','55889','55890','55891','55892','55893','55894','55895','55896','55897','55898','55899','55900','55901','55902','55903','55904','55905','55906','55907','55908','55909','55910','55911','55912','55913','55914','55915','55916','55917','55918','55919','55920','55921','55922','55923','55924','55925','55926','55927','55928','55929','55930','55931','55932','55933','55934','55935','55936','55937','55938','55939','55940','55941','55942','55943','55944','55945','55946','55947','55948','55949','55950','55951','55952','55953','55954','55955','55956','55957','55958','55959','55960','55961','55962','55963','55964','55965','55966','55967','55968','55969','55970','55971','55972','55973','55974','55975','55976','55977','55978','55979','55980','55981','55982','55983','55984','55985') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1023','1024','1025','1026','1027','1028','1029','1030','1031','1032','1033','1034','1035','1036','1037','1038','1039','1040','1041','1042','1043','1044','1045','1046','1047','1048','1049','1050','1051','1052','1053','1054','1055','1056','1057','1058','1059','1060','1061','1062','1063','1064','1065','1066','1067','1068','1069','1070','1071','1072','1073','1074','1075','1076','1077','1078','1079','1080','1081','1082','1083','1084','1085','1086','1087','1088','1089','1090','1091','1092','1093','1094','1095','1096','1097','1098','1099','1100','1101','1102','1103','1104','1105','1106','1107','1108','1109','1110','1111','1112','1113','1114','1115','1116','1117','1118','1119','1120','1121','1122','1123','1124','1125','1126','1127','1128','1129','1130','1131','1132','1133','1134','1135','1136','1137','1138','1139','1140','1141','1142','1143','1144','1145','1146','1147','1148','1149','1150','1151','1152','1153','1154','1155','1156','1157','1158','1159','1160','1161','1162','1163','1164','1165','1166','1167','1168','1169','1170','1171','1172','1173','1174','1175','1176','1177','1178','1179','1180','1181','1182','1183','1184','1185','1186','1187','1188','1189','1190','1191','1192','1193','1194','1195','1196','1197','1198','1199','1200','1201','1202','1203','1204','1205','1206','1207','1208','1209','1210','1211','1212','1213','1214','1215','1216','1217','1218','1219','1220','1221','1222','1223','1224','1225','1226','1227','1228','1229','1230','1231','1232','1233','1234','1235','1236','1237','1238','1239','1240','1241','1242','1243','5203','5209','5210','8072','8073','8218','8219','8220','8221','8222','8223','8224','8225','8226','8227','8228','8229','8230','8231','8232','8233','8234','8235','8236','8237','8238','8239','8240','8241','8242','8243','8244','8245','8246','8247','8248','8249','8250','8251','8252','8253','8254','8255','8256','8257','8258','8259','8260','8261','8262','8263','8264','8265','8266','8267','8268','8269','8270','8271','8272','8273','8274','8275','8276','8277','8278','8279','8280','8281','8282','8283','8284','8285','8286','8287','8288','8289','8290','8291','8292','8293','8294','8295','8296','8297','8298','10948','10949','10950','10951','12947','12948','12949','12950','13271','13272','13273','13274','13863','13864','13865','13866','13867','13868','13869','15307','15751','15752','15753','15754','15755','15756','15757','15758','15759','16137','16138','16139','16140','16141','16413','16414','16415','16416','16417','16418','16419','16420','16421','17397','17398','17399','17400','17401','17402','17403','17404','17973','17974','17975','17976','17977','17978','18081','18082','18111','18112','18113','18114','18115','18124','18125','18126','18127','18221','18222','18289','18290','18291','18292','18293','18294','18295','18296','18297','18298','18299','18300','18301','18302','18303','18304','18305','18306','18307','18308','18309','18310','18311','18312','18313','18314','18315','18316','18317','18318','18319','18320','18321','18322','18323','18324','18325','18326','18327','18328','18419','18420','18421','18422','18423','18424','18425','18426','18427','18428','18429','18430','18435','18436','18437','18463','18464','18465','18466','18467','18468','18469','18470','18471','18472','18473','18474','18475','18476','18477','18478','18479','18703','18704','18705','18807','18808','18809','18810','18811','18812','19124','19125','19126','19127','19128','19129','19130','19131','19132','19133','19134','19135','19136','19137','19138','19139','19140','19141','19142','19143','19144','19145','19146','19147','19148','19149','19150','19151','19152','19153','19154','19155','19156','19157','19158','19159','19160','19161','19162','19163','19164','19165','19166','19167','19168','19169','19170','19171','19172','19173','19174','19175','19176','19177','19178','19179','19180','19181','19182','19183','19191','19192','19193','19194','19900','19903','19904','19905','19906','19907','19908','19909','19910','19911','19912','19913','19914','19915','19979','20894','20895','20896','20897','20898','20899','20900','20901','20902','20903','21348','21810','21811','21812','21813','21814','21815','21816','21817','21818','21819','21820','21821','21822','21823','21824','21825','21826','21827','21828','21829','21830','21831','21832','21833','21834','21835','21836','21837','21838','21839','21840','21841','21842','21843','21844','21845','21846','21847','21848','21849','21850','21851','21852','21853','21854','21855','22052','22182','23363','23364','23365','23366','23367','23368','23369','23370','23371','23372','23373','23374','23375','23376','23377','23378','23379','23380','23381','23382','23383','23384','23385','33745','33746','33747','33748','33749','33750','33751','33752','33753','33754','33755','33756','33757','33758','33759','33760','33761','33762','33763','45797','45798','45799','45815','45816','45817','45834','46081','46220','46221','46226','46232','46717','46718','46784','46818','46895','46971','46972','46973','47327','47467','47544','47545','47552','47558','48038','48229','49180','49181','50677','51162','51163','52460','52461','52462','52463','52464','52465','52466','52467','52468','52469','52470','52471','52472','52473','52474','52475','52476','55805','55806','55807','55808','55809','55810','55811','55812','55813','55814','55815','55816','55817','55818','55819','55820','55821','55822','55823','55824','55825','55826','55827','55828','55829','55830','55831','55832','55833','55834','55835','55836','55837','55838','55839','55840','55841','55842','55843','55844','55845','55846','55847','55848','55849','55850','55851','55852','55853','55854','55855','55856','55857','55858','55859','55860','55861','55862','55863','55864','55865','55866','55867','55868','55869','55870','55871','55872','55873','55874','55875','55876','55877','55878','55879','55880','55881','55882','55883','55884','55885','55886','55887','55888','55889','55890','55891','55892','55893','55894','55895','55896','55897','55898','55899','55900','55901','55902','55903','55904','55905','55906','55907','55908','55909','55910','55911','55912','55913','55914','55915','55916','55917','55918','55919','55920','55921','55922','55923','55924','55925','55926','55927','55928','55929','55930','55931','55932','55933','55934','55935','55936','55937','55938','55939','55940','55941','55942','55943','55944','55945','55946','55947','55948','55949','55950','55951','55952','55953','55954','55955','55956','55957','55958','55959','55960','55961','55962','55963','55964','55965','55966','55967','55968','55969','55970','55971','55972','55973','55974','55975','55976','55977','55978','55979','55980','55981','55982','55983','55984','55985') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='29'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Citroen%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='29'
1156
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='29' ORDER BY `sort_name`, `type` LIMIT 1000, 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`='29'
SELECT `id`, `tag` FROM tag WHERE `id` IN('99')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('60','61','62','63','64','65','168','169','198','199','201','202','211','212','213','214','308','309','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','506','507','508','509','510','511','512','513','514','515','516','517','522','523','524','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','790','791','792','894','895','896','897','898','899','1213','1214','1215','1216','1217','1218','1219','1220','1221','1222','1223','1224','1225','1226','1227','1228','1229','1230','1231','1232','1233','1234','1235','1236','1237','1238','1239','1240','1241','1242','1243','1244','1245','1246','1247','1248','1249','1250','1251','1252','1253','1254','1255','1256','1257','1258','1259','1260','1261','1262','1263','1264','1265','1266','1267','1268','1269','1270','1271','1272','1280','1281','1282','1283','1950','1951','1952','1953','1955','1956','1957','1958','1960','1961','1962','2011','2926','2927','2928','2929','2930','2931','2932','2933','2934','2935','3380','3842','3843','3844','3845','3846','3847','3848','3849','3850','3851','3852','3853','3854','3855','3856','3857','3858','3859','3860','3861','3862','3863','3864','3865','3866','3867','3868','3869','3870','3871','3872','3873','3874','3875','3876','3877','3878','3879','3880','3881','3882','3883','3884','3885','3886','3887','4110','4250','5435','5436','5437','5438','5439','5440','5441','5442','5443','5444','5445','5446','5447','5448','5449','5450','5451','5452','5453','5454','5455','5456','5457','15823','15824','15825','15826','15827','15828','15829','15830','15831','15832','15833','15834','15835','15836','15837','15838','15839','15840','15841','27881','27882','27883','27900','27901','27902','27923','28180','28800','28801','28867','28901','28978','29052','29053','29054','29395','29535','29612','29613','29620','29626','30078','30258','31191','31192','31241')
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 = 391) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35616) 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`='35616'
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('376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','2926','2927','2928','2929','2930','2931','2932','2933','2934','2935','28800','29395','31191','31241') 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 = 406) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35494) 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`='35494'
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('396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','28801','31192') 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 = 408) 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 = 898) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32568) 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`='32568'
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('198','199','201','202','211','212','213','214','522','523','524','790','791','792','894','895','896','897','898','899','28867','29626') 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 = 383) 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 = 792) 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 = 64) 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`='64' 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 = 510) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32555) 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`='32555'
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('168','506','507','508','509','510','511','3860','3861','3862','3863','3864','3865','3866','3867','3868','3869','3870','3871','3872','3873','27881','27882','27883','27900','27901','27902','29612') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group
