Send SQL, get XML or JSON How exclude USS  select * from main where auction_type!=1

SQL1 SQL2 SQL3 SQL4 SQL5 SQL6 SQL7 SQL8 SQL9 SQL10 SQL11

FUEL: P-petrol, D-diesel, E-electro, H-hybrid, HE-hybrid erev, L-liquefied petroleum gas, C-compressed natural gas, O-other
IMAGES: set URL https://7.ajes.com/img/... for russain customers, and https://8.ajes.com/imgs/ for other countries
BLUR IMAGE: recommended to exclude USS-auction from anonymous users: where auction_type!=1

Table names main & stats click and press CTRL+U to see table structure
http://78.46.90.228/api/?code=PASS&sql=select%20*%20from%20main%20limit%2010
http://78.46.90.228/gzip/?code=PASS&sql=select%20*%20from%20main%20limit%2010   <= fast
http://78.46.90.228/api/?json&code=PASS&sql=select%20*%20from%20stats%20limit%2010
http://78.46.90.228/gzip/?json&code=PASS&sql=select%20*%20from%20stats%20limit%2010   <= fast

For Korea add 3 buttons inside each lot
where id='Jfj4Hhfk8Te'&history   <= history for Korea
where id='Jfj4Hhfk8Te'&inspection   <= inspection for Korea
where id='Jfj4Hhfk8Te'&ajax   <= show FULL information  take 30 seconds 

Images have 3 sizes
1. add &h=50 in end of URL see here
2. add &w=320 in end of URL  use MEDIUM SIZE as much as possible see here
3. original BIG photo  after MANUAL click of user. but "auction sheet" show BIG, this ok see here

1) How get all IMAGES and fields: SERIAL, INFO
select * from stats where id='ZmsWmOlaUXlc3R'   <= ID is important

2) How get CLEAR images  Request here
http://78.46.90.228/api/?code=DvemR43s&sql=select+*+from+main+where+id='ZmsWmOlaUXlc3R'&user_id=123
change =123 to real user_id from your local database

3) How get TAA extra-images  admin Control Panel / IMAGES-TAA / Balance
http://78.46.90.228/api/?code=DvemR43s&sql=select+*+from+main+where+id='ZmsWmOlaUXlc3R'&paid=taa

4) If image not correct, to clean cache. 50 lots daily
http://78.46.90.228/api/cl?code=DvemR43s&id='ZmsWmOlaUXlc3R'

5) How to send LIKE % or hieroglyphs?
right: select * from main where model_name LIKE '%25accord%25'
select * from main where color='%26%2365404;%26%2365411;%26%2365394;'
incorrectly: select * from main where model_name LIKE '%accord%'
select * from main where color='&#65404;&#65411;&#65394;'