/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorPrintAction.action.php
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`='24897'
SELECT `id`, `name`, `type` FROM nox_group
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `id`='42819'
UPDATE prints_vector SET views_count = views_count+1 WHERE id = 24897
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `id`='1'
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `id`='42819'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `id`='113'
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`='113'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','605')
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 = 24897)
SELECT vector_id FROM prints_set_vector WHERE `set_id`='26952'
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('24834','24835','24836','24837','24838','24839','24840','24841','24842','24843','24844','24845','24846','24847','24848','24849','24850','24851','24852','24853','24854','24855','24856','24857','24858','24859','24860','24861','24862','24863','24864','24865','24866','24867','24868','24869','24870','24871','24872','24873','24874','24875','24876','24877','24878','24879','24880','24881','24882','24883','24884','24885','24886','24887','24888','24889','24890','24891','24892','24893','24894','24895','24896','24897','24898','24899','24900','24901','24902','24903','24904','24905','24906','24907','24908','25156','25157','25158','25159','25160','25161','25162','25163','25164','25165','25166','25167','25168','25169','25170','25171','25172','25173','25174','25175','25176','25177','25178','25179','25180','25181','25182','25183','25184','25185','25186','25187','25188','25189','25190','25191','25192','25193','25194','25195','25196','25197','25198','25199','25200','25201','25202','25203','25204','25205','25206','25207','25208','25209','25210','25211','25212','25213','25214','25215','25216','25217','25218','25219','25220','25221','25222','25223','25224','25225','25226','25227','25228','25229','25230','25231','25232','25233','25234','25235','25236','25237','25238','25239','25240','25241','25242','25243','25244','25245','25246','25247','25248','25249','25250','25251','25252','25253','25254','25255','25256','25257','25258','25259','25260','25261','25262','25263','25264','25265','25266','25267','25268','25269','25270','25271','25272','25273','25274','25275','25276','25277','25278','25279','25280','25281','25282','25283','25284','25285','25286','25287','25288','25289','25290','25291','25292','25293','25294','25295','25296','25297','25298','25299','25300','25301','25302','25303','25304','25305','25306','25307','25308','25309','25310','25311','25312','25313','25314','25315','25316','25317','25318','25319','25320','25321','25322','25323','25324','25325','25326','25327','25328','25329','25330','25331','25332','25333','25334','25335','25336','25337','25338','25339','25340','25341','25342','25343','25344','25345','25346','25347','25348','25349','25350','25351','25352','25353','25354','25355','25356','25357','25358','25359','25360','25361','25362','25363','25364','25365','25366','25367','25368','25369','25370','25371','25372','25373','25374','25375','25376','25377','25378','25379','25380','25381','25382','25383','25384','25385','25386','25387','25388','25389','25390','25391','25392','25393','25394','25395','25396','25397','25398','25399','25400','25401','25402','25403','25404','25405','25406','25407','25408','25409','25410','25411','25412','25413','25414','25415','25416','25417','25418','25419','25420','25421','25422','25423','25424','25425','25426','25427','25428','25429','25430','25431','25432','25433','25434','25435','25436','25437','25438','25439','25440','25441','25442','25443','25444','25445','25446','25447','25448','25449','25450','25451','25452','25453','25454','25455','25456','25457','25458','25459','25460','25461','25462','25463','25464','25465','25466','25467','25468','25469','25470','25471','25472','25473','25474','25475','25476','25477','25478','25479','25480','25481','25482','25483','25484','25485','25486','25487','25488','25489','25490','25491','25492','25493','25494','25495','25496','25497','25498','25499','25500','25501','25502','25503','25504','25505','25506','25507','25508','25509','25510','25511','25512','25513','25514','25515','25516','25517','25518','25519','25520','25521','25522','25523','25524','25525','25526','25527','25528','25529','25530','25531','25532','25533','25534','25535','25536','25537','25538','25539','25540','25541','25542','25543','25544','25545','25546','25547','25548','25549','25550','25551','25552','25553','25554','25555','25556','25557','25558','25559','25560','25561','25562','25563','25564','25565','25566','25567','25568','25569','25570','25571','25572','25573','25574','25575','25576','25577','25578','25579','25580','25581','25582','25583','25584','25585','25586','25587','25588','25589','25590','25591','25592','25593','25594','25595','25596','25597','25598','25599','25600','25601','25602','25603','25604','25605','25606','25607','25608','25609','25610','25611','25612','25613','25614','25615','25616','25617','25618','25619','25620','25621','25622','25623','25624','25625','25626','25627','25628','25629','25630','25631','25632','25633','25634','25635','25636','25637','25638','25639','25640','25641','25642','25643','25644','25645','25646','25647','25648','25649','25650','25651','25652','25653','25654','25655','25656','25657','25658','25659','25660','25661','25662','25663','25664','25665','25666','25667','25668','25669','25670','25671','25672','25673','25674','25675','25676','25677','25678','25679','25680','25681','25682','25683','25684','25685','25686','25687','25688','25689','25690','25691','25692','25693','25694','25695','25696','25697','25698','25699','25700','25701','25702','25703','25704','25705','25706','25707','25708','25709','25710','25711','25712','25713','25714','25715','25716','25717','25718','25719','25720','25721','25722','25723','25724','25725','25726','25727','25728','25729','25730','25731','25732','25733','25734','25735','25736','25737','25738','25739','25740','25741','25742','25743','25744','25745','25746','25747','25748','25749','25750','25751','25752','25753','25754','25755','25756','25757','25758','25759','25760','25761','25762','25763','25764','25765','25766','25767','25768','25769','25770','25771','25772','25773','25774','25775','25776','25777','25778','25779','25780','25781','25782','25783','25784','25785','25786','25787','25788','25789','25790','25791','25792','25793','25794','25795','25796','25797','25798','25799','25800','25801','25802','25803','25804','25805','25806','25807','25808','25809','25810','25811','25812','25813','25814','25815','25816','25817','25818','25819','25820','25821','25822','25823','25824','25825','25826','25827','25828','25829','25830','25831','25832','25833','25834','25835','25836','25837','25838','25839','25840','25841','25842','25843','25844','25845','25846','25847','25848','25849','25850','25851','25852','25853','25854','25855','25856','25857','25858','25859','25860','25861','25862','25863','25864','25865','25866','25867','25868','25869','25870','25871','25872','25873','25874','25875','25876','25877','25878','25879','25880','25881','25882','25883','25884','25885','25886','25887','25888','25889','25890','25891','25892','25893','25894','25895','25896','25897','25898','25899','25900','25901','25902','25903','25904','25905','25906','25907','25908','25909','25910','25911','25912','25913','25914','25915','25916','25917','25918','25919','25920','25921','25922','25923','25924','25925','25926','25927','25928','25929','25930','25931','25932','25933','25934','25935','25936','25937','25938','25939','25940','25941','25942','25943','25944') AND `bundle`=1 ORDER BY id DESC
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `id`='1'
SELECT id FROM prints_vector WHERE prepay=0 AND id IN(select vector_id from `prints_set_vector` where set_id = 26952) ORDER BY id DESC
SELECT id FROM prints_vector WHERE prepay=0 AND item_id IN(select id from `prints_class_car` where make_id = 113 AND class = "Commercial" AND body = "Heavy Truck") ORDER BY id DESC
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('31373','29595') ORDER BY id DESC
SELECT id FROM prints_vector WHERE prepay=0 AND item_id IN(select id from `prints_class_car` where make_id = 113 AND class = "Commercial") ORDER BY id DESC
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('31787','31658','692','690','371','364','271','244','194','125') ORDER BY id DESC
SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125))
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125)) LIMIT 0, 4
SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1), (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.`id` IN(36249, 35867, 34107, 34692) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34107 AND `prints_set_vector`.`vector_id` IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35867 AND `prints_set_vector`.`vector_id` IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36249 AND `prints_set_vector`.`vector_id` IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34692 AND `prints_set_vector`.`vector_id` IN(31373,29595,31787,31658,692,690,371,364,271,244,194,125) AND `prints_vector`.`bundle` = 0
SELECT `tag_id`, `vector_id` FROM tag_vector WHERE `vector_id`='24897'
SELECT `id`, `datetime`, `price`, `purchase_type`, `ready`, `purchase_id`, `purchase_name`, `payment_id`, `status`, `mailchimp_abandoned_sent`, `user_id`, `_debug_raw_response` FROM payment WHERE `user_id`='0' AND `purchase_id`='24897' AND `status` IN('approved','add')
SELECT `id`, `vector_id`, `url`, `name`, `name_details`, `full_name`, `sort_name`, `category_id`, `make_id`, `body`, `blueprint_id`, `year`, `request_date`, `update_date`, `user_id`, `views_count`, `status`, `utm_value`, `description`, `set_name`, `set_id`, `raster_source`, `preview` FROM prints_request_vector WHERE `vector_id`='24897' ORDER BY id DESC LIMIT 0, 1