Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.database_id = d.id AND p.time_created > 1230264243
AND ((p.model LIKE' at line 26 in
SELECT
t10.*, price.minprice, price.maxprice,
(SELECT xxx.photo_id FROM _gsmpress_prod_photos as xxx WHERE xxx.photo_produkt_id = t10.id ORDER BY photo_order, photo_id LIMIT 0,1) as photo_id
FROM
(SELECT phone.url, phone.ebay, phone.id, phone.model, manufacturers.name, manufacturers.id as manid, phone_description.meta, phone_description.description, phone.rating_design, phone.rating_functions, phone.rating_performance, phone.rating_user_comfort
FROM _gsmpress_prod_phone as phone, _gsmpress_prod_manufacturers as manufacturers, _gsmpress_languages as languages,
(SELECT languages.id as langid, description.*
FROM _gsmpress_languages as languages
LEFT JOIN
(SELECT * FROM _gsmpress_prod_phone_description
WHERE phone_id = '2529') as description
ON description.language_id = languages.id) as phone_description
WHERE phone.id = '2529' AND phone.manufacturer_id = manufacturers.id AND phone_description.langid = languages.id AND languages.id = 'eng') as t10
LEFT JOIN
(SELECT MIN(p.price*c.value_czk) minprice, MAX(p.price*c.value_czk) maxprice, p.manufacturer
FROM _gsmpress_datab_prices as p, _gsmpress_currencies as c, _gsmpress_datab_database as d
LEFT JOIN
(SELECT markets.*, countries.region
FROM _gsmpress_datab_target_markets as markets, _gsmpress_countries as countries
WHERE countries.id = markets.country_id
) as m
ON m.database_id = d.id
WHERE p.product_type = 1 AND p.manufacturer = AND p.database_id = d.id AND p.time_created > 1230264243
AND ((p.model LIKE '% %') OR (p.model LIKE ' %') OR (p.model LIKE '') OR (p.model LIKE '% ')) AND d.currency = c.id AND d.time_activated > 0 AND d.authorized = 1 AND d.user_activated = 1
AND d.language_id = 'eng' AND d.ppc_enabled = 1 AND d.ppc_authorized = 1 AND d.ppc_balance > d.ppc_rate_mobile_phones
GROUP BY p.manufacturer) as price
ON price.manufacturer = manid
Warning: Cannot modify header information - headers already sent by (output started at /www/doc/www.gsmpress.com/www/admin/sql.php:53) in /www/doc/www.gsmpress.com/www/phonedetail.php on line 171
not found