/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`='20380'
SELECT `id`, `name`, `type` FROM nox_group
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `id`='38302'
UPDATE prints_vector SET views_count = views_count+1 WHERE id = 20380
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`='38302'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `id`='257'
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`='257'
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 = 20380)
SELECT vector_id FROM prints_set_vector WHERE `set_id`='34654'
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('20018','20019','20020','20021','20022','20023','20024','20025','20026','20027','20028','20029','20030','20031','20032','20033','20034','20035','20036','20037','20038','20039','20040','20041','20042','20043','20044','20045','20046','20047','20048','20049','20050','20051','20052','20053','20054','20055','20056','20057','20058','20059','20060','20061','20062','20063','20064','20065','20066','20067','20068','20069','20070','20071','20072','20073','20074','20075','20076','20077','20078','20079','20080','20081','20082','20083','20084','20085','20086','20087','20088','20089','20090','20091','20092','20093','20094','20095','20096','20097','20098','20099','20100','20101','20102','20103','20104','20105','20106','20107','20108','20109','20110','20111','20112','20113','20114','20115','20116','20117','20118','20119','20120','20121','20122','20123','20124','20125','20126','20127','20128','20129','20130','20131','20132','20133','20134','20135','20136','20137','20138','20139','20140','20141','20142','20143','20144','20145','20146','20147','20148','20149','20150','20151','20152','20153','20154','20155','20156','20157','20158','20159','20160','20161','20162','20163','20164','20165','20166','20167','20168','20169','20170','20171','20172','20173','20174','20175','20176','20177','20178','20179','20180','20181','20182','20183','20184','20185','20186','20187','20188','20189','20190','20191','20192','20193','20194','20195','20196','20197','20198','20199','20200','20201','20202','20203','20204','20205','20206','20207','20208','20209','20210','20211','20212','20213','20214','20215','20216','20217','20218','20219','20220','20221','20222','20223','20224','20225','20226','20227','20228','20229','20230','20231','20232','20233','20234','20235','20236','20237','20238','20239','20240','20241','20242','20243','20244','20245','20246','20247','20248','20249','20250','20251','20252','20253','20254','20255','20256','20257','20258','20259','20260','20261','20262','20263','20264','20265','20266','20267','20268','20269','20270','20271','20272','20273','20274','20275','20276','20277','20278','20279','20280','20281','20282','20283','20284','20285','20286','20287','20288','20289','20290','20291','20292','20293','20294','20295','20296','20297','20298','20299','20300','20301','20302','20303','20304','20305','20306','20307','20308','20309','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','20342','20343','20344','20345','20346','20347','20348','20349','20350','20351','20352','20353','20354','20355','20356','20357','20358','20359','20360','20361','20362','20363','20364','20365','20366','20367','20368','20369','20370','20371','20372','20373','20374','20375','20376','20377','20378','20379','20380','20381','20382','20383','20384','20385','20386','20387','20388','20389','20390','20391','20392','20393','20394','20395','20396','20397','20398','20399','20400','20401','20402','20403','20404','20405','20406','20407','20408','20409','20410','20411','20412','20413','20414','20415','20416','20417','20418','20419','20420','20421','20422','20423','20424','20425','20426','20427','20428','20429','20430','20431','20432','20433','20434','20435','20436','20437','20438','20439','20440','20441','20442','20443','20444','20445','20446','20447','20448','20449','20450','20451','20452','20453','20454','20455','20456','20457','20458','20459','20460','20461','20462','20463','20464','20465','20466','20467','20468','20469','20470','20471','20472','20473','20474','20475','20476','20477','20478','20479','20480','20481','20482','20483','20484','20485','20486','20487','20488','20489','20490','20491','20492','20493','20494','20495','20496','20497','20498','20499','20500','20501','20502','20503','20504','20505','20506','20507','20508','20509','20510','20511','20512','20513','20514','20515','20516','20517','20518','20519','20520','20521','20522','20523','20524','20525','20526','20527','20528','20529','20530','20531','20532','20533','20534','20535','20536','20537','20538','20539','20540','20541','20542','20543','20544','20545','20546','20547','20548','20549','20550','20551','20552','20553','20554','20555','20556','20557','20558','28931') 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 = 34654) 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('28931') 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 = 257 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('31304','30594','30592','30591','30590','29999','29579','28855','28854','28853','1403') 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(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403))
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(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403)) 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(33371, 32128, 35763, 34654) 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` = 33371 AND `prints_set_vector`.`vector_id` IN(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403) 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` = 32128 AND `prints_set_vector`.`vector_id` IN(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403) 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` = 34654 AND `prints_set_vector`.`vector_id` IN(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403) 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` = 35763 AND `prints_set_vector`.`vector_id` IN(28931,31304,30594,30592,30591,30590,29999,29579,28855,28854,28853,1403) AND `prints_vector`.`bundle` = 0
SELECT `tag_id`, `vector_id` FROM tag_vector WHERE `vector_id`='20380'
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`='20380' 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`='20380' ORDER BY id DESC LIMIT 0, 1