Καλάθι
αγορών
(0)
Αγαπημένα
Παραγγελίες
Backorder

e-RMA




new product
last stock
sun xml
image

select 
						material.*,v_z_availability.z_availability,v_z_availability.z_active_date as ArrivalDate,
						DATE_FORMAT( v_z_availability.z_active_date,'%d/%m/%Y')  as ddate,DATE_FORMAT(v_z_availability.ARRIVAL_DATE,'%d/%m/%Y') as ARRIVAL_DATE,v_z_availability.z_availability,OfferPrice,ShowDate,UntilDate
					from material 
					inner join v_z_availability on v_z_availability.ID=material.ID
					left join offers on offers.ProductCODE=material.CODE 
					where  
						v_z_availability.z_active_date in ('2020-08-10 00:00:00','2020-08-04 00:00:00','2020-07-31 00:00:00','2020-07-28 00:00:00','2020-07-24 00:00:00','2020-07-21 00:00:00','2020-07-17 00:00:00','2020-07-15 00:00:00','2020-07-10 00:00:00','2020-07-07 00:00:00','2020-07-03 00:00:00','2020-06-30 00:00:00','2020-06-23 00:00:00','2020-06-16 00:00:00','2020-06-12 00:00:00','2020-06-09 00:00:00','2020-06-05 00:00:00','2020-06-04 00:00:00','2020-05-29 00:00:00','2020-05-28 00:00:00')  
						and (material.ID not in (select mat_id from prod_to_cust_not where cust_afm=''))
						and (material.ID not in (select mat_id from prod_to_cust)  or  material.ID IN (select mat_id from prod_to_cust where cust_afm=''))  
																																													
					group by material.ID 
					order by v_z_availability.z_active_date desc  LIMIT 120, 20
Array
(
    [type] => 8
    [message] => Undefined variable: div
    [file] => /var/www/DOMAINS/sun_gr/www_sun_gr/lib_v5/init.php
    [line] => 215
)
Disk full (/tmp/#sql_6c0_13.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Νέα Προϊόντα

close
loading...