/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`='suzuki' 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`='132'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('2979','2980','2981','2982','2985','2987','2988','2989','2991','2993','2994','2995','2996','2997','2999','3000','3001','3004','3005','3008','3010','3011','3013','3015','3017','3019','3021','3022','3024','3026','3027','3029','3030','3032','3033','3034','3035','3038','3040','10421','10422','10423','10424','10425','10426','10427','10428','10429','10430','10431','10432','10433','10434','10435','10436','10437','10438','10439','10440','10441','10442','10443','10444','10445','10446','10447','10448','10449','10450','10451','10452','10453','10454','10455','10456','10457','10458','10459','10460','10461','10462','10463','10464','10465','10466','10467','10468','10469','10470','10471','10472','10473','10474','10475','10476','10477','10478','10479','10480','11173','13373','13374','13375','14116','15848','16351','16352','16353','17796','19005','19007','19065','19093','19094','19095','19096','19390','19391','19451','20310','20311','20312','20313','20314','20315','20316','20317','20318','20319','20320','20321','20322','20323','20324','20325','20326','20327','20328','20329','20330','20331','20332','20333','20334','20335','20336','20337','20338','20339','20340','20341','22379','22826','22827','22828','22829','22830','22831','22832','22833','22834','22835','22836','22837','22838','22839','22840','22841','22842','22843','22844','22845','22846','22847','22848','22849','22850','22851','22852','22853','22854','24887','24888','24889','24890','24891','24892','26400','26401','26405','26579','26647','26648','26650','26904','27840','27841','27842','27843','27844','27845','27846','27847','27848','27849','27850','27851','27852','27853','27854','27855','27856','27857','27858','27859','27860','27861','27862','27863','27864','27865','27866','27867','27868','27869','27870','27871','27878','27879','27880','27883','27884','27891','27892','27893','27894','27895','27896','27897','27898','27899','27900','27901','27902','27903','27904','27905','27906','27907','27908','27909','27910','27911','27920','27921','27922','27923','27924','27925','27926','27927','27928','27941','27942','27943','27944','27945','27946','27947','27948','27953','27954','27955','27956','27957','27958','27959','27960','27961','27962','27963','27964','27965','27966','27967','27972','27973','27974','27975','27976','27977','27978','27979','27980','27981','27982','27983','27984','27985','27986','27987','27988','27989','28019','28020','28021','28022','28023','28024','28037','28038','28039','28040','28041','28042','28043','28044','28045','28046','28047','28048','28049','28050','28051','28052','28053','28054','28055','28056','28057','28058','28059','28072','28073','28074','28075','28076','28077','28078','28079','28080','28081','28082','28083','28084','28085','28086','28090','28091','28092','28093','28094','28095','28096','28097','28098','28099','28100','28130','28131','28132','28133','28138','28139','28140','28141','28142','28143','28144','28145','28146','28151','28152','28153','28154','28155','28156','28157','28158','28159','28160','28161','28162','28163','28164','28165','28166','28167','28168','28169','28170','28171','28172','28173','28174','28175','28176','28177','28178','28179','28180','28181','28182','28183','28184','28185','28186','28187','28188','28189','28190','28191','28192','28193','28194','28195','28196','28197','28198','28199','28200','28201','28202','28203','28204','28205','28206','28207','28208','28209','28210','28211','28212','28213','28214','28215','28216','28217','28218','28219','28220','28221','28222','28223','28224','28225','28226','28227','28228','28229','28230','28231','28232','28233','28234','28235','28236','28237','28238','28239','28240','28241','28242','28243','28244','28245','28246','28247','28248','28249','28250','28251','28252','28253','28254','28255','28256','28257','28258','28259','28260','28261','28262','28263','28264','28265','28266','28267','28268','28269','28270','28291','28292','28293','28294','28295','28296','28297','28298','28299','28300','28301','28302','28303','28304','28305','28306','28307','28308','28309','28310','28311','28312','31321','31322','31323','31324','33600','33601','33602','33603','33604','33605','33606','37217','37218','45894','46106','46167','47071','48358','48362','48428','48429','48663','48664','48740','50314','50315','50316','50317','50318','50319','50320','50321','50322','50323','50949','60903','60904','60905','60906','60907','60908','60909','60910','60911','60912','60913','60914','60915','60916','60917','60918','60919','60920','60921','60922','60923','60924','60925','60926','60927','60928','60929','60930','60931','60932','60933','60934','60935','60936','60937','60938','60939','60940','62101') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2979','2980','2981','2982','2985','2987','2988','2989','2991','2993','2994','2995','2996','2997','2999','3000','3001','3004','3005','3008','3010','3011','3013','3015','3017','3019','3021','3022','3024','3026','3027','3029','3030','3032','3033','3034','3035','3038','3040','10421','10422','10423','10424','10425','10426','10427','10428','10429','10430','10431','10432','10433','10434','10435','10436','10437','10438','10439','10440','10441','10442','10443','10444','10445','10446','10447','10448','10449','10450','10451','10452','10453','10454','10455','10456','10457','10458','10459','10460','10461','10462','10463','10464','10465','10466','10467','10468','10469','10470','10471','10472','10473','10474','10475','10476','10477','10478','10479','10480','11173','13373','13374','13375','14116','15848','16351','16352','16353','17796','19005','19007','19065','19093','19094','19095','19096','19390','19391','19451','20310','20311','20312','20313','20314','20315','20316','20317','20318','20319','20320','20321','20322','20323','20324','20325','20326','20327','20328','20329','20330','20331','20332','20333','20334','20335','20336','20337','20338','20339','20340','20341','22379','22826','22827','22828','22829','22830','22831','22832','22833','22834','22835','22836','22837','22838','22839','22840','22841','22842','22843','22844','22845','22846','22847','22848','22849','22850','22851','22852','22853','22854','24887','24888','24889','24890','24891','24892','26400','26401','26405','26579','26647','26648','26650','26904','27840','27841','27842','27843','27844','27845','27846','27847','27848','27849','27850','27851','27852','27853','27854','27855','27856','27857','27858','27859','27860','27861','27862','27863','27864','27865','27866','27867','27868','27869','27870','27871','27878','27879','27880','27883','27884','27891','27892','27893','27894','27895','27896','27897','27898','27899','27900','27901','27902','27903','27904','27905','27906','27907','27908','27909','27910','27911','27920','27921','27922','27923','27924','27925','27926','27927','27928','27941','27942','27943','27944','27945','27946','27947','27948','27953','27954','27955','27956','27957','27958','27959','27960','27961','27962','27963','27964','27965','27966','27967','27972','27973','27974','27975','27976','27977','27978','27979','27980','27981','27982','27983','27984','27985','27986','27987','27988','27989','28019','28020','28021','28022','28023','28024','28037','28038','28039','28040','28041','28042','28043','28044','28045','28046','28047','28048','28049','28050','28051','28052','28053','28054','28055','28056','28057','28058','28059','28072','28073','28074','28075','28076','28077','28078','28079','28080','28081','28082','28083','28084','28085','28086','28090','28091','28092','28093','28094','28095','28096','28097','28098','28099','28100','28130','28131','28132','28133','28138','28139','28140','28141','28142','28143','28144','28145','28146','28151','28152','28153','28154','28155','28156','28157','28158','28159','28160','28161','28162','28163','28164','28165','28166','28167','28168','28169','28170','28171','28172','28173','28174','28175','28176','28177','28178','28179','28180','28181','28182','28183','28184','28185','28186','28187','28188','28189','28190','28191','28192','28193','28194','28195','28196','28197','28198','28199','28200','28201','28202','28203','28204','28205','28206','28207','28208','28209','28210','28211','28212','28213','28214','28215','28216','28217','28218','28219','28220','28221','28222','28223','28224','28225','28226','28227','28228','28229','28230','28231','28232','28233','28234','28235','28236','28237','28238','28239','28240','28241','28242','28243','28244','28245','28246','28247','28248','28249','28250','28251','28252','28253','28254','28255','28256','28257','28258','28259','28260','28261','28262','28263','28264','28265','28266','28267','28268','28269','28270','28291','28292','28293','28294','28295','28296','28297','28298','28299','28300','28301','28302','28303','28304','28305','28306','28307','28308','28309','28310','28311','28312','31321','31322','31323','31324','33600','33601','33602','33603','33604','33605','33606','37217','37218','45894','46106','46167','47071','48358','48362','48428','48429','48663','48664','48740','50314','50315','50316','50317','50318','50319','50320','50321','50322','50323','50949','60903','60904','60905','60906','60907','60908','60909','60910','60911','60912','60913','60914','60915','60916','60917','60918','60919','60920','60921','60922','60923','60924','60925','60926','60927','60928','60929','60930','60931','60932','60933','60934','60935','60936','60937','60938','60939','60940','62101') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='132'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Suzuki%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='132'
700
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='132' ORDER BY `sort_name`, `type` LIMIT 100, 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`='132'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','609','886','912','913')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1092','1094','1153','1181','1182','1183','1184','1479','1480','1540','2342','2343','2344','2345','2346','2347','2348','2349','2350','2351','2352','2353','2354','2355','2356','2357','2358','2359','2360','2361','2362','2363','2364','2365','2366','2367','2368','2369','2370','2371','2372','2373','4448','4895','4896','4897','4898','4899','4900','4901','4902','4903','4904','4905','4906','4907','4908','4909','4910','4911','4912','4913','4914','4915','4916','4917','4918','4919','4920','4921','4922','4923','6959','6960','6961','6962','6963','6964','8472','8473','8477','8651','8719','8720','8722','8976','9912','9913','9914','9915','9916','9917','9918','9919','9920','9921','9922','9923','9924','9925','9926','9927','9928','9929','9930','9931','9932','9933','9934','9935','9936','9937','9938','9939','9940','9941','9942','9943','9950','9951','9952','9955','9956','9963','9964','9965','9966','9967','9968','9969','9970','9971','9972','9973','9974','9975','9976','9977','9978','9979','9980','9981','9982','9983','9992','9993','9994','9995','9996','9997','9998','9999','10000','10013','10014','10015','10016','10017','10018','10019','10020','10025','10026','10027','10028','10029','10030','10031','10032','10033','10034','10035','10036','10037','10038','10039','10044','10045','10046','10047','10048','10049','10050','10051','10052','10053','10054','10055','10056','10057','10058','10059','10060','10061','10091','10092','10093','10094','10095','10096','10109','10110','10111','10112','10113','10114','10115','10116','10117','10118','10119','10120','10121','10122','10123','10124','10125','10126','10127','10128','10129','10130','10131','10144','10145','10146','10147','10148','10149','10150','10151','10152','10153','10154','10155','10156','10157','10158','10162','10163','10164','10165','10166','10167','10168','10169','10170','10171','10172','10202','10203','10204','10205','10210','10211','10212','10213','10214','10215','10216','10217','10218','10223','10224','10225','10226','10227','10228','10229','10230','10231','10232','10233','10234','10235','10236','10237','10238','10239','10240','10241','10242','10243','10244','10245','10246','10247','10248','10249','10250','10251','10252','10253','10254','10255','10256','10257','10258','10259','10260','10261','10262','10263','10264','10265','10266','10267','10268','10269','10270','10271','10272','10273','10274','10275','10276','10277','10278','10279','10280','10281','10282','10283','10284','10285','10286','10287','10288','10289','10290','10291','10292','10293','10294','10295','10296','10297','10298','10299','10300','10301','10302','10303','10304','10305','10306','10307','10308','10309','10310','10311','10312','10313','10314','10315','10316','10317','10318','10319','10320','10321','10322','10323','10324','10325','10326','10327','10328','10329','10330','10331','10332','10333','10334','10335','10336','10337','10338','10339','10340','10341','10342','10363','10364','10365','10366','10367','10368','10369','10370','10371','10372','10373','10374','10375','10376','10377','10378','10379','10380','10381','10382','10383','10384','13397','13398','13399','13400','15676','15677','15678','15679','15680','15681','15682','19295','19296','27985','28205','28264','29148','30387','30391','30457','30458','30689','30690','30760','31506','31937')
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 = 10384) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32093) 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`='32093'
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('10383','10384') 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 = 1480) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33840) 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`='33840'
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('1479','1480','1540','2353','2354','2355','2356','2357','2358','2359','2360','2361','10370','10371','10372','10373','10374','15676','15677','15678','27985') 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 = 28264) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36075) 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`='36075'
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('4923','28264') 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 = 9924) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 10104) 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 = 10163) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36047) 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`='36047'
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('10144','10145','10146','10147','10148','10149','10150','10151','10152','10153','10154','10155','10162','10163','10164','10165','10202','10203','10204','10205','10210','10211','10212','10213','10214','10224','28205','30387','30689') 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 = 10211) 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 = 29148) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32054) 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`='32054'
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('4917','4918','4919','4920','4921','10261','10262','10263','10264','10265','10266','10267','10268','10269','10270','10271','10272','10273','10274','10275','10276','10277','10278','10279','10280','10281','10282','10363','10364','29148') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group