the exact query was: SELECT SQL_CALC_FOUND_ROWS Description,DB_Compunation.MPN, if(shortname='',DB_Compunation.VendorName, shortname)as vname, ItemCost,thmbnail,Markup,ShippingCost,InStock, ItemID,DB_Compunation.SupplierName,DB_Compunation.active, writeprotected, URL,DB_Compunation.ItemId,thmbnail, ht, wd, new_cat, DB_Compunation.f_hidden FROM DB_Compunation left join db_urls on (urlID =DB_Compunation.ItemID) left join mfgr_lut on (DB_Compunation.VendorName=lutVendorName) where DB_Compunation.active=1 and f_hidden < 1 and ORDER BY DB_Compunation.VendorName, itemcost limit 0, 25
There was a problem processing your request - event logged
QUERY Result: SQL Code: SELECT SQL_CALC_FOUND_ROWS Description,DB_Compunation.MPN, if(shortname='',DB_Compunation.VendorName, shortname)as vname, ItemCost,thmbnail,Markup,ShippingCost,InStock, ItemID,DB_Compunation.SupplierName,DB_Compunation.active, writeprotected, URL,DB_Compunation.ItemId,thmbnail, ht, wd, new_cat, DB_Compunation.f_hidden FROM DB_Compunation left join db_urls on (urlID =DB_Compunation.ItemID) left join mfgr_lut on (DB_Compunation.VendorName=lutVendorName) where DB_Compunation.active=1 and f_hidden < 1 and ORDER BY DB_Compunation.VendorName, itemcost limit 0, 25 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 'ORDER BY DB_Compunation.VendorName, itemcost limit 0, 25' at line 1 on line:207
0 Items found in 0 pages :
the exact query was: SELECT SQL_CALC_FOUND_ROWS Description,DB_Compunation.MPN, if(shortname='',DB_Compunation.VendorName, shortname)as vname, ItemCost,thmbnail,Markup,ShippingCost,InStock, ItemID,DB_Compunation.SupplierName,DB_Compunation.active, writeprotected, URL,DB_Compunation.ItemId,thmbnail, ht, wd, new_cat, DB_Compunation.f_hidden FROM DB_Compunation left join db_urls on (urlID =DB_Compunation.ItemID) left join mfgr_lut on (DB_Compunation.VendorName=lutVendorName) where DB_Compunation.active=1 and f_hidden < 1 and
There was a problem processing your request - event logged