/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`='kenworth' 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`='262'

SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('14737','14738','14739','14740','14741','14742','14743','14744','14745','14746','14747','14748','14749','14750','14751','14752','14753','14754','14755','14756','14757','14758','14759','14760','14761','14762','14763','14764','14765','14766','14767','14768','14769','16482','16483','16484','37391','37392','37393','37394','37395','37396','37397','37398','37399','37400','37401','37402','37403','37404','37405','37406','37407','37408','37409','37410','37411','37412','37413','37414','37415','37416','37417','37418','37419','37420','37421','37422','37423','37424','37425','37426','37427','37428','37429','37430','37431','37432','37433','37434','37435','37436','37437','37438','37439','37440','37441','37442','37443','37444','37445','37446','37447','37448','37449','37450','37451','37452','37453','37454','37455','37456','37457','37458','37459','37460','37461','37462','37463','37464','37465','37466','37467','37468','37469','37470','37471','37472','37473','37474','37475','37476','37477','37478','37479','37480','37481','37482','37483','37484','37485','37486','37487','37488','37489','37490','37491','37492','37493','37494','37495','37496','37497','37498','37499','37500','37501','37502','37503','37504','37505','37506','37507','37508','37509','37510','37511','37512','37513','37514','37515','37516','37517','37518','37519','37520','37521','37522','37523','37524','37525','37526','37527','37528','37529','37530','37531','37532','37533','37534','37535','37536','37537','37538','37539','37540','37541','37542','37543','37544','37545','37546','37547','37548','37549','37550','37551','37552','37553','37554','37555','37556','37557','37558','37559','37560','37561','37562','37563','37564','37565','37566','37567','37568','37569','37570','37571','37572','37573','37574','37575','37576','37577','37578','37579','37580','37581','37582','37583','37584','37585','37586','37587','37588','37589','37590','37591','37592','37593','37594','37595','37596','37597','37598','37599','37600','37601','37602','37603','37604','37605','37606','37607','37608','37609','37610','37611','37612','37613','37614','37615','37616','37617','37618','37619','37620','37621','37622','37623','37624','37625','37626','37627','37628','37629','37630','37631','37632','37633','37634','37635','37636','37637','37638','37639','37640','37641','37642','37643','37644','37645','37646','37647','37648','37649','37650','37651','37652','37653','37654','37655','37656','37657','37658','37659','37660','37661','37662','37663','37664','37665','37666','37667','37668','37669','37670','37671','37672','37673','37674','37675','37676','37677','37678','37679','37680','37681','37682','37683','37684','37685','37686','37687','37688','37689','37690','37691','39058','39059','39060','39061','39062','39063','39064','39065','39066','39067','39068','39069','39070','39071','39072','39073','39074','39075','39076','39077','39078','39079','39080','39081','39082','39083','39084','39085','39086','39087','39088','39089','39090','39091','39092','39093','39094','39095','39096','39097','39098','39099','39100','39101','39102','45857','46763','46764','46765','46766','46767','47296','47510','48263','48557','48558','48559','48560','48561','48562','48567','49690','49691','49692','49693','49694','49695','49696','49697','49698','49699','49700','49701','49702','49703','49704','49705','49706','49707','49708','49709','49710','49711','49712','49713','49714','49715','49716','49717','49718','49719','49720','49721','49722','49723','49724','49725','49726','49727','49728','49729','49730','49731','49732','49733','49734','49735','50168','50169','50170','50171','50172','50173','50174','50175','50176','50787','52249','52250','52251','53022','53023','53024','53025','53026','53027','53028','53941') AND `class_id`='1'

SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('14737','14738','14739','14740','14741','14742','14743','14744','14745','14746','14747','14748','14749','14750','14751','14752','14753','14754','14755','14756','14757','14758','14759','14760','14761','14762','14763','14764','14765','14766','14767','14768','14769','16482','16483','16484','37391','37392','37393','37394','37395','37396','37397','37398','37399','37400','37401','37402','37403','37404','37405','37406','37407','37408','37409','37410','37411','37412','37413','37414','37415','37416','37417','37418','37419','37420','37421','37422','37423','37424','37425','37426','37427','37428','37429','37430','37431','37432','37433','37434','37435','37436','37437','37438','37439','37440','37441','37442','37443','37444','37445','37446','37447','37448','37449','37450','37451','37452','37453','37454','37455','37456','37457','37458','37459','37460','37461','37462','37463','37464','37465','37466','37467','37468','37469','37470','37471','37472','37473','37474','37475','37476','37477','37478','37479','37480','37481','37482','37483','37484','37485','37486','37487','37488','37489','37490','37491','37492','37493','37494','37495','37496','37497','37498','37499','37500','37501','37502','37503','37504','37505','37506','37507','37508','37509','37510','37511','37512','37513','37514','37515','37516','37517','37518','37519','37520','37521','37522','37523','37524','37525','37526','37527','37528','37529','37530','37531','37532','37533','37534','37535','37536','37537','37538','37539','37540','37541','37542','37543','37544','37545','37546','37547','37548','37549','37550','37551','37552','37553','37554','37555','37556','37557','37558','37559','37560','37561','37562','37563','37564','37565','37566','37567','37568','37569','37570','37571','37572','37573','37574','37575','37576','37577','37578','37579','37580','37581','37582','37583','37584','37585','37586','37587','37588','37589','37590','37591','37592','37593','37594','37595','37596','37597','37598','37599','37600','37601','37602','37603','37604','37605','37606','37607','37608','37609','37610','37611','37612','37613','37614','37615','37616','37617','37618','37619','37620','37621','37622','37623','37624','37625','37626','37627','37628','37629','37630','37631','37632','37633','37634','37635','37636','37637','37638','37639','37640','37641','37642','37643','37644','37645','37646','37647','37648','37649','37650','37651','37652','37653','37654','37655','37656','37657','37658','37659','37660','37661','37662','37663','37664','37665','37666','37667','37668','37669','37670','37671','37672','37673','37674','37675','37676','37677','37678','37679','37680','37681','37682','37683','37684','37685','37686','37687','37688','37689','37690','37691','39058','39059','39060','39061','39062','39063','39064','39065','39066','39067','39068','39069','39070','39071','39072','39073','39074','39075','39076','39077','39078','39079','39080','39081','39082','39083','39084','39085','39086','39087','39088','39089','39090','39091','39092','39093','39094','39095','39096','39097','39098','39099','39100','39101','39102','45857','46763','46764','46765','46766','46767','47296','47510','48263','48557','48558','48559','48560','48561','48562','48567','49690','49691','49692','49693','49694','49695','49696','49697','49698','49699','49700','49701','49702','49703','49704','49705','49706','49707','49708','49709','49710','49711','49712','49713','49714','49715','49716','49717','49718','49719','49720','49721','49722','49723','49724','49725','49726','49727','49728','49729','49730','49731','49732','49733','49734','49735','50168','50169','50170','50171','50172','50173','50174','50175','50176','50787','52249','52250','52251','53022','53023','53024','53025','53026','53027','53028','53941') AND `class_id`='1'

SELECT name FROM prints_make WHERE `id`='262'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Kenworth%" ORDER BY name_title

?page=###page###

SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='262'

498

SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='262' 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`='262'

SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('19469','19470','19471','19472','19473','19474','19475','19476','19477','19478','19479','19480','19481','19482','19483','19484','19485','19486','19487','19488','19489','19490','19491','19492','19493','19494','19495','19496','19497','19498','19499','19500','19501','19502','19503','19504','19505','19506','19507','19508','19509','19510','19511','19512','19513','19514','19515','19516','19517','19518','19519','19520','19521','19522','19523','19524','19525','19526','19527','19528','19529','19530','19531','19532','19533','19534','19535','19536','19537','19538','19539','19540','19541','19542','19543','19544','19545','19546','19547','19548','19549','19550','19551','19552','19553','19554','19555','19556','19557','19558','19559','19560','19561','19562','19563','19564','19565','19566','19567','19568','19569','19570','19571','19572','19573','19574','19575','19576','19577','19578','19579','19580','19581','19582','19583','19584','19585','19586','19587','19588','19589','19590','19591','19592','19593','19594','19595','19596','19597','19598','19599','19600','19601','19602','19603','19604','19605','19606','19607','19608','19609','19610','19611','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19627','19628','19629','19630','19631','19632','19633','19634','19635','19636','19637','19638','19639','19640','19641','19642','19643','19644','19645','19646','19647','19648','19649','19650','19651','19652','19653','19654','19655','19656','19657','19658','19659','19660','19661','19662','19663','19664','19665','19666','19667','19668','19669','19670','19671','19672','19673','19674','19675','19676','19677','19678','19679','19680','19681','19682','19683','19684','19685','19686','19687','19688','19689','19690','19691','19692','19693','19694','19695','19696','19697','19698','19699','19700','19701','19702','19703','19704','19705','19706','19707','19708','19709','19710','19711','19712','19713','19714','19715','19716','19717','19718','19719','19720','19721','19722','19723','19724','19725','19726','19727','19728','19729','19730','19731','19732','19733','19734','19735','19736','19737','19738','19739','19740','19741','19742','19743','19744','19745','19746','19747','19748','19749','19750','19751','19752','19753','19754','19755','19756','19757','19758','19759','19760','19761','19762','19763','19764','19765','19766','19767','19768','19769','21136','21137','21138','21139','21140','21141','21142','21143','21145','21146','21147','21148','21149','21150','21151','21152','21153','21154','21155','21156','21157','21158','21159','21160','21161','21162','21163','21164','21165','21166','21167','21168','21169','21170','21171','21172','21173','21174','21175','21176','21177','21178','21179','21180','27947','28846','28847','28848','28849','28850','29364','29578','30292','30586','30587','30588','30593','31349')

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 = 28847) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35846) 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`='35846'

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('19569','19570','19571','19572','21136','21137','21138','21139','21140','21141','21142','21143','21145','21146','21147','21148','21149','21150','21151','21152','21153','21154','21155','21156','21157','21158','21159','21160','21161','21162','21163','21164','21165','21166','21167','21168','21169','21170','21171','21172','21173','21174','21175','21176','21177','21178','21179','21180','28846','28847','28848','30292','31349') 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 = 28846) 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 = 28850) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32123) 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`='32123'

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('28850','29364') 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('19469','19470','19471','19472','19473','19474','19475','19476','19477','19478','19479','19480','19481','19482','19483','19484','19485','19486','19487','19488','19489','19490','19491','19492','19493','19494','19495','19496','19497','19498','19499','19500','19501','19502','19503','19504','19505','19506','19507','19508','19509','19510','19511','19512','19513','19514','19515','19516','19517','19518','19519','19520','19521','19522','19523','19524','19525','19526','19527','19528','19529','19530','19531','19532','19533','19534','19535','19536','19537','19538','19539','19540','19541','19542','19543','19544','19545','19546','19547','19548','19549','19550','19551','19552','19553','19554','19555','19556','19557','19558','19559','19560','19561','19562','19563','19564','19565','19566','19567','19568','19569','19570','19571','19572','19573','19574','19575','19576','19577','19578','19579','19580','19581','19582','19583','19584','19585','19586','19587','19588','19589','19590','19591','19592','19593','19594','19595','19596','19597','19598','19599','19600','19601','19602','19603','19604','19605','19606','19607','19608','19609','19610','19611','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19627','19628','19629','19630','19631','19632','19633','19634','19635','19636','19637','19638','19639','19640','19641','19642','19643','19644','19645','19646','19647','19648','19649','19650','19651','19652','19653','19654','19655','19656','19657','19658','19659','19660','19661','19662','19663','19664','19665','19666','19667','19668','19669','19670','19671','19672','19673','19674','19675','19676','19677','19678','19679','19680','19681','19682','19683','19684','19685','19686','19687','19688','19689','19690','19691','19692','19693','19694','19695','19696','19697','19698','19699','19700','19701','19702','19703','19704','19705','19706','19707','19708','19709','19710','19711','19712','19713','19714','19715','19716','19717','19718','19719','19720','19721','19722','19723','19724','19725','19726','19727','19728','19729','19730','19731','19732','19733','19734','19735','19736','19737','19738','19739','19740','19741','19742','19743','19744','19745','19746','19747','19748','19749','19750','19751','19752','19753','19754','19755','19756','19757','19758','19759','19760','19761','19762','19763','19764','19765','19766','19767','19768','19769','21136','21137','21138','21139','21140','21141','21142','21143','21145','21146','21147','21148','21149','21150','21151','21152','21153','21154','21155','21156','21157','21158','21159','21160','21161','21162','21163','21164','21165','21166','21167','21168','21169','21170','21171','21172','21173','21174','21175','21176','21177','21178','21179','21180','27947','28848','28849','29364','29578','30292','30586','30587','30588','30593','31349')

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 = 30587) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34379) 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`='34379'

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('19624','19625','19626','19627','19628','19629','19630','19631','19632','19634','30587') 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 = 29364) 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 = 30593) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36224) 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`='36224'

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('19724','19725','19726','19727','19728','19729','19730','19731','19732','19733','19734','19735','19736','19737','19738','19739','19740','19741','19742','19743','19744','19745','19746','19747','19748','19749','19750','19751','19752','19753','30593') 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 = 30586) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34378) 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`='34378'

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('19633','19635','19636','19637','19638','19639','19640','19641','19642','19643','19644','19645','19646','19647','19648','19649','19650','19651','19652','19653','19654','19655','19656','19657','19658','19659','19660','19661','19662','19663','30586') ORDER BY price LIMIT 0, 1

SELECT `id`, `name`, `type` FROM nox_group