02/07/2024 08:55:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 08:55:36 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' , '2157' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 02/07/2024 08:55:36 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 = '92499' 02/07/2024 08:55:36 am >> DELETE FROM ps_document_detail WHERE id_document = '92499' 02/07/2024 08:55:36 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 ( '92499' , '919' , 'BALZA RICAMATA BIANCA - CM 15 - KOM/020 - OGGETTI' , '3' , '-3' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '75.00' ) 02/07/2024 09:09:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 09:09:05 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' , '2158' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 02/07/2024 09:09:05 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 = '92500' 02/07/2024 09:09:05 am >> DELETE FROM ps_document_detail WHERE id_document = '92500' 02/07/2024 09:09:05 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 ( '92500' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 02/07/2024 09:36:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983226' AND id_product != '4397' AND ean13 != '' 02/07/2024 09:36:14 am >> UPDATE ps_product SET id_supplier = '53', reference = '4/2', ean13 = '9788895983226', date_upd = NOW() WHERE id_product = '4397' 02/07/2024 09:36:14 am >> UPDATE ps_product_lang SET name = 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE', description = '
SCHEDE PER I FANCIULLI.
Vengono denominate Quaderno di viaggio. Non si tratta di un quaderno attivo da utilizzare in maniera scolastica, ma di uno strumento che si accresce di volta in volta con il contributo creativo dei fanciulli e dei loro catechisti.
Sono a colori da inserire in un raccoglitore (formato A5) che verranno consegnate di volta in volta dal catechista.
' WHERE id_product = '4397' 02/07/2024 09:36:14 am >> UPDATE ps_product SET wholesale_price = '0.87', on_sale = '0', price = '3.8' WHERE id_product = '4397' 02/07/2024 09:36:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.87', price = '3.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '4397' 02/07/2024 09:36:14 am >> DELETE FROM ps_specific_price WHERE id_product = '4397' 02/07/2024 09:36:14 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '4397' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 02/07/2024 09:37:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983240' AND id_product != '4495' AND ean13 != '' 02/07/2024 09:37:09 am >> UPDATE ps_product SET id_supplier = '53', reference = '4/2', ean13 = '9788895983240', date_upd = NOW() WHERE id_product = '4495' 02/07/2024 09:37:09 am >> UPDATE ps_product_lang SET name = 'GESÙ RESTA CON NOI 3 - SCHEDE', description = 'SCHEDE PER I FANCIULLI.
Vengono denominate Quaderno di viaggio. Non si tratta di un quaderno attivo da utilizzare in maniera scolastica, ma di uno strumento che si accresce di volta in volta con il contributo creativo dei fanciulli e dei loro catechisti.
Sono a colori da inserire in un raccoglitore (formato A5) che verranno consegnate di volta in volta dal catechista.
' WHERE id_product = '4495' 02/07/2024 09:37:09 am >> UPDATE ps_product SET wholesale_price = '0.87', on_sale = '0', price = '3.8' WHERE id_product = '4495' 02/07/2024 09:37:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.87', price = '3.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '4495' 02/07/2024 09:37:09 am >> DELETE FROM ps_specific_price WHERE id_product = '4495' 02/07/2024 09:37:09 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '4495' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 02/07/2024 09:37:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983219' AND id_product != '4394' AND ean13 != '' 02/07/2024 09:37:21 am >> UPDATE ps_product SET id_supplier = '53', reference = '4/2', ean13 = '9788895983219', date_upd = NOW() WHERE id_product = '4394' 02/07/2024 09:37:21 am >> UPDATE ps_product_lang SET name = 'GESÙ CI CHIAMA 1 - SCHEDE', description = 'SCHEDE PER I FANCIULLI.
Vengono denominate Quaderno di viaggio. Non si tratta di un quaderno attivo da utilizzare in maniera scolastica, ma di uno strumento che si accresce di volta in volta con il contributo creativo dei fanciulli e dei loro catechisti.
Sono a colori da inserire in un raccoglitore (formato A5) che verranno consegnate di volta in volta dal catechista.
' WHERE id_product = '4394' 02/07/2024 09:37:21 am >> UPDATE ps_product SET wholesale_price = '0.87', on_sale = '0', price = '3.8' WHERE id_product = '4394' 02/07/2024 09:37:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.87', price = '3.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '4394' 02/07/2024 09:37:21 am >> DELETE FROM ps_specific_price WHERE id_product = '4394' 02/07/2024 09:37:21 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '4394' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 02/07/2024 09:48:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 09:48: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' , '2159' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 02/07/2024 09:48: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 = '92501' 02/07/2024 09:48:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92501' 02/07/2024 09:48: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 ( '92501' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 02/07/2024 09:48: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 ( '92501' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 02/07/2024 09:54:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983660' AND id_product != '16997' AND ean13 != '' 02/07/2024 09:54:46 am >> UPDATE ps_product SET id_supplier = '53', reference = '13/4', ean13 = '9788895983660', date_upd = NOW() WHERE id_product = '16997' 02/07/2024 09:54:46 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO IL PADRONE DELLE MESSE ', description = 'Questo opuscolo offre uno schema per pregare i misteri del rosario chiedendo al Signore il dono delle vocazioni sacerdotali e religiose, è un sussidio semplice che può essere usato da parrocchie, gruppi di preghiera e comunità religiose. Ogni vocazione è un dono che viene dall\'alto e pertanto va invocato umilmente e incessantemente.
Formato 17X11
pagine 34
' WHERE id_product = '16997' 02/07/2024 09:54:46 am >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.5000' WHERE id_product = '16997' 02/07/2024 09:54:46 am >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16997' 02/07/2024 09:54:46 am >> DELETE FROM ps_specific_price WHERE id_product = '16997' 02/07/2024 09:54:46 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '16997' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 02/07/2024 10:02:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 10:02: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' , '2160' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '32.00' , NOW() , NOW() ) 02/07/2024 10:02: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 = '92502' 02/07/2024 10:02:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92502' 02/07/2024 10:02: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 ( '92502' , '22723' , 'LUCI SUL PALCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 02/07/2024 10:02: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 ( '92502' , '22724' , 'PAROLA E TERAPIA - E. ANDREUCCETTI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 02/07/2024 10:04:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 10:04:54 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' , '2161' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 02/07/2024 10:04:54 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 = '92503' 02/07/2024 10:04:54 am >> DELETE FROM ps_document_detail WHERE id_document = '92503' 02/07/2024 10:04:54 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 ( '92503' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/07/2024 11:18:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 11:18:52 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' , '2162' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 02/07/2024 11:18:52 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 = '92504' 02/07/2024 11:18:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92504' 02/07/2024 11:18: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 ( '92504' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 02/07/2024 11:18: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 ( '92504' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 02/07/2024 11:26:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 11:26:04 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' , '2163' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 02/07/2024 11:26:04 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 = '92505' 02/07/2024 11:26:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92505' 02/07/2024 11:26:04 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 ( '92505' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/07/2024 11:26:04 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 ( '92505' , '22388' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 02/07/2024 11:49:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 11:49:12 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' , '2164' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.00' , '51.64' , NOW() , NOW() ) 02/07/2024 11:49:12 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 = '92506' 02/07/2024 11:49:12 am >> DELETE FROM ps_document_detail WHERE id_document = '92506' 02/07/2024 11:49:12 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 ( '92506' , '21447' , 'VELO TULLE ' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 02/07/2024 11:49:12 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 ( '92506' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 02/07/2024 11:59:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 11:59: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 ( '11' , '2165' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.35' , '13.35' , NOW() , NOW() ) 02/07/2024 11:59: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 = '92507' 02/07/2024 11:59:10 am >> DELETE FROM ps_document_detail WHERE id_document = '92507' 02/07/2024 11:59: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 ( '92507' , '19671' , 'UN MESE CON IL PREZIOSISSIMO SANGUE - 8074' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 02/07/2024 11:59: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 ( '92507' , '15743' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 02/07/2024 11:59: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 ( '92507' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '2' , '-2' , '4' , '0.60' , '0.6' , '0' , '0' , '1.20' ) 02/07/2024 11:59: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 ( '92507' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 02/07/2024 12:11:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 12:11:28 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' , '2166' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.25' , '25.42' , NOW() , NOW() ) 02/07/2024 12:11:28 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 = '92508' 02/07/2024 12:11:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92508' 02/07/2024 12:11:28 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 ( '92508' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/07/2024 12:11:28 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 ( '92508' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/07/2024 12:11:28 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 ( '92508' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2024 12:12:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2024' AND id_document != '92331' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 02/07/2024 12:12:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2024', document_date = '2024-06-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 = '19.90', price_tax_excluded = '17.06', date_upd = NOW() WHERE id_document = '92331' 02/07/2024 12:12: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 = '92331' 02/07/2024 12:12:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '92331' 02/07/2024 12:12: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 ( '92331' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 02/07/2024 12:12: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 ( '92331' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 02/07/2024 12:12: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 ( '92331' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 02/07/2024 12:12: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 ( '92331' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/07/2024 12:12: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 ( '92331' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '5' , '-5' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.50' ) 02/07/2024 12:12: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 ( '92331' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 02/07/2024 12:12: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 ( '92331' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '3.30' ) 02/07/2024 12:12: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 ( '92331' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/07/2024 12:18:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 12:18:24 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' , '2167' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.60' , '61.15' , NOW() , NOW() ) 02/07/2024 12:18:24 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 = '92509' 02/07/2024 12:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '92509' 02/07/2024 12:18:24 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 ( '92509' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 02/07/2024 12:18:24 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 ( '92509' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/07/2024 12:18:24 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 ( '92509' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 02/07/2024 12:30:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 12:30: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 ( '11' , '2168' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.00' , '117.21' , NOW() , NOW() ) 02/07/2024 12:30: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 = '92510' 02/07/2024 12:30:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92510' 02/07/2024 12:30:34 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 ( '92510' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 02/07/2024 06:11:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 06:11: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 ( '11' , '2169' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.90' , '16.31' , NOW() , NOW() ) 02/07/2024 06:11: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 = '92511' 02/07/2024 06:11:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92511' 02/07/2024 06:11: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 ( '92511' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 02/07/2024 06:17:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 06:17: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 ( '11' , '2170' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 02/07/2024 06:17: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 = '92512' 02/07/2024 06:17:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '92512' 02/07/2024 06:17: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 ( '92512' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2024 06:17: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 ( '92512' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2024 06:51:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 02/07/2024 06:51:11 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' , '2171' , '2024-07-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 02/07/2024 06:51:11 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 = '92513' 02/07/2024 06:51:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92513' 02/07/2024 06:51:11 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 ( '92513' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 02/07/2024 07:40:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1995' AND id_document != '92300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-14') 02/07/2024 07:40:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1995', document_date = '2024-06-14', 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 = '16.15', price_tax_excluded = '16.15', date_upd = NOW() WHERE id_document = '92300' 02/07/2024 07:40:56 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 = '92300' 02/07/2024 07:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '92300' 02/07/2024 07:40: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 ( '92300' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.65' , '6.65' , '0' , '' , '6.65' ) 02/07/2024 07:40: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 ( '92300' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2024 07:40: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 ( '92300' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )