iosheet
User Icon ++

📘 iosheet Actual Menu


excel_upload
excel_table_list
excel_TableSelect
SQL 작성 및 수정
chatting_test
weather_city
user_Chatting
user_RecentChat
DuctCircle_Chart
DuctCircle_Table
notice
FAQ
News
board
new_program_01
new_program_02
new_program_03
new_program_04
new_program_05
new_program_06
SQL 실행 결과 (new_program_03.php)

🧾 SQL 실행 결과 (new_program_03.php)

📄 SQL 파일 경로: /home/iosheet/public_html/upload/new_program_03.txt
🕒 실행 시각: 2026-01-15 05:59:52
📜 실행된 SQL 문:
SELECT 
        s.거래일,
        s.코드,
        sp.품명,
        sp.규격,
        sp.사이즈,
        s.수량,
        s.판매단가,
        sp.가격,
        (s.수량 * s.판매단가) AS 판매금액,
        (s.수량 * sp.가격) AS 계획금액,
        s.판매처
    FROM ex_tkduct_sales_list s
    LEFT JOIN ex_spiral sp ON s.코드 = sp.코드
    ORDER BY s.거래일 DESC, s.코드 ;
📊 결과 데이터
거래일코드품명규격사이즈수량판매단가가격판매금액계획금액판매처
2022-08-30altape_502900018000청라푸드
2022-08-30cld_1170_47270000140000(주)삼영에어테크
2022-08-30coupling_250socket_Coupling2502504440044001760017600(주)삼영에어테크
2022-08-30coupling_250socket_Coupling2502508280044002240035200청라푸드
2022-08-30coupling_400socket_Coupling4004002528088001056017600크린에어테크 주식회사
2022-08-30coupling_400socket_Coupling400400234208800684017600크린에어테크 주식회사
2022-08-30damper_10020480096000크린에어테크 주식회사
2022-08-30damper_100205200104000크린에어테크 주식회사
2022-08-30damper_25021150023000크린에어테크 주식회사
2022-08-30damper_25021020020400크린에어테크 주식회사
2022-08-30damper_35015300053000크린에어테크 주식회사
2022-08-30damper_35015300053000크린에어테크 주식회사
2022-08-30el90_150elbow9015015020690011500138000230000크린에어테크 주식회사
2022-08-30el90_250elbow90250250101940019400194000194000청라푸드
2022-08-30el90_250elbow90250250211640194002328038800크린에어테크 주식회사
2022-08-30el90_250elbow90250250101164019400116400194000크린에어테크 주식회사
2022-08-30el90_250elbow90250250121164019400139680232800크린에어테크 주식회사
2022-08-30el90_300elbow90300300101404023400140400234000크린에어테크 주식회사
2022-08-30el90_300elbow90300300101404023400140400234000크린에어테크 주식회사
2022-08-30el90_350elbow90350350102034033900203400339000크린에어테크 주식회사
2022-08-30el90_350elbow90350350102034033900203400339000크린에어테크 주식회사
2022-08-30el90_350elbow90350350202034033900406800678000크린에어테크 주식회사
2022-08-30el90_400elbow9040040062310038500138600231000크린에어테크 주식회사
2022-08-30el90_400elbow9040040062310038500138600231000크린에어테크 주식회사
2022-08-30flange_socket_2002780015600주식회사 세진크랭크
2022-08-30grille_600475000300000(주)삼영에어테크
2022-08-30hood_18601250000250000크린에어테크 주식회사
2022-08-30hood_1860_13401250000250000크린에어테크 주식회사
2022-08-30hood_30001680000680000크린에어테크 주식회사
2022-08-30hood_3000_13001680000680000크린에어테크 주식회사
2022-08-30r_350reducer350350217200215003440043000주식회사 세진크랭크
2022-08-30ryt_400reduce_y_type_branch400400140380673004038067300크린에어테크 주식회사
2022-08-30ryt_400reduce_y_type_branch400400140380673004038067300크린에어테크 주식회사
2022-08-30sp_250_05Spiral_0.5t250250401450014500580000580000청라푸드
2022-08-30sp_250_05Spiral_0.5t250250894201450075360116000크린에어테크 주식회사
2022-08-30sp_250_05Spiral_0.5t250250887001450069600116000크린에어테크 주식회사
2022-08-30sp_350_05Spiral_0.5t350350401365021000546000840000크린에어테크 주식회사
2022-08-30sp_350_05Spiral_0.5t350350401260021000504000840000크린에어테크 주식회사
2022-08-30sp_400_05Spiral_0.5t400400161541023700246560379200크린에어테크 주식회사
2022-08-30sp_400_05Spiral_0.5t400400161422023700227520379200크린에어테크 주식회사
2022-08-30spin_in_30012000020000(주)삼영에어테크
2022-08-30straight_100014800048000(주)삼영에어테크
2022-08-30straight_100014500045000(주)삼영에어테크
2022-08-30sus_band_250_1088006400(주)삼영에어테크
2022-08-30tarpaulin_insulation_250_1010560056000(주)삼영에어테크
2022-08-30vd_300_30012000020000(주)삼영에어테크
2022-08-30yt_40014038040380크린에어테크 주식회사
2022-08-30yt_40014038040380크린에어테크 주식회사
2022-08-29altape_50180008000(주)삼영에어테크
2022-08-29coupling_300socket_Coupling30030014900520049005200(주)삼영에어테크
2022-08-29coupling_800socket_Coupling8008004230002910092000116400광한기계
2022-08-29coupling_850socket_Coupling850850226000336005200067200광한기계
2022-08-29el90_300elbow90300300120000234002000023400(주)삼영에어테크
2022-08-29el90_400elbow90400400238500385007700077000한신콤프렛서
2022-08-29flange_socket_2502850017000(주)삼영에어테크
2022-08-29hood_1200_700_500_h6001130000130000(주)삼영에어테크
2022-08-29r_150reducer15015017500750075007500(주)삼영에어테크
2022-08-29tarpaulin_flexible_100_420120024000(주)삼영에어테크
2022-08-29tran_t_410_5701100000100000한신콤프렛서
2022-08-28coupling_200socket_Coupling200200261003500122007000광한기계
2022-08-28damper_1256900054000광한기계
2022-08-28el45_1256740044400광한기계
2022-08-28el45_200elbow452002004970097003880038800광한기계
2022-08-28el90_1251211500138000광한기계
2022-08-28el90_200elbow9020020071580015800110600110600광한기계
2022-08-28flange_socket_1256500030000광한기계
2022-08-28flange_socket_2002750015000광한기계
2022-08-28r_150reducer1501505750075003750037500광한기계
2022-08-28sp_125_05Spiral_0.5t1251251673007300116800116800광한기계
2022-08-28sp_200_05Spiral_0.5t200200281160011600324800324800광한기계
2022-08-28t_200tee200200111500115001150011500광한기계
2022-08-28yb_200y_branch20020058900138004450069000광한기계
2022-08-27cap_200End_cap200200245706100914012200신진산업
2022-08-27damper_1256900054000신진산업
2022-08-27duct_sub12700027000광한기계
2022-08-27el45_1256862051720신진산업
2022-08-27el45_200elbow4520020041185097004740038800신진산업
2022-08-27el90_125128620103440신진산업
2022-08-27el90_200elbow902002007118501580082950110600신진산업
2022-08-27flange_socket_1256500030000신진산업
2022-08-27flange_socket_2002750015000신진산업
2022-08-27galvanized_sheet12000020000신진산업
2022-08-27r_150reducer1501505562075002810037500신진산업
2022-08-27sp_125_05Spiral_0.5t125125165480730087680116800신진산업
2022-08-27sp_200_05Spiral_0.5t20020028870011600243600324800신진산업
2022-08-27t_200tee2002001862011500862011500신진산업
2022-08-27yb_200y_branch20020057120138003560069000신진산업
2022-08-26coupling_250socket_Coupling25025013300440033004400나우테크
2022-08-26coupling_250socket_Coupling2502504440044001760017600한창상사
2022-08-26damper_1002750015000보람상사(주)
2022-08-26damper_150190009000디엘테크 (DL TECH)
2022-08-26diffuser_150180008000디엘테크 (DL TECH)
2022-08-26el45_600elbow4560060034050040500121500121500대흥우드산업(주)
2022-08-26el90_150elbow9015015038050115002415034500나우테크
2022-08-26el90_250elbow90250250119400194001940019400디엘테크 (DL TECH)
2022-08-26el90_250elbow90250250213580194002716038800나우테크
2022-08-26hanger_175hanger_ring175175330804400924013200나우테크
2022-08-26hanger_Rail_35_3020250050000디엘테크 (DL TECH)
2022-08-26hoodcap_sus_15021200024000디엘테크 (DL TECH)
2022-08-26r_250reducer250250112400124001240012400디엘테크 (DL TECH)
2022-08-26sirocco_fan_SS-TFB-36HS1650000650000한국그릇
2022-08-26sp_100_054511020440나우테크
2022-08-26sp_150_05Spiral_0.5t1501508623089004984071200나우테크
2022-08-26sp_175_05Spiral_0.5t17517587070101005656080800나우테크
2022-08-26sp_250_05Spiral_0.5t2502508101501450081200116000나우테크
2022-08-26sus_band_200_847002800디엘테크 (DL TECH)
2022-08-26sus_band_250_10109009000한창상사
2022-08-26sus_band_250_1038002400디엘테크 (DL TECH)
2022-08-26t_100185008500보람상사(주)
2022-08-26t_150tee15015015950850059508500디엘테크 (DL TECH)
2022-08-26tarpaulin_flexible_200_813215027950디엘테크 (DL TECH)
2022-08-26tarpaulin_flexible_250_10502600130000한창상사
🔄 다시 실행