/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`='ram' 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`='395'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('18923','18924','18925','18926','19316','19318','19750','20816','20817','20818','20819','20820','20821','20822','20823','20824','20825','20826','20827','20828','20829','20830','20831','20832','20833','20834','20836','24300','24301','24302','32311','45882','45888','45899','45900','45902','45903','46257','46504','46722','46927','47251','47252','47253','47254','47255','47256','47257','47258','47259','47260','47261','47335','47336','47337','47338','47343','47344','47345','47346','47347','47348','47349','47350','47351','47352','47353','47354','47355','47356','47357','47358','47365','47366','47376','47377','47378','47379','47380','47387','47388','47389','47390','47391','47392','47393','47394','47395','47396','47397','47398','47399','47400','47401','47402','47403','47404','47405','47406','47407','47408','47409','47410','47411','47412','47445','47446','47447','47448','47449','47450','47451','47452','47528','47529','47530','47531','47532','47533','47534','47535','47536','47537','47538','47539','47540','47541','47542','47543','47551','47582','47623','47624','47858','47859','47860','47861','47862','47863','47864','47865','47866','47867','47868','47869','47870','47871','47872','47873','47874','47875','47876','47877','47878','47879','47880','47881','47882','47883','47884','47885','47886','47887','47888','47889','47890','47891','47949','48049','48057','48155','48156','48157','48158','48204','48268','48269','48293','48294','48295','48296','48297','48298','48299','48300','48301','48302','48303','48304','48305','48306','48307','48308','48309','48310','48311','48312','48313','48314','48315','48316','48317','48318','48319','48320','48321','48322','48323','48324','48492','48672','48698','48818','48819','48824','49028','49033','49034','49045','49046','49047','49051','49176','49177','49178','49202','49220','49221','50684','50692','50693','50694','50755','50756','50757','50758','50774','50777','50783','50786','50789','50815','50878','50879','50880','50881','50882','50883','50884','50885','50886','50887','50888','50889','50890','50891','50892','50893','50894','50895','50896','50897','50898','50899','50900','50901','61952','61953','62145') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('18923','18924','18925','18926','19316','19318','19750','20816','20817','20818','20819','20820','20821','20822','20823','20824','20825','20826','20827','20828','20829','20830','20831','20832','20833','20834','20836','24300','24301','24302','32311','45882','45888','45899','45900','45902','45903','46257','46504','46722','46927','47251','47252','47253','47254','47255','47256','47257','47258','47259','47260','47261','47335','47336','47337','47338','47343','47344','47345','47346','47347','47348','47349','47350','47351','47352','47353','47354','47355','47356','47357','47358','47365','47366','47376','47377','47378','47379','47380','47387','47388','47389','47390','47391','47392','47393','47394','47395','47396','47397','47398','47399','47400','47401','47402','47403','47404','47405','47406','47407','47408','47409','47410','47411','47412','47445','47446','47447','47448','47449','47450','47451','47452','47528','47529','47530','47531','47532','47533','47534','47535','47536','47537','47538','47539','47540','47541','47542','47543','47551','47582','47623','47624','47858','47859','47860','47861','47862','47863','47864','47865','47866','47867','47868','47869','47870','47871','47872','47873','47874','47875','47876','47877','47878','47879','47880','47881','47882','47883','47884','47885','47886','47887','47888','47889','47890','47891','47949','48049','48057','48155','48156','48157','48158','48204','48268','48269','48293','48294','48295','48296','48297','48298','48299','48300','48301','48302','48303','48304','48305','48306','48307','48308','48309','48310','48311','48312','48313','48314','48315','48316','48317','48318','48319','48320','48321','48322','48323','48324','48492','48672','48698','48818','48819','48824','49028','49033','49034','49045','49046','49047','49051','49176','49177','49178','49202','49220','49221','50684','50692','50693','50694','50755','50756','50757','50758','50774','50777','50783','50786','50789','50815','50878','50879','50880','50881','50882','50883','50884','50885','50886','50887','50888','50889','50890','50891','50892','50893','50894','50895','50896','50897','50898','50899','50900','50901','61952','61953','62145') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='395'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Ram%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='395'
317
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='395' 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`='395'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','601')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1010','1011','1012','1013','1405','1407','1802','2848','2849','2850','2851','2852','2853','2854','2855','2856','2857','2858','2859','2860','2861','2862','2863','2864','2865','2866','2868','6372','6373','6374','14387','27973','27979','27992','27993','27995','27996','28348','28589','28805','29009','29319','29320','29321','29322','29323','29324','29325','29326','29327','29328','29329','29403','29404','29405','29406','29411','29412','29413','29414','29415','29416','29417','29418','29419','29420','29421','29422','29423','29424','29425','29426','29433','29434','29444','29445','29446','29447','29448','29455','29456','29457','29458','29459','29460','29461','29462','29463','29464','29465','29466','29467','29468','29469','29470','29471','29472','29473','29474','29475','29476','29477','29478','29479','29480','29513','29514','29515','29516','29517','29518','29519','29520','29596','29597','29598','29599','29600','29601','29602','29603','29604','29605','29606','29607','29608','29609','29610','29611','29619','29650','29691','29692','29913','29914','29915','29916','29917','29918','29919','29920','29921','29922','29923','29924','29925','29926','29927','29928','29929','29930','29931','29932','29933','29934','29935','29936','29937','29938','29939','29940','29941','29942','29943','29944','29945','29946','29998','30089','30097','30185','30186','30187','30188','30234','30297','30298','30322','30323','30324','30325','30326','30327','30328','30329','30330','30331','30332','30333','30334','30335','30336','30337','30338','30339','30340','30341','30342','30343','30344','30345','30346','30347','30348','30349','30350','30351','30352','30353','30521','30698','30718','30837','30838','30843','31046','31049','31050','31061','31062','31063','31067','31187','31188','31189','31213','31230','31231','31248','31256','31257','31258','31318','31319','31320','31321','31337','31339','31345','31348','31351','31372','31435','31436','31437','31438','31439','31440','31441','31442','31443','31444','31445','31446','31447','31448','31449','31450','31451','31452','31453','31454','31455','31456','31457','31458','31788','31981')
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 = 29924) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35813) 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`='35813'
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('29913','29918','29919','29924','29930','29932','29937','30234','31061','31213','31231','31319') 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 = 29937) 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 = 28589) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35983) 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`='35983'
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('2848','2849','2853','2866','28589','29319','29320','29321','29455','29456','29457','29998','30187','30188','30297','30328','30329','30330','30331','31050','31256','31257','31258','31339','31372') 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 = 29414) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35821) 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`='35821'
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('1405','1407','2865','2868','27973','27979','29009','29403','29404','29405','29406','29411','29412','29413','29414','29415','29416','29417','29418','29419','29424','29425','29426','30097','30718','31049','31337') 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 = 29933) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35814) 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`='35814'
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('29914','29916','29920','29921','29925','29928','29933','29938','29940','29943','30837','31062','31320') 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 = 29458) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35993) 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`='35993'
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('2850','2851','2852','29322','29323','29324','29325','29326','29327','29328','29329','29458','29459','29460','29461','29462','29463','29464','30185','30186','30298','30322','30323','30324','30325','30326','30327','30332','30333','30334','30335','30336','30343','30344','30345','30346','30347','31067','31187','31248','31345','31435','31436','31437','31438','31439','31440','31441','31442','31443','31444','31445','31446') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group