Data and Lists - Quality resources for your e-business success online
Languages:
English  
Currencies:
Shopping Cart:

0 items
Categories
We Accept
Liberty Reserve
2CO Payment
MC LogoVisa LogoAmex Logo
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Specials
World City Names Database with Latitude and Longitude
World City Names Database with Latitude and Longitude
$59.00

$49.00
Newsletter
Please enter your email address:


LANGUAGES
English French Spanish German
Italian Portuguese Greek Turkish
Categories
Business Diretory
Business Diretory
Geographic Data
Geographic Data
Historical Data
Historical Data
Knowledge Base
Knowledge Base
Socio-Economic Data
Socio-Economic Data
Website Promotion
Website Promotion
What's New?
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ebusinessgems.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '22' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 8

[TEP STOP]