Részletes keresés

Mobiltelefon, telefon tartozék - Mobilmánia webáruház

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in E:\www\www.mobilmania.hu\include\draw_product_list.php on line 219

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'ORDER'. (severity 15) in E:\www\www.mobilmania.hu\include\draw_product_list.php on line 219

Warning: mssql_query() [function.mssql-query]: Query failed in E:\www\www.mobilmania.hu\include\draw_product_list.php on line 219

SQL hiba: Incorrect syntax near the keyword 'ORDER'.
SELECT * FROM ( SELECT TOP -16 * FROM ( SELECT TOP 9 * FROM (SELECT id, sname, b.sprice * 1.25 sprice, (SELECT adat_0 FROM termekadat d WHERE d.pk_termekadatkerdes = -1 AND a.id = d.itemid) old_price, d.stock, a.groupid, (SELECT quant FROM dreserve r WHERE a.id = r.itemid AND r.store = 'R00' AND kind = 'R' AND place = '0000000000') reserved_stock, a.lastupdate FROM ditem a, dsprice b, ditemk c, dstock d WHERE a.id = b.itemid AND a.id = d.itemid AND d.store = 'R00' AND b.pkey = 'P09' AND a.id = c.itemid AND c.webflag = '1' AND a.prop3 = 'V00' AND b.sprice > 0 AND a.prop1 = 'X00' AND a.groupid IN (1100, 1200, 1400, 1600, 1650, 1660, 1700, 1900, 2000, 2100, 2300, 2400, 2600, 2900, 3500, 3800, 4000) ) main_query ORDER BY 6,2,1) tempquery_1 ORDER BY 6 DESC,2 DESC,1 DESC) tempquery_2 ORDER BY 6,2,1

Warning: mssql_close(): supplied argument is not a valid MS SQL-Link resource in E:\www\www.mobilmania.hu\include\draw_product_list.php on line 220