/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`='27061'
SELECT `id`, `name`, `type` FROM nox_group
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `id`='44983'
UPDATE prints_vector SET views_count = views_count+1 WHERE id = 27061
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`='44983'
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 = 27061)
SELECT vector_id FROM prints_set_vector WHERE `set_id`='28803'
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('26382','26383','26384','26385','26386','26387','26388','26389','26390','26391','26392','26393','26394','26395','26396','26397','26398','26399','26400','26401','26402','26403','26404','26405','26406','26407','26408','26409','26410','26411','26412','26413','26414','26415','26416','26417','26418','26419','26420','26421','26422','26423','26424','26425','26426','26427','26428','26429','26430','26431','26432','26433','26434','26435','26436','26437','26438','26439','26440','26441','26442','26443','26444','26445','26446','26447','26448','26449','26450','26451','26452','26453','26454','26455','26456','26457','26458','26459','26460','26461','26462','26463','26464','26465','26466','26467','26468','26469','26470','26471','26472','26473','26474','26475','26476','26477','26478','26479','26480','26481','26482','26483','26484','26485','26486','26487','26488','26489','26490','26491','26492','26493','26494','26495','26496','26497','26498','26499','26500','26501','26502','26503','26504','26505','26506','26507','26508','26509','26510','26511','26512','26513','26514','26515','26516','26517','26518','26519','26520','26521','26522','26523','26524','26525','26526','26527','26528','26529','26530','26531','26532','26533','26534','26535','26536','26537','26538','26539','26540','26541','26542','26543','26544','26545','26546','26547','26548','26549','26550','26551','26552','26553','26554','26555','26556','26557','26558','26559','26560','26561','26562','26563','26564','26565','26566','26567','26568','26569','26570','26571','26572','26573','26574','26575','26576','26577','26578','26579','26580','26581','26582','26583','26584','26585','26586','26587','26588','26589','26590','26591','26592','26593','26594','26595','26596','26597','26598','26599','26600','26601','26602','26603','26604','26605','26606','26607','26608','26609','26610','26611','26612','26613','26614','26615','26616','26617','26618','26619','26620','26621','26622','26623','26624','26625','26626','26627','26628','26629','26630','26631','26632','26633','26634','26635','26636','26637','26638','26639','26640','26641','26642','26643','26644','26645','26646','26647','26648','26649','26650','26651','26652','26653','26654','26655','26656','26657','26658','26659','26660','26661','26662','26663','26664','26665','26666','26667','26668','26669','26670','26671','26672','26673','26674','26675','26676','26677','26678','26679','26680','26681','26682','26683','26684','26685','26686','26687','26688','26689','26690','26691','26692','26693','26694','26695','26696','26697','26698','26699','26700','26701','26702','26703','26704','26705','26706','26707','26708','26709','26710','26711','26712','26713','26714','26715','26716','26717','26718','26719','26720','26721','26722','26723','26724','26725','26726','26727','26728','26729','26730','26731','26732','26733','26734','26735','26736','26737','26738','26739','26740','26741','26742','26743','26744','26745','26746','26747','26748','26749','26750','26751','26752','26753','26754','26755','26756','26757','26758','26759','26760','26761','26762','26763','26764','26765','26766','26767','26768','26769','26770','26771','26772','26773','26774','26775','26776','26777','26778','26779','26780','26781','26782','26783','26784','26785','26786','26787','26788','26789','26790','26791','26792','26793','26794','26795','26796','26797','26798','26799','26800','26801','26802','26803','26804','26805','26806','26807','26808','26809','26810','26811','26812','26813','26814','26815','26816','26817','26818','26819','26820','26821','26822','26823','26824','26825','26826','26827','26828','26829','26830','26831','26832','26833','26834','26835','26836','26837','26838','26839','26840','26841','26842','26843','26844','26845','26846','26847','26848','26849','26850','26851','26852','26853','26854','26855','26856','26857','26858','26859','26860','26861','26862','26863','26864','26865','26866','26867','26868','26869','26870','26871','26872','26873','26874','26875','26876','26877','26878','26879','26880','26881','26882','26883','26884','26885','26886','26887','26888','26889','26890','26891','26892','26893','26894','26895','26896','26897','26898','26899','26900','26901','26902','26903','26904','26905','26906','26907','26908','26909','26910','26911','26912','26913','26914','26915','26916','26917','26918','26919','26920','26921','26922','26923','26924','26925','26926','26927','26928','26929','26930','26931','26932','26933','26934','26935','26936','26937','26938','26939','26940','26941','26942','26943','26944','26945','26946','26947','26948','26949','26950','26951','26952','26953','26954','26955','26956','26957','26958','26959','26960','26961','26962','26963','26964','26965','26966','26967','26968','26969','26970','26971','26972','26973','26974','26975','26976','26977','26978','26979','26980','26981','26982','26983','26984','26985','26986','26987','26988','26989','26990','26991','26992','26993','26994','26995','26996','26997','26998','26999','27000','27001','27002','27003','27004','27005','27006','27007','27008','27009','27010','27011','27012','27013','27014','27015','27016','27017','27018','27019','27020','27021','27022','27023','27024','27025','27026','27027','27028','27029','27030','27031','27032','27033','27034','27035','27036','27037','27038','27039','27040','27041','27042','27043','27044','27045','27046','27047','27048','27049','27050','27051','27052','27053','27054','27055','27056','27057','27058','27059','27060','27061','27062','27063','27064','27065','27066','27067','27068','27069','27070','27071','27072','27073','27074','27075','27076','27077','27078','27079','27080','27081','27082','27083','27084','27085','27086','27087','27088','27089','27090','27091','27092','27093','27094','27095','27096','27097','27098','27099','27100','27101','27102','27103','27104','27105','27106','27107','27108','27109','27110','27111','27112','27113','27114','27115','27116','27117','27118','27119','27120','27121','27122','27123','27124','27125','27126','27127','27128','27129','27130','27131','27132','27133','27134','27135','27136','27137','27138','27139','27140','27141','27142','27143','27144','27145','27146','27147','27148','27149','27150','27151','27152','27153','27154','27155','27156','27157','27158','27159','27160','27161','27162','27163','27164','27165','27166','27167','27168','27169','27170','27171','27172','27173','27174','27175','27176','27177','27178','27179','27180','27181','27182','27183','27184','27185','27186','27187','27188','27189','27190','27191','27192','27193','27194','27195','27196','27197','27198','27199','27200','27201','27202','27203','27204','27205','27206','27207','27208','27209','27210','27211','27212','27213','27214','27215','27216','27217','27218','27219','27220','27221','27222','27223','27224','27225','27226','27227','27228','27229','27230','27231','27232','27233','27234','27235','27236','27237','27238','27239','27240','27241','27242','27243','27244','27245','27246','27247','27248','27249','27250','27251','27252','27253','27254','27255','27256','27257','27258','27259','27260','27261','27262','27263','27264','27265','27266','27267','27268','27269','27270','27271','27272','27273','27274','27275','27276','27277','27278','27279','27280','27281','27282','27283','27284','27285','27286','27287','27288','27289','27290','27291','27292','27293','27294','27295','27296','27297','27298','27299','27300','27301','27302','27303','27304','27305','27306','27307','27308','27309','27310','27311','27312','27313','27314','27315','27316','27317','27318','27319','27320','27321','27322','27323','27324','27325','27326','27327','27328','27329','27330','27331','27332','27333','27334','27335','27336','27337','27338','27339','27340','27341','27342','27343','27344','27345','27346','27347','27348','27349','27350','27351','27352','27353','27354','27355','27356','27357','27358','27359','27360','27361','27362','27363','27364','27365','27366','27367','27368','27369','27370','27371','27372','27373','27374','27375','27376','27377','27378','27379','27380','27381','27382','27383','27384','27385','27386','27387','27388','27389','27390','27391','27392','27393','27394','27395','27396','27397','27398','27399','27400','27401','27402','27403','27404','27405','27406','27407','27408','27409','27410','27411','27412','27413','27414','27415','27416','27417','27418','27419','27420','27421','27422','27423','27424','27425','27426','27427','27428','27429','27430','27431','27432','27433','27434','27435','27436','27437','27438','27439','27440','27441','27442','27443','27444','27445','27446','27447','27448','27449','27450','27451','27452','27453','27454','27455','27456','27457','27458','27459','27460','27461','27462','27463','27464','27465','27466','27467','27468','27469','27470','27471','27472','27473','27474','27475','27476','27477','27478','27479','27480','27481','27482','27483','27484','27485','27486','27487','27488','27489','27490','27491','27492','27493','27494','27495','27496','27497','27498','27499','27500','27501','27502','27503','27504','27505','27506','27507','27508','27509','27510','27511','27512','27513','27514','27515','27516','27517','27518','27519','27520','27521','27522','27523','27524','27525','27526','27527','27528','27529','27530','27531','27532','27533','27534','27535','27536','27537','27538','27539','27540','27541','27542','27543','27544','27545','27546','27547','27548','27549','27550','27551','27552','27553','27554','27555','27556','27557','27558','27559','27560','27561','27562','27563','27564','27565','27566','27567','27568','27569','27570','27571','27572','27573','27574','27575','27576','27577','27578','27579','27580','27581','27582','27583','27584','27585','27586','27587','27588','27589','27590','27591','27592','27593','27594','27595','27596','27597','27598','27599','27600','27601','27602','27603','27604','27605','27606','27607','27608','27609','27610','27611','27612','27613','27614','27615','27616','27617','27618','27619','27620','27621','27622','27623','27624','27625','27626','27627','27628','27629','27630','27631','27632','27633','27634','27635','27636','27637','27638','27639','27640','27641','27642','27643','27644','27645','27646','27647','27648','27649','27650','27651','27652','27653','27654','27655','27656','27657','27658','27659','27660','27661','27662','27663','27664','27665','27666','27667','27668','27669','27670','27671','27672','27673','27674','27675','27676','27677','27678','27679','27680','27681','27682','27683','27684','27685','27686','27687','27688','27689','27690','27691','27692','27693','27694','27695','27696','27697','27698','27699','27700','27701','27702','27703','27704','27705','27706','27707','27708','27709','27710','27711','27712','27713','27714','27715','27716','27717','27718','27719','27720','27721','27722','27723','27724','27725','27726','27727','27728','27729','27730','27731','27732','27733','27734','27735','27736','27737','27738','27739','27740','27741','27742','27743','27744','27745','27746','27747','27748','27749','27750','27751','27752','27753','27754','27755','27756','27757','27758','27759','27760','27761','27762','27763','27764','27765','27766','27767','27768','27769','27770','27771','27772','27773','27774','27775','27776','27777','27778','27779','27780','27781','27782','27783','27784','27785','27786') 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 = 28803) 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('30531','369','367','356','274','268','267','244','242','192') 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,30531,369,367,356,274,268,267,244,242,192))
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,30531,369,367,356,274,268,267,244,242,192)) 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(35867, 34107, 36249, 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,30531,369,367,356,274,268,267,244,242,192) 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,30531,369,367,356,274,268,267,244,242,192) 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,30531,369,367,356,274,268,267,244,242,192) 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,30531,369,367,356,274,268,267,244,242,192) AND `prints_vector`.`bundle` = 0
SELECT `tag_id`, `vector_id` FROM tag_vector WHERE `vector_id`='27061'
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`='27061' 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`='27061' ORDER BY id DESC LIMIT 0, 1