Андрей Васильев

$handle = curl_init();
curl_setopt($handle, CURLOPT_URL, 'fantasyland.ru/login.php');
curl_setopt($handle, CURLOPT_POST, 1);
curl_setopt($handle, CURLOPT_POSTFIELDS, 'login=ххх&password=ххх');
curl_setopt($handle, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($handle, CURLOPT_HEADER, 0);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($handle, CURLOPT_COOKIEFILE, 'cookie.txt');
curl_setopt($handle, CURLOPT_COOKIEJAR, 'cookie.txt');
curl_exec($handle);

curl_setopt($handle, CURLOPT_URL, 'fantasyland.ru/cgi/v_trade_load_all.php');
$page = curl_exec($handle);

SELECT p.*, ps.price as special_price FROM product p
LEFT JOIN product_special ps ON p.id = ps.product_id

SELECT p.id, 
IF (ps.price IS NOT NULL AND ps.date_start < NOW() AND ps.date_end > NOW() , ps.price, p.price) as price FROM product p
LEFT JOIN product_special ps ON p.id = ps.product_id