/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`='international' 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`='64'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('5119','5120','13659','13660','13661','13662','13663','13664','13665','13666','13667','13668','13669','13670','13671','13672','13673','13674','13675','13676','13677','13678','13679','13680','13681','13682','13683','13684','13685','15788','17721','17722','17723','17724','17725','17726','17727','17728','17729','17730','17731','17732','17733','17734','17735','17736','17737','39121','39122','39123','39124','39125','39126','39127','39128','39129','39130','39131','39132','39133','39134','39135','39136','39137','39138','39139','39140','39141','39142','39143','39144','39145','39146','39147','39148','39149','39150','39151','39152','39153','39154','39155','39156','39157','39158','39159','39160','39161','39162','39163','39164','39165','39166','39167','39168','39169','39170','39171','39172','39173','39174','39175','39176','39177','39178','39179','39180','39181','39182','39183','39184','39185','39186','39187','39188','39189','39190','39191','39192','39193','39194','39195','39196','39197','39198','39199','39200','39201','39202','39203','39204','39205','39206','39207','39208','39209','39210','39211','39212','39213','39214','39215','39216','39217','39218','39219','39220','39221','39222','39223','39224','39225','39226','39227','39228','39229','39230','39231','39232','39233','39234','39235','39236','39237','39238','39239','39240','39241','39242','39243','39244','39245','39246','39247','39248','39249','39250','39251','39252','39253','39254','39255','39256','39257','39258','39259','39260','39261','39262','39263','39264','39265','39266','39267','39268','39269','39270','39271','39272','39273','39274','39275','39276','39277','39278','39279','39280','39281','39282','39283','39284','39285','39286','39287','39288','39289','39290','39291','39292','39293','39294','39295','39296','39297','39298','39299','39300','39301','39302','39303','39304','39305','39306','39307','39308','39309','39310','39311','39312','39313','39314','39315','39316','39317','39318','39319','39320','39321','39322','39323','39324','39325','39326','39327','39328','39329','39330','39331','39332','39333','39334','39335','39336','39337','39338','39339','39340','39341','39342','39343','39344','39345','39346','39347','39348','39349','39350','39351','39352','39353','39354','39355','39356','39357','39358','39359','39360','39361','39362','39363','39364','39365','39366','39367','39368','39369','39370','39371','39372','39373','39374','39375','39376','39377','39378','39379','39380','39381','39382','39383','39384','39385','39386','39387','39388','39389','39390','39391','39392','39393','39394','39395','39396','39397','39398','39399','39400','39401','39402','39403','39404','39405','39406','39407','39408','39409','39410','39411','39412','39413','39414','39415','39416','39417','39418','39419','39420','39421','39422','39423','39424','39425','39426','39427','39428','39429','39430','39431','39432','39433','39434','39435','39436','39437','39438','39439','39440','39441','39442','39443','39444','39445','39446','39447','39448','39449','39450','39451','39452','39453','39454','39455','39456','39457','39458','39459','39460','39461','46660','46691','46695','46756','46757','46758','46759','46760','46761','46807','47228','47927','48207','48208','48211','48771','48772','49008','49644','49645','49646','49647','49648','49649','49650','49651','49652','49653','49654','49655','49656','49657','49658','49659','49660','49661','49662','49663','49664','49665','49666','49667','49668','49669','50131','50132','50133','51015','51373','51374','51375','51376','51377','51378','51379','51380','51381','51382','51383','51384','51385','51386','51387','51388','51389','51390','51391','51392','51393','51394','51395','51396','51397','51398','51399','51400','51401','51402','51403','51404','51405','51406','51407','51408','51409','51410','51411','51412','51413','51414','51415','51416','51417','51418','51419','51420','51421','51422','51423','51424','51425','51426','51427','51428','51429','51430','51431','61881','61882') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('5119','5120','13659','13660','13661','13662','13663','13664','13665','13666','13667','13668','13669','13670','13671','13672','13673','13674','13675','13676','13677','13678','13679','13680','13681','13682','13683','13684','13685','15788','17721','17722','17723','17724','17725','17726','17727','17728','17729','17730','17731','17732','17733','17734','17735','17736','17737','39121','39122','39123','39124','39125','39126','39127','39128','39129','39130','39131','39132','39133','39134','39135','39136','39137','39138','39139','39140','39141','39142','39143','39144','39145','39146','39147','39148','39149','39150','39151','39152','39153','39154','39155','39156','39157','39158','39159','39160','39161','39162','39163','39164','39165','39166','39167','39168','39169','39170','39171','39172','39173','39174','39175','39176','39177','39178','39179','39180','39181','39182','39183','39184','39185','39186','39187','39188','39189','39190','39191','39192','39193','39194','39195','39196','39197','39198','39199','39200','39201','39202','39203','39204','39205','39206','39207','39208','39209','39210','39211','39212','39213','39214','39215','39216','39217','39218','39219','39220','39221','39222','39223','39224','39225','39226','39227','39228','39229','39230','39231','39232','39233','39234','39235','39236','39237','39238','39239','39240','39241','39242','39243','39244','39245','39246','39247','39248','39249','39250','39251','39252','39253','39254','39255','39256','39257','39258','39259','39260','39261','39262','39263','39264','39265','39266','39267','39268','39269','39270','39271','39272','39273','39274','39275','39276','39277','39278','39279','39280','39281','39282','39283','39284','39285','39286','39287','39288','39289','39290','39291','39292','39293','39294','39295','39296','39297','39298','39299','39300','39301','39302','39303','39304','39305','39306','39307','39308','39309','39310','39311','39312','39313','39314','39315','39316','39317','39318','39319','39320','39321','39322','39323','39324','39325','39326','39327','39328','39329','39330','39331','39332','39333','39334','39335','39336','39337','39338','39339','39340','39341','39342','39343','39344','39345','39346','39347','39348','39349','39350','39351','39352','39353','39354','39355','39356','39357','39358','39359','39360','39361','39362','39363','39364','39365','39366','39367','39368','39369','39370','39371','39372','39373','39374','39375','39376','39377','39378','39379','39380','39381','39382','39383','39384','39385','39386','39387','39388','39389','39390','39391','39392','39393','39394','39395','39396','39397','39398','39399','39400','39401','39402','39403','39404','39405','39406','39407','39408','39409','39410','39411','39412','39413','39414','39415','39416','39417','39418','39419','39420','39421','39422','39423','39424','39425','39426','39427','39428','39429','39430','39431','39432','39433','39434','39435','39436','39437','39438','39439','39440','39441','39442','39443','39444','39445','39446','39447','39448','39449','39450','39451','39452','39453','39454','39455','39456','39457','39458','39459','39460','39461','46660','46691','46695','46756','46757','46758','46759','46760','46761','46807','47228','47927','48207','48208','48211','48771','48772','49008','49644','49645','49646','49647','49648','49649','49650','49651','49652','49653','49654','49655','49656','49657','49658','49659','49660','49661','49662','49663','49664','49665','49666','49667','49668','49669','50131','50132','50133','51015','51373','51374','51375','51376','51377','51378','51379','51380','51381','51382','51383','51384','51385','51386','51387','51388','51389','51390','51391','51392','51393','51394','51395','51396','51397','51398','51399','51400','51401','51402','51403','51404','51405','51406','51407','51408','51409','51410','51411','51412','51413','51414','51415','51416','51417','51418','51419','51420','51421','51422','51423','51424','51425','51426','51427','51428','51429','51430','51431','61881','61882') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='64'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "International%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='64'
561
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='64' 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`='64'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','887','888','889')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('21199','21200','21201','21202','21203','21204','21205','21206','21207','21208','21209','21210','21211','21212','21213','21214','21215','21216','21217','21218','21219','21220','21221','21222','21223','21224','21225','21226','21227','21228','21229','21230','21231','21232','21233','21234','21235','21236','21237','21238','21239','21240','21241','21242','21243','21244','21245','21246','21247','21248','21249','21250','21251','21252','21253','21254','21255','21256','21257','21258','21259','21260','21261','21262','21263','21264','21265','21266','21267','21268','21269','21270','21271','21272','21273','21274','21275','21276','21277','21278','21279','21280','21281','21282','21283','21284','21285','21286','21287','21288','21289','21290','21291','21292','21293','21294','21295','21296','21297','21298','21299','21300','21301','21302','21303','21304','21305','21306','21307','21308','21309','21310','21311','21312','21313','21314','21315','21316','21317','21318','21319','21320','21321','21322','21323','21324','21325','21326','21327','21328','21329','21330','21331','21332','21333','21334','21335','21336','21337','21338','21339','21340','21341','21342','21343','21344','21345','21346','21347','21348','21349','21350','21351','21352','21353','21354','21355','21356','21357','21358','21359','21360','21361','21362','21363','21364','21365','21366','21367','21368','21369','21370','21371','21372','21373','21374','21375','21376','21377','21378','21379','21380','21381','21382','21383','21384','21385','21386','21387','21388','21389','21390','21391','21392','21393','21394','21395','21396','21397','21398','21399','21400','21401','21402','21403','21404','21405','21406','21407','21408','21409','21410','21411','21412','21413','21414','21415','21416','21417','21418','21419','21420','21421','21422','21423','21424','21425','21426','21427','21428','21429','21430','21431','21432','21433','21434','21435','21436','21437','21438','21439','21440','21441','21442','21443','21444','21445','21446','21447','21448','21449','21450','21451','21452','21453','21454','21455','21456','21457','21458','21459','21460','21461','21462','21463','21464','21465','21466','21467','21468','21469','21470','21471','21472','21473','21474','21475','21476','21477','21478','21479','21480','21481','21482','21483','21484','21485','21486','21487','21488','21489','21490','21491','21492','21493','21494','21495','21496','21497','21498','21499','21500','21501','21502','21503','21504','21505','21506','21507','21508','21509','21510','21511','21512','21513','21514','21515','21516','21517','21518','21519','21520','21521','21522','21523','21524','21525','21526','21527','21528','21529','21530','21531','21532','21533','21534','21535','21536','21537','21538','21539','28743','28774','28778','28839','28840','28841','28842','28843','28844','28890','29296','29976','30237','30238','30241','30791','30792','31027','31564','31715','31716')
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 = 30238) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33872) 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`='33872'
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('30237','30238') 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 = 21523) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31307) 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`='31307'
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('21520','21521','21522','21523','21524','21525','21526','21527','21528','21529','21530','21531','21532','21533','21534','21535','21536','21537','21538','21539','28844') 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 = 28743) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34777) 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`='34777'
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('28743','29296','30241','30791') ORDER BY price LIMIT 0, 1
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 `prepay`=0 AND `id` IN('21199','21200','21201','21202','21203','21204','21205','21206','21207','21208','21209','21210','21211','21212','21213','21214','21215','21216','21217','21218','21219','21220','21221','21222','21223','21224','21225','21226','21227','21228','21229','21230','21231','21232','21233','21234','21235','21236','21237','21238','21239','21240','21241','21242','21243','21244','21245','21246','21247','21248','21249','21250','21251','21252','21253','21254','21255','21256','21257','21258','21259','21260','21261','21262','21263','21264','21265','21266','21267','21268','21269','21270','21271','21272','21273','21274','21275','21276','21277','21278','21279','21280','21281','21282','21283','21284','21285','21286','21287','21288','21289','21290','21291','21292','21293','21294','21295','21296','21297','21298','21299','21300','21301','21302','21303','21304','21305','21306','21307','21308','21309','21310','21311','21312','21313','21314','21315','21316','21317','21318','21319','21320','21321','21322','21323','21324','21325','21326','21327','21328','21329','21330','21331','21332','21333','21334','21335','21336','21337','21338','21339','21340','21341','21342','21343','21344','21345','21346','21347','21348','21349','21350','21351','21352','21353','21354','21355','21356','21357','21358','21359','21360','21361','21362','21363','21364','21365','21366','21367','21368','21369','21370','21371','21372','21373','21374','21375','21376','21377','21378','21379','21380','21381','21382','21383','21384','21385','21386','21387','21388','21389','21390','21391','21392','21393','21394','21395','21396','21397','21398','21399','21400','21401','21402','21403','21404','21405','21406','21407','21408','21409','21410','21411','21412','21413','21414','21415','21416','21417','21418','21419','21420','21421','21422','21423','21424','21425','21426','21427','21428','21429','21430','21431','21432','21433','21434','21435','21436','21437','21438','21439','21440','21441','21442','21443','21444','21445','21446','21447','21448','21449','21450','21451','21452','21453','21454','21455','21456','21457','21458','21459','21460','21461','21462','21463','21464','21465','21466','21467','21468','21469','21470','21471','21472','21473','21474','21475','21476','21477','21478','21479','21480','21481','21482','21483','21484','21485','21486','21487','21488','21489','21490','21491','21492','21493','21494','21495','21496','21497','21498','21499','21500','21501','21502','21503','21504','21505','21506','21507','21508','21509','21510','21511','21512','21513','21514','21515','21516','21517','21518','21519','21520','21521','21522','21524','21525','21526','21527','21528','21529','21530','21531','21532','21533','21534','21535','21536','21537','21538','21539','28774','28778','28839','28840','28841','28842','28843','28844','28890','29296','29976','30237','30241','30791','30792','31027','31564','31715','31716')
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 = 29296) 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 = 28839) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31303) 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`='31303'
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('21282','21283','21284','21285','21286','21287','21288','21289','21290','21291','21292','21293','21294','21295','21296','28839') 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 = 28774) 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`='28774' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group