20/10/2022 08:20:43 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fYwE9UJRLy61uc0y' , NOW() , NOW() ) 20/10/2022 08:20:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6997' , '1' ) 20/10/2022 08:20:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6997' , '2' ) 20/10/2022 08:20:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6997' , '3' ) 20/10/2022 08:22:11 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6997' 20/10/2022 08:22:11 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6997' , '10' , '226' , '' , 'PISTOLATO' , 'DINO' , 'VIA CHIESA 41' , '' , '30034' , 'GAMBARARE DI MIRA' , '' , '' , '3356247053' , '' , '' , NOW() , NOW() ) 20/10/2022 08:22:11 am >> UPDATE ps_customer SET email = 'gambarare@patriarcatovenezia.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6997' 20/10/2022 08:23:43 am >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 08:23:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '100' , '2022-10-20' , '' , '6997' , '0' , '88682007' , 'VIA CHIESA 41 30034 GAMBARARE DI MIRA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '78.15' , '78.15' , NOW() , NOW() ) 20/10/2022 08:23:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7918' 20/10/2022 08:23:43 am >> DELETE FROM ps_document_detail WHERE id_document = '7918' 20/10/2022 08:23:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7918' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '30' , '-30' , '4' , '2.50' , '2.5' , '0' , '5' , '71.25' ) 20/10/2022 08:29:51 am >> SELECT document_num FROM ps_document WHERE document_num = '189' AND id_document != '67972' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-19') 20/10/2022 08:29:51 am >> UPDATE ps_document SET id_document_type = '21', document_num = '189', document_date = '2022-10-19', document_letter = '', id_customer = '964', id_supplier = '', id_address = '4671035', address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '224.40', price_tax_excluded = '224.40', date_upd = NOW() WHERE id_document = '67972' 20/10/2022 08:29:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67972' 20/10/2022 08:29:51 am >> DELETE FROM ps_document_detail WHERE id_document = '67972' 20/10/2022 08:29:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67972' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '100' , '-100' , '4' , '2.4000' , '2.4' , '0' , '15' , '204.00' ) 20/10/2022 08:29:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 20/10/2022 08:29:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 20/10/2022 08:29:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67972' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '15' , '20.40' ) 20/10/2022 08:29:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 20/10/2022 08:29:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 20/10/2022 08:30:13 am >> SELECT document_num FROM ps_document WHERE document_num = '187' AND id_document != '67967' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-18') 20/10/2022 08:30:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '187', document_date = '2022-10-18', document_letter = '', id_customer = '75', id_supplier = '', id_address = '4669484', address1 = 'VIA STRETTOLA 84019 MARINA DI VIETRI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '107.95', price_tax_excluded = '107.95', date_upd = NOW() WHERE id_document = '67967' 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67967' 20/10/2022 08:30:13 am >> DELETE FROM ps_document_detail WHERE id_document = '67967' 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67967' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 20/10/2022 08:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 20/10/2022 08:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67967' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 20/10/2022 08:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 20/10/2022 08:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67967' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.4000' , '2.4' , '0' , '15' , '20.40' ) 20/10/2022 08:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 20/10/2022 08:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67967' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 20/10/2022 08:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 20/10/2022 08:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 20/10/2022 08:30:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67967' , '4120' , 'FEDE NELLO ZAINETTO' , '12' , '-12' , '4' , '5.0000' , '5' , '0' , '15' , '51.00' ) 20/10/2022 08:30:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 20/10/2022 08:30:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 20/10/2022 08:30:48 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ttPN3E2pFSVIqzBP' , NOW() , NOW() ) 20/10/2022 08:30:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3943' , '1' ) 20/10/2022 08:30:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3943' , '2' ) 20/10/2022 08:30:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3943' , '3' ) 20/10/2022 08:32:07 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3943' 20/10/2022 08:32:07 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3943' , '10' , '158' , '' , 'CIRELLI' , 'FABRIZIO' , 'SS 89 KM 175,800 , snc ' , '' , '71043' , 'MANFREDONIA' , '' , '' , '3926555821' , '' , '' , NOW() , NOW() ) 20/10/2022 08:32:07 am >> UPDATE ps_customer SET email = 'fabriziocirelli@icloud.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3943' 20/10/2022 08:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '7917' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-19') 20/10/2022 08:35:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12', document_date = '2022-10-19', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '925.00', price_tax_excluded = '925.00', date_upd = NOW() WHERE id_document = '7917' 20/10/2022 08:35:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7917' 20/10/2022 08:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '7917' 20/10/2022 08:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7917' , '115' , 'SAN FRANCESCO D\'ASSISI RACCONTATO AI RAGAZZI N.E.' , '150' , '-150' , '4' , '4.0000' , '4' , '0' , '0' , '600.00' ) 20/10/2022 08:35:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '115' AND id_supplier = '' 20/10/2022 08:35:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '115' , '' , '1' ) 20/10/2022 08:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7917' , '17' , 'LA FEDE NELLO ZAINETTO' , '65' , '-65' , '4' , '5.0000' , '5' , '0' , '0' , '325.00' ) 20/10/2022 08:35:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 20/10/2022 08:35:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 20/10/2022 08:37:38 am >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 08:37:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '192' , '2022-10-20' , '' , '3943' , '0' , '4676033' , 'SS 89 KM 175,800 , snc 71043 MANFREDONIA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '43.49' , '43.49' , NOW() , NOW() ) 20/10/2022 08:37:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 08:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 08:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:37:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:37:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:37:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:37:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:38:14 am >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '67987' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 08:38:14 am >> UPDATE ps_document SET id_document_type = '21', document_num = '192', document_date = '2022-10-20', document_letter = '', id_customer = '3943', id_supplier = '', id_address = '4676033', address1 = 'SS 89 KM 175,800 , snc 71043 MANFREDONIA', address2 = '', note = 'IN ATTESA DI BONIFICO', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '43.49', price_tax_excluded = '43.49', date_upd = NOW() WHERE id_document = '67987' 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 08:38:14 am >> DELETE FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:38:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 20/10/2022 08:38:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:38:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 20/10/2022 08:38:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:38:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 20/10/2022 08:38:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:38:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 20/10/2022 08:38:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 20/10/2022 08:38:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 08:38:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 20/10/2022 08:38:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 20/10/2022 08:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 08:38:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/10/2022 08:38:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/10/2022 08:49:26 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2022 08:49:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20188' , '1' , '' , 'nuovo-prodotto' ) 20/10/2022 08:49:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20188' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2022 08:49:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20188' , '0' , '1' , '0' , '0' ) 20/10/2022 08:50:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924094' AND id_product != '20188' AND ean13 != '' 20/10/2022 08:50:51 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839924094', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:50:51 am >> UPDATE ps_product_lang SET name = 'penitenza e unzione dei malati - a. maffeis', description = '' WHERE id_product = '20188' 20/10/2022 08:50:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32' WHERE id_product = '20188' 20/10/2022 08:50:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:50:51 am >> DELETE FROM ps_specific_price WHERE id_product = '20188' 20/10/2022 08:51:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924094' AND id_product != '20188' AND ean13 != '' 20/10/2022 08:51:23 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839924094', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:51:23 am >> UPDATE ps_product_lang SET name = 'penitenza e unzione dei malati - a. maffeis', description = '' WHERE id_product = '20188' 20/10/2022 08:51:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32' WHERE id_product = '20188' 20/10/2022 08:51:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:51:23 am >> DELETE FROM ps_specific_price WHERE id_product = '20188' 20/10/2022 08:51:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924094' AND id_product != '20188' AND ean13 != '' 20/10/2022 08:51:54 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839924094', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:51:54 am >> UPDATE ps_product_lang SET name = 'PENITENZA E UNZIONE DEI MALATI - A. MAFFEIS', description = '' WHERE id_product = '20188' 20/10/2022 08:51:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.0000' WHERE id_product = '20188' 20/10/2022 08:51:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20188' 20/10/2022 08:51:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20188' 20/10/2022 08:52:46 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2022 08:52:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20189' , '1' , '' , 'nuovo-prodotto' ) 20/10/2022 08:52:46 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20189' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2022 08:52:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20189' , '0' , '1' , '0' , '0' ) 20/10/2022 08:55:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259751768' AND id_product != '20189' AND ean13 != '' 20/10/2022 08:55:31 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9791259751768', date_upd = NOW() WHERE id_product = '20189' 20/10/2022 08:55:31 am >> UPDATE ps_product_lang SET name = 'VOCAZIONE ALL\'AMORE - F. APRILE', description = '' WHERE id_product = '20189' 20/10/2022 08:55:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20189' 20/10/2022 08:55:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20189' 20/10/2022 08:55:31 am >> DELETE FROM ps_specific_price WHERE id_product = '20189' 20/10/2022 08:56:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259751768' AND id_product != '20189' AND ean13 != '' 20/10/2022 08:56:05 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9791259751768', date_upd = NOW() WHERE id_product = '20189' 20/10/2022 08:56:05 am >> UPDATE ps_product_lang SET name = 'VOCAZIONE ALL\'AMORE - F. APRILE', description = '' WHERE id_product = '20189' 20/10/2022 08:56:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0000' WHERE id_product = '20189' 20/10/2022 08:56:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0000', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '245', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20189' 20/10/2022 08:56:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20189' 20/10/2022 08:57:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '611923' , '2022-10-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '6.29' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '215.85' , '215.85' , NOW() , NOW() ) 20/10/2022 08:57:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67988' 20/10/2022 08:57:10 am >> DELETE FROM ps_document_detail WHERE id_document = '67988' 20/10/2022 08:57:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '18666' , 'SCOPRIAMO LA BIBBIA' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 20/10/2022 08:57:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18666' AND id_supplier = '7' 20/10/2022 08:57:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18666' , '7' , '1' ) 20/10/2022 08:57:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 20/10/2022 08:57:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '3' , '3' , '4' , '12.00' , '12' , '0' , '35+7' , '21.7620' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '20188' , 'PENITENZA E UNZIONE DEI MALATI - A. MAFFEIS' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20188' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20188' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '11096' , 'VANGELO E ATTI DEGLI AP. INTERLINEARE' , '2' , '2' , '4' , '32.50' , '32.5' , '0' , '33' , '43.5500' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11096' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11096' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' , '1' , '4' , '85.00' , '85' , '0' , '33' , '56.9500' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7186' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7186' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '20189' , 'VOCAZIONE ALLAMORE - F. APRILE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20189' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20189' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '3' , '3' , '4' , '12.00' , '12' , '0' , '33' , '24.1200' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '12895' , 'PASSI VERSO LA CRESIMA' , '2' , '2' , '4' , '7.90' , '7.9' , '0' , '35' , '10.2700' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '7' , '1' ) 20/10/2022 08:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67988' , '4168' , 'FIGLI DEL VENTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 20/10/2022 08:57:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '4168' AND id_supplier = '7' 20/10/2022 08:57:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4168' , '7' , '1' ) 20/10/2022 09:02:06 am >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '67987' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 09:02:06 am >> UPDATE ps_document SET id_document_type = '21', document_num = '192', document_date = '2022-10-20', document_letter = '', id_customer = '3943', id_supplier = '', id_address = '4676033', address1 = 'SS 89 KM 175,800 , snc 71043 MANFREDONIA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '43.49', price_tax_excluded = '43.49', date_upd = NOW() WHERE id_document = '67987' 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 09:02:06 am >> DELETE FROM ps_document_detail WHERE id_document = '67987' 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 20/10/2022 09:02:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67987' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 09:02:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/10/2022 09:02:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/10/2022 09:51:19 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 20/10/2022 09:51:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '243.19', price_tax_excluded = '216.55', date_upd = NOW() WHERE id_document = '61817' 20/10/2022 09:51:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 09:51:19 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 09:51:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 09:51:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 20/10/2022 09:51:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 09:51:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/10/2022 09:51:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/10/2022 09:51:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 20/10/2022 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 20/10/2022 09:51:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 20/10/2022 09:51:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 20/10/2022 10:09:39 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 20/10/2022 10:09:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '270.99', price_tax_excluded = '239.34', date_upd = NOW() WHERE id_document = '61817' 20/10/2022 10:09:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 10:09:39 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 10:09:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 10:09:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 20/10/2022 10:09:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 20/10/2022 10:09:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 20/10/2022 10:09:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 20/10/2022 10:09:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 20/10/2022 10:09:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 20/10/2022 10:09:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '20.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 10:09:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 20/10/2022 10:09:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/10/2022 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 10:09:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 20/10/2022 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 10:09:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 20/10/2022 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 20/10/2022 10:09:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 20/10/2022 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '10' , '-10' , '1' , '1' , '0.81967213114754' , '22' , '0' , '10.00' ) 20/10/2022 10:09:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 20/10/2022 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '7.80' ) 20/10/2022 10:09:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 10:09:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 10:10:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 10:10:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3112' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 20/10/2022 10:10:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67989' 20/10/2022 10:10:03 am >> DELETE FROM ps_document_detail WHERE id_document = '67989' 20/10/2022 10:10:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67989' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 20/10/2022 10:10:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 20/10/2022 10:10:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 20/10/2022 10:36:15 am >> SELECT document_num FROM ps_document WHERE document_num = '77/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 10:36:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '77/A' , '2022-10-20' , 'A' , '292' , '0' , '4671062' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1571.00' , '1571.00' , NOW() , NOW() ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67990' 20/10/2022 10:36:16 am >> DELETE FROM ps_document_detail WHERE id_document = '67990' 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '-6' , '4' , '13.5' , '13.5' , '0' , '0' , '81.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '-8' , '4' , '13.5' , '13.5' , '0' , '0' , '108.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '-2' , '4' , '13.5' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '-2' , '4' , '13.5' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '-2' , '4' , '13.5' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '55' , '-55' , '4' , '4.5' , '4.5' , '0' , '0' , '247.50' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5' , '4.5' , '0' , '0' , '315.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '10' , '-10' , '4' , '4.5' , '4.5' , '0' , '0' , '45.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5' , '4.5' , '0' , '0' , '112.50' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '30' , '-30' , '4' , '4.5' , '4.5' , '0' , '0' , '135.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '14530' , 'PANE E VINO - GUIDA 3' , '8' , '-8' , '4' , '13.5' , '13.5' , '0' , '0' , '108.00' ) 20/10/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '60' , '-60' , '4' , '4.5' , '4.5' , '0' , '0' , '270.00' ) 20/10/2022 10:40:37 am >> SELECT document_num FROM ps_document WHERE document_num = '77/A' AND id_document != '67990' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 10:40:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '77/A', document_date = '2022-10-20', document_letter = 'A', id_customer = '292', id_supplier = '', id_address = '4671062', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1571.00', price_tax_excluded = '1571.00', date_upd = NOW() WHERE id_document = '67990' 20/10/2022 10:40:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67990' 20/10/2022 10:40:37 am >> DELETE FROM ps_document_detail WHERE id_document = '67990' 20/10/2022 10:40:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '0' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 20/10/2022 10:40:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '81.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '15927' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15927' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '55' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '247.50' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '10' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '45.00' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '' , '1' ) 20/10/2022 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 20/10/2022 10:40:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '' 20/10/2022 10:40:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '' , '1' ) 20/10/2022 10:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '30' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '135.00' ) 20/10/2022 10:40:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '' 20/10/2022 10:40:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '' , '1' ) 20/10/2022 10:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '14530' , 'PANE E VINO - GUIDA 3' , '8' , '0' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 20/10/2022 10:40:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '' 20/10/2022 10:40:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '' , '1' ) 20/10/2022 10:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67990' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '60' , '0' , '4' , '4.5000' , '4.5' , '0' , '0' , '270.00' ) 20/10/2022 10:40:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 20/10/2022 10:40:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 20/10/2022 10:56:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 10:56:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3113' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 20/10/2022 10:56:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67991' 20/10/2022 10:56:14 am >> DELETE FROM ps_document_detail WHERE id_document = '67991' 20/10/2022 10:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67991' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 20/10/2022 10:56:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/10/2022 10:56:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/10/2022 11:07:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:07:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3114' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 20/10/2022 11:07:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67992' 20/10/2022 11:07:08 am >> DELETE FROM ps_document_detail WHERE id_document = '67992' 20/10/2022 11:07:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67992' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 20/10/2022 11:07:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 20/10/2022 11:07:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 20/10/2022 11:27:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:27:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3115' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 20/10/2022 11:27:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67993' 20/10/2022 11:27:23 am >> DELETE FROM ps_document_detail WHERE id_document = '67993' 20/10/2022 11:27:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67993' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '7.00' , '7' , '0' , '5' , '13.30' ) 20/10/2022 11:27:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 20/10/2022 11:27:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 20/10/2022 11:27:59 am >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:27:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '78/A' , '2022-10-20' , 'A' , '1148' , '0' , '1148' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.20' , '59.20' , NOW() , NOW() ) 20/10/2022 11:27:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67994' 20/10/2022 11:27:59 am >> DELETE FROM ps_document_detail WHERE id_document = '67994' 20/10/2022 11:27:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67994' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '4' , '-4' , '4' , '14.80' , '14.8' , '0' , '0' , '59.20' ) 20/10/2022 11:30:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:30:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3116' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.20' , '95.09' , NOW() , NOW() ) 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67995' 20/10/2022 11:30:41 am >> DELETE FROM ps_document_detail WHERE id_document = '67995' 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67995' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/10/2022 11:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18962' AND id_supplier = '' 20/10/2022 11:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18962' , '' , '1' ) 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67995' , '19693' , 'CALENDARIO LITURGICO 2023' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 20/10/2022 11:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 20/10/2022 11:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67995' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/10/2022 11:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 20/10/2022 11:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67995' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 20/10/2022 11:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 20/10/2022 11:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 20/10/2022 11:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67995' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.56' , '0.56' , '0' , '0' , '19.60' ) 20/10/2022 11:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/10/2022 11:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/10/2022 11:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:31:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3117' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 20/10/2022 11:31:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67996' 20/10/2022 11:31:00 am >> DELETE FROM ps_document_detail WHERE id_document = '67996' 20/10/2022 11:31:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67996' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '4' , '-4' , '4' , '5' , '5' , '0' , '5' , '19.00' ) 20/10/2022 11:31:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 20/10/2022 11:31:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 20/10/2022 11:32:19 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 20/10/2022 11:32:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '273.49', price_tax_excluded = '241.39', date_upd = NOW() WHERE id_document = '61817' 20/10/2022 11:32:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 11:32:19 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 11:32:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 11:32:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 20/10/2022 11:32:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 20/10/2022 11:32:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '20.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/10/2022 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 20/10/2022 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '7.80' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 20/10/2022 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 20/10/2022 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 20/10/2022 11:41:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2022 11:41:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20190' , '1' , '' , 'nuovo-prodotto' ) 20/10/2022 11:41:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20190' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2022 11:41:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20190' , '0' , '1' , '0' , '0' ) 20/10/2022 11:42:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898577217' AND id_product != '20190' AND ean13 != '' 20/10/2022 11:42:38 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788898577217', date_upd = NOW() WHERE id_product = '20190' 20/10/2022 11:42:38 am >> UPDATE ps_product_lang SET name = 'MISTERO MARIANO NEL MISTERO TRINITARIO', description = '' WHERE id_product = '20190' 20/10/2022 11:42:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '20190' 20/10/2022 11:42:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '469', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20190' 20/10/2022 11:42:38 am >> DELETE FROM ps_specific_price WHERE id_product = '20190' 20/10/2022 11:43:06 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2022 11:43:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20191' , '1' , '' , 'nuovo-prodotto' ) 20/10/2022 11:43:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20191' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2022 11:43:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20191' , '0' , '1' , '0' , '0' ) 20/10/2022 11:46:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:46:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3118' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/10/2022 11:46:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67997' 20/10/2022 11:46:19 am >> DELETE FROM ps_document_detail WHERE id_document = '67997' 20/10/2022 11:46:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67997' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 11:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 20/10/2022 11:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 20/10/2022 11:50:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883335716' AND id_product != '20191' AND ean13 != '' 20/10/2022 11:50:21 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788883335716', date_upd = NOW() WHERE id_product = '20191' 20/10/2022 11:50:21 am >> UPDATE ps_product_lang SET name = 'LITURGIA UN\'INTRODUZIONE', description = '' WHERE id_product = '20191' 20/10/2022 11:50:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20191' 20/10/2022 11:50:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '272', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20191' 20/10/2022 11:50:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20191' 20/10/2022 11:50:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883335716' AND id_product != '20191' AND ean13 != '' 20/10/2022 11:50:37 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788883335716', date_upd = NOW() WHERE id_product = '20191' 20/10/2022 11:50:37 am >> UPDATE ps_product_lang SET name = 'LITURGIA UN\'INTRODUZIONE', description = '' WHERE id_product = '20191' 20/10/2022 11:50:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20191' 20/10/2022 11:50:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20191' 20/10/2022 11:50:37 am >> DELETE FROM ps_specific_price WHERE id_product = '20191' 20/10/2022 11:54:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2022000005705' , '2022-10-19' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '115.98' , '115.98' , NOW() , NOW() ) 20/10/2022 11:54:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67998' 20/10/2022 11:54:33 am >> DELETE FROM ps_document_detail WHERE id_document = '67998' 20/10/2022 11:54:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67998' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35' , '15.6000' ) 20/10/2022 11:54:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20139' AND id_supplier = '107' 20/10/2022 11:54:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20139' , '107' , '1' ) 20/10/2022 11:54:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67998' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '2' , '2' , '4' , '30.00' , '30' , '0' , '35' , '39.0000' ) 20/10/2022 11:54:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 20/10/2022 11:54:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 20/10/2022 11:54:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67998' , '20191' , 'LITURGIA UNINTRODUZIONE' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35' , '19.5000' ) 20/10/2022 11:54:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20191' AND id_supplier = '107' 20/10/2022 11:54:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20191' , '107' , '1' ) 20/10/2022 11:54:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67998' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '46' , '46' , '4' , '1.20' , '1.2' , '0' , '35' , '35.8800' ) 20/10/2022 11:54:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 20/10/2022 11:54:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 20/10/2022 11:55:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 11:55:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3119' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 20/10/2022 11:55:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67999' 20/10/2022 11:55:11 am >> DELETE FROM ps_document_detail WHERE id_document = '67999' 20/10/2022 11:55:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67999' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '13.20' ) 20/10/2022 11:55:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 20/10/2022 11:55:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 20/10/2022 11:56:14 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 20/10/2022 11:56:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '283.49', price_tax_excluded = '249.59', date_upd = NOW() WHERE id_document = '61817' 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 11:56:14 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 11:56:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 20/10/2022 11:56:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 20/10/2022 11:56:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 20/10/2022 11:56:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 20/10/2022 11:56:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 11:56:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/10/2022 11:56:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 20/10/2022 11:56:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 20/10/2022 11:56:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '20.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 20/10/2022 11:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 20/10/2022 11:56:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 20/10/2022 11:56:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 20/10/2022 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 20/10/2022 11:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 20/10/2022 11:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 20/10/2022 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '7.80' ) 20/10/2022 11:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 20/10/2022 11:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 20/10/2022 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 20/10/2022 11:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 20/10/2022 11:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 20/10/2022 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 11:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20171' AND id_supplier = '' 20/10/2022 11:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20171' , '' , '1' ) 20/10/2022 12:02:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '31' AND id_document != '67976' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-19') 20/10/2022 12:02:16 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '31', document_date = '2022-10-19', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '3', price_tax_included = '10124.00', price_tax_excluded = '10124.00', date_upd = NOW() WHERE id_document = '67976' 20/10/2022 12:02:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67976' 20/10/2022 12:02:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '67976' 20/10/2022 12:02:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '960' , '-960' , '4' , '2.4000' , '2.4' , '0' , '0' , '2304.00' ) 20/10/2022 12:02:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 20/10/2022 12:02:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 20/10/2022 12:02:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '9675' , 'SARETE MIEI TESTIMONI' , '800' , '-800' , '4' , '3.0000' , '3' , '0' , '0' , '2400.00' ) 20/10/2022 12:02:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 20/10/2022 12:02:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 20/10/2022 12:02:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '4154' , 'FESTA DEL PERDONO' , '840' , '-840' , '4' , '3.0000' , '3' , '0' , '0' , '2520.00' ) 20/10/2022 12:02:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 20/10/2022 12:02:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 20/10/2022 12:02:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '2679' , 'CONOSCERE GESU\'' , '600' , '-600' , '4' , '3.5000' , '3.5' , '0' , '' , '2100.00' ) 20/10/2022 12:02:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 20/10/2022 12:02:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 20/10/2022 12:02:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '100' , '-100' , '4' , '5.0000' , '5' , '0' , '0' , '500.00' ) 20/10/2022 12:02:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11097' AND id_supplier = '' 20/10/2022 12:02:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11097' , '' , '1' ) 20/10/2022 12:02:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67976' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '50' , '-50' , '4' , '6.0000' , '6' , '0' , '0' , '300.00' ) 20/10/2022 12:02:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 20/10/2022 12:02:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 20/10/2022 12:24:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245471' AND id_product != '10748' AND ean13 != '' 20/10/2022 12:24:13 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861245471', date_upd = NOW() WHERE id_product = '10748' 20/10/2022 12:24:13 pm >> UPDATE ps_product_lang SET name = 'TU MI CHIAMI PER NOME', description = '' WHERE id_product = '10748' 20/10/2022 12:24:13 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '5.9' WHERE id_product = '10748' 20/10/2022 12:24:13 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '5.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10748' 20/10/2022 12:24:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '10748' 20/10/2022 12:24:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246362' AND id_product != '16129' AND ean13 != '' 20/10/2022 12:24:38 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861246362', date_upd = NOW() WHERE id_product = '16129' 20/10/2022 12:24:38 pm >> UPDATE ps_product_lang SET name = 'TU MI DONI IL TUO SPIRITO', description = '' WHERE id_product = '16129' 20/10/2022 12:24:38 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '5.9' WHERE id_product = '16129' 20/10/2022 12:24:38 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '5.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16129' 20/10/2022 12:24:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '16129' 20/10/2022 12:27:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 12:27:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3120' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.22' , '97.32' , NOW() , NOW() ) 20/10/2022 12:27:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68000' 20/10/2022 12:27:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '68000' 20/10/2022 12:27:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 20/10/2022 12:27:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '' 20/10/2022 12:27:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '' , '1' ) 20/10/2022 12:27:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16129' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16129' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 20/10/2022 12:27:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 12:27:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 20/10/2022 12:27:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 20/10/2022 12:27:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 12:27:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 20/10/2022 12:27:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 20/10/2022 12:27:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 20/10/2022 12:27:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 20/10/2022 12:27:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 20/10/2022 12:27:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68000' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 20/10/2022 12:27:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 20/10/2022 12:27:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 20/10/2022 12:33:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 12:33:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3121' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.55' , '38.55' , NOW() , NOW() ) 20/10/2022 12:33:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68001' 20/10/2022 12:33:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '68001' 20/10/2022 12:33:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68001' , '18750' , 'SONO STATA ALLE PORTE DEL CIELO E DELLINFERNO - G. POLO' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '0' , '19.00' ) 20/10/2022 12:33:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18750' AND id_supplier = '' 20/10/2022 12:33:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18750' , '' , '1' ) 20/10/2022 12:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68001' , '7125' , 'NOVENA E CORONCINA ALLANGELO RAFFAELE - 8262' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 20/10/2022 12:33:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7125' AND id_supplier = '' 20/10/2022 12:33:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7125' , '' , '1' ) 20/10/2022 12:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68001' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 20/10/2022 12:33:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 20/10/2022 12:33:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 20/10/2022 12:46:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 12:46:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3122' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 20/10/2022 12:46:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68002' 20/10/2022 12:46:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '68002' 20/10/2022 12:46:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68002' , '20054' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 20/10/2022 12:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 20/10/2022 12:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 20/10/2022 01:00:23 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/10/2022 01:00:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20192' , '1' , '' , 'nuovo-prodotto' ) 20/10/2022 01:00:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20192' , '1' , '1' , '2' , NOW() , NOW() ) 20/10/2022 01:00:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20192' , '0' , '1' , '0' , '0' ) 20/10/2022 01:01:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856686463' AND id_product != '20192' AND ean13 != '' 20/10/2022 01:01:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788856686463', date_upd = NOW() WHERE id_product = '20192' 20/10/2022 01:01:36 pm >> UPDATE ps_product_lang SET name = 'VI CHIEDO IN NOME DI DIO', description = '' WHERE id_product = '20192' 20/10/2022 01:01:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '20192' 20/10/2022 01:01:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20192' 20/10/2022 01:01:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '20192' 20/10/2022 01:02:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '5371' , '2022-10-18' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.67' , '99.67' , NOW() , NOW() ) 20/10/2022 01:02:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68003' 20/10/2022 01:02:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '68003' 20/10/2022 01:02:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68003' , '20192' , 'VI CHIEDO IN NOME DI DIO' , '2' , '2' , '4' , '16.90' , '16.9' , '0' , '27' , '24.6740' ) 20/10/2022 01:02:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20192' AND id_supplier = '47' 20/10/2022 01:02:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20192' , '47' , '1' ) 20/10/2022 01:02:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68003' , '7221' , 'OLTRE IL RELATIVISMO - F. CORALLUZZO' , '5' , '5' , '4' , '20.00' , '20' , '0' , '30' , '70.0000' ) 20/10/2022 01:02:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7221' AND id_supplier = '47' 20/10/2022 01:02:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7221' , '47' , '1' ) 20/10/2022 02:33:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '79/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 02:33:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '79/A' , '2022-10-20' , 'A' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.00' , '116.00' , NOW() , NOW() ) 20/10/2022 02:33:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68004' 20/10/2022 02:33:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '68004' 20/10/2022 02:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68004' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '3' , '-3' , '4' , '12.00' , '12' , '0' , '0' , '36.00' ) 20/10/2022 02:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68004' , '7221' , 'OLTRE IL RELATIVISMO - F. CORALLUZZO' , '4' , '-4' , '4' , '20.00' , '20' , '0' , '0' , '80.00' ) 20/10/2022 02:38:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872984666' AND id_product != '20054' AND ean13 != '' 20/10/2022 02:38:32 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/2', ean13 = '9788872984666', date_upd = NOW() WHERE id_product = '20054' 20/10/2022 02:38:32 pm >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23', description = '' WHERE id_product = '20054' 20/10/2022 02:38:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '20054' 20/10/2022 02:38:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20054' 20/10/2022 02:38:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20054' 20/10/2022 03:01:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:01:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3123' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.00' , '77.05' , NOW() , NOW() ) 20/10/2022 03:01:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68005' 20/10/2022 03:01:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '68005' 20/10/2022 03:01:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68005' , '16121' , 'CLERGY GRIGIO JEANS - XXL' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 20/10/2022 03:01:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16121' AND id_supplier = '' 20/10/2022 03:01:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16121' , '' , '1' ) 20/10/2022 03:01:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68005' , '13526' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 45' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 20/10/2022 03:01:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13526' AND id_supplier = '' 20/10/2022 03:01:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13526' , '' , '1' ) 20/10/2022 03:13:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:13:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3124' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 20/10/2022 03:13:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68006' 20/10/2022 03:13:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '68006' 20/10/2022 03:13:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68006' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 20/10/2022 03:13:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '' 20/10/2022 03:13:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '' , '1' ) 20/10/2022 03:15:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '357' 20/10/2022 03:15:03 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '357' , '10' , '210' , 'PARROCCHIA S. MARIA AD MARTIRES' , 'TERRASI' , 'P. GIORGIO' , 'VIA TORRIONE' , '' , '84100' , 'SALERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 20/10/2022 03:15:03 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '357' 20/10/2022 03:16:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '80/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:16:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '80/A' , '2022-10-20' , 'A' , '357' , '0' , '4675734' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '44.00' , NOW() , NOW() ) 20/10/2022 03:16:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68007' 20/10/2022 03:16:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '68007' 20/10/2022 03:16:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '5' , '-5' , '4' , '1.20' , '1.2' , '0' , '0' , '6.00' ) 20/10/2022 03:16:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17014' , 'COME GIOISCE LO SPOSO ... - GUIDA - S. MURATORE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 20/10/2022 03:16:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68007' , '17015' , 'COME GIOISCE LO SPOSO ... - SUSSIDIO - S. MURATORE' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 20/10/2022 03:37:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:37:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3125' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.68' , '79.53' , NOW() , NOW() ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68008' 20/10/2022 03:37:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '68008' 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '5108' , 'SAN GIOVANNI PAOLO II - 366' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5108' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5108' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '9' , '-9' , '4' , '1.00' , '1' , '0' , '0' , '9.00' ) 20/10/2022 03:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 20/10/2022 03:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 20/10/2022 03:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 20/10/2022 03:37:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 20/10/2022 03:37:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 20/10/2022 03:37:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '8469' , 'PRETE UNO SPOSO - BONETTI/PEDROLI' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '5' , '11.31' ) 20/10/2022 03:37:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8469' AND id_supplier = '' 20/10/2022 03:37:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8469' , '' , '1' ) 20/10/2022 03:37:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 20/10/2022 03:37:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 20/10/2022 03:37:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 20/10/2022 03:37:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '6' , '-6' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.90' ) 20/10/2022 03:37:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 20/10/2022 03:37:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 20/10/2022 03:37:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/10/2022 03:37:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 20/10/2022 03:37:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 20/10/2022 03:44:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3125' AND id_document != '68008' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:44:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3125', document_date = '2022-10-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '31.86', price_tax_excluded = '31.51', date_upd = NOW() WHERE id_document = '68008' 20/10/2022 03:44:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68008' 20/10/2022 03:44:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '68008' 20/10/2022 03:44:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/10/2022 03:44:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 20/10/2022 03:44:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 20/10/2022 03:44:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:44:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 20/10/2022 03:44:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 20/10/2022 03:44:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:44:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 20/10/2022 03:44:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 20/10/2022 03:44:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 20/10/2022 03:44:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/10/2022 03:45:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 20/10/2022 03:45:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 20/10/2022 03:45:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '8469' , 'PRETE UNO SPOSO - BONETTI/PEDROLI' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '5' , '11.31' ) 20/10/2022 03:45:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8469' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8469' , '' , '1' ) 20/10/2022 03:45:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 20/10/2022 03:45:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 20/10/2022 03:45:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '6' , '-6' , '1' , '0.16' , '0.13114754098361' , '22' , '0' , '0.96' ) 20/10/2022 03:45:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 20/10/2022 03:45:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68008' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/10/2022 03:45:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 20/10/2022 03:45:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 20/10/2022 03:45:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3084' AND id_document != '67943' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-18') 20/10/2022 03:45:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3084', document_date = '2022-10-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.70', price_tax_excluded = '26.86', date_upd = NOW() WHERE id_document = '67943' 20/10/2022 03:45:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67943' 20/10/2022 03:45:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '67943' 20/10/2022 03:45:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67943' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '3.30' ) 20/10/2022 03:45:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 20/10/2022 03:45:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 20/10/2022 03:45:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67943' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 20/10/2022 03:45:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 20/10/2022 03:45:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 20/10/2022 03:45:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67943' , '9457' , 'S. GIOVANNI XXIII - S. GIOVANNI PAOLO II - 414 ' , '2' , '-2' , '1' , '3.45' , '2.827868852459' , '22' , '0' , '6.90' ) 20/10/2022 03:45:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9457' AND id_supplier = '' 20/10/2022 03:45:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9457' , '' , '1' ) 20/10/2022 03:56:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 03:56:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3126' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.50' , '22.86' , NOW() , NOW() ) 20/10/2022 03:56:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68009' 20/10/2022 03:56:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '68009' 20/10/2022 03:56:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68009' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 20/10/2022 03:56:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 20/10/2022 03:56:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 20/10/2022 03:56:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68009' , '10475' , 'TEALIGHTS X 50 ' , '5' , '-5' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '18.50' ) 20/10/2022 03:56:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10475' AND id_supplier = '' 20/10/2022 03:56:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10475' , '' , '1' ) 20/10/2022 04:00:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 04:00:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3127' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.50' , '35.66' , NOW() , NOW() ) 20/10/2022 04:00:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68010' 20/10/2022 04:00:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '68010' 20/10/2022 04:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68010' , '18554' , 'MADONNA ROSARIO BABY - 023 MDR/9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/10/2022 04:00:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18554' AND id_supplier = '' 20/10/2022 04:00:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18554' , '' , '1' ) 20/10/2022 04:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68010' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 20/10/2022 04:00:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 20/10/2022 04:00:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 20/10/2022 04:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68010' , '9209' , 'S. FAMIGLIA BABY - 023 HF/9 BB' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 20/10/2022 04:00:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9209' AND id_supplier = '' 20/10/2022 04:00:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9209' , '' , '1' ) 20/10/2022 04:27:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '81/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 04:27:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '81/A' , '2022-10-20' , 'A' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '395.10' , '327.15' , NOW() , NOW() ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68011' 20/10/2022 04:27:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '68011' 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '' , 'OSTIE' , '3' , '-3' , '0' , '2.3' , '2.3' , '' , '0' , '6.90' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '' , 'PARTICOLE' , '3' , '-3' , '0' , '3.8' , '3.8' , '' , '0' , '11.40' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 20/10/2022 04:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68011' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 20/10/2022 04:29:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 04:29:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3128' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 20/10/2022 04:29:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68012' 20/10/2022 04:29:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '68012' 20/10/2022 04:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68012' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 20/10/2022 04:29:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 20/10/2022 04:29:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 20/10/2022 04:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 04:38:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3129' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 20/10/2022 04:38:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68013' 20/10/2022 04:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '68013' 20/10/2022 04:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68013' , '6811' , 'MOCCOLO 80X200' , '5' , '-5' , '1' , '8' , '6.5573770491803' , '22' , '0' , '40.00' ) 20/10/2022 04:38:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 20/10/2022 04:38:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 20/10/2022 05:09:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 05:09:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '193' , '2022-10-20' , '' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.88' , '116.88' , NOW() , NOW() ) 20/10/2022 05:09:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68014' 20/10/2022 05:09:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '68014' 20/10/2022 05:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68014' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 20/10/2022 05:09:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68014' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 20/10/2022 06:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 06:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3130' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/10/2022 06:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68015' 20/10/2022 06:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '68015' 20/10/2022 06:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68015' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/10/2022 06:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 20/10/2022 06:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 20/10/2022 06:03:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 06:03:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '41/E' , '2022-10-20' , 'E' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '14.5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '340.00' , '340.00' , NOW() , NOW() ) 20/10/2022 06:03:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68016' 20/10/2022 06:03:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '68016' 20/10/2022 06:03:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:03:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:03:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:07:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 06:07:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3131' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '34.84' , NOW() , NOW() ) 20/10/2022 06:07:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68017' 20/10/2022 06:07:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '68017' 20/10/2022 06:07:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68017' , '11389' , 'VINO ROSSO DOLCE - 103' , '5' , '-5' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '42.50' ) 20/10/2022 06:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 20/10/2022 06:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 20/10/2022 06:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/E' AND id_document != '68016' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 06:08:11 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/E', document_date = '2022-10-20', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4670598', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '340.00', price_tax_excluded = '340.00', date_upd = NOW() WHERE id_document = '68016' 20/10/2022 06:08:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68016' 20/10/2022 06:08:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '68016' 20/10/2022 06:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 20/10/2022 06:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 20/10/2022 06:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 20/10/2022 06:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 20/10/2022 06:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '38' , '108.50' ) 20/10/2022 06:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 20/10/2022 06:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 20/10/2022 06:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68016' , '' , 'SPESE DI SPEDIZIONE' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 20/10/2022 06:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 20/10/2022 06:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 20/10/2022 07:01:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 07:01:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3132' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.68' , '15.68' , NOW() , NOW() ) 20/10/2022 07:01:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68018' 20/10/2022 07:01:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '68018' 20/10/2022 07:01:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68018' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 20/10/2022 07:01:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 20/10/2022 07:01:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 20/10/2022 07:03:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-20') 20/10/2022 07:03:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3133' , '2022-10-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 20/10/2022 07:03:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68019' 20/10/2022 07:03:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '68019' 20/10/2022 07:03:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68019' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 20/10/2022 07:03:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 20/10/2022 07:03:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 20/10/2022 07:43:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '611970' , '2022-10-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '19.62' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '672.48' , '672.48' , NOW() , NOW() ) 20/10/2022 07:43:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68020' 20/10/2022 07:43:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '68020' 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '48' , '48' , '4' , '5.00' , '5' , '0' , '35+7' , '145.0800' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '4' , '4' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '8' , '4' , '15.00' , '15' , '0' , '35+7' , '72.5400' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '6' , '4' , '15.00' , '15' , '0' , '35+7' , '54.4050' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '14529' , 'PANE E VINO - SUSSIDIO' , '60' , '60' , '4' , '5.00' , '5' , '0' , '35+7' , '181.3500' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '14529' , 'PANE E VINO - SUSSIDIO' , '5' , '5' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '36' , '36' , '4' , '5.00' , '5' , '0' , '35+7' , '108.8100' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '3' , '3' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15927' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15927' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '7' 20/10/2022 07:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '7' , '1' ) 20/10/2022 07:43:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68020' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 20/10/2022 07:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '7' 20/10/2022 07:43:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '7' , '1' )