Database
test
running on
localhost
Structure
SQL
Export
Search
Query
Field :
`admin`.*
`admin`.`id`
`admin`.`name`
`admin`.`password`
`agent`.*
`agent`.`id`
`agent`.`username`
`agent`.`password`
`agent`.`mailadres`
`agent`.`agenturl`
`agent`.`agentemail`
`agent`.`notes`
`agent`.`agentphone`
`agent`.`agentcell`
`agent`.`agentfax`
`agent`.`actnum`
`agent`.`userlevel`
`agent`.`signupdate`
`agent`.`lastlogin`
`agent`.`lastloginfail`
`agent`.`numloginfail`
`agent_tbl_files`.*
`agent_tbl_files`.`id_files`
`agent_tbl_files`.`bin_data`
`agent_tbl_files`.`description`
`agent_tbl_files`.`filename`
`agent_tbl_files`.`filesize`
`agent_tbl_files`.`filetype`
`agent_tbl_files`.`agentnum`
`agent_tbl_files`.`owner`
`agents`.*
`agents`.`id`
`agents`.`agent`
`agents`.`agentpass`
`agents`.`agenturl`
`agents`.`agentemail`
`agents`.`notes`
`agents`.`agentphone`
`agents`.`agentcell`
`agents`.`agentfax`
`contact`.*
`contact`.`id`
`contact`.`name`
`contact`.`phone_no`
`contact`.`email`
`contact`.`comments`
`contact`.`bikeid`
`contact`.`year`
`contact`.`make`
`contact`.`model`
`contact`.`dateposted`
`favs`.*
`favs`.`uid`
`favs`.`vid`
`friendmail`.*
`friendmail`.`id`
`friendmail`.`fromname`
`friendmail`.`fromemail`
`friendmail`.`toemail`
`friendmail`.`toname`
`friendmail`.`message`
`friendmail`.`dateposted`
`signup`.*
`signup`.`id`
`signup`.`username`
`signup`.`password`
`signup`.`mailadres`
`signup`.`actnum`
`signup`.`userlevel`
`signup`.`signupdate`
`signup`.`lastlogin`
`signup`.`lastloginfail`
`signup`.`numloginfail`
`tbl_files`.*
`tbl_files`.`id_files`
`tbl_files`.`description`
`tbl_files`.`filename`
`tbl_files`.`thumbname`
`tbl_files`.`prop_num`
`tbl_files`.`owner`
`user`.*
`user`.`id`
`user`.`username`
`user`.`password`
`user`.`mailadres`
`user`.`agenturl`
`user`.`agentemail`
`user`.`notes`
`user`.`agentphone`
`user`.`agentcell`
`user`.`agentfax`
`user`.`actnum`
`user`.`userlevel`
`user`.`signupdate`
`user`.`lastlogin`
`user`.`lastloginfail`
`user`.`numloginfail`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`title`
`vehicles`.`city`
`vehicles`.`state`
`vehicles`.`zip`
`vehicles`.`price`
`vehicles`.`fulldesc`
`vehicles`.`type`
`vehicles`.`featured`
`vehicles`.`photo`
`vehicles`.`bold`
`vehicles`.`dateposted`
`vehicles`.`agent`
`vehicles`.`notes`
`vehicles`.`owner`
`vehicles`.`model`
`vehicles`.`make`
`vehicles`.`year`
`vehicles`.`drivetrain`
`vehicles`.`transmission`
`vehicles`.`body`
`vehicles`.`doors`
`vehicles`.`features`
`vehicles`.`stereo`
`vehicles`.`color`
`vehicles`.`miles`
`vehicles`.`opt1`
`vehicles`.`opt2`
`vehicles`.`opt3`
`vehicles`.`opt4`
`vehicles`.`opt5`
`vehicles`.`opt6`
`vehicles`.`opt7`
`vehicles`.`opt8`
`vehicles`.`opt9`
`vehicles`.`opt10`
`vehicles`.`hitcount`
`admin`.*
`admin`.`id`
`admin`.`name`
`admin`.`password`
`agent`.*
`agent`.`id`
`agent`.`username`
`agent`.`password`
`agent`.`mailadres`
`agent`.`agenturl`
`agent`.`agentemail`
`agent`.`notes`
`agent`.`agentphone`
`agent`.`agentcell`
`agent`.`agentfax`
`agent`.`actnum`
`agent`.`userlevel`
`agent`.`signupdate`
`agent`.`lastlogin`
`agent`.`lastloginfail`
`agent`.`numloginfail`
`agent_tbl_files`.*
`agent_tbl_files`.`id_files`
`agent_tbl_files`.`bin_data`
`agent_tbl_files`.`description`
`agent_tbl_files`.`filename`
`agent_tbl_files`.`filesize`
`agent_tbl_files`.`filetype`
`agent_tbl_files`.`agentnum`
`agent_tbl_files`.`owner`
`agents`.*
`agents`.`id`
`agents`.`agent`
`agents`.`agentpass`
`agents`.`agenturl`
`agents`.`agentemail`
`agents`.`notes`
`agents`.`agentphone`
`agents`.`agentcell`
`agents`.`agentfax`
`contact`.*
`contact`.`id`
`contact`.`name`
`contact`.`phone_no`
`contact`.`email`
`contact`.`comments`
`contact`.`bikeid`
`contact`.`year`
`contact`.`make`
`contact`.`model`
`contact`.`dateposted`
`favs`.*
`favs`.`uid`
`favs`.`vid`
`friendmail`.*
`friendmail`.`id`
`friendmail`.`fromname`
`friendmail`.`fromemail`
`friendmail`.`toemail`
`friendmail`.`toname`
`friendmail`.`message`
`friendmail`.`dateposted`
`signup`.*
`signup`.`id`
`signup`.`username`
`signup`.`password`
`signup`.`mailadres`
`signup`.`actnum`
`signup`.`userlevel`
`signup`.`signupdate`
`signup`.`lastlogin`
`signup`.`lastloginfail`
`signup`.`numloginfail`
`tbl_files`.*
`tbl_files`.`id_files`
`tbl_files`.`description`
`tbl_files`.`filename`
`tbl_files`.`thumbname`
`tbl_files`.`prop_num`
`tbl_files`.`owner`
`user`.*
`user`.`id`
`user`.`username`
`user`.`password`
`user`.`mailadres`
`user`.`agenturl`
`user`.`agentemail`
`user`.`notes`
`user`.`agentphone`
`user`.`agentcell`
`user`.`agentfax`
`user`.`actnum`
`user`.`userlevel`
`user`.`signupdate`
`user`.`lastlogin`
`user`.`lastloginfail`
`user`.`numloginfail`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`title`
`vehicles`.`city`
`vehicles`.`state`
`vehicles`.`zip`
`vehicles`.`price`
`vehicles`.`fulldesc`
`vehicles`.`type`
`vehicles`.`featured`
`vehicles`.`photo`
`vehicles`.`bold`
`vehicles`.`dateposted`
`vehicles`.`agent`
`vehicles`.`notes`
`vehicles`.`owner`
`vehicles`.`model`
`vehicles`.`make`
`vehicles`.`year`
`vehicles`.`drivetrain`
`vehicles`.`transmission`
`vehicles`.`body`
`vehicles`.`doors`
`vehicles`.`features`
`vehicles`.`stereo`
`vehicles`.`color`
`vehicles`.`miles`
`vehicles`.`opt1`
`vehicles`.`opt2`
`vehicles`.`opt3`
`vehicles`.`opt4`
`vehicles`.`opt5`
`vehicles`.`opt6`
`vehicles`.`opt7`
`vehicles`.`opt8`
`vehicles`.`opt9`
`vehicles`.`opt10`
`vehicles`.`hitcount`
`admin`.*
`admin`.`id`
`admin`.`name`
`admin`.`password`
`agent`.*
`agent`.`id`
`agent`.`username`
`agent`.`password`
`agent`.`mailadres`
`agent`.`agenturl`
`agent`.`agentemail`
`agent`.`notes`
`agent`.`agentphone`
`agent`.`agentcell`
`agent`.`agentfax`
`agent`.`actnum`
`agent`.`userlevel`
`agent`.`signupdate`
`agent`.`lastlogin`
`agent`.`lastloginfail`
`agent`.`numloginfail`
`agent_tbl_files`.*
`agent_tbl_files`.`id_files`
`agent_tbl_files`.`bin_data`
`agent_tbl_files`.`description`
`agent_tbl_files`.`filename`
`agent_tbl_files`.`filesize`
`agent_tbl_files`.`filetype`
`agent_tbl_files`.`agentnum`
`agent_tbl_files`.`owner`
`agents`.*
`agents`.`id`
`agents`.`agent`
`agents`.`agentpass`
`agents`.`agenturl`
`agents`.`agentemail`
`agents`.`notes`
`agents`.`agentphone`
`agents`.`agentcell`
`agents`.`agentfax`
`contact`.*
`contact`.`id`
`contact`.`name`
`contact`.`phone_no`
`contact`.`email`
`contact`.`comments`
`contact`.`bikeid`
`contact`.`year`
`contact`.`make`
`contact`.`model`
`contact`.`dateposted`
`favs`.*
`favs`.`uid`
`favs`.`vid`
`friendmail`.*
`friendmail`.`id`
`friendmail`.`fromname`
`friendmail`.`fromemail`
`friendmail`.`toemail`
`friendmail`.`toname`
`friendmail`.`message`
`friendmail`.`dateposted`
`signup`.*
`signup`.`id`
`signup`.`username`
`signup`.`password`
`signup`.`mailadres`
`signup`.`actnum`
`signup`.`userlevel`
`signup`.`signupdate`
`signup`.`lastlogin`
`signup`.`lastloginfail`
`signup`.`numloginfail`
`tbl_files`.*
`tbl_files`.`id_files`
`tbl_files`.`description`
`tbl_files`.`filename`
`tbl_files`.`thumbname`
`tbl_files`.`prop_num`
`tbl_files`.`owner`
`user`.*
`user`.`id`
`user`.`username`
`user`.`password`
`user`.`mailadres`
`user`.`agenturl`
`user`.`agentemail`
`user`.`notes`
`user`.`agentphone`
`user`.`agentcell`
`user`.`agentfax`
`user`.`actnum`
`user`.`userlevel`
`user`.`signupdate`
`user`.`lastlogin`
`user`.`lastloginfail`
`user`.`numloginfail`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`title`
`vehicles`.`city`
`vehicles`.`state`
`vehicles`.`zip`
`vehicles`.`price`
`vehicles`.`fulldesc`
`vehicles`.`type`
`vehicles`.`featured`
`vehicles`.`photo`
`vehicles`.`bold`
`vehicles`.`dateposted`
`vehicles`.`agent`
`vehicles`.`notes`
`vehicles`.`owner`
`vehicles`.`model`
`vehicles`.`make`
`vehicles`.`year`
`vehicles`.`drivetrain`
`vehicles`.`transmission`
`vehicles`.`body`
`vehicles`.`doors`
`vehicles`.`features`
`vehicles`.`stereo`
`vehicles`.`color`
`vehicles`.`miles`
`vehicles`.`opt1`
`vehicles`.`opt2`
`vehicles`.`opt3`
`vehicles`.`opt4`
`vehicles`.`opt5`
`vehicles`.`opt6`
`vehicles`.`opt7`
`vehicles`.`opt8`
`vehicles`.`opt9`
`vehicles`.`opt10`
`vehicles`.`hitcount`
Sort :
Ascending
Descending
Ascending
Descending
Ascending
Descending
Show :
Criteria :
Ins :
And :
Del :
Or :
Modify :
Or :
And :
Ins
Del
Or :
And :
Ins
Del
Or :
And :
Ins
Del
Use Tables :
admin
agent
agent_tbl_files
agents
contact
favs
friendmail
signup
tbl_files
user
vehicles
Add/Delete Criteria Row :
-3
-2
-1
0
1
2
3
Add/Delete Field Columns :
-3
-2
-1
0
1
2
3
SQL-query on database
test
: