CATEGORY LISTINGS > YANMAR
Posting in Category:

Yanmar



Please enter your login information to post.
Username:
Password:
I want to stay logged in.

Message Title:

Message Text:
bold italic underline
 http link
 https secure link
 ftp ftp link
 mail email link
   hr  
  highlight 
 LI   Quote  ordered list unordered list



HTML code is not permitted. Special symbols permit some HTML functionality.

  [ CATEGORY LISTINGS : THREADS ]




SELECT Advert_Number, Size_Type, Banner_Name, FName, LName, CompanyName FROM Advert_Imp a LEFT OUTER JOIN Seller s ON a.Company_ID = s.SellerID WHERE Show_Advert=1 AND Size_Type = 2 ORDER BY Advert_Number
#AltName#
#AltName#
SELECT Imps_Available FROM Advert_Imp WHERE Advert_Number = UPDATE Advert_Imp SET Imps_Available = #Imps_Available1# WHERE Advert_Number = SELECT Impressions FROM Advert_Imp_Trans WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# UPDATE Advert_Imp_Trans SET Impressions = #Impressions1# WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# INSERT INTO Advert_Imp_Trans (Advert_Number, Date, Impressions, Clicks) VALUES (#Advert_Number#, #CurrentNow#, 1, 0)
SELECT Advert_Number, Banner_Name, FName, LName, CompanyName FROM Advert_Imp a LEFT OUTER JOIN Seller s ON a.Company_ID = s.SellerID WHERE Show_Advert=1 AND Size_Type=1 ORDER BY NEWID()
#AltName#
SELECT Imps_Available FROM Advert_Imp WHERE Advert_Number = UPDATE Advert_Imp SET Imps_Available = #Imps_Available1# WHERE Advert_Number = SELECT Impressions FROM Advert_Imp_Trans WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# UPDATE Advert_Imp_Trans SET Impressions = #Impressions1# WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# INSERT INTO Advert_Imp_Trans (Advert_Number, Date, Impressions, Clicks) VALUES (#Advert_Number#, #CurrentNow#, 1, 0)
Advertize on Diesel Engine Trader

Customer Testimonials

Newsletter

Subscribe to our mailing list to get all the latest DET news.as well as daily or weekly notifications of new engines, gensets and spare parts listings.

'The engine was on other sites, but we received the most calls from DieselEngineTrader.com. We sold it to the first caller-from DieselEngineTrader.com. Also, there was a waiting list on the engine if the first sale fell through! Thanks for the great service!'

Fran Trapp, South Carolina, USA

'Had a Mack 7427 in my shop for 2 years and couldn't sell it! Within a month of advertising on DieselEngineTrader.com I sold the engine to a guy in Oklahoma - was glad to get rid of it!'

Stan iles, Aqua Fria Aggregates, Arizona, USA

'We've been selling on DieselEngineTrader.com since June 2011. It works well for us, we get a good level of inquiries and we've sold engines all over the world!'

Jim Smith, Industrial Engines, Grimsby, UK